Export my data in format Excel

[turbofib]

hi,..
i want to do it..
i want to export my data (i.e. High[0] of daily) in a file....
i want to read this file in excel

how i create this script ? thank

[NinjaTrader_PaulH]

Hello turbofib,

Thanks for your post.

Here is a link to a reference working example of exporting data to a text file that can be read by a spreadsheet program. You can use as is or modify as needed. The code is commented to help clarify its functionality. http://ninjatrader.com/support/forum...ead.php?t=3475

[turbofib]

i try it...but 've a problem...

See my pics

I print candle value but there is character bad

[NinjaTrader_PaulH]

Hello turbofib,

Thanks for your post.

To debug, add a print statement just above where you are sending the output to the file, have the print statement send the very same data to the output window. Open an output window (Tools>output window) and observe if you see the same characters.

[Rawheritage]

i have downloaded and imported the samplestreamwriter.
What do i do next?

Please help me

[NinjaTrader_PaulH]

Hello Rawheritage,

Thanks for your post and welcome to the forums!

Add the indicator "sample stream writer" to a chart, it will immediate write the data from the chart to a file in Documents>NinjaTrader8> called MyTestFile.txt

Remove the indicator from the chart when you have collected the needed info.

[abele]

There is still character bad?
javascript obfuscator

[Rawheritage]

Thanks for the quick reply.

I checked it and it works, but it does not include data from all indicators i am using. Is it possible to have to include all data from indicators?

[NinjaTrader_PaulH]

Hello Rawheritage,

Thanks for your reply.

Glad that you have it working.

The reference sample is just that a reference example of how to write data from the chart. You can certainly modify the example to output any information you wish. To include indicators data you would need to modify the code to add the indicator output to the output string of data in the reference sample.

For example, to include the data of a 20 period SMA, in line 50 you can change it from:

sw.WriteLine(Time[0] + " " + Open[0] + " " + High[0] + " " + Low[0] + " " + Close[0]);

to:

sw.WriteLine(Time[0] + " " + Open[0] + " " + High[0] + " " + Low[0] + " " + Close[0]+" "+SMA(20)[0]);

Once changed you would need to compile the indicator then remove the indicator from the chart and re-add to the chart to then generate the new data.

If you have different charts with different indicators you may have to change this several times or create copies, each matching the charts you wish to draw data from.

If you are unfamiliar with Ninjascript/C# programming, we can certainly provide you with links to educations resources to get you started. For you understanding, in the support department at NinjaTrader we do not create, debug, or modify code for our clients.

[Rawheritage]

Thanks!

I am having trouble with one indicator:

IndicatorX(color dncolor,int period, color upcolor)

I can not figure out how to code the color part.
Please help me out. Where can i read about out or maybe you have some examples?

thanks!

[NinjaTrader_AlanS]

Hello Rawheritage,

Thanks for your reply.

One of the changes that was made in the move from NinjaTrader 7 to NinjaTrader 8 was to replace the implementation of PlotColors for indicators with PlotBrushes - or more specifically, the Drawing.Color structure which was used to set various Color properties has been updated to now use the System.Windows.Media.Brushes class instead.

You can find more information on PlotBrushes here:
http://ninjatrader.com/support/helpG...lotbrushes.htm

You can view any code breaking changes in our help guide here:
http://ninjatrader.com/support/helpG...ebreakingtable

Please let me know if I may be of any further assistance.

[StockJock]

Is there a video tutorial for using Stream Writer to export IEOD data from NinjaTrader? Can it export IEOD data when NT is connected to TD Ameritrade?

[NinjaTrader_AlanS]

Hello StockJock,

We do not have any video tutorials going over this specific item.

You will be able to export historical data that is recorded from your TDAmeritrade connection with a StreamWriter.

Here is a link to the StreamWriter reference sample:

https://ninjatrader.com/support/foru...ead.php?t=3475

Please let me know if I may be of any further assistance.