NexusFi: Find Your Edge


Home Menu

 





Export Overnight Data from Sierra Chart to Excel


Discussion in Sierra Chart

Updated
      Top Posters
    1. looks_one mudry with 1 posts (0 thanks)
    2. looks_two chasepatrol with 1 posts (0 thanks)
    3. looks_3 Sawtooth with 1 posts (0 thanks)
    4. looks_4 johnbarrry with 1 posts (0 thanks)
    1. trending_up 1,339 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?
[WTS] ATAS Lifetime ULTRA license – EU buyers only – …
Platforms and Indicators
My Rant with AMP Futures
Trading Reviews and Vendors
EA
Platforms and Indicators
I developed a free AI-powered (Kronos) forecasting indic …
The Elite Circle
requesting .nrd replay files from 2026 spy and qqq
The Elite Circle
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Would you consider buying or leasing an algo?
6 thanks
Trading Journal (Neural Network Production Pipeline Mode …
4 thanks
Trading psychology articles
4 thanks
Big Mike in Ecuador
3 thanks
The Scalpers Journey
2 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