Exporting performance results?

[JS999]

I am pretty sure that this is not already part of the program, but if I missed it please let me know. I am wondering how hard it would be to program in a simple export of trading results to a .csv file, for use in Excel. Basically, it would be the information that you would find if you just clicked on the Trades tab in the Account Performance section... in essence, a listing of each trade, what price it occurred at, commission calculations, and so on. Your code is already doing all of that calculation to show the information on the page, we now just need a routine to write it line by line to a .csv file so we can get our performance information out of the database if we want to store and manipulate it in Excel. It would be nice to be able to export the executions as well, and the summary section.

Basically, I am thinking that you just include an "export" button on each relevant tab (Trades, Executions, Summary, etc.) that pops up a dialog and asks you to specify a name for a .csv file, and then proceeds to write all the information currently displayed on the page to that file line by line. Would this be possible?

[NinjaTrader_Dierk]

How about Right click on grid->Grid-> export to Excel?

[JS999]

How about Right click on grid->Grid-> export to Excel?

Excellent! This is exactly what I was looking for. Of course, it might be good to place a button somewhere up top that also brings up this menu, just to let people know that it exists. It never occurred to me to right-click on the grid to get to this functionality - normally one would expect to see this as a menu item or some in some other obvious place. But thanks, it appears to do the job.

Since we're on the topic, I can report a bug that has existed in 6.5 and still exists in NT 7 related to this page. If you place some trades in instrument A, then go to the Trades tab, you will see them show up. However, if you then switch to instrument B and place some more trades, you will not see those results show up in the tab right away (i.e. it will be as though they were not recorded). In order to see the trades for the new instrument, you have to click away from the "Account Performance" tab first, then click back to it. In that case, the second instrument's results will now be there.

It has to do with the second instrument not being added to the Instruments list under the Advanced section on the Account Performance tab until you first click away from it and then reload it. It's a minor bug, but you can check it out.

[NinjaTrader_JoshP]

JS999,

Thank you for the report. We will look into it.

Edit: This is expected since the only switching the tabs will refill the boxes.