How To Track High Yield Dividend Stocks in Google Sheets

Dividend stocks are a great way to build wealth and passive income. In this tutorial, see how we can create a dividend tracker with Google Sheets automation. Use google finance to track your stocks or as a watchlist for dividend stocks you may be interested in.

#Dividend #GoogleSheets #Excel

[SinikadzaiChewte]

I'm 54 and my wife and I are VERY worried about our future, gas and food prices rising daily. We have had our savings dwindle with the cost of living into the stratosphere, and we are finding it impossible to replace them. We can get by, but can't seem to get ahead. My condolences to anyone retiring in this crisis, 30 years nonstop just for a crooked system to take all you worked for.

[myrle-vg]

I think investors should always put their cash to work, especially In 2024, we'll start to see more market diversification. I'm hoping to invest about $350k of my savings in stocks against next year. Hope to make millions in 2024

[nicholasniemiec]

I just want to hear this dude whisper softly in my ear. I don’t know exactly what it is about his voice. It’s so soothing though. I could listen to Brian Turgeon say “let’s get started” right before I go to sleep for the rest of my life. His voice is so soft, gentle, caring. You can tell he cares about his spreadsheets, he cares about his followers, he cares about us. Goodnight, Brian.

[jotaele]

This is the best and most pedagogical video I have seen so far about stock/dividends tracker, the way you explain the formulas and everything is amazing, instead of just copying we are actually UNDERSTANDING what each thing does, appreciate it! subscribed.

[andrewbuch]

this is nice and all, but where do you get the dividend data from the start? can it be automated? i don't see anything in google sheets that pulls dividend cash amounts.

[ozcanonal]

It’s a pleasure to watch your videos and learn something new every time. Thanks 🙏

[marymilner]

Just what I am looking for and even better - thanks!

[glennbrown]

I had to watch this in the same manner as when I watch painter Bob Ross! I watch for 2-3 minutes, then I take about 15 minutes to think about and do what I just saw! Amazing and very useful Google Sheets skills/knowledge, Bro. I like your stock picks, too!

[shawnl]

So I've watched a few of your videos and I think your doing great. I was hoping that you might expand more on the dividends, to include a 5 year average dividend yield and a 10 year dividend yield, so that a dividend investor, using those averages might be able decide if a company is over/under valued.

[leesnodgrass]

Excellent video and I learned a lot following your tutorial from scratch. I'd love to see another video on adding quantities of shares to see the annual impact.

[cwilson]

Hi Brian, I'm just learning to build these spreadsheets and love that you put this tutorial on line! thanks a ton for the head start vs figuring all this out on my own. Cheers!

[idonavot]

Do you have here a link to open that spreadsheet that you created? Thanks

[TBradFashionModel]

Holy Cow whipping around, ...I was whipped off the trail, I will have to watch this in slow motion.

[kanegs]

Very nice!...well done, love it! Learned a lot!

[Gijs]

Hi Brian, thanks for the video it's been a great help. I've added some features such as graphs and barcharts to give the tracker some more visuals.
Great video and keep at it making awesome content like this!

[adamporetti]

That's great but is there a way that the yield data can be populated dynamically with Google Finance or other??

[MrMmahesh]

Man you have a amazing taken in Google sheets. Very nice 👍👍

[phunt]

How do you create short 2 with the dividend amt. Whst is the formuls?

[sartajbhullar]

Please give us a way where sheets can display the dividend data, yield, projected (based on your shares), ex dividend date, payout that stuff. Really like your videos. Thanks for all you do.

[timelwood]

Nice job Brian! How do i get a copy of this tracker ?