Skip to content
The title slide and first slides of the Stock Trade Journal template

Stock Trade Journal

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Bold
Difficulty
Beginner
Updated
November 16, 2026

Every slide (5)

Overview

A trade journal helps most when it records the reasoning and the mistakes next to the numbers. The Trades tab takes the dates, symbol, side, shares, entry, exit, fees and setup, then fills in profit, return, result and days held. Short trades are handled, and a trade with no exit price stays marked Open.

Results turns the journal into a win rate, an average win, an average loss and a profit factor, with net profit split by setup and by long versus short. The Lessons tab asks whether you followed your plan, names the main slip and records a rule for next time. Symbols and prices in the sample are invented.

Useful for

  • Find out which setup earns and which one loses
  • Compare average win with average loss, not just win rate
  • Review how often you broke your own trading plan

What's included

  • 4 tabs: Trades, Results, Lessons, How to use
  • Trades: a table
  • Results: a dashboard with 6 summary figures
  • Lessons: a table with 3 summary figures
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Trades tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I keep a trading journal?

Record the date, symbol, entry, exit and size of every trade, plus why you took it and what you learned. Review the journal on a schedule, looking for setups and habits that repeat.

How do I calculate win rate and profit factor?

Win rate is winning trades divided by closed trades. Profit factor is the sum of winning profits divided by the sum of losing amounts. Both are calculated for you on the Results tab.

Should I count fees in my trade results?

Yes, they reduce profit. Enter commissions or other costs in the Fees column and the profit formula subtracts them. Keep broker statements for taxes.

  • #investment-tracker
  • #stock-trade-journal
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More investment tracker templates

See all 14

Also in Finance

All finance templates
Get this template

Preparing your template…