Import IBKR Flex CSV¶
OVERVIEW¶
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.
HOW TO USE¶
Step 1 — Create the Flex Query (one-time setup)¶
- Log in to IBKR Client Portal.
- Go to Performance & Reports → Flex Queries.
- Under Trade Confirmation Flex Query (or Activity Flex Query), click Create.
- Add the Trades section and include at least these fields:
| Required Fields | Optional Fields (for options) |
|---|---|
| Symbol | UnderlyingSymbol |
| AssetClass | Put/Call |
| CurrencyPrimary | Strike |
| TradeDate | Expiry |
| DateTime | |
| Quantity | |
| Price (or TradePrice) | |
| IBCommission | |
| Buy/Sell |
- Set the format to CSV and save the query.
Tip
You only do this once. After that, running the query is two clicks.
Step 2 — Export and import¶
- In Client Portal, run your Flex Query and choose Export → CSV.
- In Tapeboard, open the Journal and click [ IMPORT_CSV ].
- Select the exported file. Tapeboard detects the IBKR layout automatically.
FEATURES¶
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¶
Note
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.
Tip
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.
Note
Re-importing the same export is safe: duplicate trades are de-duplicated on import.