How to Build a Dividend Stock Watchlist in Google Sheets!
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.
-
44:28
Steven Crowder
1 hour ago🔴 DOJ Chief Admits Trump Indictments a Politically Motivated ‘Perversion of Justice’
122K178 -
1:35:09
Graham Allen
3 hours agoFBI KNEW ABOUT GA SHOOTER!! Trump DESTROYS Kamala at Town Hall + Tim Walz Is Being Subpoenaed!!
30.5K85 -
LIVE
Rethinking the Dollar
29 minutes agoVolatility Up & Markets Trending Down! What Comes Next? | Morning Check-In
112 watching -
2:02:26
Matt Kohrs
9 hours agoBEWARE! The Stock Market Is TILTED || The MK Show
26.9K1 -
LIVE
LFA TV
14 hours agoABOVE THE LAW? | LIVE FROM AMERICA with JEREMY HERRELL 9/5/24 11am
4,334 watching -
1:06:32
2 MIKES LIVE
2 hours agoThe Mike Schwartz Show 09-05-2024
15K -
28:40
BonginoReport
5 hours agoThe Censorship Regime Came After Me (Ep.36) - 09/05/24
37.8K72 -
1:40:09
Game On!
12 hours agoSuper Bowl Champ vs Reigning MVP! NFL 2024 is here!
41.9K1 -
13:06
Lloyd And Mandy
14 hours agoWhy We Left Australia And May NEVER GO BACK....
57.5K75 -
11:07
Dermatologist Dr. Dustin Portela
16 days agoHow to Fix Crepey Skin - Doctor Explains
26.5K5