BackTesting Problem [SOLVED]
BackTesting Problem
Backtesting signal no longer writes to excel. This problem started with 8.5 RC but I thought it was because I missed setting the steps correctly because you changed that format. Now it doesn't write at all. I wish you would not have changed it - it was fine the way it was. Any suggestions?
DLL's not being called in version 6777
Watching Process Explorer I can see that there are no dll's actively being called during the optimization process. Likely the reason for no writes to excel.
- TJ
- Posts: 7743
- Joined: 29 Aug 2006
- Location: Global Citizen
- Has thanked: 1033 times
- Been thanked: 2223 times
Re: BackTesting Problem
suggestion: go back to the version that works.Backtesting signal no longer writes to excel. This problem started with 8.5 RC but I thought it was because I missed setting the steps correctly because you changed that format. Now it doesn't write at all. I wish you would not have changed it - it was fine the way it was. Any suggestions?
unless you need the new features in the new version, my policy is: don't fix anything that ain't broke.
- furytrader
- Posts: 354
- Joined: 30 Jul 2010
- Location: Chicago, IL
- Has thanked: 155 times
- Been thanked: 217 times
Re: BackTesting Problem
In the past, there were a few problems with how MC writes to Excel:
1) It saves the Excel file with an ".xlsx" extension but that's not the correct format. It's really ".xls"
2) If you don't have the application "excel.exe" on your computer (which can happen with newer versions of MS Office), it won't work - even if you have Excel on your computer. I actually had to buy an old copy off of Ebay (Office 2003) to get it to work, even though I have office 2010 on my computer as well.
This may have been fixed in later versions.
1) It saves the Excel file with an ".xlsx" extension but that's not the correct format. It's really ".xls"
2) If you don't have the application "excel.exe" on your computer (which can happen with newer versions of MS Office), it won't work - even if you have Excel on your computer. I actually had to buy an old copy off of Ebay (Office 2003) to get it to work, even though I have office 2010 on my computer as well.
This may have been fixed in later versions.
- Andrew MultiCharts
- Posts: 1587
- Joined: 11 Oct 2011
- Has thanked: 931 times
- Been thanked: 559 times
Re: BackTesting Problem
Please provide us with the script sample and the .dll file to let us study the issue.
Re: BackTesting Problem
I'm confused by the statement:
MultiCharts used to save these in ".xls" format. I submitted a bug report about this some time ago, and the format was changed to ".xlsx." See this link:
http://www.multicharts.com/pm/viewissue ... _no=MC-619
Unfortunately, it seems that MultiCharts has reverted this back to ".xls" in the latest release of MultiCharts 8.5. I hope this can be fixed again, and changed back to ".xlsx."
The ".xls" format is an older format. The correct format for Office 2007 and higher is ".xlsx." If the performance reports are saved in ".xls" format, then they give a warning message before they're opened in modern versions of Excel. See the attached screenshot for an example (taken from Excel 2013).It saves the Excel file with an ".xlsx" extension but that's not the correct format. It's really ".xls"
MultiCharts used to save these in ".xls" format. I submitted a bug report about this some time ago, and the format was changed to ".xlsx." See this link:
http://www.multicharts.com/pm/viewissue ... _no=MC-619
Unfortunately, it seems that MultiCharts has reverted this back to ".xls" in the latest release of MultiCharts 8.5. I hope this can be fixed again, and changed back to ".xlsx."
- Attachments
-
- ScreenHunter_05 Mar. 25 18.07.gif
- (8.7 KiB) Downloaded 1030 times
-
- Posts: 742
- Joined: 09 Apr 2010
- Location: Texas
- Has thanked: 483 times
- Been thanked: 274 times
- Contact:
Re: BackTesting Problem
Maybe the expert staff at MC could give us the option of exporting to .xls OR .xlsx then there would be no issues with future versions...
- Andrew MultiCharts
- Posts: 1587
- Joined: 11 Oct 2011
- Has thanked: 931 times
- Been thanked: 559 times
Re: BackTesting Problem
Checking this.http://www.multicharts.com/pm/viewissue ... _no=MC-619
Unfortunately, it seems that MultiCharts has reverted this back to ".xls" in the latest release of MultiCharts 8.5. I hope this can be fixed again, and changed back to ".xlsx."
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2957 times
Re: BackTesting Problem
You need to use MS office version that supports Visual Basic for applications in order to export the performance report. Report will be exported either in xls or xlsx format depending on the version of MS Office package that was installed last. If you want to change that - repair the office package you want to utilize for export of the report.
Please submit a feature request to the Project Management of our web site so other users can vote for it: https://www.multicharts.com/pm/Maybe the expert staff at MC could give us the option of exporting to .xls OR .xlsx then there would be no issues with future versions...
Re: BackTesting Problem
I don't think this is entirely correct. I have MultiCharts 8.5 installed with Office 2013. It is exporting performance reports as ".xls" files, not ".xlsx" files.You need to use MS office version that supports Visual Basic for applications in order to export the performance report. Report will be exported either in xls or xlsx format depending on the version of MS Office package that was installed last.
Could this be a conflict with Office 2013? I.e., that MultiCharts exports in ".xlsx" format for Office 2007 and Office 2010, but reverts back to ".xls" for Office 2013?
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2957 times
Re: BackTesting Problem
We are checking it.Could this be a conflict with Office 2013? I.e., that MultiCharts exports in ".xlsx" format for Office 2007 and Office 2010, but reverts back to ".xls" for Office 2013?
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2957 times
Re: BackTesting Problem [SOLVED]
There is indeed an issue with Office 2013. It will be fixed in the next version of MultiCharts.Could this be a conflict with Office 2013? I.e., that MultiCharts exports in ".xlsx" format for Office 2007 and Office 2010, but reverts back to ".xls" for Office 2013?