"Cycle Detected" Error?

[#1]

Hey all,

I'm messing around with JMP for simulating some trading strategy I'm working on .  I am getting a strange error with the enclosed table:

Cycle detected for data column: Open Stock Value

0. Open Stock Value

  1. Close Shares

0. Open Stock Value

    2. Action

    2. Adj Close

  1. ::TableVariableColumn::

  1. ::RowColumn::

I have never seen this error before, and I double checked for recursion; I don't see any problem with my formulas.  Am I missing something?  Anyone seen this error before?

Cheers!

Chadd

Table script attached

[#2]

Open Stock Value is a function of Close Shares and Close Shares is a function of Open Stock Value...

PG

[#3]

Open Stock Value is a function of Lag(Close Shares,1), so the *previous* row, not current row. That shouldn't be recursive.

[#4]

I think JMP's analysis of your formulas is based on variables, not rows. It is less sophisticated than Excel's which is based on cells.

PG

[#5]

Yup, I was hoping to avoid the E-word for this project, unless I want to do some scripting.