QA cannot import Interactive Broker report
4 replies
siolibros
6 years ago #241933
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? )

Mark Fric
6 years ago #241957
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
siolibros
6 years ago #241959
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

Mark Fric
6 years ago #242138
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

A Casey
4 years ago #267812
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:
I would like to thank Tomas and the development team for their help.
Two things are infinate, The Universe and Human Stupidity, and am not sure about The Universe!
"Albert Einstein"
Viewing 4 replies - 1 through 4 (of 4 total)