QA cannot import Interactive Broker report

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? )

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.

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

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.

For any one who would like to import their trades from another platform into Quant Analyzer to do a portfolio, money management, monte carlo, what if scenarios, please watch this video to learn how to do it:

https://youtu.be/8c5mQ1vG67Q

I would like to thank Tomas and the development team for their help.