Login Page - Create Account

Support Board


Date/Time: Tue, 25 Feb 2025 09:57:33 +0000



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

[2021-04-06 23:25:19]
Sawtooth - Posts: 4175
this does not work for me when having a spreadsheet study reference another spreadsheet study subgraph
This is true.
The Spreadsheet System for Trading study and the Spreadsheet System/Alert study can see the Spreadsheet Study study's output, but not the reverse. The Spreadsheet Study study cannot see either of the other two studies, nor another Spreadsheet Study study.

To get a Spreadsheet Study study to see a subgraph's output from another Spreadsheet Study study, use the Spreadsheet Formula study with a formula like this in its Formula field:
=ID5.SG1
where ID5 is the Spreadsheet Study study, and SG1 is its column K.

If one Spreadsheet Study study is cross-dependent with another Spreadsheet Study study, it could cause calculation precedent issues where the data won't update as expected.