Support Board
Date/Time: Tue, 04 Mar 2025 18:12:51 +0000
Post From: Spreadsheet for trading, persistent data is reset when a cell is modified.
| [2021-12-16 23:07:34] |
| Sawtooth - Posts: 4179 |
|
1. There would not be any signals to monitor if the market was closed and no new data was coming in. 2. You can retrieve values but not formulas. Have a look at this function: https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#GetCorrespondingMatch_Function IMO, it's not a good idea to use a blank column beyond the Formula Columns because any addition, removal, or rearrangement of studies in the Studies to Graph list could overwrite that column. If the formula doesn't need to be aligned with a chart bar, you can use Column H, or you can add a sheet that is not associated with a chart. Spreadsheet >> Add Sheet, then give it a unique name. 3. It's possible to lock a condition TRUE, and automatically release it, but it can be tricky to get it to work. The formula only requires one static cell, and it shouldn't be K3 because that is the Buy Entry cell of a Formula Column. Here is an example: https://www.sawtoothtrade.com/example-9.html And see post #4 here: Spreadsheet programming question #CREF using Locking the State of a One Time Condition |