Exporting Performance Report to Excel

Questions about MultiCharts and user contributed studies.
mefTrader
Posts: 141
Joined: 23 Jun 2011
Has thanked: 9 times
Been thanked: 7 times

Exporting Performance Report to Excel

Postby mefTrader » 08 Nov 2011

I would like to be able to export performance reports directly to excel 97-2003? Currently they are saved in an unknown format and need to be forced "Save as 97-2003".

Is there a setting somewhere in MC that does this?

User avatar
Henry MultiСharts
Posts: 8521
Joined: 25 Aug 2011
Has thanked: 1213 times
Been thanked: 2741 times

Re: Exporting Performance Report to Excel

Postby Henry MultiСharts » 08 Nov 2011

Hello Sir.
Please let me know what version of MultiCharts are you running.
What file format do you have in "Save as" window of the Performance Report?
Please attach the screenshots.

mefTrader
Posts: 141
Joined: 23 Jun 2011
Has thanked: 9 times
Been thanked: 7 times

Re: Exporting Performance Report to Excel

Postby mefTrader » 08 Nov 2011

Mc 7.0 Beta 4 (Build 4344)

Save as type "Microsoft Excel WorkBork (*.xls)"

I need the option to save to "97-2003"

User avatar
Henry MultiСharts
Posts: 8521
Joined: 25 Aug 2011
Has thanked: 1213 times
Been thanked: 2741 times

Re: Exporting Performance Report to Excel

Postby Henry MultiСharts » 08 Nov 2011

"Microsoft Excel WorkBook (*.xls)" is the file type for Microsoft Office 97-2003.
If the file saved in this format is not opened by MS Office on your PC-you need to check the file type association setup in your Windows.

mefTrader
Posts: 141
Joined: 23 Jun 2011
Has thanked: 9 times
Been thanked: 7 times

Re: Exporting Performance Report to Excel

Postby mefTrader » 09 Nov 2011

Attached is the warning I get when I open the file after saving the performance report.

I am using EXCEL 2007 on this machine.

On another machine I am using a much earlier version of EXCEL '97-2003' but it does not recognise this format.

on this machine I have to forcibly save the file as '97-2003' format so that I can open it on the machine that has the older version of EXCEL i.e '97-2003'.
Attachments
XCEL.jpg
XCEL.jpg (36.98 KiB) Viewed 338 times

User avatar
Henry MultiСharts
Posts: 8521
Joined: 25 Aug 2011
Has thanked: 1213 times
Been thanked: 2741 times

Re: Exporting Performance Report to Excel

Postby Henry MultiСharts » 09 Nov 2011

MultiCharts saves the report in the .xlsx file format if you have MS Office 2007, 2010 installed on your PC.
The report is saved in the .xls file format if you have MS Office 97, 2003 installed on the PC.
If you have MC Office 2007 installed and you have saved the report (.xlsx)-you will need to "save as ms office 2003 (.xls)" this file manually on this pc to open it on the PC with MS Office 97/2003.


Return to “MultiCharts”