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, which recognises the IBKR column layout automatically. By the end, your IBKR trades will be in your portfolio with prices and performance filled in.

Before you start

• Have your IBKR Account Management login handy.
• In Metrifly, pick the single portfolio you want the trades to go into (not a group).

Step 1 — Create a Flex Query in IBKR

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.

Trades query

Use the Trades section and include these columns:

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

Dividends query (optional)

Use the Cash Transactions section and include:

Type, SettleDate, ISIN, Description, Amount, CurrencyPrimary

Withholding-tax rows in the Cash Transactions export are excluded automatically.

Step 2 — Download the file

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

Step 3 — Import the file into Metrifly

1. In Metrifly, go to Transactions → Add Holdings and select Upload a file.
2. Upload your file. Metrifly recognises the IBKR format, maps the columns, and previews the trades it found.
3. Review the trades, then 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.

Good to know

Metrifly imports stock (equity) rows only — options, futures, and forex rows are skipped. IBKR exports lead with ISIN rather than a ticker, and that’s fine: map the ISIN column and Metrifly works out the symbol and exchange from it. Exports without an AssetClass column are supported too.

Troubleshooting

Problem	Fix
Holdings show Check symbol after import	Make sure the ISIN column is mapped — Metrifly uses it to resolve the symbol.
Options or futures are missing	That’s expected — only equity rows are imported.
Some trades are missing	Re-run the Flex Query with a wider date range.

Related articles

• Import your trade history from a file
• Add a trade manually
• Find your broker’s export guide