Build A Fully Functioning STOCK WATCHLIST With Live Data In Google Sheets

Brian Turgeon (bmturgeon) 1,014,208 lượt xem 3 years ago

Video Not Working? Fix It Now

Easily build a complete stock watchlist in Google Sheets.

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

Links to referenced videos can be found below:

GOOGLE FINANCE:
https://youtu.be/94XpstOfZoU

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

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

INDEX FUNCTION:
https://youtu.be/hH54skyJfvg

IF ERROR:
https://youtu.be/R7E7BC1FjMg

ALTERNATING COLORS:
https://youtu.be/K_iOt87vKFE

REFERENCE CELLS:
https://youtu.be/HRzfHcgDvyk

#GoogleFinance #StockWatchlist #StockTracker

Comment