Support Board

Date/Time: Sat, 18 May 2024 03:38:28 +0000

Post From: Reference value from one custom spreadsheet study to another custom spreadsheet study

[2021-04-06 12:36:51] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4000
You can't directly reference a cell in another spreadsheet file like you can in Excel. However, the Spreadsheet Study study outputs its subgraphs which can be seen in the other two spreadsheet studies. You can also use the Spreadsheet Formula study as an intermediary, where its formula references a subgraph and its output can be seen by a spreadsheet study. Caution: you can get into a calculation precedence issue if there are crossing references.