Not logged in
Viewing 4 posts - 1 through 4 (of 4 total)

Forums>StrategyQuant>General Discussion>QuantAnalyzer cannot load the report by multicharts

  • #267856 |
    Participant
    2 Posts

    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.
    #267859
    tomas262
    Administrator
    1827 Posts

    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

    #267886
    Participant
    2 Posts

    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)

     

    #267893
    tomas262
    Administrator
    1827 Posts

    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 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.