Support Board
Date/Time: Wed, 05 Feb 2025 04:07:17 +0000
Post From: SPREADSHEET FORMULA HELP
[2020-02-23 02:48:38] |
Sawtooth - Posts: 4167 |
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 |