How to export trades from your broker to CSV

Almost every broker lets you download your trade history as a CSV, but the menu names differ and some files lack details such as time of day or commissions. Here is where to look. Brokers redesign their sites often, so if a menu has moved, search your broker's help pages for "download activity" or "export orders".

thinkorswim (Schwab)

Monitor, then Account Statement, choose the dates, and use the menu to Export to File. The Account Trade History section has every execution with its time. It has no commissions, so set your fees in the journal. Full steps: export thinkorswim trades.

Interactive Brokers

Performance & Reports, then Statements, Activity, and download as CSV. The Trades section lists executions with times and commissions.

Robinhood

From your account, open the reports and statements area and request an account activity report as CSV. The file has dates but no time of day, so hour-of-day statistics will not be meaningful, and option expirations and assignments need checking.

Webull

On the desktop app, open Orders, then the order history, and use Export. Only filled orders are useful. Times include a time-zone label.

Fidelity

Two options: the Active Trader Pro Orders export has exact times; the Fidelity.com Activity & Orders History download has commissions but only dates. Do not import both for the same period. Full guide: export Fidelity trades.

Other brokers

Any CSV with a symbol, side, quantity, price and date or time can be imported with column mapping. OptiqJournal suggests the mapping automatically and remembers it for next time.

After you export

1. Open the file once to check that it contains the period you expect.
2. Import it into your journal and check that the number of executions looks right.
3. Compare the total P&L with your broker statement. The statement is the official record.
4. Avoid importing overlapping files from two different report types.

Create a free account and import your first file. If you are new to journaling, read what is a trading journal.