Questions about exporting data to Excel

[Stoop]

Hi,

I'm trying to make a strategy analyzer that is more suitable for the current strategy I'm running. However I have a couple of problems that I was hoping someone could help me with.

Basically I'm exporting data from NT to Excel and I am having a very hard time trying to find the right way of finding certain values:

- Cumulative profit by period, like the values you see under the "Periods" tab in Strategy Analyzer.

- Entry price of first trade

- Exit price of last trade

Also I have a question regarding how NT runs a backtest when I test multiple instruments. Does it run through one instrument at a time, or does it run through all of them at the same time bar by bar? I'm guessing its the first one, but I just have to be sure.

Is there any way to differentiate between the different instruments while it is backtesting? I'm asking because if I don't manage to differentiate between the instruments I will just see the last instrument NT tested in Excel.

Hope I made the questions understandable.

- Stoop

[NinjaTrader_Joydeep]

Hello Stoop,
You can use the TradeCollection class to find the trades. To get the first and last trade please use the below code snippet.

Trade t = this.Performance.AllTrades[0];
Trade t1 this.Performance.AllTrades[this.Performance.AllTrades.Count - 1]

http://www.ninjatrader.com/support/helpGuides/nt7/index.html?tradecollection.htm

Yes, NinjaTrader runs one instrument at a time if you are backtesting a list of instruments.

You can use the Instrument class to do it. Please refer to our help guide to know more

http://www.ninjatrader.com/support/helpGuides/nt7/index.html?instrument.htm

[Stoop]

Thank you very much!