Login Page - Create Account

Support Board


Date/Time: Fri, 20 Jun 2025 09:52:31 +0000



Post From: Range Zone (Study Help/Suggestions)

[2022-06-01 22:17:06]
Sawtooth - Posts: 4229
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.