Support Board
Date/Time: Tue, 28 Jul 2026 21:24:06 +0000
Post From: Lock a One Time Value in a spreadsheet
| [2014-02-02 15:03:33] |
| Sawtooth - Posts: 4342 |
|
The "Locking the State of a One Time Condition" only locks a TRUE. It cannot retain a variable. Retaining a variable is possible using a formula like this: O3: =IF(F3>5000,A3-INT(A3),O4) This will retain the bar time of the bar that exceeds 5000 volume, and retain it until the next time the bar exceeds 5000 volume. |