Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 08:11:01 +0000



Referencing cells from other spreadsheets

View Count: 2089

[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]
Sierra Chart Engineering - Posts: 104368
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]
Sierra Chart Engineering - Posts: 104368
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]
Sierra Chart Engineering - Posts: 104368
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]
Sierra Chart Engineering - Posts: 104368
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]
Sierra Chart Engineering - Posts: 104368
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:

Login

Login Page - Create Account