Import your Interactive Brokers trades into a free trading journal

Save a Flex Query of your executions as a CSV file, import it, and replay any trade on its chart.

Create a free accountStart free. No card required.

Or replay a day, no account needed

Example: AAPL, NVDA and SPY, Sep 1 to 21, imported.

Step 1

Export your executions from Interactive Brokers.

Set up the query once in the Client Portal, then run it whenever you want a new file.

Go to Performance & Reports, then Flex Queries.
Click + on the Activity Flex Query panel and name the query.
In Trades, tick Executions and these fields: Symbol, Trade Date, Trade Time, Quantity, Trade Price, IB Commission, Buy/Sell and IB Execution ID.
Click Save.
Choose CSV as the format, then click Continue and Create.
Click the blue Run arrow, choose your dates and CSV, then click Run.

Step 2

Import the file into your journal.

Check how each column was read before you import.

Open the journal and choose Import trades.
Pick the CSV file and TraderPier matches its columns for you.
Click Preview with this mapping, then import.
Tick Save this format for next time so you can skip matching on your next file.

What imports

Each fill is imported with its commission.

Imported

Every fill is imported with its date, time, symbol, side, quantity and price.
Each fill's commission is taken off your P&L.
Buys and sells are joined into whole trades, even when you scale out.

Not imported

Stops and targets aren't imported, because the file only lists fills.
Options trades aren't imported, since TraderPier journals US stocks and ETFs only.

Example: META and NVDA, Sep 2 to 29, replayed.

After the import

See each trade on its chart.

Open any trade to play it back bar by bar, with your entry and exit marked on the chart.

Questions

Before you import.

What if I import the same file twice?

Fills you've already imported are skipped by their IB Execution ID, so nothing is added twice.

How many trades can I keep?

On the free plan, TraderPier stores up to 10,000 trades and you can replay the ones from the last 30 weekdays. Upgrade to the Trader plan to replay a year of history for $29 a month.

What if a row doesn't import?

The preview lists any row that failed and why, before anything is saved.

Which markets can I journal?

US stocks and ETFs.