Support Board
Date/Time: Sat, 14 Feb 2026 22:06:52 +0000
Post From: Spreadsheet latch cell
| [2025-12-29 22:30:28] |
| TraderGD - Posts: 13 |
|
Sawtooth - "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))" That is actually similar to how I started. When I could not get it to work as intended I went to the Sierra Help section. I have changed my spreadsheet so that Sierra's "E3" reference has been now replaced with my crossover trigger column, which in my spreadsheet is Column O. In this screenshot Sierra's "E3" is represented by my cell "O3". I have red arrows where there was a crossover event that produced a 1 in column O. Sierra's K3 does produce a 1 in that same row, but it is not staying as a 1. Attached is a screenshot of how Sierra's formulas are resulting. One of those two columns highlighted in green (presumed Sierra's K / my T) should stay as a "1" after the initial Crossover. Column U in my spreadsheet is assumed to be the latch reset condition. I have it exactly as Sierra's example, but with the cell names changed. =AND(OR(O3=1,T3>0),U3=FALSE) . But even if I delete all content in cell U3, it does not change anything in Column T. I will keep messing with it |
 columns.JPG / V - Attached On 2025-12-29 22:28:03 UTC - Size: 184.35 KB - 22 views |