Login Page - Create Account

Support Board


Date/Time: Wed, 12 Mar 2025 11:42:19 +0000



Post From: Referencing a value from one spreadsheet to another

[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.