Support Board
Date/Time: Sun, 12 Jan 2025 11:48:38 +0000
Spreadsheet, call up Symbols directly, no Chart
View Count: 652
| [2017-02-08 23:12:26] |
| User136839 - Posts: 20 |
|
Hello, I would like to track just the "last price" of 50+ symbol in a spreadsheet and consolidate the data to process. I've done this by creating a separate chart for each symbol and then using the first chart to overlay all the other symbols on. Then I add a Spreadsheet study and do the calculations. This is very cumbersome and slows the software and PC down a lot as there is a lot of data that I don't need being created (Open, High Low, Volume, HLC Average etc). I've looked a the documentation but can't find a simplified way to do this. Is is possible to call up "just" the "last price" of the symbols directly in the spreadsheet without creation of the charts, the Overlay and additional superfluous data? Many thanks |
| [2017-02-09 02:18:18] |
| |
|
Yes. Refer to: http://www.sierrachart.com/index.php?page=doc/GettingQuotes.html#QuotesOnSpreadsheets 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-02-09 15:12:27] |
| User136839 - Posts: 20 |
|
Thanks for getting back so quickly. I didn't explain that I need a couple of days worth of 15 second Last price data for each of the 50 symbols. The Quote Spreadsheet organizes the Symbols in a rows, so it's not possible to create a progressive time line of price. I don't see how that can work with Quote Spreadsheets. Can you please elaborate? Cheers Date Time Of Last Edit: 2017-02-09 15:14:52
|
| [2017-02-09 18:04:09] |
| |
|
OK therefore you need to use the method you currently are. Just keep the Number of Rows setting with the Spreadsheet study to the minimum you need: http://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#NumberofRows 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: