Login Page - Create Account

Support Board


Date/Time: Tue, 23 Oct 2018 08:46:01 +0000



Referencing cells from other spreadsheets

Support Request:
[2017-11-29 05:16:15]
User606491 - Posts: 98
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: 98
Thank you. Can this also be done across chartbooks?
[2017-11-29 18:43:21]
Sierra Chart Engineering - Posts: 65120
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2017-11-29 20:34:52]
User606491 - Posts: 98
I appreciate both the internal and external assistance.
[2017-11-29 23:09:57]
Sierra Chart Engineering - Posts: 65120
Here is the relevant documentation:
https://www.sierrachart.com/index.php?page=doc/WorkingWithSpreadsheets.php#ReferencesToOtherSpreadsheetsWindows
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2017-11-30 04:01:25]
Sierra Chart Engineering - Posts: 65120
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:

https://www.sierrachart.com/index.php?page=doc/WorkingWithSpreadsheets.php#ReferencesToOtherSpreadsheetsWindows
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2017-12-04 15:56:32]
User606491 - Posts: 98
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: 65120
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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2017-12-04 18:28:16]
User606491 - Posts: 98
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: 65120
This is the reason why we prepared this documentation here. It explains this:
https://www.sierrachart.com/index.php?page=doc/WorkingWithSpreadsheets.php#ReferencesToOtherSpreadsheetsWindows

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. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.

To post a message in this thread, you need to login with your Sierra Chart account:

Login


Login Page - Create Account