NexusFi: Find Your Edge


Home Menu

 





Export Overnight Data from Sierra Chart to Excel


Discussion in Sierra Chart

Updated
    1. trending_up 274 views
    2. thumb_up 0 thanks given
    3. group 3 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?
Help re translation of ninjascript to EL
NinjaTrader
Elite Trader Funding, Avoid?
Funded Trading Evaluation Firms
Historical data for Kospi and Nikkei Index
NinjaTrader
is there a better Trade Performance tool for NinjaTrader?
NinjaTrader
Brendt Skorupinsky
Trading Reviews and Vendors
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
ApexTraderFunding.com experience and review
84 thanks
What is Markets Chat (markets.chat) real-time trading ro …
53 thanks
HumbleTraders next chapter
42 thanks
1 Minute Man
21 thanks
Tao te Trade: way of the WLD
17 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: Stage5, FCM:Dorman, Data:Denali, Routing:Teton
Trading: YM ES NQ
Posts: 474 since Nov 2009
Thanks Given: 222
Thanks Received: 603



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


© 2024 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 - Privacy Policy - Sitemap - Downloads - Top
no new posts