Statistical Data

[kaywai]

Hi,

I am able to generate data from my indicator code which is sufficient for me to form a sample for statistical purposes.

The problem I have is how can I store this data as it is being generated so that I can export it to Excel for further manipulation. Some of the data I would like to store include the Timestamp, and the range of a series of bars.

Any suggestions?

Regards

Kay Wai

[NinjaTrader_Bertrand]

Kay, you could for example use System.IO and write the data to a text file that Excel could import then - http://www.ninjatrader.com/support/f...ead.php?t=3477

[kaywai]

Hi Bertrand,

The code seems rather completed for my level of understanding especially when you can save the data from the output window and open it in excel. The problem I have is that it is showing up in Excel like:-

12/31/2010 16:51
BSsetuprange is0.0038
1/1/2011 1:15
BSsetuprange is0.0028
1/1/2011 2:21
BSsetuprange is0.0056
1/1/2011 3:27
BSsetuprange is0.0028

when what I would like is this:-

12/30/2010 10:30 BSsetuprange is0.0012
12/30/2010 15:54 BSsetuprange is0.0017
12/30/2010 20:00 BSsetuprange is0.0017
12/31/2010 0:00 BSsetuprange is0.0041

Other than cutting and pasting the cells individually, could you tell me how I achieve the latter result?

Regards

Kay Wai

[NinjaTrader_Bertrand]

Right, it would depend on your preferences and needs, you can certainly also manually copy it over if you don't wish to get into coding at that level - the exported data would need to be reformatted in Excel according to your needs.

For a direct link to Excel, you can check into this thread from a fellow user here :

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