Exporting data indicator to Excel

[gravdigaz6]

Hello, first excuse me for my English,
I would like to export data from the swing Price Action Indicator of NT to Excel:
in particular, the coordinates of the three points that form the wave ABC for points A, B, C price and corresponding time.
Then I would have the entry point corresponding to the close of the candle designated by the arrow of the input signal; the price of the VWAP of the SD4, sd3 bottom and up, the ATR 14 and volume.
I tried by myself I know it's possible to do but it is a little more complex for the coordinates of ABC points.

thank's.

[NinjaTrader_CalH]

Hello,

Thank you for your note.

Exporting to Excel is not supported with NinjaTrader.

However, you would need to include a reference to the Microsoft.Interop.Excel.Dll in the script.
This will allow you to open a new workbook or existing one and write data to it.

Let me know if I can be of further assistance.

[gravdigaz6]

Hello,

Thank you for your note.

Exporting to Excel is not supported with NinjaTrader.

However, you would need to include a reference to the Microsoft.Interop.Excel.Dll in the script.
This will allow you to open a new workbook or existing one and write data to it.

Let me know if I can be of further assistance.

yes I did it, but then I do not know how to process to write the data that i want to export in excel.
Is there a video training to do that or something else?

[NinjaTrader_CalH]

Hello,

You can view the link below on how to use this with in C# programming -
http://msdn.microsoft.com/en-us/libr...(v=vs.80).aspx

[arbuthnot]

Hello, first excuse me for my English,
I would like to export data from the swing Price Action Indicator of NT to Excel:
in particular, the coordinates of the three points that form the wave ABC for points A, B, C price and corresponding time.
Then I would have the entry point corresponding to the close of the candle designated by the arrow of the input signal; the price of the VWAP of the SD4, sd3 bottom and up, the ATR 14 and volume.
I tried by myself I know it's possible to do but it is a little more complex for the coordinates of ABC points.

thank's.

Hi gravdigaz6

I've often taken data over from Ninja into Excel without doing any formal 'exporting' as such.

What I do is 'print' the data I need into the Output Window and then copy it over into an Excel worksheet.

What you'll have is just one column, which may be a mixture of three different columns of data. (For example, you may have: Open[0], Close[0], and EMA (20)[0].)

You 'extract' the different lines of data by using an Excel function such as LOOKUP function. More precisely:

in col A, put the whole numbers: 1,2,3...

in col B, paste the data

in col C, a function like: =LOOKUP(3*$A2-2,$A:$A,$B:$B)

in col D, a function like: =LOOKUP(3*$A2-1,$A:$A,$B:$B)

in col E, a function like: =LOOKUP(3*$A2,$A:$A,$B:$B)

This will split the data into the number of columns you require.

You may be a world-class Excel expert, but if you need any further help, please let me know!

Hope it all works out.

[Baruch]

or you can use my strategy:

https://www.bigmiketrading.com/download/ninjatrader-7/strategies/1372-download.html?view

[elliot5]

Is this the same code that dinoysus has been distributing? I have had trouble getting that to work....