Support Board
Date/Time: Mon, 21 Apr 2025 23:36:08 +0000
Data export to excel, limited to RTH
View Count: 143
| [2025-02-09 21:07:31] |
| DODSurf - Posts: 14 |
|
Hello, Would it be possible in Sierra Chart to: 1. Export RTH data (no Globex) for multiple charts to an excel Looking to report Open High Low and Settlement (OHLS) restrcited to RTH. Examples Silver, report only OHLS Regular Trading Hours (RTH 8:25a-1:25p) Gold would be 8:20 to 1:30 2. Even better, maintain historical data(previous days) in to that local excel file, allow older data to persist and do not overwrite I noticed the Quote Board doesn't seem to allow filtering out Globex data to show RTH-only Open/High/Low values. I see several export data options but am not sure which to focus on, or would a study be better for this. Thank you |
| [2025-02-09 23:15:09] |
| Sierra_Chart Engineering - Posts: 19290 |
|
The first thing to do is to set the chart to the regular trading hours through the Session Times: Chart Session Times This can only be done through an Intraday chart. However, when using Intraday chart data you will not get the official settlement price. And then use this study: Write Bar Data to File So do this for each chart where you want to automatically have data exported. 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 |
To post a message in this thread, you need to log in with your Sierra Chart account: