Login Page - Create Account

Support Board


Date/Time: Thu, 02 May 2024 10:36:40 +0000



Post From: locking state plus a value

[2014-01-24 00:20:13]
Sawtooth - Posts: 3989
Another way to lock the TRUE is to use double IF statements. This allows a way to lock a TRUE at all bars until you release it. For example (in cell Z3):

IF(StartLineConditions,TRUE,IF(StopLineConditions,FALSE,Z4))

Then find the value at the first TRUE, and retain it until you release it. (in cell Y3):
=IF(AND(Z3=TRUE,Z4=FALSE),D3,IF(Z3=FALSE,0,Y4))
This is the value you plot.