Support Board
Date/Time: Sun, 01 Feb 2026 16:37:32 +0000
Post From: Range Zone (Study Help/Suggestions)
| [2022-06-01 22:17:06] |
| Sawtooth - Posts: 4312 |
|
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. |