Support Board
Date/Time: Wed, 05 Nov 2025 03:29:23 +0000
Post From: Range Zone (Study Help/Suggestions)
| [2022-06-01 22:17:06] |
| Sawtooth - Posts: 4285 |
|
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. |