QA cannot import Interactive Broker report

[Customer27 Posts]

hello

I’m trying to import reports data from Interactive Brokers. No way.
From IB I can export data to CSV, but when loading the CSV file into Quant Analyzer, i get this error:

error loading using MT4ReportLoader – Loading CSV settings failed. Invalid values length. Expected: 14, got: 18
– error loading using FxBlue loader – Failed to parse order. Line: Statement;Data;BrokerName;Interactive Brokers;;;;;;;;;;;;;;
– error loading using ForexTester loader – Failed to parse order. Line: Statement;Data;BrokerName;Interactive Brokers;;;;;;;;;;;;;;
– error loading using GeneralCsv loader – Incorrect csv file or format unrecognized. Failed to parse order. Line: Statement;Data;BrokerName;Interactive Brokers;;;;;;;;;;;;;;
– error loading using Myfxbook loader – Incorrect Myfxbook file or format unrecognized. Automatic detection of date format failed. Reason: Date format not recognized(1).
Sample: Data
– error loading using ZuluTrade loader – Automatic detection of date format failed. Reason: Incorrect trade definition!?
Line: Statement;Data;BrokerName;Interactive Brokers;;;;;;;;;;;;;;
– error loading using NinjaTrader loader – Failed to parse order. Line: Statement;Data;BrokerName;Interactive Brokers;;;;;;;;;;;;;;
– error loading using Tradestation loader – Failed to load Tradestation report file: test2.csv – Loading CSV settings failed. Invalid values length. Expected: 12, got: 18

Please help me
(when writing this thread i’m not able to upload any attachment…why? )

[Administrator2333 Posts]

what kind of data are you trying to import to QA? Is it chart data or list of trades?

Can you attach it here again? Attachments should work now, if not please let me know.

Mark
StrategyQuant architect

[Customer27 Posts]

ok

here the attach

I exported the list of trades in cvs format, but when importing into Excel, it also shows a lot of other information in a misleading format…hmm

and when I try to import into QA I get error loading.

I do understand and see QA tries to load using several trading platforms.

any suggestion will be appreciated

regards

Attachments:

You must be logged in to view attached files.

[Administrator2333 Posts]

I reviewed it, but we’ll be not adding Interactive Brokers support to QA for now.

Their report is too complicated and doesn’t contain all the necessary information that we need. It is primarily a statement report for some period, not trading history report.

Mark
StrategyQuant architect