Subscribe Bookmark RSS Feed

"Cycle Detected" Error?

thechadd

Community Trekker

Joined:

Jun 23, 2011

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

4 REPLIES
pgstats

Community Trekker

Joined:

Aug 30, 2011

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

PG

thechadd

Community Trekker

Joined:

Jun 23, 2011

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

pgstats

Community Trekker

Joined:

Aug 30, 2011

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

thechadd

Community Trekker

Joined:

Jun 23, 2011

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