Skip to content

Export your trades from Interactive Brokers

Interactive Brokers (IBKR) is a global broker, and it exports trades through a Flex Query — a custom report you set up once and reuse. This shows you how to build that query, download it, and import it into Metrifly with the IBKR preset. By the end, your IBKR trades will be in your portfolio with prices and performance filled in.

  • Have your IBKR Account Management login handy.
  • In Metrifly, pick the single portfolio you want the trades to go into (not a group).
  1. Log in to IBKR and open Account Management.
  2. In the sidebar, go to Reporting → Flex Queries.
  3. Click + to create a new Flex Query. (You can create separate queries for trades and dividends.)
  4. Set the export format to CSV.

Use the Trades section and include these columns:

Buy/Sell, TradeDate, ISIN, Quantity, TradePrice, TradeMoney, CurrencyPrimary, IBCommission, IBCommissionCurrency

Use the Cash Transactions section and include:

Type, SettleDate, ISIN, Description, Amount, CurrencyPrimary

Run each query for your date range and download the CSV file (or files). These are what Metrifly imports.

  1. In Metrifly, go to Transactions → Add Holdings → Import from file.
  2. Choose IBKR (Interactive Brokers) from the broker list.
  3. Upload your file. Metrifly maps the columns and previews the trades it found.
  4. Click Import. Your trades save in the background and your holdings update within a minute.

For the full import walkthrough, see Import your trade history from a file.

ProblemFix
Holdings show Check symbol after importMake sure the ISIN column is mapped — Metrifly uses it to resolve the symbol.
Options or futures are missingThat’s expected — only equity rows are imported.
Some trades are missingRe-run the Flex Query with a wider date range.