MultiCharts Easter Sale has jumped in! Up to 50% off Explore offers
+1 888 340 6572
MultiCharts Project Management
previous_open_issue.png
Go to the previous open issue
previous_issue.png
Go to the previous issue (open or closed)
star_faded.png
Please log in to bookmark issues
bug_report_small.png
Open Bug report MC-619

Incorrect file extension for Portfolio Performance Reports

action_vote_minus_faded.png
4
Votes
action_vote_plus_faded.png
next_issue.png
Go to the next issue (open or closed)
next_open_issue.png
Go to the next open issue
Description

When you save a Portfolio Performance Report, the Portfolio Backtester will save the PPR as a Microsoft Excel file, specifically using the ".xls" extension. However, Excel 2007 and Excel 2010 use a different etension for their native files, namely ".xlsx."
If you try to open such a file using Excel 2007 or Excel 2010, Excel will give you an error message stating that the file extension is incorrect: "The file you are trying to open, 'Portfolio Perfoamnce Report.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now? [OK] [Cancel]."
If you then click the "OK" button, the file opens fine. However, this problem also causes some other quirky/buggy behavior in Excel.
This same problem also occurs when saving a Strategy Performance Report using Multicharts.
I can fix this manually simply by changing the file extension to ".xlsx." However, it would be better if Multicharts could save files by default using the ".xlsx" filename, at least for machines that have Excel 2007 or higher installed.

Steps to reproduce this issue
  1.  Backtest a straegy using the Portfolio Backtester on a machine that is running Excel 2007 or Excel 2010.
  2.  Save the Portfolio Performance Report by clicking the "save" icon.
  3.  Double-click on the resulting file in Windows to open it in Excel.
  4.  Excel will give the error message above.
Comments (0)
History
Issue basics
  • Type of issue
    Bug report
  • Category
    Usability
  • Targeted for
    MultiCharts 7.2 (RELEASED)
  • Status
    Released
  • Priority
    Not determined
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
    0 subscriber(s)
    Click here to show the list of subscribers
Times and dates
  • Posted at
  • Last updated
Issue details
  • Reproducability
    Not determined
  • Severity
    Low
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