Login Page - Create Account

Support Board


Date/Time: Wed, 12 Mar 2025 05:57:23 +0000



Using data from Sierra Chart

View Count: 516

[2022-05-05 21:56:01]
RonW - Posts: 105
Your recent offering of NASDAQ TotalView makes this question much more pertinent.

I have looked through the Support Board and see conflicting answers from you guys on this type of question. (Maybe the dates tell the story, I don't know.)

Background: I was looking at CQG Integrated Client, which, granted, is far more expensive than Sierra Chart.

However, I am able to take their data and do my own analysis. For example, if I can set up an intraday chart using 4 weeks of data with a VWAP, a moving average, and a MACD in CQG IC, I could use Excel RTD functionality to draw the exact same chart in real time outside of CQG IC.

So is it possible to do this, i.e. access data, both realtime and historical, both equities and futures, in Sierra and use it for analysis outside of Sierra? It is possible with CQG IC.

Is it possible with Excel RTD? Is it possible with Python? Is it possible, but only with your ACSIL?

Are there any resources that you can point me to?

Honestly, and I regret to admit it, I would pay something additional for a new higher tier "Service Package" to be able to do this.

Thanks for your attention.
[2022-05-06 02:27:30]
Sierra_Chart Engineering - Posts: 18750
What you can do is use the Spreadsheet Study:
Using the Spreadsheet Study

And then use this Spreadsheet Study input to write the spreadsheet price and study data to a file periodically:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#PeriodicallySaveSheetAsTextInMinutes

And there is a way to read this automatically into Excel. Check with the Excel documentation for how to read a text file back into Excel when the file is updated.
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, use the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2022-05-06 02:31:53

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

Login

Login Page - Create Account