Export Detailed Equity Curve Values from Optimization Report

Hi,

I would like to run an optimization and somehow have the "detailed" or mark-to-market equity curves from each result of the optimization exported or written to an excel file.

I would like to do some additional analysis of the equity curves and need an easy way to get this into excel. At the moment I know of no easy way to do this. There might be 50 equity curves or 500. It all depends.

Is there some code that can be written to accomplish this? Or is there another way that I am not aware of?

Hi trader0311,

afaik, there is no straightforward way to do what you are trying to do, but there are workarounds. Here is what I would do:

make sure you have ELCollections installed.

create a MapNN like this: fill the map in your code like this: write the map to disk like this: This code will create a CSV file with the date in the first column and the equity in the second column, which you can load into Excel. You will probably want to make sure that you assign different file names for every set of parameters, I leave that exercise to your imagination.

All the best, Felix

Thank you so much for your help. I will look into this method and make sure I have the necessary ELCollections installed.