Support Board
Date/Time: Wed, 05 Feb 2025 18:01:14 +0000
Post From: Working with multiple sheets
| [2025-01-14 18:43:07] |
| John - SC Support - Posts: 37756 |
|
We just tested the following scenario and everything is working as expected: - Two Spreadsheet Studies on different charts (Chart #1 and Chart #2), both using the same spreadsheet as defined by the "Spreadsheet Name" field on the Study Settings window. - Each spreadsheet study has the "Chart Data Output Specification Type" set to "By Number", and the "Chart Data Output Sheet Number" is set to "0", meaning each chart uses its own Chart Number for the Sheet Name, resulting in two sheets named "Sheet1" and "Sheet2". - With an RSI study on Chart #2, we can enter the following formula in cell K3 of Sheet1 and get the data properly populated: ='Sheet2'!AA3 So you should be fine with your scenario as you state. Make sure you are referencing the cells properly as defined here: Working with Spreadsheets: References to Other Sheets within a Spreadsheet If you continue to have an issue, then we need to know what error you are getting in the spreadsheet. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |