Skip to main content
All manual pages
§IMPORT_IBKRFREE

Import IBKR Flex Query CSV

Import your Interactive Brokers trade history into the Tapeboard journal with an IBKR Flex Query CSV — or connect your Flex token once and let server-side auto-sync pull new fills every weekday evening.

Interactive Brokers has no retail REST API for trade history, so your history comes in two ways: a one-off Flex Query CSV export, or a connected auto-sync that pulls new fills for you nightly.

Set it once; the server syncs for you every weekday evening (22:15/22:30 UTC), deduped against everything already in your journal.

  1. Journal → [ IMPORT / SYNC ].
  2. In the "connect a broker" section, use the IBKR FLEX card: paste your Flex Web Service token and the query ID of a Flex Query containing the fields below.
  3. Done — sync runs on the server. The card shows the last sync time and any error.

Your token is encrypted at rest (AES-GCM-256); disconnecting deletes it.

Option B — One-off CSV export

  1. In IBKR Client Portal, go to Performance & Reports → Flex Queries and create a Trade Confirmation (or Activity) query with at least: Symbol, AssetClass, CurrencyPrimary, TradeDate, DateTime, Quantity, Price, IBCommission, Buy/Sell. For options, also add UnderlyingSymbol, Put/Call, Strike, Expiry.
  2. Run it → Export → CSV.
  3. In Tapeboard: Journal → [ IMPORT / SYNC ] → UPLOAD CSV FILE. The IBKR layout is auto-detected. (Same picker also reads Schwab, Fidelity, Webull, Robinhood, DAS, Sterling, TradeStation, and tastytrade exports; unrecognized formats get a column-mapping wizard instead of an error.)

What gets imported

  • Equities + options. Stock rows pair into round-trip trades (scaled entries/exits handled); option rows pair per contract with the 100× multiplier. Futures and non-USD rows are skipped.
  • Commissions, prices, and times come straight from the Flex export.
  • Duplicate-safe. Every row is fingerprinted; re-importing the same file (or a sync overlapping a CSV you already imported) skips duplicates.
  • Columns are matched by name, not position — template reorders are fine.

Tip

Set a stop-loss on imported trades in the journal editor to unlock R-multiple and SQN stats — broker exports don't carry stops.