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

  • @myrle-v4g
    @myrle-v4g22 күн бұрын

    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

    @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

    @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

    @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

    @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

    @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

  • @nicholasniemiec6878
    @nicholasniemiec6878 Жыл бұрын

    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.

  • @glennbrown306
    @glennbrown306 Жыл бұрын

    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!

  • @cwilson6880
    @cwilson68807 ай бұрын

    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!

  • @andrewbuch4472
    @andrewbuch4472 Жыл бұрын

    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

    @Joe-tg5rq

    2 ай бұрын

    Did you find out how to get the dividend data to start sheet 2?

  • @jessicam-brown9

    @jessicam-brown9

    2 ай бұрын

    @@Joe-tg5rq I thought I was missing something as well.

  • @ktran991
    @ktran991Ай бұрын

    Beautiful. Thank you!

  • @ozcanonal
    @ozcanonal7 ай бұрын

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

  • @peterwilliams6188
    @peterwilliams6188 Жыл бұрын

    Brilliant - thank you

  • @idonavot4435
    @idonavot4435 Жыл бұрын

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

  • @Moguiman
    @Moguiman Жыл бұрын

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

  • @marymilner8144
    @marymilner81442 ай бұрын

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

  • @TBradFashionModel
    @TBradFashionModel Жыл бұрын

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

  • @phunt8551
    @phunt8551 Жыл бұрын

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

  • @INWMI
    @INWMI Жыл бұрын

    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?

  • @stevenleith7237
    @stevenleith72375 ай бұрын

    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?

  • @kanegs1
    @kanegs18 ай бұрын

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

  • @Gijs9114
    @Gijs911411 ай бұрын

    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

    @brianturgeon

    11 ай бұрын

    Thanks so much, glad you customized it!

  • @TeresaBatica
    @TeresaBatica4 ай бұрын

    Great!!!

  • @MrMmahesh007
    @MrMmahesh007 Жыл бұрын

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

  • @strangergranger10
    @strangergranger108 ай бұрын

    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!

  • @leesnodgrass5708
    @leesnodgrass57083 ай бұрын

    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.

  • @shawnl9449
    @shawnl9449 Жыл бұрын

    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

    @brianturgeon

    Жыл бұрын

    That's a great idea, appreciate it!

  • @shawnl9449

    @shawnl9449

    Жыл бұрын

    @@brianturgeon Do you have an email address that I can contact you on?

  • @dyendil
    @dyendil4 ай бұрын

    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?

  • @NikiinCanada
    @NikiinCanada Жыл бұрын

    I like it

  • @Thewesrobertson
    @Thewesrobertson3 ай бұрын

    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?

  • @adamporetti5983
    @adamporetti5983 Жыл бұрын

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

  • @Gijs9114

    @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

  • @91210paige
    @91210paige8 ай бұрын

    Anyone see the link to this?

  • @bhavneshparikh8283
    @bhavneshparikh82836 ай бұрын

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

  • @jeremygoodmurphy1324
    @jeremygoodmurphy1324 Жыл бұрын

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

  • @theocratickingdom30

    @theocratickingdom30

    Жыл бұрын

    This is what I was wondering.

  • @Gijs9114

    @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.

  • @picklepete112
    @picklepete112 Жыл бұрын

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

  • @bward7960
    @bward7960 Жыл бұрын

    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

    @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

  • @Joe-zu7xx
    @Joe-zu7xx9 ай бұрын

    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.

  • @malonhermetica
    @malonhermetica Жыл бұрын

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

  • @raulmungia7307
    @raulmungia7307 Жыл бұрын

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

  • @InfirmierMobileQuebec
    @InfirmierMobileQuebec Жыл бұрын

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

  • @strangergranger10

    @strangergranger10

    8 ай бұрын

    Following

  • @sartajbhullar3782
    @sartajbhullar37825 ай бұрын

    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.

  • @phunt8551
    @phunt8551 Жыл бұрын

    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

  • @kgba17580
    @kgba175808 ай бұрын

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

  • @babinbabababafredyprakash2836
    @babinbabababafredyprakash2836 Жыл бұрын

    from where could I download the template

  • @WenSaiPanther
    @WenSaiPanther Жыл бұрын

    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

    @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.

  • @daepark4681
    @daepark4681 Жыл бұрын

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

  • @antonekgrycksboskolan5766

    @antonekgrycksboskolan5766

    Жыл бұрын

    Right click in marked header, add two column to the right.

  • @antonekgrycksboskolan5766
    @antonekgrycksboskolan57668 ай бұрын

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

  • @timelwood2555
    @timelwood2555 Жыл бұрын

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

  • @djessdark948

    @djessdark948

    Жыл бұрын

    up

  • @kgba17580
    @kgba175808 ай бұрын

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

  • @ddp2049
    @ddp2049 Жыл бұрын

    Do you the same sheet in excel?

  • @brianturgeon

    @brianturgeon

    Жыл бұрын

    The same could be done in Excel, except for the Google Finance live data. That is exclusive to Sheets. Hope that helps

  • @mr.xernorus4026
    @mr.xernorus402610 ай бұрын

    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.

  • @abdurahiman347
    @abdurahiman3476 ай бұрын

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

  • @kironkav
    @kironkav Жыл бұрын

    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

  • @sottovuotospinto
    @sottovuotospinto8 ай бұрын

    Not possible to share it?

  • @DynamicsInFinances
    @DynamicsInFinancesАй бұрын

    Maybe add a field for the # of shares?

  • @Loveonly56
    @Loveonly566 ай бұрын

    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 ?

  • @Sunil.Gidwani
    @Sunil.Gidwani5 ай бұрын

    Very nice video can you share sheet link please

  • @39lloydb
    @39lloydb7 ай бұрын

    Where's the template?

  • @Loveonly56
    @Loveonly566 ай бұрын

    AND SHARE THIS COPY SHEET PELASE

  • @josephglavin2472
    @josephglavin24729 ай бұрын

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

Келесі