How to export your trades as a CSV
Every major broker lets you download your trade history as a CSV file, usually from the account history, activity, orders or statements area of its website or desktop platform. Look for an option to export or download your trades, orders or transactions, choose CSV as the format, and pick a date range that covers the trades you want to analyze.
Export trade history — the individual buys and sells (fills), or transactions — not a positions or balances report: those don't say when you bought and sold, so there are no trades to analyze. Start the date range before you opened the oldest position you want included, so each trade's opening fill is in the file.
•
Interactive Brokers: an Activity Statement saved as CSV (the analyzer reads its Trades section), or a trade report with date, symbol, side, quantity and price columns.
•
Webull: your order history exported as CSV. Filled orders are read; cancelled and unfilled orders are skipped.
•
Robinhood: the account activity report, which Robinhood provides as a CSV. Option expirations and assignments are handled; dividends, transfers and other cash activity are skipped.
•
Charles Schwab and thinkorswim: the transaction history or trade history export, saved as CSV.
•
Fidelity, E*TRADE, TradeStation, tastytrade, Tradovate, NinjaTrader and others: the account history, transaction or trade/fill history export, saved as CSV.
How the analyzer reads your file
Your file is read entirely in your browser. The analyzer recognises the broker from the file's columns, then groups your buys and sells into trades first-in, first-out: a trade opens with its first fill and closes when the position is flat again. Positions still open at the end of the file are counted but left out of the report.
Rows that aren't trades — cancelled orders, dividends, transfers, interest — are skipped, and the report tells you how many. SetMetric is not affiliated with any broker; broker names are used only to describe which export files the analyzer can read.
What the numbers mean
•
Net P&L: the total profit or loss of your closed trades, after any fees and commissions in the file.
•
Win rate: the share of closed trades that made money after fees. A trade that closed exactly flat counts toward the total but isn't a win.
•
Profit factor: money made on winning trades divided by money lost on losing trades. Above 1 means your winners more than paid for your losers.
•
Expectancy: the average result per trade — win rate × average win, minus loss rate × average loss.
•
Average win and average loss: the size of a typical winner and loser. The bigger your losses are compared with your wins, the higher the win rate you need just to break even.
•
Max drawdown: the largest fall in cumulative P&L from a high point to a later low — the worst losing stretch in the file.
•
P&L by hour of entry: trades grouped by the hour you entered them, in New York time, so the open, midday and the afternoon can be compared.
Why keep a trading journal
A one-off report shows where you stand. A journal shows why. Results are usually driven by a handful of patterns — a time of day, a symbol, a setup taken too early, a stop that got moved — and those only become clear when the same numbers are tracked across hundreds of trades, next to notes on what you were thinking when you took them.
SetMetric is a free trading journal built on the same calculations as this page. Import your broker's CSV, tag your setups and mistakes, write a few lines about each trading day, and your win rate, expectancy, drawdown and P&L by symbol, weekday and time of day stay up to date as you trade.