Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 27 Apr 2024 01:12:33 +0000
Accessing Multiple Charts from a Single Spreadsheet System for Trading
View Count: 1353
| [2019-06-20 22:34:15] |
| User94606 - Posts: 327 |
|
I have 4 charts in my chartbook. Chart 1 contains the Spreadsheet System for Trading. Can I use the Spreadsheet System for Trading from chart 1 to access data from chart 2, 3, and 4? If so, can you provide a reference?
|
| [2019-06-21 03:13:26] |
| |
|
Yes. This is fully documented here: Referencing Other Charts in Spreadsheet Study Formulas 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 |
| [2019-06-21 12:07:38] |
| User94606 - Posts: 327 |
|
I added Study/Price Overlay into chart #1 and selected Chart #4 for the Study to Overlay. However, I am not seeing the data in the Spreadsheet System for Trading which is part of chart #1. How do you troubleshoot this?
|
| [2019-06-21 15:20:48] |
| |
|
Refer to: Using the Spreadsheet Study: Solving Study Not Displaying On Spreadsheet Sheet It could also be caused by a calculation order issue: Chart Studies: Study Calculation Precedence And Related Issues 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 |
| [2019-06-22 12:45:47] |
| User94606 - Posts: 327 |
|
I am still not be able to see the data from the Study/Price Overlay Study on the spreadsheet. I am attaching a copy of the chartbook and spreadsheet for your reference. Chart #7, includes a Study/Price Overlay study for chart #4.
|
Private File Private File |
| [2019-06-23 21:23:27] |
| John - SC Support - Posts: 31159 |
|
From what we see, the data is showing up in the spreadsheet, but on occasion we have seen some of the headers in Row 1 displaying above some of the items from the Study/Price Overlay. This could lead you to think the data was not in the spreadsheet, but it really was. Take a look at the information in Row 2 to look for ID9, which is the Study/Price Overlay, and it should be at the end of the additional data in your spreadsheet. If you do have additional headers showing up, then this is most likely a calculation order issue. Try moving the Spreadsheet System for Trading study to the top of the list of studies and then delete the incorrect headers in the spreadsheet itself, and then select Edit >> Reload and Recalculate, just to get everything back in sync, and you should be fine. For the most reliable, advanced, and zero cost futures order routing, use 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: