Exporting historical data NT7 to excel (contract rollover?)
I wish to view the daily OHLC and Volume for CL for past 12 months so I can maually track changes in Range etc, - similar to how mypivots does this daily (NYMEX Light Sweet Crude Oil February 2012) . I presume I can achieve this using Ninjatraders export historical data manager to dump this info. into a .csv file and then into excel.
Has anyone done this before, or track this info. on a regular basis?
And if so how do you allow for contract rollovers?
The following user says Thank You to sleepy for this post:
Due to time constraints, please do not PM me if your question can be resolved or answered on the forum.
Need help? 1) Stop changing things. No new indicators, charts, or methods. Be consistent with what is in front of you first. 2) Start a journal and post to it daily with the trades you made to show your strengths and weaknesses. 3) Set goals for yourself to reach daily. Make them about how you trade, not how much money you make. 4) Accept responsibility for your actions. Stop looking elsewhere to explain away poor performance. 5) Where to start as a trader? Watch this webinar and read this thread for hundreds of questions and answers. 6) Help using the forum? Watch this video to learn general tips on using the site.
If you want to support our community, become an Elite Member.
The following 6 users say Thank You to Big Mike for this post:
How can I export the data including the last date with the ExportData strategy? For example, the current last date in the database is 27th January, however if I apply the ExportData strategy till January 30th, the last exported date is January 26th. In other words, the last date doesn't get written by the strategy.
It's has been a while since I used NinjaTrader, so I might be doing it wrong.
I have these settings with the ExportData strategy:
Please register on futures.io to view futures trading content such as post attachment(s), image(s), and screenshot(s).
I couldn't find any errors in the code, but I'm no NinjaTrader expert.
Thanks MXASJ, that was it! I noticed that, in the 'strategy applied to chart' window, the CalculateOnBarClose had to be set to 'false' to export the last date (otherwise the result was the same as in the Strategy Analyzer), so I changed the ExportDate line CalculateOnBarClose to 'false'.
Now it also exports the last values in the Strategy Analyzer, meaning that the ExportData strategy can be applied to a whole list of instruments at the same time.
Thanks for your help MXASJ, and for creating the strategy in the first place off course.
The following 2 users say Thank You to Jura for this post:
I was wondering if anyone is using this great tool to export indicator data?
I'm working with this section of the code:
//This is the best place to modify the code to output indicator data if required.
string data = (Time.ToString("yyyy-MM-dd HH:mm:ss") + dataSeparator + Close + EMA(14));
if (splitDateTime == true)
data = data.Replace(' ',dataSeparator);
Does anyone have working examples of how this code can be adapted to export indicator data? The EMA example provided above is not working for me. I'm curious if others have managed to get it working for them.