Build a Stock Watchlist in Google Sheets! (Tutorial)

Access Tickerdata and my Spreadsheets: https://tickerdata.com/

Get 59% off of Seeking Alpha Premium!
https://www.sahg6dtr.com/9D5QH2/R74QP/

Get up to 17 Free stocks with moomoo | Open a new account and deposit:
https://j.moomoo.com/00ru2z


In this video, I show you how powerful of a tool google sheets can be. I take you step by step on how to build a stock watchlist in google sheets. Let me know if you have any questions!

Formulas:

Here is the updated formula to pull dividends and industry:

Dividends:
=(SUBSTITUTE(index(importhtml("http://finviz.com/quote.ashx?t="&I2,"table",10),7,2),"*",""))

Industry:
=if(I2="","",IFERROR(substitute(Index(IMPORTHTML("https://finviz.com/quote.ashx?t="&I2,"Table",8),3,1),"*",""),"-"))

=if(I2="","",Left(Q2, Search(" |",Q2)))

*Be sure to adjust I2 to where your ticker is located

12 Month Return: =(GOOGLEFINANCE(C5,"price") / index(GOOGLEFINANCE(C5,"price", datevalue(today()-365) ) , 2,2) - 1 )

1 Yr Chart: =(SPARKLINE(index(GOOGLEFINANCE(C5,"price",today()-365,today()),,2),{"Charttype","column";"color","purple"}))

2 Yr Chart: =(SPARKLINE(index(GOOGLEFINANCE(C5,"price",today()-730,today()),,2),{"Charttype","column";"color","purple"}))


Join my free monthly newsletter! https://dividendology.substack.com/


Social Media (and other fun stuff): https://linktr.ee/dividendology


I am not a Financial advisor or licensed professional. Nothing I say or produce on YouTube, or anywhere else, should be considered as advice. All content is for educational purposes only. I am not responsible for any financial losses or gains. Invest and trade at your own risk. Some of the links in the description may be affiliate links.