Date/Time: Thu, 30 Nov 2023 01:16:35 +0000
Post From: Spreadsheet auto populate formula isn't working
|John - SC Support - Posts: 27353|
It does not work like you are thinking.
When you rename the sheet, it is actually renaming the sheet, but the Spreadsheet Study is still referencing the sheet by the number, so the system creates the new sheet, which is not associated with a study, so it is a "standard" sheet. Meanwhile, the Spreadsheet Study creates a new sheet for its purposes.
Basically you can not rename a sheet when using the Spreadsheet Study. The only way to do this would be to name the Formula Sheet prior to starting the Spreadsheet Study. Refer to the following:
Spreadsheet Study Inputs: Formula Source Sheet Number
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing