Support Board
Date/Time: Sat, 14 Feb 2026 22:06:54 +0000
Post From: Spreadsheet latch cell
| [2025-12-29 16:36:10] |
| Sawtooth - Posts: 4313 |
|
I was assuming the data would need to go in three different columns, not three different rows?
Locking a cell TRUE doesn't require the use of a Formula Column, since Formula Columns auto-populate across all bars.The idea is you would reference $H$3 in your K3/M3 formulas. Note: It can be difficult to get the H5 formula to go back to TRUE from FALSE because it requires a secondary trigger. An easier way to do what you want is by creating a persistent TRUE variable in a Formula Column, using two IF statements, like this in W3: =IF(IndicatorCrossover,1,IF(OR(TradeEntry,2ndIndicatorTRUE),0,W4)) The first IF creates the persistent TRUE, the second IF releases it. Date Time Of Last Edit: 2025-12-29 16:38:04
|