Google Sheets · 100% free

Free Stock Trading Journal for Google Sheets

Copy our Google Sheets trading journal and log every stock day trade—ticker, entry, exit, size, fees, and setup—the same 2019 v2 sheet TradeJournal.co grew from before broker auto-import existed.

Get the template Copy sheet on template page

No signup · Same 2019 v2 sheet · 15+ metrics

Key takeaway

TradeJournal.co's free stock trading journal Google Sheets template is a one-click copy of the 2019 v2 sheet with trade log and performance dashboard tabs. Tag tickers, session, and setup for honest win-rate reviews. For automatic stock broker import and AI pattern detection, use TradeJournal.co (14-day free trial and a free $300 pro trader call).

More Google Sheets journals

$25K challenge case study

Pre-filled sheet + video walkthrough.

Forex Google Sheets

Pairs, pips & session tags.

Crypto Google Sheets

Spot, perps & exchange fees.

Options Google Sheets

Premium, spreads & structure tags.

Google Sheets trading journal template — all copy links & sheet versions

Stocks journal — Google Sheets

Sheet copy links live on our main Google Sheets trading journal template page.

Copy the Google Sheets on our template page

The 2019 v2 sheet (plus 2018 and example portfolio) is on one page—make a copy in Google Sheets or export to Excel. Customize it for stocks using the tips below.

Google Sheets trading journal template

No signup · File → Make a copy · optional auto-import

What to track in your stock trading journal

Equity stats break when you mix position sizes and hold times—log fields that match how you actually trade stocks.

Ticker & sector

Filter the dashboard by symbol or sector so you see which names you trade well.

Entry, exit & size

One row per round trip; the sheet calculates P&L and running totals automatically.

Session & catalyst

Tag open-drive, midday, or power hour—many stock edges are time-of-day specific.

Setup & R-multiple

Morning panic, breakout, dip buy—group P&L by playbook, not gut feel.

Customize the sheet for stock day trading

Rename Setup to your playbook (morning panic, VWAP reclaim, gap fade).
Use Notes for float, market cap, or dollar volume from your screener.
Log fees and locates so net P&L matches your broker statement.
Weekly: review the Strategy breakdown tab and cut setups with negative expectancy.

Rated 5 stars on TrustPilot

Join 12,000+ traders who journal with TradeJournal.

See all reviews

FAQ

Yes. Journal each round trip in the sheet even when you are limited to three day trades per five days in a margin account under $25K. Many traders pair a cash IRA (T+2 settlement) with a small margin account to spread trades—track both in one copy with account tags in Notes.

Yes. Use setup tags or a custom column for market cap bucket ($2–$10 small caps vs. larger names) so stats are not blended misleadingly.

The blank template is the 2019 v2 journal. We also publish a pre-filled example from Alex Winkler's documented $25K challenge—see our case study page for the real trades, video walkthrough, and growth projections.

After File → Make a copy in Google Sheets, use File → Download → Microsoft Excel (.xlsx) anytime.

Related guides

Google Sheets trading journal template

Pillar page — all sheet copy links

$25K stock challenge case study

Pre-filled sheet + video

Start journaling stocks trades today

Copy the Google Sheet free—or automate reviews with TradeJournal.co when manual entry slows you down.

Copy Google Sheet Try the app free