Unassigned Variables

Looking at this line below with DebugView, variable xt is shown as unassigned.

It seems like it should be an array ?

xt = Nz(log(Close-ref(close,-1)));

Really you should spend at least 10 seconds checking things before posting.

Re-run the formula under debugger and you will find that the array is produced and everything works as it should.

  1. Place a breakpoint AFTER assignment
  2. Math 101: Logarithm from NEGATIVE data does not exist (so if Ref( Close,-1) is greater than Close you are doing mathematically impossible thing)
  3. Use [code] tags or three backticks
1 Like