Login Page - Create Account

Support Board


Date/Time: Wed, 19 Mar 2025 08:27:14 +0000



Post From: Spreadsheet programming question

[2022-10-13 00:18:29]
Sawtooth - Posts: 4186
It's not possible to make an intrabar value persistent in a spreadsheet study.

Only close-of-bar values can be made persistent.
Here are some examples:
Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables
Spreadsheet Example Formulas and Usage: Return Last Two Zig Zag Reversal Values

You can only make an intrabar TRUE (not a value) persistent, using this method:
Spreadsheet Studies Special Tasks: Locking the State of a One Time Condition
https://www.sawtoothtrade.com/example-9.html