ThetaRecap

Broker guide

Interactive Brokers wheel tracker: import your CSV

Interactive Brokers exports through Flex Queries — configurable CSV reports you set up once and re-run. ThetaRecap targets the trades Flex export, reads options from their explicit component columns, and uses IBKR's execution id as a stable reference, so imports are precise and reconcile cleanly.

Options-aware Flex Query trades CSV

Export the CSV from Interactive Brokers

  1. 1In IBKR Account Management, open Reports / Flex Queries.
  2. 2Create (or reuse) a Trades Flex Query that includes the trade date/time, symbol, buy/sell, quantity, trade price, and the option component columns.
  3. 3Run the query for your date range and download the result as CSV.
  4. 4Upload the CSV to ThetaRecap; it is stored immutably before parsing.

What ThetaRecap reads

  • One row per execution, with IBExecID as a stable broker reference
  • Options via explicit columns: Put/Call, Strike, Expiry, UnderlyingSymbol, Multiplier
  • Open/Close indicator combined with side to classify BTO / STO / BTC / STC
  • Lifecycle codes in Notes/Codes: A (assignment), Ep (expiration), Ex (exercise)
  • Flex date/time in the query's timezone, converted to UTC

Full options support. Because IBKR gives explicit option components and execution ids, roll linking and reconciliation are especially precise. The option symbol string is never guessed at — ThetaRecap reads the structured columns.

Good to know

  • ThetaRecap targets the single-section Flex trades export. Support for the multi-section Activity Statement “Trades” section is a planned fast-follow.
  • Set your Flex Query to include the option component columns and an Open/Close indicator. Without a lifecycle code and without an open/close indicator, an option row is ambiguous and stops with a clear error.
  • Expiry is accepted as YYYYMMDD, YYYY-MM-DD, or MM/DD/YYYY; date/time is accepted in several common Flex formats.

ThetaRecap parsers are deliberately loud: in an ambiguous case they stop with a clear error rather than silently skipping a row. And because your raw file is stored immutably, a parser fix re-runs against your original upload — you never re-export to recover.

More on importing

Campaign accountingRolls, assignment, and the ACB waterfall.Tastytrade guideImport guide for another broker.Schwab guideImport guide for another broker.Robinhood guideImport guide for another broker.

Import your Interactive Brokers history free.

CSV in, campaigns out. No brokerage credentials, ever.

Start freeSee pricing

No card required. Free while we are in public beta.