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?

sleepy

sleepy 

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? sleepy

Yes, check here:
https://nexusfi.com/download/ninjatrader-7/misc/339-download.html?view

Mike

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.

This is where the ExportData code was left off. Not sure which version you have, but there was a bug fix that might have addressed that issue:

// 15 December 2010: ver 3.31 Minor bug fix where Open[0] data was not being output.

Hope it helps!

MXASJ 

This is where the ExportData code was left off. Not sure which version you have, but there was a bug fix that might have addressed that issue: // 15 December 2010: ver 3.31 Minor bug fix where Open[0] data was not being output. Hope it helps!

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?

With these settings...


..I get this output:


...and this is in the NinjaTrader Database:


(February 3rd is missing from the output)

Any suggestions appreciated!

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.

MXASJ 

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'.

 

Code

protected override void Initialize() { CalculateOnBarClose = 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.

Export NinjaTrader Prices to Excel - YouTube

THIS WAS VERY EASY WORKED GREAT!

HOPE IT WAS HELPFUL TO YOU FOLKS


BRIAN

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.

Thanks.