+1 888 340 6572
MultiCharts Project Management
Go to the previous open issue
Go to the previous issue (open or closed)
Please log in to bookmark issues
Open Feature request MC-679

Saving and loading optimization reports

Go to the next issue (open or closed)
Go to the next open issue

I have two feature requests that are related to MC-678. Both relate to the option to save optimization reports in Portfolio Backtester. I.e.,

First, it would be great if saved optimization reports could contain more information about what optimization this relates to. Currently, an optimization report in .csv format only contains a generic title (e.g., "Report_2011-10-28_16-13-06.csv"), and no information about what portfolio was backtested or the particular input parameters. I'll often look at an optimization report and ask myself, "how did I get these results?"

It would be ideal if you could include some information into the optimization report about the portfolio used and the inputs and other variables used. E.g., the filename could be based on the name of the portfolio (e.g., "BollingerBand Uptrend 2011-10-28_16-13-06.csv" for a portfolio called "BollingerBand Uptrend.pws"). You could embed additional information into the file about the entry and exit signals, the "begin" and "end" values for the inputs, the properties of the portfolio (e.g., the trade size), and similar information. This could be prepended to the start of the file, which would still allow Microsoft Excel or another program to open the .csv file and see the other data.

Second, it would be great if there were a way to load performance reports back into Portfolio Backtester. That way, I wouldn't have to run the same optimization a second time just to see the performance report again in MultiCharts (rather than Excel).

Steps to reproduce this issue

See above.

Comments (3)
user-offline.png  Xyzzy (Xyzzy)
Oct 28, 2011 - 19:39

As an additional note concering the second request, it would be great if the CSV file could be loaded back into the Portfolio Backtester. That way, the user wouldn't have to save the performance report in two separate formats -- CSV and something else.

user-offline.png  EdL (EdL)
Mar 31, 2013 - 09:59

This would be very useful. Surprised it wasn't implemented staright up. Would save re-running the optimizsation or having to load the report in excel

user-offline.png  Xyzzy (Xyzzy)
Oct 01, 2014 - 18:37

I like Guest's suggestions. Perhaps there could be a checkbox like "show unoptimized variables." If checked, then the optimization report would show columns for all of the variables -- including the fixed values for the unoptmized variables. Alternatively, there could be a single column for each signal that contains all of the inputs in a compact string representation, e.g.: "10, 2, 5" for input1 = 10, input2 = 2, input3 = 5.

Issue basics
  • Type of issue
    Feature request
  • Category
  • Targeted for
    Not determined
  • Status
    Under Review
User pain
  • Type of bug
    Not triaged
  • Likelihood
    Not triaged
  • Effect
    Not triaged
Affected by this issue (3)
People involved
  • Posted by
    user-offline.png  Xyzzy (Xyzzy)
  • Owned by
    Not owned by anyone
  • Assigned to
    Not assigned to anyone
  • Subscribers
    2 subscriber(s)
    Click here to show the list of subscribers
Times and dates
  • Posted at
  • Last updated
Issue details
  • Resolution
    Not determined
  • Severity
Attachments (0)
There is nothing attached to this issue
Commits (0)
There are no code checkins for this issue
Duplicate issues (0)
This issue does not have any duplicates