Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 27 Apr 2024 15:33:23 +0000
Spreadsheet Formula for Mulitple symbols
View Count: 1247
| [2018-08-18 18:40:36] |
| User600744 - Posts: 29 |
|
I want to create a spreadsheet with a list of 50 symbols, their current price and current VWAP price. How do I go about doing this. I have tried doing this using a Quote Spreadsheet but VWAP is not a column option. The only way I can think is to have 50 charts feeding 50 spreadsheets. Then having 1 master spreadsheet referencing the others. Is there an easier way. Thanks |
| [2018-08-18 20:41:56] |
| |
|
Refer to this page: Displaying a Table of Study Values on a Spreadsheet 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 |
| [2018-08-19 13:56:06] |
| User600744 - Posts: 29 |
|
Thanks for the quick reply. I now have a Study Summary with a list of symbols and the data I want to use. How do I achieve the same but with a Spreadsheet so I can perform calculations. Thanks |
| [2018-08-19 20:51:33] |
| |
|
Basically what you describe in post #1 but there is not a need to use 50 separate Spreadsheets. You can just use one Spreadsheet and use the Spreadsheet Study to output the data to a single Spreadsheet and make sure each chart is outputting data to a different Sheet within the Spreadsheet window.
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 Date Time Of Last Edit: 2018-08-19 20:52:13
|
| [2018-08-19 22:05:35] |
| User600744 - Posts: 29 |
|
Would I need to have all 50 charts open to run the spreadsheet? It seems strange that I can get the information I need into a Study Summary Quote Board fairly easily. Why can that data not be put into a spreadsheet in the same way? Thanks |
| [2018-08-20 01:02:47] |
| |
|
Are you using 50 charts now with the Study Summary window? You could load 50 symbols into a single chart by using this study: http://www.sierrachart.com/index.php?page=doc/WorkingWithCharts.html#OverlayingMultipleSymbols And so long as you do not require the Volume Weighted Average Price study to rely on the underlying data, you can then base that study on one of those symbols loaded into the chart. 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 Date Time Of Last Edit: 2018-08-20 01:07:02
|
To post a message in this thread, you need to log in with your Sierra Chart account: