QuantAnalyzer cannot load the report by multicharts
3 replies
yuting0103
3 years ago #267856
QuantAnalyzer cannot load the report by multicharts (V14)
==
TWF.FITX HOT @QB_Strategy_PureTrend_GetDDM Back-Testing Strategy Performance Report.xlsx
– error loading using ZuluTrade loader – Automatic detection of date format failed. Reason: Incorrect trade definition!?
Line: All Trades,Long Trades,Short Trades,
– error loading using ForexSB loader – Failed to parse row: Net Profit,6.52576E7,6.52576E7,n/a, – Cannot get a numeric value from a text cell
– error loading using Multicharts loader – Failed to parse row: Trade #,Order #,Type,Signal,Date,Time,Price,Contracts,Profit (),Profit (%),Cum. Profit (),Cum. Profit (%),Run-up (),Run-up (%),Drawdown (),Drawdown (%), – Cannot get a numeric value from a text cell
– error loading using Tradestation loader – Failed to load Tradestation report file: TWF.FITX HOT @QB_Strategy_PureTrend_GetDDM Back-Testing Strategy Performance Report.xlsx – Sheet index (7) is out of range (0..4)
tomas262
3 years ago #267859
Hello,
you need to export the Trade List into an XLSX file and import this into QuantAnalyzer. That should work without any issues
If not let us know (ideally create a bug report and attach the report you load) using this link https://roadmap.strategyquant.com/projects/qa4/tasks/new
yuting0103
3 years ago #267886
hi
it seems not work with the exported xlsx file from MC v14.
does it need a standard format that I have to copy/paste it to myself? or specific version(v9/v12?)?
==
TXF.xlsx
– error loading using ZuluTrade loader – Automatic detection of date format failed. Reason: Incorrect trade definition!?
Line: 1.0,1.0,EntryLong,Buy,Mon Aug 31 00:00:00 GMT 2015,Sun Dec 31 00:00:00 GMT 1899,5507.0,28.0,946400.0,0.030688214999092064,946400.0,9.464,3682000.0,0.11939349918285819,-439600.0,-0.014254585073542764,
– error loading using Multicharts loader – Sheet index (4) is out of range (0..0)
– error loading using ForexSB loader – Failed to parse row: ,2.0,ExitLong,Sell,Wed Sep 30 00:00:00 GMT 2015,Sun Dec 31 00:00:00 GMT 1899,5681.0,28.0,,,,,,,,, – Cannot get a text value from a numeric cell
– error loading using Tradestation loader – Failed to load Tradestation report file: TXF.xlsx – Sheet index (7) is out of range (0..0)
tomas262
3 years ago #267893
Hello,
please create a report and attach the ‘Trade list’ report XLXS file generated by MC 14 into our roadmap using this link https://roadmap.strategyquant.com/projects/qa4/tasks/new
Developers will test whether the report loads correctly
Viewing 3 replies - 1 through 3 (of 3 total)