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

Stock Watchlist

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

A watchlist is only useful if you write down the price at which you would act. On Tickers, list each symbol with its sector, the price now, a level at or below which you would buy and a level at or above which you would sell. The Signal column reads Buy zone, Sell zone or Wait, and two more columns show how far the price is above the buy level and below the sell level.

The Targets tab counts names in each zone and by sector. Notes keeps the reason you are watching, the main risk, a review date and a status such as Researching or Ready, plus a count of reviews that are due. Company names and prices are invented. Update prices by hand or paste them in.

Useful for

  • See which names have reached the price you set
  • Spot a watchlist that is all in one sector
  • Remember why you were interested in each stock

What's included

  • 4 tabs: Tickers, Targets, Notes, How to use
  • Tickers: a table
  • Targets: a dashboard with 4 summary figures
  • Notes: a table with 2 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 Tickers 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 make a stock watchlist?

List the stocks you follow with their current prices, then add the buy and sell prices you decided on in advance. Record why you are watching each one.

How many stocks should be on a watchlist?

Enough that you can follow each one, which is often a dozen or two. The sector count in this sheet shows if the list is lopsided.

Will prices refresh on their own?

No. You type or paste prices, which keeps the file consistent in both programs and needs no add-ins.

  • #investment-tracker
  • #stock-watchlist
  • #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…