Reply

QuantAnalyzer cannot load the report by multicharts

3 replies

yuting0103

Subscriber, bbp_participant, community, 7 replies.

Visit profile

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)

 

Attachments:
You must be logged in to view attached files.

0

tomas262

Administrator, sq-ultimate, 2 replies.

Visit profile

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

0

yuting0103

Subscriber, bbp_participant, community, 7 replies.

Visit profile

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)

 

0

tomas262

Administrator, sq-ultimate, 2 replies.

Visit profile

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

0

Viewing 3 replies - 1 through 3 (of 3 total)