How to import Charles Schwab trades into a trading journal
Two minutes from Schwab's History page to a filled-in journal: export your transactions as CSV, drop the file into note500, and your fills are paired into round-trip trades automatically — options, deposits and fees included.
Step 1 — Export your transactions from Schwab
- Log in at schwab.com and open Accounts → History.
- Select the account you want to journal and set the date range (start with everything you want in the journal — you can re-import later date ranges any time).
- Click Export (top-right of the transactions
table) and choose CSV. You'll get a file like
XXXX123_Transactions_2026-07-30.csv.
The export contains a row per transaction — trades, dividends, transfers — with columns like Date, Action, Symbol, Quantity, Price, Fees & Comm, Amount. Don't edit the file; note500 reads it as-is.
Step 2 — Import into note500
- In note500, open the Data tab (Import / Export).
- On the Import trades card, choose which account to import into.
- Leave Broker format on Auto-detect — Schwab's export is recognized by its column headers. (If a file is ever detected as the wrong broker, pick Charles Schwab here to force it.)
- Click ⬆ CSV and select the downloaded file.
note500 then pairs your buy and sell fills into round-trip trades,
parses option contracts from Schwab's symbol format (e.g.
SPXW 05/21/2026 7450.00 C becomes a dated SPXW call with
the right multiplier), records deposits and withdrawals as cash flows
so your balance history is right, and books fees.
By default imported trades are added next to whatever is already logged. The "Overwrite existing days" checkbox replaces the days present in your file instead — export a backup first if you use it.
Prefer zero clicks? Connect Schwab directly
On paid plans, note500 can also sync Schwab automatically through a read-only connection (via SnapTrade): new fills import on their own, open positions appear with live marks, and your account balance is captured at every sync. The connection cannot place trades or move money — it can only read. File import remains available on the Plus and Ultimate plans for back-filling history or for accounts you'd rather not connect.
What you get once your trades are in
- A P&L calendar of green and red days with weekly totals and economic-event markers.
- Your equity curve and end-of-day balance history.
- Reports: win rate, profit factor, expectancy, drawdown, R-multiples, per-symbol performance.
- AI trade reviews that read your actual trades and point at your edge and your leaks.
Also works with Fidelity, E*TRADE, TD Ameritrade, Tastytrade, Interactive Brokers, Webull and Robinhood exports — same Data tab, same auto-detection.