Build a Stock Watchlist in Google Sheets! (Tutorial)

Access Tickerdata and my Spreadsheets: tickerdata.com/
Get 59% off of Seeking Alpha Premium!
www.sahg6dtr.com/9D5QH2/R74QP/
Get up to 17 Free stocks with moomoo | Open a new account and deposit:
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("finviz.com/quote.ashx?t="&I2,"table",10),7,2),"*",""))
Industry:
=if(I2="","",IFERROR(substitute(Index(IMPORTHTML("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! dividendology.substack.com/
Social Media (and other fun stuff): linktr.ee/dividendology
I am not a Financial advisor or licensed professional. Nothing I say or produce on TH-cam, 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.

[@Dividendology]

Formulas:

[@Nightbreed357]

Industry formula does not work currently. For me, it just prints "-", which is default for Error.

[@ilop4953]

Thank you my friend. One of the BEST tutorial I have found.

[@daviddijkman9946]

Wow this is an amazingly clear video, even for an excel noob like me you make it look easy! Thanks a lot :)

[@memphis370z]

Excellent video! Thank you for sharing.

[@jeanphi0078]

Thank you very much fro this very informative video. One question why you cannot add $ symbol for the dividend column

[@andrecorreia9029]

Fantastic video. Thank you!. Could be interesting if you add a column for your intrinsic value calculation, margin of safety and acceptable price to buy :D

[@ReedsDividendJourney]

Great video

[@callumhewson8514]

Got Error Message (same as last time on your older video and you told me it was fixed on more recent) = Message = function INDEX parameter 2 value is 7 Valis values are between 0 and 1 inclusive

[@niculaeandrei418]

Hi and thanks for all your video and informations. It's help me so very much.

[@Waleed-Joudeh]

Thank u !! This is nice !!

[@campbellew4551]

Awesome video!

[@joaobarbosa3807]

incredible work, but i have a doubt when i pull the dividend data and try to do the calculations for the dividend yield google sheets say: "Paramete 1 expects number values but is a text and cannot be coerced to a number." Any idea on how to solve this?

[@fizr3564]

wat about a column for exdiv date? formula?

[@kingc209]

Love this, Question: when i put in the formula for dividend I get this

[@DisruptiveWealthCreation]

Great walthrough on the tutorial LIKE 143#

[@patrickbradsher9559]

Trying to code Industry into A3, but it is not working. I can pull it up using Stock Ticker in code but not automate from cell. Any ideas to why it's not working?

[@Billyonaire__]

Man seems to work for other people, idk what I'm doing wrong but the dividend formula gives me

[@Martin_Kitahara]

Hi, in my German sheet your formula for dividends doesnt work. I figured out that we replace "," with ";" in our google formulas commands (example: =GOOGLEFINANCE(B15;"PE") but I still didnt get it to work for the dividend. Anyone have some advice?

[@barendippel554]

Great Vid, but I do have some company's from Europe wich are not listed at finviz :(