Login Page - Create Account

Support Board


Date/Time: Fri, 10 Jan 2025 22:12:50 +0000



Spreadsheet Shared between chartbooks

View Count: 1051

[2016-10-09 21:02:45]
ForgivingComputers.com - Posts: 982
I have a Chartbook with a chart that uses spreadsheets. If I change the symbol and file save as... the chartbook, I can then have both chartbooks open at the same time. My question is do I need to make a separate spreadsheet for the new chartbook? I have noticed that when I have the same spreadsheet in both chartbooks, the functionality appears to be OK, but the spreadsheet goes back and forth between the two symbols when viewing it. It would appear to impact performance, but I don't know if the performance impact is only when I am viewing the spreadsheet, or if it is constantly rewriting all the cells in the background too. It would be simpler if I don't have to clone the spreadsheet too, but I don't want to slow everything down.

Please advise.

Thanks!
[2016-10-09 22:58:44]
Sierra Chart Engineering - Posts: 104368
The solution to this is to make sure different Sheets are being used for every chart in all of the Chartbooks, through this input:
Spreadsheet Study Inputs: Chart Data Output Sheet Number
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
[2016-10-10 00:56:23]
ForgivingComputers.com - Posts: 982
I understand how the output sheets work. I was asking if there is a performance hit or any other reason why I can't have the same spreadsheet attached to different chartbooks. Chart #1 in chartbook1 and chart #1 in chartbook2 both have defaultspreadsheet.scss as studies. When both chartbooks are open, is there any issue or do I need to save and attach the second spreadsheet with a different name? I suspect the answer is "NO" but I want to make sure.
[2016-10-10 02:21:38]
Sierra Chart Engineering - Posts: 104368
if there is a performance hit
Yes.
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
Date Time Of Last Edit: 2016-10-10 02:22:22

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account