Reply

QA cannot import Interactive Broker report

4 replies

siolibros

Customer, bbp_participant, community, 28 replies.

Visit profile

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

0

Mark Fric

Administrator, sq-ultimate, 2 replies.

Visit profile

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

0

siolibros

Customer, bbp_participant, community, 28 replies.

Visit profile

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

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

0

Mark Fric

Administrator, sq-ultimate, 2 replies.

Visit profile

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

0

A Casey

Subscriber, bbp_participant, community, customer, sq-ultimate, 1 replies.

Visit profile

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:

https://youtu.be/8c5mQ1vG67Q

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"

0

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