Export to EXCEL data on each firm in a portfolio of securities

[Steven Gold]

I have back-tested a portfolio of all DOW firms (30 firms in total) and want to Export to EXCEL the data for each firm in the portfolio. Is their a way to get all the data for each firm exported to EXCEL with doing it individually for each firm? Please help!!

[NinjaTrader_PaulH]

Hello Steven Gold,

Thanks for your post.

If you select the Dow 30 to analyze, the strategy analyzer will display a summary row for each of the 30 companies plus a combined line. By default not all fields available are shown. To show all available fields, right mouse click on the instruments summary and select "Grid" then "Properties". In the properties window "check mark" all the fields of interest. Then right mouse click again and select "grid" then "export to excel". I have attached an example with the grid fully populated with the dow 30 and all available fields.

Please let me know if I can be of further assistance

[Steven Gold]

Thanks so much. This is excellent!