Support Board
Date/Time: Mon, 29 Dec 2025 09:14:54 +0000
Spreadsheet latch cell
View Count: 14
| [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 - 7 views |
| [2025-12-29 01:52:47] |
| Sierra_Chart Engineering - Posts: 22043 |
|
The functionality as explained here does work as documented: Spreadsheet Studies Special Tasks: Locking the State of a One Time Condition The formula in U3 is not correct. It needs to reference itself. It is not referencing itself. The second parameter of the OR function needs to reference U3. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2025-12-29 01:53:03
|
To post a message in this thread, you need to log in with your Sierra Chart account: