Login Page - Create Account

Support Board


Date/Time: Sun, 25 May 2025 13:19:00 +0000



How to export Price Data and Studies in Excel

View Count: 4917

[2019-11-01 15:52:46]
babatunde yusuf - Posts: 2
Hello,

I want to export price data and volume at price studies into excel spreadsheet for further analysis but do not know how to export data in excel. Any assistance will be appreciated.
[2019-11-02 12:42:10]
Sierra Chart Engineering - Posts: 104368
Refer to the following for exporting Price data:
Edit Menu: Procedure to Export Bar Data for Use in Spreadsheet Programs

Without using ACSIL and creating a custom study, the only way to get Volume by Price data is to use the Spreadsheet Study and turn on the option for Output Volume at Price Data. Refer to the following:
Spreadsheet Study Inputs: Output Volume at Price Data

You can then export the Spreadsheet data. Refer to the following:
Spreadsheet Studies Special Tasks: Exporting Sheet Data Containing Price and Study Data to Text File
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
[2023-05-28 21:24:21]
User906368 - Posts: 5
Just as a follow up question here, how can I download daily open and close data for futures?
[2023-05-29 08:36:20]
Sierra_Chart Engineering - Posts: 19695
This happens automatically when you open a Historical Daily Chart:
Getting Started, Opening Charts and Basic Trading: Open A Chart

There is nothing special to do.
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
[2023-05-30 02:36:41]
j4ytr4der_ - Posts: 947
Consider also that depending on what you are trying to do, you may not need Excel or any external spreadsheet program at all. I've done numerous types of analysis directly in SC using the Spreadsheet System for Trading study, which then allows me to have the whole thing running on live data, or on any historical period I want to see, without messing with any export/import at all. It's quite nice.

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

Login

Login Page - Create Account