Interactive Brokers trade journal: auto-import with Flex Query
Turn your Interactive Brokers account into a full trading journal — how Flex Query import works, multi-currency P&L, and automatic round-trip reconstruction for options and stocks.
Interactive Brokers gives you institutional-grade execution and a firehose of raw data — but not a journal. IBKR’s reports are powerful and dense, which is exactly the problem: the insights you want (real round-trip P&L, win rate, performance by symbol and time) are buried under statements built for accounting, not for improving your trading.
How Flex Query import works
IBKR exposes your trade history through Flex Queries — configurable report feeds you can authorize a third party to read. MyTradeLens uses a read-only Flex Query to pull your fills automatically: no password sharing, no trading access, just your executed orders flowing in on a schedule. You set it up once and the journal stays current.
- Read-only — Flex Query exposes trade history, never trading or withdrawal access.
- Automatic — once connected, new fills import without manual CSV exports.
- Multi-currency — P&L is reconciled across the currencies IBKR traders actually use.
- Complete — options and equity fills are both pulled and grouped.
From fills to round-trips
IBKR reports list executions; a journal needs trades. MyTradeLens reconstructs your fills — entries, adds, rolls, partial closes — into single round-trip positions with a true entry, exit, hold time, and net P&L after commissions. That’s the step that makes your win rate and average win/loss trustworthy instead of distorted by order count.
What you get on top
Once your IBKR history is reconstructed, the analytics come automatically: a profit calendar, P&L by symbol, day, and hour, expectancy, and goal tracking with breach alerts. If you also trade through Schwab or Moomoo, those connect too — so a multi-broker trader gets one unified journal instead of three exports to reconcile by hand.