Export to Excel (indictors)

[akvevo]

Hi NT,

I am looking at a chart; CL 2000 ticks for instance, with indicators.
Is there a way to export these values to Excel ?

Thanks
AK

[NinjaTrader_ChelseaB]

Hello AK,

Thank you for your note.

To get information from an indicator to excel you would need to write that information to file from the indicator.

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

Or, you could add the indicators to a market analyzer and then export the grid contents.

http://ninjatrader.com/support/helpGuides/nt8/en-us/working_with_data_grids.htm

[akvevo]

Thanks Chelsea,

I am assuming that your second solutions will only allow me to get the 'current' value ?
If I wanted to export ATR historically for instance, I'd need your first suggestion - is that correct ?

Once I import SampleStreamWriter indicator, what actions do I need to do to export the data to excel ? I have added the sample indicator to a chart which results in a blank panel.

I see the following line in the sample:

path = NinjaTrader.Core.Globals.UserDataDir + "MyTestFile.txt"; // Define the Path to our test file

Am I correct in saying that this should be change to a local directory (destination) and NT8 will write the excel file once the Indicator script compiles ?

[NinjaTrader_ChelseaB]

Hello akvevo,

Yes, the export grid contents would be a snapshot of the current data.

To export historical values a custom coded indicator is needed.

The SampleStreamWriter is a sample that demonstrates the code necessary to write to a file.

This provides a learning tool so that you can use the same building blocks to create your custom indicator that writes values to file (in the format you choose).

For Excel, I would recommend a .cvs text file with values delimited by commas.

https://www.computerhope.com/issues/ch001356.htm

After importing to view the code of the SampleStreamWriter indicator

• Click New -> NinjaScript Editor
• On the right in the explorer pane double click the Indicators folder
• Double click SampleStreamWriter to open it

[akvevo]

Works a treat, thanks

[Angus7]

I'm new to NT8. Most other platforms I work with exporting data to excel is a very simple & a couple of clicks. Do you have a simple way to export to excel data from a chart (OHLC, a couple MA's)?

I installed the sample stream writer but I'm not a computer programmer, I am a trader.

Thanks in advance

[NinjaTrader_PaulH]

Hello Angus7,

Thanks for your reply.

There are no means within NinjaTrader to export chart data to excel. I will enter a feature request to add this capability to NinjaTrader8 and will update this thread when I have further information.

The sample steamwriter is a working example of how to code to output data from the chart to a file that can be read in excel. If you would like this customized for you, we can provide references to 3rd party coders who can provide coding services.

[Angus7]

Can you export to csv today?

[NinjaTrader_PaulH]

Hello Angus,

Thanks for your reply.

Today you can export from the Historical data manager to a text file that can be read into excel. This would be the data that NinjaTrader builds bars from. The historical data would be available in 1-tick, 1-minute or 1-day bar formats, please see: https://ninjatrader.com/support/help...?exporting.htm (Here is a link for importing data, I added because it explains the text file format we export to: https://ninjatrader.com/support/help...?importing.htm)

If you want to export a charts data, then you would have to use the samplesteamwriter that outputs only the OHLC data of the charts bars to a text file that can be read into excel.

As previously advised there is no built in means to export chart data and indicator data.
.

[Angus7]

Wow, that surprises me that you can't export data to excel. I've never run across that in any of the platforms that I currently use(I'm running 4 other trade platforms).

Thanks

[NinjaTrader_PaulH]

Hello Angus7,

The feature request to export chart data already exists so your vote was added to it. For your future reference the feature request is assigned as SFT-2077, "Add Export feature for Y-Axis values"

If/when the feature request is implemented, it will be listed in the Release notes of the version, which can be seen in the helpguide.

Thanks for your interest in improving our product.

[TheTrader1997]

Hello,

I really love the ninjatrader platform especially since the new order flow tools have been available. I would also like to export certain indicator data to excel and I am inquiring about the "Add Export feature for Y-Axis values". I am wondering if this feature has been implemented yet for ninja trader.

Thank you for your assistance

[NinjaTrader_Kate]

Hello TheTrader1997,

Thank you for your reply.

There is no current update on this particular request, SFT-2077. However, we are continuing to gather user votes for the request and it remains open.

As with all feature requests, interest is tracked before implementation is considered, so we cannot offer an ETA or promise of fulfillment. If implemented, it will be noted in the Release Notes page of the Help Guide.

Release Notes — https://ninjatrader.com/support/help...ease_notes.htm

Please let us know if we may be of further assistance to you.

[gtsouli]

Hello,

I would like to export, from NT8 to CSV or TXT file, the historical values of some indicators. Could you please show me how to proceed ?

I followed the steps you shared in the previous post :

https://ninjatrader.com/support/forum/forum/ninjatrader-8/indicator-development/100367-export-to-excel-indictors?p=794417#post794417

but I don't know which line(s) to customize in StreamWriter in order to get the historical values of my indicators, in different time frames.

Thank you in advance

[NinjaTrader_Kate]

Hello gtsouli,

Thank you for your reply.

You'd need to call the indicator within your script and then get the current value on each bar and add that to where it actually writes the line. I'm attaching a very simple modification of the SampleStreamWriter found in our help guide that calls a 14 period SMA and exports this value to a .csv file along with the Time, Open, High, Low, and Close prices.

Please let us know if we may be of further assistance to you.