Support Board

Date/Time: Sat, 18 May 2024 11:36:43 +0000

Post From: SPREADSHEET FORMULA HELP

[2020-02-23 02:48:38] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4000
Locking the TRUE state of a formula condition can only lock a TRUE, not a value. I would approach this by creating a persistent variable of each of the conditions in their own Formula Column, then reference each in the K3 formula. You'll need a persistent variable of: - TRUE if the Opening Candle is green. - the Opening Candle's Open price. - TRUE when the Swing High occurs at or subsequent to the Opening Candle. - the Swing Low's price at or subsequent to the Swing High going TRUE. Some of the above persistent variables will need to be released, which will essentially cancel the setup. Here are some examples of persistent variable formulas: Spreadsheet Example Formulas and Usage: Persistent and Incrementing Variables