Support Board
Date/Time: Sun, 24 Nov 2024 16:02:11 +0000
Recreating 2 Spreadsheet cells using Spreadsheet Formula
View Count: 173
| [2024-05-21 12:59:41] |
| User656492 - Posts: 143 |
|
I'm trying to use spreadsheet formula studies instead of a spreadsheet to accomplish this: In Cell O3: =if ( E4 > B4, D4 - $H$3, P4- $H$3) In Cell P3: =if ( E4 > B4, D4, O5) This works perfectly, allowing me to follow up the lows of each bar with an offset value in cell $H$3, which = 1.0 Using 2 spreadsheet formula studies, I get zero values instead of the "else" values in the above if's. id9: =if( id0.sg4[-1] > id0.sg1[-1] , id0.sg3[-1] , id10.sg1[-2] ) id10: =if( id0.sg4[-1] > id0.sg1[-1] , id0.sg3[-1] , id9.sg1[-1] -1) This is producing 0 for the else condition of id9.sg1 and -1 for id10.sg1 I'm sure I'm doing something dumb, but can not figure it out. Anybody? Date Time Of Last Edit: 2024-05-21 13:08:57
|
| [2024-05-21 15:02:08] |
| John - SC Support - Posts: 36238 |
|
We are more surprised that what you did in the Spreadsheet Study worked. You are creating a Circular Reference, where ID9 depends on ID10 to be calculated, but ID10 requires ID9 to be calculated. You simply can not do this. You would need to redo the formulas such that you do not have this situation. As to why the Spreadsheet Study worked, we can not say. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-05-21 15:23:01] |
| User656492 - Posts: 143 |
|
Thanks, John. I did not have this answer on my bingo card!
|
To post a message in this thread, you need to log in with your Sierra Chart account: