Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 03 May 2024 16:38:19 +0000
[User Discussion] - Reference value from one custom spreadsheet study to another custom spreadsheet study
View Count: 530
| [2021-04-06 00:21:43] |
| User355030 - Posts: 163 |
|
Is it possible to reference a value from one custom spreadsheet study to another custom spreadsheet study? Every time I try, I get the "Name?" error @tombgilb @SC |
| [2021-04-06 12:36:51] |
| Sawtooth - Posts: 3992 |
|
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. |
| [2021-04-06 22:55:30] |
| User355030 - Posts: 163 |
|
Tom, Thanks for the reply, "However, the Spreadsheet Study study outputs its subgraphs which can be seen in the other two spreadsheet studies." this does not work for me when having a spreadsheet study reference another spreadsheet study subgraph... If I use a "spreadsheet system for trading" then it allows me to reference the subgraphs. @tomgilb |
| [2021-04-06 23:25:19] |
| Sawtooth - Posts: 3992 |
|
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. |
To post a message in this thread, you need to log in with your Sierra Chart account: