Exporting Price and Indicator Data from chart

[StevenV]

Does anybody know how I can export both the price data and what every indicators I have on my chart to a text file so I can then import it into Excel.

Thanks, Steven

[VTtrader]

We have an "export mode" for our databox add-on that does this. Currently it's bar by bar based on a mouse click, but an upcoming version will have more flexibility. http://integratedtradingtech.com/

VT

[StevenV]

Thanks for the reply VTtrader...but I need to be able to export all of the data loaded on the chart at once.

Does anyone else know how I can do this...

Thanks

[NinjaTrader_AdamP]

StevenV,

You would need to do this yourself using custom indicators/ etc.

Here are some reference samples :

http://www.ninjatrader.com/support/forum/showthread.php?t=3475

http://www.ninjatrader.com/support/forum/showthread.php?t=3477

Please let me know if I may assist further.

[koganam]

Thanks for the reply VTtrader...but I need to be able to export all of the data loaded on the chart at once.

Does anyone else know how I can do this...

Thanks

You will need to use a StreamWriter to write your data to a file.

OHLC values come from the respective DataSeries. For the indicator values, you will have to iterate through the ChartControl.Indicators[] array, and output their values.

[StevenV]

Hi Koganam,

I am not a programmer and do not know how to do this. Do you anybody who can do this quickly?

Thanks, Steven

[exy2000]

Hi,

I also would be interested in getting an app that could dump all the data (OHLC and custom indicator values) off a chart into a text or csv file.

Cheers
Chris

[stockgoblin]

Hey Koganam,

By any chance have you expanded this idea to create an export indicator for separate analysis?

[koganam]

Hey Koganam,

By any chance have you expanded this idea to create an export indicator for separate analysis?

Unfortunately no: all I did was explain the concept of how to go about it.

[stockgoblin]

Hey Kog,

Ninjatrader_Matthew and I completed one today and now I can export batch instruments in Weekly timeframe through the Market Analyzer. Saves me hours and hours. Kick ass.

Thanks anyway!

[Baruch]

Hey Koganam,

By any chance have you expanded this idea to create an export indicator for separate analysis?

I did it. I put it in BMT strategy download.

Baruch

[Farmer George]

Hey Kog,

Ninjatrader_Matthew and I completed one today and now I can export batch instruments in Weekly timeframe through the Market Analyzer. Saves me hours and hours. Kick ass.

Thanks anyway!

How did you do that? Thanks.

[arbuthnot]

Just seen this thread.

All I can add is that I've exported a lot of data (price and indicator levels) from NT to Excel through the expedient of printing to the Output Window, via Notepad and Word (to change things like paragraphs (^p in Word 'Replace') into tabs (^t in Word 'Replace'), then into Excel.

The analysis Excel can then undertake far exceeds anything NT can do on its own, for someone who knows quite a bit about Excel and is not a Master of NT.

[Farmer George]

Just seen this thread.

All I can add is that I've exported a lot of data (price and indicator levels) from NT to Excel through the expedient of printing to the Output Window, via Notepad and Word (to change things like paragraphs (^p in Word 'Replace') into tabs (^t in Word 'Replace'), then into Excel.

The analysis Excel can then undertake far exceeds anything NT can do on its own.

Thanks for that.How did you get the indicators values to the Output Window?

[arbuthnot]

Thanks for that.How did you get the indicators values to the Output Window?

Hi George

I've just tested this so I know it works:

This is example of a line of code (for either inds or strats) that prints to the output window the EMA at each bar close:

Print(EMA(14)[0]);

This may output to many decimal places. These can be shortened using the ROUND function in Excel, which can truncate to as many decimal places as you wish.