Support Board
Date/Time: Tue, 04 Mar 2025 18:07:32 +0000
Post From: Spreadsheet for trading, persistent data is reset when a cell is modified.
| [2021-12-16 17:45:46] |
| User346098 - Posts: 47 |
|
I read it, it shouldn't be Ignored according to that documentation. OK so I read it again : " Ignored Signals During Historical Data Downloading [Link] - [Top] With the Spreadsheet System for Trading study and the Spreadsheet System/Alert study, System and Alert signals from the Sheet formula columns are ignored on historical data and when historical data is being downloaded. They are monitored for when the chart is actually updating with new data. A chart will be updating with new data during real-time chart updating with live data, during replays, or during a Back Test. If you want to see the Back Test results from historical Buy and Sell signals from the Buy/Sell formula columns in the case of when using the Spreadsheet System for Trading study, then refer to the Back Testing section." So signals are not monitored if the market was closed and no new data was coming in? 2) different question: is it possible to have different formulas at each row in a column copied from a different column ? I found Spreadsheet Studies Special Tasks: Using Different Formulas or Data at Each Row of the Formula Columns (K-Z) but this only copies the result of the formulas entered from the source column I need this since I am trying to set different formulas on a single sheet in a single column but different rows and have the formulas copied from other sheets in the spreadsheet, I need them copied because they refer to data local to the sheet they are copied to, I tried workaround like this: AX3 on formulasheet contains a sheet number: =INDIRECT(CONCATENATE("Sheet",formulasheet!AX3, "!","$J$8"))*INDIRECT(CONCATENATE("Sheet",formulasheet!AX3, "!","$J$9")) thinks start getting complicated just to get a single cell from the formulasheet when I use: =INDIRECT(CONCATENATE("formulasheet!BL", ROW(VLOOKUP(J$91, formulasheet!AX:AX,1))))) 3) Last question Is it also possible to have a value/state from a formula saved and not reset when I change any other cell on the sheet or source sheet, per example using Spreadsheet Studies Special Tasks: Locking the State of a One Time Condition if this formula entered on K3: =AND(OR(E3=10,K3>0),H3=FALSE) ,K3 will remain true when E10 is true, but if condition for E10 is false AND I change some other cell on the sheet it will reset back to false ! Thanks, Marcelo. Date Time Of Last Edit: 2021-12-16 18:34:22
|