"Cycle Detected" Error?<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />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?Yup, I was hoping to avoid the E-word for this project, unless I want to do some scripting.
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?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?Open Stock Value is a function of Close Shares and Close Shares is a function of Open Stock Value...
PG
