The column mapper accepts any broker's CSV — you match its columns during import. But if you build the file yourself (or can rename the columns of an export), using these exact headers means the mapper fills in automatically with nothing left to adjust. You can grab a ready-made file from the CSV template button on the Brokers page (choose “Any broker (CSV)” → Import a file).
Rules
- One row = one trade (a full round-trip, entry through exit).
- Leave Exit Price blank to log a still-open position.
- Dates as YYYY-MM-DD (MM/DD/YYYY also works); times as 24-hour HH:MM.
- Re-importing the same file is safe — duplicates are skipped.
Columns
| Column | Required | What it is |
|---|---|---|
| Symbol | Yes | Ticker or instrument — e.g. AAPL, ES, BTC-USD. |
| Side | Optional | Buy/Sell or Long/Short. Buy, Long, B, or Bot ⇒ long; anything else ⇒ short. Omit to default to long. |
| Quantity | Optional | Shares or contracts. |
| Entry Price | Yes | Average price you entered at. |
| Exit Price | Optional | Average price you exited at. Leave blank to keep the trade open. |
| Entry Date | Yes | Date you entered. Use YYYY-MM-DD (MM/DD/YYYY also works). |
| Exit Date | Optional | Date you exited. |
| Entry Time | Optional | Time you entered — 24h HH:MM (or 9:35 AM). |
| Exit Time | Optional | Time you exited. |
| Commission | Optional | Total fees for the round trip. |
Example
Symbol,Side,Quantity,Entry Price,Exit Price,Entry Date,Exit Date,Entry Time,Exit Time,Commission AAPL,Buy,100,182.50,190.25,2025-03-03,2025-03-05,09:35,15:52,2.00 TSLA,Sell,50,245.00,238.10,2025-03-06,2025-03-06,10:15,14:40,1.50 NVDA,Buy,25,880.00,,2025-03-10,,09:31,,1.00
Not able to match the headers exactly? No problem — import anyway and map the columns in a couple of clicks.