+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
feature_request_small.png
Open Feature request MC-1100

Exporting to Excel a Portfolio Performance Report

action_vote_minus_faded.png
10
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

There is a need to be able to choose which data sheets are exported to excel.
A porfolio of 470 symbols takes about 2 hours to export because of all the calculations
need to do the "Correlation Analysis sheet" and others. In tradestation you can choose
what data you want exported to excel.
 
I just need the Performance Summary, Trade Analysis  and Equity Curve charts. All the
other things are not needed for preliminary research.
 
Also, It would be great if the settings info contained the inputs used for the signals and the money management rules.
 
I am running a MacPro using Bootcamp with Windows 7 (64bit) and MC (64 bit) with 8 Gigs of Ram.

Steps to reproduce this issue

Run a portfolio of 470 symbols over 14 years and save it to excel.

Comments (5)
#0
user-offline.png  DaveW (DaveW)
Jun 26, 2013 - 05:44

When the design for this is considered, please consider:
* allowing a 'text only' export of all data to CSV
* using a more efficient method of writing to excel (or to a CSV for text-only export). The current process is unbelivably slow considering all of the metrics have already been generated when the export is initiated. I can only guess that is because the current export routines are designed in a very inefficient way to allow the graphics to be exported into Excel. An export of a 3 - 5 MB CSV file (or an Excel file using a more efficient method of writing the file) should take seconds.
Also, agree the settings and inputs should absolutely be exported.

#0
user-offline.png  Xyzzy (Xyzzy)
Jul 24, 2013 - 14:30

The "Agree Completely" comment was from me. (I didn't realize that I wasn't logged in.)

#0
user-offline.png  FastLane (Enalmada)
Jul 17, 2014 - 20:17

A configuration tab for performance summary under the settings are so we could select more or less would be very convenient.

#0
user-offline.png  MultiCharts Support (MultiCharts)
Sep 12, 2014 - 05:54

In MultiCharts 9.1 we will add ability of skipping the export of "List of Trades" data for reducing the total export time.

#0
user-offline.png  MultiCharts Support (MultiCharts)
Oct 02, 2014 - 01:20

No workarounds are required. In MultiCharts 9.1 you will be able to select which tabs to include in the export file. I.e. that will be possible to export "List of trades" only.

History
Issue basics
  • Type of issue
    Feature request
  • Category
    Performance
  • Targeted for
    MultiCharts 9.1 (RELEASED)
  • Status
    Released
User pain
  • Type of bug
    Not triaged
  • Likelihood
    Not triaged
  • Effect
    Not triaged
Affected by this issue (2)
People involved
Times and dates
  • Posted at
  • Last updated
Issue details
  • Resolution
    Not determined
  • Severity
    Normal
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