Support Board
Date/Time: Sun, 24 Nov 2024 12:39:01 +0000
spreadsheet going blank
View Count: 1412
| [2013-10-24 02:41:31] |
| User021827 - Posts: 174 |
|
I was going along testing different simple moving average crossovers to get used to spreadsheet when they stopped working. When I did the replay , whether bar or regular replay, the spreadsheet did not fill up with data and the formelas disappeared from the function cells at the end of the replay. The cells that had the buy and sell formulas where then empty, like someone erased them. Of course there were no trades placed. Did nothing different from previous tests. Have you seen this before ? thnks shane |
| [2013-10-24 04:57:00] |
| |
|
You may not be looking at the correct Sheet within the Spreadsheet. And you need to be familiar with the Formula Source Sheet Number input: https://www.sierrachart.com/index.php?l=doc/doc_WorksheetStudyInputs.html#FormulaSourceSheetNumber And also the Chart Data Output Sheet Number input. 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, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2013-10-24 12:10:59] |
| User021827 - Posts: 174 |
|
hi thanks for the link I think it was due to this, which I found in the link you sent "If you enter Formulas in cells K3 through Z3 on a Sheet in a Spreadsheet that has formulas copied from another Sheet because the Formula Source Sheet Number input is set to a different Sheet number, then the formulas you enter will be erased when the Spreadsheet is updated. They will be either blank or replaced by the formulas from the source Sheet[/i]." thanks for your help sincerely, Shane |
To post a message in this thread, you need to log in with your Sierra Chart account: