topic Re: "Cycle Detected" Error? in Discussions

"Cycle Detected" Error?

Anonymous — Mon, 04 Mar 2013 01:42:21 GMT

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

Re: "Cycle Detected" Error?

pgstats — Mon, 04 Mar 2013 02:51:31 GMT

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

Re: "Cycle Detected" Error?

Anonymous — Mon, 04 Mar 2013 15:47:11 GMT

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

Re: "Cycle Detected" Error?

pgstats — Mon, 04 Mar 2013 15:59:40 GMT

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.

Re: "Cycle Detected" Error?

Anonymous — Mon, 04 Mar 2013 17:33:30 GMT

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