Printing to an excel file or CSV

[burtoninlondon]

Hello,

I want to be able to monitor and log my account PnL so that I can track the performance of a portfolio of strategies.

I have created the strategy below which prints this message to the NinjaScript Output window every 5 minutes.

 protected override void OnBarUpdate()
        {
            Print("Time : " + Time[0] + ", Pnl : " + Convert.ToString(Account.Get(AccountItem.RealizedProfitLoss, Currency.UsDollar) + Account.Get(AccountItem.UnrealizedProfitLoss, Currency.UsDollar)));
        }​

I then am able to manually copy the text in the NinjaScript Output window and paste into Excel.

My question is...is there a way to automate this process so that every 5 minutes the print statement is appended to a new line in an excel file?

If so, do you have any examples?

Thanks,

Neil

[NinjaTrader_Gaby]

Hello Neil,

Thank you for your post.

It is possible to write information to a csv file using StreamWriter.

https://ninjatrader.com/support/helpGuides/nt8/using_streamwriter_to_write_to.htm

Please let us know if you have any further questions.

[burtoninlondon]

Thanks NinjaTrader_Gaby, I'll take a look.

Do you know if it is possible to access historical unrealized PnL values? I know you can access MAE & MFE values in a Strategy Analyzer backtest but it would be interesting to know if you can access unrealized PnL values, perhaps each time OnBarUpdate is run in the backtest.

Thanks,

Neil

[NinjaTrader_Gaby]

Hello,

You can use GetUnrealizedPnL() in backtest.

https://ninjatrader.com/support/helpguides/nt8/position_getunrealizedprofitloss.htm

Please read the note in the Help Guide regarding how to use in backtest.