// ibkr import

Your IBKR Trading Journal

Journal your Interactive Brokers trades without re-typing a single one. Export the Transaction History statement from Client Portal, drop it in, and TickerScribe recognizes it on sight — options, stocks, and cash, mapped automatically.

Transaction History CSV in · recognized on sight · 100% free

// how-to-export

From Client Portal to your journal

Four steps, about two minutes.

  1. 01

    Run the Transaction History statement

    In IBKR Client Portal, open Performance & Reports → Statements and run the Transaction History statement.

  2. 02

    Pick your date range, choose CSV

    Select the period and CSV as the format. IBKR caps a statement at one year — for older history, run one file per year.

  3. 03

    Drop the file into the Import Wizard

    Settings → Import Data, drag the file in. TickerScribe recognizes the IBKR layout on sight — no column mapping, no file cleanup.

  4. 04

    Preview & commit

    See every trade before anything is saved. Duplicates are flagged and skipped, then trades post to the ledger — multi-leg positions grouped, strategies detected.

// auto-detected

The whole statement. Zero setup.

The drop step works because TickerScribe reads IBKR's statement exactly as Client Portal produces it — several sections bundled into one CSV, every row prefixed with a section name. Here's what happens to each line.

U1234567_TransactionHistory.csvInteractive Brokers · auto-detected
Statement,Data,Title,Transaction Historyrecognized
Summary,Data,Base Currency,EURbase currency
Transaction History,Header,Date,Account,Description,Transaction Type,Symbol,…columns mapped
Transaction History,Data,…,Sell,SAP,-12.0,224.15,EUR,…stock trade
Transaction History,Data,…,Sell,PLTR 261218C00045000,-1.0,…option · OCC parsed
Transaction History,Data,…,Electronic Fund Transfer,Deposit,…cash
Transaction History,Data,…,Forex Trade Component,EUR.USD,…FX leg · skipped

The Transaction History section is extracted automatically; everything else in the file is read for context or safely ignored.

TickerScribe Import Wizard recognizing an Interactive Brokers Transactions CSV — 158 rows, 11 columns, identified as Interactive Brokers (Transactions), with the Source, Scope, Map, and Preview steps shown

The moment it lands: recognized, mapped, ready to preview.

What comes acrossFrom one file

Stocks

Buys and sells with quantities, prices, and commissions — partial lots and short positions included.

Options

OCC symbols are parsed into underlying, strike, expiration, and call/put. Multi-leg detection groups spreads into single positions, and 30+ strategies are detected automatically.

Cash transactions

Deposits, withdrawals, dividends, credit interest, fees, and withholding taxes — so your portfolio value and deployed capital stay accurate.

Multi-currency accounts

IBKR reports amounts in your base currency but prices in each instrument's own currency. TickerScribe normalizes prices to the base currency using IBKR's own figures — no FX-rate lookups — and the per-trade conversion legs are filtered out instead of importing as bogus trades.

Safe re-imports

Every trade carries a content fingerprint. Re-running a file, or importing overlapping date ranges, flags duplicates on the preview step and skips them.

Using a Flex Query or a TWS export instead? Those aren't auto-detected, but they import through the universal CSV mapper — columns auto-suggested, confirmed once, remembered after.

Two minutes from Client Portal

Bring your IBKR history home

No credit card required. Export one statement, drop it in, and see your real numbers.

Frequently Asked Questions

Is TickerScribe really free?
Yes — completely free, no credit card, no trade caps. Import your full IBKR history, journal options and stocks together, and keep ledger-accurate P&L without paying anything.
Which IBKR file does TickerScribe auto-detect?
The Transaction History statement CSV from Client Portal (Performance & Reports → Statements). It's a multi-section file — Statement, Summary, Transaction History, each row prefixed with a section name — and TickerScribe reads it as-is: the Transaction History section is extracted and every column is mapped automatically. No cleanup, no column mapping.
Do IBKR options trades import correctly?
Yes. IBKR reports options in OCC symbol format (e.g. PLTR 261218C00045000), and TickerScribe parses out the underlying, strike, expiration, and call/put automatically. Multi-leg detection then groups related legs into a single position, and the journal takes it from there — strategies detected, rollovers chained, assignments handled.
My IBKR account isn't in USD — will the amounts come across right?
Yes. IBKR statements report amounts in your account's base currency while quoting prices in each instrument's native currency. TickerScribe normalizes prices to the base currency using IBKR's own reported amounts — no external FX rates — and filters out the Forex Trade Component conversion legs so they don't pollute your journal. And you don't have to check currencies yourself: TickerScribe reads the base currency straight from the statement, compares it to your account, and if they don't match, offers to switch the account to the right currency in one click.
Can I use a Flex Query or TWS export instead?
Auto-detection covers the Transaction History statement, but Flex Query and TWS exports still work — they go through the universal CSV mapper, which reads your headers and auto-suggests a match for every column. Confirm the mapping once and it's remembered for next time.
IBKR limits statements to one year — how do I import older history?
Run one statement per year and import the files one after another. Every trade carries a content fingerprint, so overlapping date ranges are safe — duplicates are flagged on the preview step and skipped, and only new trades come through.