Robinhood shows each options order in the app, but it doesn't tell you how a strategy has performed over time: your win rate on put credit spreads, your return on capital, or what your wheel trades actually earned once assignments are counted. To analyze that, you need your history out of Robinhood. This guide shows how to export it, explains what's in the file, and covers the details that trip people up when importing it.
Step 1: Generate the Account Activity Report
Robinhood calls the export an account activity report. From your Robinhood account:
- Go to Account, then Reports and statements.
- Select Account activity report, then Generate new report.
- Choose the account type, a start date and an end date.
Robinhood says most reports take about 2 hours to generate and can take up to 24 hours. You'll be notified when it's ready, and you download it as a CSV from Reports. Futures, crypto and spending account activity aren't included.
Step 2: Pick the Right Date Range
This is the most common mistake. The file only contains what happened between your start and end dates. If you sold a put in December and bought it back in January, a report starting January 1 contains the buy-back but not the sale, so there's no way to know what the trade earned.
Start the report before the oldest position you still care about was opened. If you're unsure, go back a few extra months. Import each period once: trades already in your account are skipped only when they match exactly, so re-importing a range that overlaps an earlier import can create duplicates if positions changed in between.
What's in the File
Every row has the same nine columns:
| Column | What it holds |
|---|---|
| Activity Date | The trade date (Process Date and Settle Date follow it) |
| Instrument | The underlying ticker, e.g. AMD |
| Description | For options: ticker, expiration, Call/Put and strike, e.g. AMD 10/23/2026 Put $570.00 |
| Trans Code | The type of transaction (see below) |
| Quantity, Price, Amount | Contracts, price per share, and the cash that moved. Negative amounts are in parentheses, e.g. ($720.08) |
Transaction codes for options traders
| Trans Code | Meaning |
|---|---|
| STO | Sell to open: you sold a put or call (a CSP, covered call, or a spread's short leg) |
| BTO | Buy to open: you bought a put or call (a long option, or a spread's long leg) |
| BTC | Buy to close: you bought back an option you had sold |
| STC | Sell to close: you sold an option you had bought |
| OEXP | Option expiration. The description reads Option Expiration for AMD 10/23/2026 Put $570.00 |
| OASGN | Option assigned: your short option was exercised against you |
| OEXCS | Option exercised: you exercised a long option |
| Buy / Sell | Stock trades, including the shares delivered by an assignment or exercise |
| INT, DCF, ACATI, GOLD | Interest, debit card transfers, transfers in from another broker, and the Gold subscription fee |
Three details that aren't obvious
- Fees aren't a separate column. They're the gap between Price × Quantity × 100 and Amount. Selling 9 contracts at $4.20 is $3,780.00, and an Amount of $3,779.56 means $0.44 went to fees.
- Rows are newest first. Read from the bottom up to follow a position from open to close.
- Expirations, assignments and exercises have no price or amount. Some also show a quantity like
10S. Don't read the "S" as "short": match the event to the trade that opened the position instead.
Step 3: Import It into Options Tracker
On the Trades page, choose Import and upload the CSV as-is. Options Tracker recognizes the Robinhood format automatically, then:
- matches each closing trade, expiration and assignment to the trade that opened it, including partial closes;
- works out fees from the Amount column;
- merges orders that filled in several pieces at the same price into one trade;
- groups legs you opened together on the same day into spreads: verticals, iron condors and butterflies, and synthetics;
- creates stock positions when puts are assigned (see what happens when a cash-secured put gets assigned), and imports your stock buys and sales with their realized gains.
Before anything is saved, the preview lists what needs your attention, such as closes whose opening trade is before your date range. Interest, card transfers and other cash activity are skipped.
Edge Cases to Check After Importing
- Both legs of a spread settling in stock. If a put spread finishes below both strikes, Robinhood assigns the short put and exercises the long put on the same day, so you buy and sell the same shares. Options Tracker records this as a closed spread at its full width, with no stock position left behind.
- Positions transferred in from another broker (ACATI) have no trade price, so they aren't imported. Add them by hand if they're still open.
- Shares bought before your report's start date aren't in the file. Stock you buy and sell within the date range is imported, but if you later sell (or write covered calls on) shares you already owned, add them on the Positions page before importing so the sale and the calls have shares to use.
What You Get
Once imported, you can see realized P&L by month, win rate by strategy and ticker, return on capital, and the risk on your open spreads, none of which the Robinhood app shows. For a broader introduction, see how to track options trades.
Create a free account and import your Robinhood history in a few minutes.
Robinhood is a trademark of Robinhood Markets, Inc. Options Tracker is not affiliated with or endorsed by Robinhood.