Support Board
Date/Time: Sun, 12 Jan 2025 23:47:31 +0000
Spreadsheet System for Trading disconnects from chart after symbol rollover.
View Count: 948
| [2017-03-09 15:31:30] |
| User930315 - Posts: 55 |
|
After executing a symbol rollover for a chart with the Spreadsheet System for Trading applied, I am unable to get the chart and sheet connected again. My sheet shows that it’s linked to chart #2 which is correct, but the symbol in the sheet has not been updated to the one shown in chart #2. The sheet has been renamed “AutoTrading” and also shows the previous contract in cell J40. When I attempt to select the sheet in the Spreadsheet System for Trading it expects a sheet number, but since my sheet has been renamed there is no number shown. Entering numbers (1-4 for instance) in the “Chart Data Output Sheet Number” settings field results in the creation of a new sheet, not the linking of the study to my existing “AutoTrading” sheet. Restarting the program has no effect. Is there a way to get this spreadsheet reconnected to the chart or do I have to delete and reapply the spreadsheet study each time the symbol changes? Date Time Of Last Edit: 2017-03-09 15:34:55
|
| [2017-03-09 17:26:58] |
| |
|
If the Chart number is #2, and the Chart Data Output Sheet Number input with the Spreadsheet System for Trading study is set to 0 or 2, then the Sheet name in the Spreadsheet must be Sheet2. It cannot be "AutoTrading".
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 |
| [2017-03-09 17:33:24] |
| User930315 - Posts: 55 |
|
Is that a specific Spreadsheet System for Trading requirement due to the way it was implemented, or is it also the case across other Spreadsheet studies that pull data from a chart?
Date Time Of Last Edit: 2017-03-09 17:40:26
|
| [2017-03-09 17:43:38] |
| |
|
Yes this is a requirement for all of the Spreadsheet studies. We do plan to add the capability to use different names for Sheets but that has not yet been done. 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: