Login Page - Create Account

Support Board


Date/Time: Thu, 13 Mar 2025 08:12:53 +0000



Post From: Range Zone (Study Help/Suggestions)

[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.