Stock Trading Journal Template (Excel + Google Sheets, Free)

What's inside the stock trading journal template

The workbook is a single Trade Log sheet with 200 rows: date, symbol, entry price, exit price, quantity, fees, a Setup dropdown, and an Emotion dropdown. P&L per trade calculates automatically as you fill in each row - no manual math, no separate calculator.

A summary block below the log rolls the whole log up into a dashboard: closed trades logged, win rate, total P&L, and average win versus average loss - so you can see your overall trading performance without scrolling through every row.

Setup and Emotion are dropdown lists, not free-text fields, so your journal stays consistent from trade to trade - you can filter or sort by either one to see which setups or emotional states actually make you money.

P&L per trade, win rate, and profit factor - the formulas

P&L per trade is (exit price minus entry price) times quantity, minus fees - a straightforward realized P&L calculation for a closed long trade. Win rate counts only rows with a non-blank P&L value, so an empty row never drags your win rate down.

Average win and average loss split winning and losing trades into two separate averages, which is a more useful read on your edge than a single blended average P&L - a strategy with a 40% win rate can still be profitable if average win is much bigger than average loss.

Two of the scraped competitor templates (TradeBB, TradeZella) offer similar dashboard math but push you toward a paid, account-based SaaS journal for anything beyond the basics - this file is a single ungated spreadsheet with no signup.

Trading psychology and lessons-learned log

Every trade row has a Setup and an Emotion column, both dropdown lists, so the psychology side of your trading is tracked in the same place as the numbers - not in a separate notebook you forget to update.

Because Setup and Emotion sit in the same row as entry, exit and P&L, you can sort or filter the log to answer questions like 'which setup actually wins most often' or 'do I lose more on trades I entered feeling FOMO' - patterns that are hard to see from a raw trade blotter alone.

Who this template is for

Active retail traders who want a single offline file to log every trade, review win rate and average win/loss, and start connecting emotional state to actual outcomes - without creating an account with a trading-journal SaaS product.

This template is for tracking and reviewing your own trading history. It is not financial advice, does not recommend specific trades, and does not connect to any brokerage or live market data.