Skip to main content
All manual pages
§IMPORT_IBKRFREE

Import IBKR Flex Query CSV

Import your Interactive Brokers trade history into the Tapeboard journal using an IBKR Flex Query CSV — the same export Tradervue uses. Equities are paired into round-trip trades automatically with commissions, entry/exit prices, and timestamps.

Interactive Brokers has no retail REST API for transaction history, so the reliable way to get your IBKR trades into a journal is the Flex Query CSV — a custom report you configure once in Client Portal and then export whenever you want to sync. Tapeboard reads that file directly, pairs your fills into round-trip trades, and carries commissions and execution times through.

Create the Flex Query (one-time setup)

  1. Log in to IBKR Client Portal (interactivebrokers.com).
  2. Go to Performance & Reports → Flex Queries.
  3. Under Trade Confirmation Flex Query (or Activity Flex Query), click Create.
  4. Add the Trades section and include at least these fields: Symbol, AssetClass, CurrencyPrimary, TradeDate, DateTime, Quantity, Price (or TradePrice), IBCommission, and Buy/Sell. To import options as well, also add UnderlyingSymbol, Put/Call, Strike, and Expiry.
  5. Set the format to CSV and save the query.

You only do this once. After that, running the query is two clicks.

Export and import

  1. In Client Portal, run your Flex Query and choose Export → CSV.
  2. In Tapeboard, open the Journal and click [ IMPORT_CSV ].
  3. Select the exported file. Tapeboard detects the IBKR layout automatically.

What gets imported

  • Equities and options. Stock (STK) rows pair into trades. Option (OPT) rows import too when your Flex query includes the Put/Call, Strike, and Expiry fields — buy-to-open and sell-to-close for the same contract pair into one option trade with the 100× contract multiplier applied. Futures, cash, and non-USD rows are skipped.
  • Round-trip pairing. Opening and closing fills for the same symbol are matched chronologically, including scaled entries and exits. A position that is still open imports as an open trade.
  • Commissions, prices, and times come straight from the Flex export — no manual cleanup.

Notes

  • IBKR Flex templates can reorder columns; Tapeboard matches by column name, not position, so your exact template still works as long as it includes the fields above.
  • Set a stop-loss on imported trades (the journal trade editor) to unlock R-multiple and SQN stats — broker exports don't carry a stop.
  • Re-importing the same export is safe: duplicate trades are de-duplicated on import.