Uploaded July 2021 | Updated September 2026, 3 hours ago

---

Easily build a complete stock watchlist in Google Sheets.

Here's my template for this sheet:
docs.google.com/spreadsheets/d/1lW0SUfsty7qEVJpWuV7ANkBZK027RI_CouSsDM0XfmQ/edit?usp=sharing

Links to referenced videos can be found below:

GOOGLE FINANCE:
youtu.be/94XpstOfZoU

CUSTOM # FORMAT (POS. OR NEG.):
youtu.be/8Kn2Bm1Dok0

CUSTOM # FORMAT (LARGE NUMBERS):
youtu.be/iXGoznnWphQ

INDEX FUNCTION:
youtu.be/hH54skyJfvg

IF ERROR:
youtu.be/R7E7BC1FjMg

ALTERNATING COLORS:
youtu.be/K_iOt87vKFE

REFERENCE CELLS:
youtu.be/HRzfHcgDvyk

#GoogleFinance #StockWatchlist #StockTracker