How To Track High Yield Dividend Stocks in Google Sheets 

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

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.

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!

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!

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

Beautiful. Thank you!

Brilliant - thank you

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

Great!!!

Great video - I was able to duplicate it exactly. The pace was fine.

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.

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

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

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

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.

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!

I like it

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

I love this tutorial. I give this a like 👍 and also a follow. Hopefully, you’ll be able to put this google sheet for us to have a copy. Thank you!

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

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.

Brian where are you scrapping the dataset for each Stock, Dividend and Month? - Minute 4:45. Cab this be scrapped or ae we doing it manually?

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

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

I'm having serious problems trying to introduce US and other countries taxes and also the US/EUR conversion into the equation. Found you table very easy to implement, do you have any advice for my tedious task?

Great! Thank you. I'm looking for a good way to show my dividend yield in real time in percentage . Do you know a good way to?

what is the formula for the Dividend column on the Dividend list sheet or is this something that need to be added manually?

Now this was awesome word on the street is that you recorded this in Minella’s room?!!!!😮

Great video. Easy to follow. However, as you know, companies are not obliged to pay a dividend. Would it be possible for your tracker to show missed dividends as a red cell.

I am going to make this but do you happen to have a Copy and Paste version available like you have for the Stock Tracker?

Can be available portpoliy file ? Means etf share etc all are available in one file?

Great video! I'd like a copy of this tracker, where's the link?

Anyone see the link to this?

hey Brian Thank you for the video, however the link to download the template is not available, could you please add it.

Great Videos, Please explain, how to write 52 week high stocks in excel sheet.

cant get it to work i get as far as doing googlefinance etc and i get name in but wont put price in

Hey Brian... Excellent video but I lost you and I know I could not do this on my own. Do you know if there is a site that has a blank spread sheet with all the formulas? Thanks in advance.

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

Hola q tal? De donde saco la "dividend list"??? Se puede descargar?

Maybe add a field for the # of shares?

from where could I download the template

I am sorry but I dont see how you get the dividend amount for each stock. What is the formula to get from another party

Let me see if I got it. Your dividends list was entered manually, but you're (not your) making a calendar-type calculator for the totals. I was hoping it was a current automatic dividend spreadsheet. It looks good, not just what I need.

Like yourself I’m very knowledgeable when using all aspects of excel and inputting data. However, many people are not. Your video was much to quick in execution

Hi, adding 2 colums, video at 2:24, how did you do it? Thanks.

HI can this be done with uk stocks n shares please, thanks in advance

Any idea how to do to continue with this in year 2024 in a smart way?

Do you the same sheet in excel?

That cool but whats the point, what i wanted was this but also be able to swtich year from like 2000 to 2080 back and fourth.

AND SHARE THIS COPY SHEET PELASE

Very nice video can you share sheet link please

Not possible to share it?

HI NICE VIDEO PLEASE HELP FOR MY PROBLEM IF I WANT ONLY COMPANY NAME HOW TO KNOW NAME LISTED CODE LIKE I KNOW COMPANY NAME IS APPLE INC SO HOW CAN AND WHICH FORMULA TO KNOW TICKER NAME IS AAPL HAVE ANY FORMULA ?

Where's the template?

Please Slow down. If we knew what we were doing, we wouldn't be here. :)