Support Board
Date/Time: Thu, 12 Dec 2024 21:19:44 +0000
Duplicated a Spreadsheet System/Alert study and all the formulas are blank.
View Count: 108
[2024-10-07 21:14:22] |
C_Money - Posts: 69 |
Hello. I duplicated a chartbook and a spreadsheet system alert study to make slight changes to both. However, when I open the duplicated spreadsheet system/alert study, all of the formulas are blank. First I add the study to the chart, set the settings exactly as they were on the other chartbook, then I select the duplicated spreadsheet and hit apply. What am I missing? |
[2024-10-07 21:19:25] |
C_Money - Posts: 69 |
Ok. It has something to do with the fact that I created an additional folder inside my Data folder to keep the spreadsheet files organized. I'm guessing the spreadsheet is unable to reference the formulas because they're stored somewhere else in the hierarchy?
|
[2024-10-08 13:46:38] |
John - SC Support - Posts: 36652 |
It is best to keep the spreadsheet files in the 'Data' folder. What you are doing can be done, but when you duplicate the chart with a Spreadsheet study on it, that spreadsheet is then going to be saved to the default 'Data' folder. Which is going to be part of the problem you are having. The other thing to keep in mind is that when you duplicate a chart with a Spreadsheet Study on it, the new chart will most likely use a new sheet. This depends on how you have the Inputs for the Sheet Number/Name set. If you do not change these Inputs, then each chart uses its own sheet number which is related to the chart number (Chart #5 will use 'Sheet5'. But, if you specify a sheet name/number, then when you duplicate the chart, the new chart will use the same Sheet as the original chart. But this is definitely not recommended - rather you should use a Formula sheet. Refer to the following and the Input below it: Spreadsheet Study Inputs: Formula Source Sheet Specification Type 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: