Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
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?
I've converted the indicator ExportChartData to a Strategy to make it easier to apply against a basket of instruments. Thanks to BigMike and Sam for some older comments and code that inspired this :).
Next releases will include enums to select various …
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:
I couldn't find any errors in the code, but I'm no NinjaTrader expert.
Thanks MXASJ, very much appreciated. However, with the latest version (24 February 2011) I still can't export the last data, so I assume I'm doing it myself wrong.
Who can give me some feedback on these settings - are they wrong?
I'm guessing its because I use that in the Strategies tab and enable/disable to export the data, and not as a backtest. It works fine here. Tested on ES 3/12.
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.
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[0].ToString("yyyy-MM-dd HH:mm:ss") + dataSeparator + Close[0] + EMA(14)[0]);
if (splitDateTime == true)
{
data = data.Replace(' ',dataSeparator);
}
sw.WriteLine(data);
break;
*********************
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.