Support Board
Date/Time: Thu, 13 Mar 2025 04:16:10 +0000
[User Discussion] - Range Zone (Study Help/Suggestions)
View Count: 532
| [2022-06-01 20:05:15] |
| Department - Posts: 1 |
|
Hello, Is there a study that will draw lines from a candle's open/close (or high/low that I can edit) and continue drawing forward as long as the next candles have an open or close within the range? I've attached 2 example images of what it should look like from the ES 4000 tick. I attempted to do this through the spreadsheets but kept getting #CREF! error when trying to retain the open/close values of the range. I couldn't solve this issue even though it works just fine in excel (no circular referencing found) and when using stagnate data (not live - no refreshing). If there is a similar enough study that I could be referred to that has ACSIL documentation that would also be helpful. Thank you. |
 RangeEx1.PNG / V - Attached On 2022-06-01 20:00:12 UTC - Size: 3.75 KB - 153 views RangeEx2.PNG / V - Attached On 2022-06-01 20:00:17 UTC - Size: 4.1 KB - 143 views |
| [2022-06-01 22:17:06] |
| Sawtooth - Posts: 4182 |
|
Excel allows iterative calculations, Sierra Chart spreadsheet studies do not. To retain open/close values, you can create a persistent value of each in Formula Columns using the IF function, like this: =IF(rangecondition,B3,O4) where this formula goes in O3. |
To post a message in this thread, you need to log in with your Sierra Chart account: