cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar

"Cycle Detected" Error?

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 4
pgstats
Level I

Re: "Cycle Detected" Error?

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

PG

Re: "Cycle Detected" Error?

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

pgstats
Level I

Re: "Cycle Detected" Error?

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

Re: "Cycle Detected" Error?

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