Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Mon, 13 May 2024 09:44:23 +0000

How to Post a Message for Support

Post From: Lock a One Time Value in a spreadsheet

[2014-02-02 15:03:33]
[Go To First Post]
Sawtooth - Posts: 3995
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.