Login Page - Create Account

Support Board


Date/Time: Sun, 24 Nov 2024 04:04:39 +0000



Post From: Color bar based on alert condition

[2024-07-08 14:11:54]
John - SC Support - Posts: 36238
When you add one of the Spreadsheet studies to a chart, you are also creating a spreadsheet file. That file is defined on the settings page for the study. Refer to the following:
Chart Studies: Settings and Inputs Tab >> Spreadsheet Name / DLL File and Function Name

When you do this, that spreadsheet name defaults to a specific name depending on the particular spreadsheet study you are using. For instance, the "Spreadsheet Study" has a default name of "DefaultSpreadsheetStudy".

Therefore, if you do not change this name, and you save the chartbook, then that "DefaultSpreadsheetStudy" is going to be saved. And if you then add another Spreadsheet study to another chart, then that same spreadsheet will get used.

This may, or may not, be a problem, as each chart, by default, uses a specific sheet within the spreadsheet based on the Chart Number. So if you have the same chart number, then the spreadsheet will have information already in it.

The point here is that you need to be careful about the name of the spreadsheet file. It sounds like you might want a separate file for each instance of the spreadsheet study you use. Make sure you change this in the settings for the study.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing