NexusFi: Find Your Edge


Home Menu

 





Export Overnight Data from Sierra Chart to Excel


Discussion in Sierra Chart

Updated
      Top Posters
    1. looks_one Sawtooth with 1 posts (0 thanks)
    2. looks_two johnbarrry with 1 posts (0 thanks)
    3. looks_3 mudry with 1 posts (0 thanks)
    4. looks_4 chasepatrol with 1 posts (0 thanks)
    1. trending_up 1,060 views
    2. thumb_up 0 thanks given
    3. group 4 followers
    1. forum 2 posts
    2. attach_file 0 attachments




 
Search this Thread
  #1 (permalink)
 chasepatrol 
Bremen, Germany
 
Experience: Intermediate
Platform: Sierra Chart
Broker: AMP/CQG
Trading: ES, FDAX
Posts: 35 since Jan 2023
Thanks Given: 37
Thanks Received: 39

Hey guys,

I'll try to expert chart / price and study data from Sierra Chart to Excel. Basically I need things like OHLC, IB High, IB Low, IB Mid, VPOC, etc in Excel.
I figured out how to do that with the function built in Sierra Chart via "Edit > Export Bar and Study Data to Text file". I figured out how to set the candle period to get all data of a RTH session (in ES or FDAX for example). That works great.

I now want to compare the RTH data with the previous overnight session data. Therefore I need to export the overnight data. But I simply can not figure out how to do that / how to set up the session times correctly.
If I just set the session times to overnight times and then adjust the bar period accordingly it gives me not the correct data. For example it gives me data from Sunday to Monday Morning in a line and so on.

Do you have any idea how to correctly get the data for each and every overnight session?


Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
CME Launches Bitcoin Volatility Futures June 1 -- First …
Cryptocurrency
Thanks Mike. Godspeed.
The Elite Circle
Topstep Acquires The Futures Desk -- Prop Firm Consolida …
Funded Trading Evaluation Firms
After $87M Settles NO: Irans Nuclear Redline Sets Up the …
Prediction Markets & Event Contracts
Probability Collapse: Bitcoin $150k Craters from 15% to …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Big Mike in Ecuador
205 thanks
Sober Journey With S&P
21 thanks
30 Sessions
20 thanks
Volume Indicators
8 thanks
Thanks Mike. Godspeed.
7 thanks
  #2 (permalink)
 johnbarrry 
South Africa
 
Experience: None
Platform: ninja
Trading: zn
Posts: 7 since Nov 2013
Thanks Given: 0
Thanks Received: 1


chasepatrol View Post
Hey guys,

I'll try to expert chart / price and study data from Sierra Chart to Excel. Basically I need things like OHLC, IB High, IB Low, IB Mid, VPOC, etc in Excel.
I figured out how to do that with the function built in Sierra Chart via "Edit > Export Bar and Study Data to Text file". I figured out how to set the candle period to get all data of a RTH session (in ES or FDAX for example). That works great.

I now want to compare the RTH data with the previous overnight session data. Therefore I need to export the overnight data. But I simply can not figure out how to do that / how to set up the session times correctly.
If I just set the session times to overnight times and then adjust the bar period accordingly it gives me not the correct data. For example it gives me data from Sunday to Monday Morning in a line and so on.

Do you have any idea how to correctly get the data for each and every overnight session?

You may want to try and setup a Sierra spread sheet using "Fractime" and "Trunc" to select required dates and times that you require, and then export only that data. "=if(and(Trunc($A3)>$H$35,Fractime($A3)>$H$27,Fractime($A3)<$H$28),1,0) " H35 = Start date Time between H 27 and H 28


Reply With Quote
  #3 (permalink)
 Sawtooth 
Prescott AZ USA
 
Experience: Advanced
Platform: SierraChart
Broker: EdgeClear, FCM:Phillip, Data:Denali, Routing:Teton
Trading: YM RTY ES NQ
Posts: 480 since Nov 2009
Thanks Given: 222
Thanks Received: 608



Quoting 
Do you have any idea how to correctly get the data for each and every overnight session?

- Add a chart with only the overnight Start Time and End Time.
- Add an instance of the Study/Price Overlay study for each study you need from the RTH chart.


Reply With Quote




Last Updated on November 27, 2023


© 2026 NexusFi®, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Downloads - Top
no new posts