How to manage the trades output from strategy optimization results

[J2512]

Hi all

I am creating a strategy and I have done the optimization, after that I can download a excel file with the trades from 10 best results, I mean a excel file from each one. My goal is to get access to those results and create an add on or external script to download all trades in an unique excel file. and of course, I would like to do the same from diferents optimizations.

Till now I have discovered that results from optimizations are stored in Documents\NinjaTrader 8\db\NinjaTrader.sdf.

But I do not know how to access to it and how to get the data from optimizations under study.

Any help will be welcomed.

Regards.

[NinjaTrader_ChelseaB]

Hello J2512,

There is not supported direct access to the database.

You would need to export the grids from the results.

The results are saved the Strategy Analyzer Logs if you need to re-open these.

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

[J2512]

Hi @NinjaTrader_ChelseaB

Thanks for your response. since I wrote my first message I have got access to the database but optimizations results are not stored in it. But once I run a optimization I can export trades results by clicking right mouse buttom,then those results are atored temporaly in some place/folder but i cannot find it, could you tell me where those data are stored?


My goal is to get trades results of each optimization iteration to be able analyze that in separate way and automate this process, then for my is Ok if I can get that by coding in the strategy or after optimization is done by another external script downloading the results automatically and create muy own database to analyze it.


Regards.

[NinjaTrader_ChelseaB]

Hello J2512,

The results are from running a backtest or optimization and are stored in memory, but the test parameters are saved in the Strategy Analyzer logs so these can be pulled again.

If you want the trades, then write these to file from the SystemPerformance.

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

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

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

[J2512]

Hi Chelsea

Thanks for your support!!!

Regards,