Support Board
Date/Time: Thu, 16 Jan 2025 23:44:09 +0000
Referencing cells from other spreadsheets
View Count: 2229
| [2017-11-29 05:16:15] |
| User606491 - Posts: 164 |
|
How do I reference cells between spreadsheets? I would like to aggregate calculations from across multiple spreadsheets, then use these calculations to prioritize which symbols should be traded. The documentation I've seen requires the use the study/price overlay tool. However, the cells I would like to reference are not first-order outputs from the study/price overlay, but rather derived calculations. Example: 1. A strength of trend metric is calculated by combining X and Y studies 2. I would like to aggregate this metric into a "master spreadsheet" for all symbols in my universe 3. Based on prioritization system, I would then like to send Buy/Sell signals back to each symbol-specific spreadsheet How do I reference cells between spreadsheets? thank you, Eric |
| [2017-11-29 13:14:13] |
| User606491 - Posts: 164 |
|
Thank you. Can this also be done across chartbooks?
|
| [2017-11-29 18:43:21] |
| |
|
The responses so far are not from Sierra Chart support. We will be responding to this with some updated documentation later today.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2017-11-29 20:34:52] |
| User606491 - Posts: 164 |
|
I appreciate both the internal and external assistance.
|
| [2017-11-29 23:09:57] |
| |
|
Here is the relevant documentation: Working with Spreadsheets: References to Other Spreadsheets Windows Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2017-11-30 04:01:25] |
| |
|
We have updated this documentation further explaining how to create an additional View into the same Spreadsheet so that you can view two Sheets at the same time: Working with Spreadsheets: References to Other Spreadsheets Windows Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2017-12-04 15:56:32] |
| User606491 - Posts: 164 |
|
Folks, It is becoming increasingly important for me to be able to compare data outputs from spreadsheets in different chartbooks. I require the ability to aggregate/centralize outputs from multiple spreadsheets distributed across multiple chartbooks (not charts). Is this functionality in the development pipeline? As it currently stands, I cannot compare risk/return metrics across symbols because each symbol is contained within a unique chartbook. I cannot combine all symbols into one chartbook for various reasons that are not immediately relevant to this discussion. thank you, as always. |
| [2017-12-04 18:15:30] |
| |
|
There really pretty much 0% chance that referencing data between different Spreadsheets will happen. It is not something to put reliance on. Also, you can use a common Spreadsheet among different Chartbooks. This has always been supported by ensuring that each chart uses a different Sheet within the Spreadsheet. Let us know if you need help with that. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2017-12-04 18:28:16] |
| User606491 - Posts: 164 |
|
Yes, using a common spreadsheet among different chartbooks would be helpful. Where can i find documentation on that.
|
| [2017-12-04 19:09:10] |
| |
|
This is the reason why we prepared this documentation here. It explains this: Working with Spreadsheets: References to Other Spreadsheets Windows Just go through the steps. The relevant study Input is the Chart Data Output Sheet Number. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: