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
/ @brianturgeon
brianturgeon.yt
Пікірлер: 77
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
@Daneilchirs
22 күн бұрын
Since risk is at an all-time high right now, perhaps you should be a little more patient and return when it has decreased. Alternatively, you can consult a trained financial expert for strategy.
@shizue-w7n
22 күн бұрын
Yes true, I have been in touch with a brokerage Advisor. With an initial starting reserve of $80k, my advisor chooses the entry and exit commands for my portfolio, which has grown to approximately $550k.
@shanisonia
22 күн бұрын
I’ve been looking to switch to an advisor for a while now. Any help pointing me to who your advisor is?
@shizue-w7n
22 күн бұрын
Angela Lynn Shilling is the licensed advisor I use. Just research the name. You’d find necessary details to work with a correspondence to set up an appointment.
@shanisonia
22 күн бұрын
I searched for her full name online, found her page, and sent an email to schedule a meeting. Hopefully, she responds soon. Thank you
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.
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!
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!
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.
@Joe-tg5rq
2 ай бұрын
Did you find out how to get the dividend data to start sheet 2?
@jessicam-brown9
2 ай бұрын
@@Joe-tg5rq I thought I was missing something as well.
Beautiful. Thank you!
It’s a pleasure to watch your videos and learn something new every time. Thanks 🙏
Brilliant - thank you
Do you have here a link to open that spreadsheet that you created? Thanks
Great video - I was able to duplicate it exactly. The pace was fine.
Just what I am looking for and even better - thanks!
Holy Cow son,......that whipping around,...I was whipped off the trail, I will have to watch this in slow motion.
How do you create short 2 with the dividend amt. Whst is the formuls?
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?
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?
Very nice!...well done, love it! Learned a lot!
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!
@brianturgeon
11 ай бұрын
Thanks so much, glad you customized it!
Great!!!
Man you have a amazing taken in Google sheets. Very nice 👍👍
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!
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.
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.
@brianturgeon
Жыл бұрын
That's a great idea, appreciate it!
@shawnl9449
Жыл бұрын
@@brianturgeon Do you have an email address that I can contact you on?
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?
I like it
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?
That's great but is there a way that the yield data can be populated dynamically with Google Finance or other??
@Gijs9114
11 ай бұрын
Yes this is possible. I've added it to my personal dividend portfolio tracker (based on this video) i've made a video explaining exactly how I made mine on my channel
Anyone see the link to this?
Can be available portpoliy file ? Means etf share etc all are available in one file?
what is the formula for the Dividend column on the Dividend list sheet or is this something that need to be added manually?
@theocratickingdom30
Жыл бұрын
This is what I was wondering.
@Gijs9114
11 ай бұрын
@@theocratickingdom30 if you guys are talking about Column C in the 2nd Tab (the tab where he enters payment data) this is 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.
@DavidGomez-le7if
10 ай бұрын
that depends in Mexico FIBRAS (REIT's) are obliged to pay 95% of the fiscal result to the investors, not sure how it works in the USA. But that is the way it works in Mexico
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.
Hola q tal? De donde saco la "dividend list"??? Se puede descargar?
Great video! I'd like a copy of this tracker, where's the link?
hey Brian Thank you for the video, however the link to download the template is not available, could you please add it.
@strangergranger10
8 ай бұрын
Following
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.
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
HI can this be done with uk stocks n shares please, thanks in advance
from where could I download the template
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.
@Gijs9114
11 ай бұрын
I've put some work into expanding the tracker Brian detailed in this video. perhaps check out my take on it and maybe it's what you're looking for.
Hi, adding 2 colums, video at 2:24, how did you do it? Thanks.
@antonekgrycksboskolan5766
Жыл бұрын
Right click in marked header, add two column to the right.
Any idea how to do to continue with this in year 2024 in a smart way?
Nice job Brian! How do i get a copy of this tracker ?
@djessdark948
Жыл бұрын
up
cant get it to work i get as far as doing googlefinance etc and i get name in but wont put price in
Do you the same sheet in excel?
@brianturgeon
Жыл бұрын
The same could be done in Excel, except for the Google Finance live data. That is exclusive to Sheets. Hope that helps
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.
Great Videos, Please explain, how to write 52 week high stocks in excel sheet.
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
Not possible to share it?
Maybe add a field for the # of shares?
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 ?
Very nice video can you share sheet link please
Where's the template?
AND SHARE THIS COPY SHEET PELASE
Please Slow down. If we knew what we were doing, we wouldn't be here. :)