Support Board
Date/Time: Wed, 12 Mar 2025 11:55:30 +0000
Referencing a value from one spreadsheet to another
View Count: 531
| [2022-05-04 10:52:00] |
| VolTrader73 - Posts: 136 |
|
Hello. How can I use a value calculated in one spreadsheet in another ? To clarify : I would like to see the value from spreadsheet Trading11 cell W3 in spreadsheet Trading22 cell Z3. Both sheets are within the same workspace. I tried like I do in Excel: click Z3 (In scss Trading22) enter "=" then move to scss Trading11 and click W3 "enter". Dose not work. pls advise |
| [2022-05-04 14:18:03] |
| Sawtooth - Posts: 4182 |
|
It is not supported to reference another spreadsheet file, as with Excel. Working with Spreadsheets: References to Other Spreadsheets Windows A workaround is to use the Spreadsheet Formula study with a formula like this in its Formula field: =ID1.SG13 where ID1 is the Trading11 spreadsheet study (SG13 is column W). Then Trading22 spreadsheet can see its output in columns AA and higher. |
To post a message in this thread, you need to log in with your Sierra Chart account: