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.
-
LIVE
The Charlie Kirk Show
1 hour agoThe Return of the King: The Republican National Convention, Day 4 | Navarro, Presler, Sen. Rubio
12,992 watching -
53:31
The Dan Bongino Show
3 hours agoThe Troubling Truth Is Starting To Emerge (Ep. 2289) - 07/18/2024
468K2.06K -
49:36
Dave Portnoy
3 hours agoThe Unnamed Show With Dave Portnoy, Kirk Minihane, Ryan Whitney - Ep. 22
14K1 -
1:29:37
Steve-O's Wild Ride! Podcast
1 day agoBert Kreischer Is Disappointed -Wild Ride #224
25.9K5 -
LIVE
Blue Siesta ASMR
1 hour agoASMR Sims 4 Gameplay | Pregnant with the MOST TOXIC guy in the house | Soft Spoken
105 watching -
2:01:21
LFA TV
7 hours agoTHE FIX IS IN! | LIVE FROM AMERICA 7.18.24 11am EST
62.1K36 -
55:12
The Rubin Report
2 hours agoJoe Biden Accidentally Drops a Clue That He’s About to Drop Out
54.6K28 -
43:49
Legal Insurrection
14 hours agoWill We Ever Know the Truth About the Trump Assassination Attempt?
7.76K2 -
29:29
Breaking Points
3 hours ago7/18/24: LIVE AMA!
25.6K8 -
1:23:16
Graham Allen
5 hours agoBiden Is Dropping OUT And They Are Using COVID!! + Secret Service KNEW The Attack Was Coming?!
75.1K280