Support Board

Date/Time: Fri, 26 Apr 2024 04:58:27 +0000

Post From: Spreadsheet Trading: Stop loss by price structure

[2020-02-15 02:54:31] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3976
how to lock the values of low of the entry bar when K3 is true? You can't lock a value using 'Locking the State of a One Time Condition', only a TRUE condition. You'll want to use a persistent variable in a Formula Column, like this, in P3: =IF(M3,0,IF(K3,D3-$J$21*1,P4)) This will make a value persistent when K3 goes TRUE, and release it when M3 goes TRUE. (You can use any event to release the persistent variable.)