Login Page - Create Account

Support Board


Date/Time: Fri, 19 Aug 2022 06:08:15 +0000



References Between Spreadsheets

View Count: 11840

[2021-11-15 17:39:46]
User337568 - Posts: 45
Hi:

What is the correct reference information for the Master Spreadsheet?

I want to create this Master spreadsheet idea, and I get a #REF error in my AGGregation spreadsheet.
Here is the error:

[ '[ES1439]Sheet1'!E3 ] '[ES1439]Sheet1'!E3 = #REF! (error)

I have three spreadsheets:
ES1439
NQ1439
AGGChart - intended Master

Because the Study Summary Window does not allow text output, I am creating a Master spreadsheet with Text output.

I looked on the web and found this excel Workbook reference information:
[Workbook_name]Sheet_name!Cell_address

I can post the chartbook if desired, but I am lost with how to reference the slave workbooks into the Master. In my case, the Master is "AGGChart."
[2021-11-15 17:56:34]
John - SC Support - Posts: 18115
Refer to the information here:
Working with Spreadsheets: References to Other Sheets within a Spreadsheet
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2021-11-15 18:49:56]
User337568 - Posts: 45
Thank you and I couldn’t get that working.
Perhaps I’ll just post my test Chartbook and someone might help get me started.
Date Time Of Last Edit: 2021-11-15 21:15:34
[2021-11-15 20:15:23]
John - SC Support - Posts: 18115
You can not reference data between different Spreadsheets. Refer to the information here:
Working with Spreadsheets: References to Other Spreadsheets Windows
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:

Login

Login Page - Create Account