Step 1 — Export from Interactive Brokers
- 1Sign in to the IBKR Portal (Client Portal).
- 2Simplest: Performance & Reports › Statements › Activity Statement, choose the period, format CSV, and download.
- 3Or, for repeated imports: create a Flex Query with the Trades and Cash Transactions sections, format CSV, and run it for the period you need.
Choose a period that covers your first trade so that positions and average costs are complete. IBKR’s own guides describe Activity Statements and Flex Queries in detail.
What InvestIQ reads
- Trades with their quantity, price, currency and commissions.
- The instrument table, which gives each security’s ISIN and listing exchange.
- Dividends and withholding tax from the cash sections.
Step 2 — Import the file into InvestIQ
- 1Create a free account, open Portfolios and choose “Import CSV / statement”.
- 2Drop the file. InvestIQ recognises the broker from the file’s columns and reads each line: buys, sells, dividends, fees.
- 3Review what it found. Each instrument is matched to its listing (by ISIN and market where the file gives them); anything ambiguous is shown for you to confirm before anything is written.
- 4Import. Re-importing the same file later skips the lines already imported, so you can add a newer export without creating duplicates.
Step 3 — Run the audit
Once the positions are in, run a portfolio audit: concentration, diversification, market risk, quality of the holdings, fit with the limits you set and liquidity, with the findings that deserve a look. What each part measures is described on the portfolio analyzer page.
Good to know
- IBKR’s exchange codes are used to pick the right listing; for example, “TSE” in an IBKR file means Toronto.
- Multi-currency accounts are fine: each trade keeps its own currency.