Support Board
Date/Time: Mon, 29 Dec 2025 09:14:22 +0000
Post From: Spreadsheet latch cell
| [2025-12-29 00:48:58] |
| TraderGD - Posts: 5 |
|
Hello, I have an indicator that fires once and then gives no signal until the next occurence. I want to create a cell that remembers that change and stays "TRUE" until some other condition resets it. I have tried the information given here, Spreadsheet Studies Special Tasks: Locking the State of a One Time Condition I already had some formulas in a spreadhseet, so I used different columns than what the example listed; Sierra example "K3" is in Column T Sierra example "H3" is in column U Sierra example "E3" is in column V I have transposed all column labels in all formulas as above. After I enter the final command as listed in the example, I can sit here and watch Column U continuosly change from 1s to 0s in every visible row. Is that expected, and if so, I am a bit lost on which cell becomes my coondition-TRUE trigger. :) The concept behind it is simple; If an indicator has a crossover, then I want the condition to become TRUE and remain TRUE until it is RESET by either a) a trade entry ( which will be at a later time via a different trade entry condition trigger), or b) until a different indicator returns TRUE (which would indicate that the TRUE state of the original latch cell was now FALSE). See attached screenshot with the contents of cell "H3" displayed. |
 Sierra screenshot.JPG / V - Attached On 2025-12-29 00:48:36 UTC - Size: 278.05 KB - 6 views |