How to Build a Dividend Stock Watchlist in Google Sheets!

Save
3 years ago
31

Link to download my stock valuation spreadsheets:
https://www.patreon.com/dividendology

Get up to 12 free stocks now using my link for Webull! (Free Money!!): https://a.webull.com/i/Dividendology

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

In this video, I take you step by step on how to build an interactive dividend stock watchlist in google sheets. Let me know if you have any questions down below in the comments!

Formulas:

Trendline:
=SPARKLINE((GOOGLEFINANCE(A2,"price", today()-364, today())))

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

Dividend Payout:
=(SUBSTITUTE(index(importhtml("http://finviz.com/quote.ashx?t="&A2,"table",9),7,2),"*",""))

Payout Ratio:
=(SUBSTITUTE(index(importhtml("http://finviz.com/quote.ashx?t="&A2,"table",9),11,8),"*",""))

Industry:
=if(A2="","",IFERROR(substitute(Index(IMPORTHTML("https://finviz.com/quote.ashx?t="&A2,"Table",7),3,1),"*",""),"-"))
=left(L2, Search(" |",L2))

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.

Loading comments...