Swing Trading Journal for Charles Schwab | Excel Trade Journal with Schwab CSV Import & Sizer
Stop retyping your Schwab trades. Export your account history from schwab.com as CSV, paste it into this workbook and its formulas turn every buy and sell into a clean round-trip trade. Scale-ins, partial exits, shorts and fees are handled. Then paste the trades into a swing-trading journal that calculates P&L, R-multiples, holding days and return on cost.
On schwab.com, open Accounts, then History, and export the transactions to CSV. Trades placed in thinkorswim on a Schwab account appear in the same history. The title line, dividends, interest, journals and the totals line are skipped automatically. No macros, add-ins, logins or subscription, and your data never leaves your file.
The column layout is taken from public sources on the Charles Schwab export format (official help or developer pages and public sample files, listed in the User Guide). If Charles Schwab renames a column, type the new header on the Import Setup sheet; nothing else needs to change.
It also has a built-in position-size calculator. Enter your entry, stop and target to get shares, position value, % of account and reward:risk, capped by your max position size. The portfolio heat table pulls your open trades from the journal and warns you before total open risk goes over your limit.
The dashboard updates itself: net P&L, win rate, profit factor, expectancy in R, payoff ratio, max drawdown, an equity curve, and P&L by month, setup, weekday and side. A 'cost of mistakes' table shows what chasing entries or moving stops really cost you.
It comes with 22 fictional example trades, a fictional sample Charles Schwab file to practise the import (46 executions, 22 trades) and a 9-page PDF guide with a step-by-step import walkthrough.
What's included
• Rangefolio-Swing-Journal-Schwab.xlsx (11 sheets: Start Here, Settings, Trade Journal, Dashboard, Position Sizer, Schwab Import, Import Setup, Import Results, Lists, plus 2 protected helper sheets)
• sample-schwab-transactions.csv (fictional sample, 46 executions / 22 trades)
• User-Guide.pdf (9 pages: setup, Charles Schwab export walkthrough with public format sources, importing, journaling, sizing, dashboard, troubleshooting)
Who it's for
• Stock and ETF swing traders who use Charles Schwab (schwab.com and thinkorswim accounts)
• Traders who think in R-multiples and want to know their real expectancy
• Anyone who wants a risk-first routine: size every trade and cap total portfolio heat
• People who prefer a spreadsheet they own to a monthly journaling subscription
File formats and compatibility
• Microsoft Excel .xlsx workbook, sample CSV and PDF user guide, delivered as one zip
• Built for Microsoft Excel 2019/365 (.xlsx, no macros). Tested in LibreOffice Calc. Google Sheets import is possible but not officially supported.
• Formulas only: no macros or VBA, no add-ins, works offline
• Instant digital download; no physical item is shipped
FAQ
Q: Does it connect to my Charles Schwab account?
A: No. Nothing logs in or syncs. You export a file from your broker, open it and paste it in. Your data stays in your own file.
Q: Does it handle partial exits and scaling in?
A: Yes. Fills are grouped from flat to flat for each symbol. Adds are averaged into the entry price and partial sales into the exit price. A trade stays marked Partial until it's fully closed. Short trades are supported.
Q: Does it import thinkorswim trades?
A: Yes, when they're on a Schwab account: they appear in the schwab.com account history, which is the file this importer reads. Stocks and ETFs only; option rows are skipped.
Q: Schwab's file has no trade times. Is that a problem?
A: No. Fills are ordered by date, and fills on the same day use the file order (Schwab lists newest first).
Q: How is this different from the IBKR version?
A: It's the same journal, sizer and dashboard. Only the import sheet differs: this one reads Charles Schwab's export instead of an Interactive Brokers Flex Query. You only need the version for your broker.
Q: Is this financial advice?
A: No. It's a record-keeping and calculation tool for education only. It doesn't recommend any trade. All example data is fictional.
Not affiliated with or endorsed by Charles Schwab.
Disclaimer: For educational and record-keeping purposes only. Not financial, investment, tax or trading advice. Trading involves substantial risk of loss. Example data is fictional. Charles Schwab is named only to describe file compatibility. Not affiliated with or endorsed by Charles Schwab. Export formats are based on public documentation and can change.