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
Ай бұрын
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
Ай бұрын
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.
@shizue-w7n
Ай бұрын
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.
@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.
@jotaele495
7 күн бұрын
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.
@brianturgeon
6 күн бұрын
@@jotaele495 Thank you!
@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
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.
@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!
@TBradFashionModel
Жыл бұрын
Holy Cow son,......that whipping around,...I was whipped off the trail, I will have to watch this in slow motion.
@idonavot4435
Жыл бұрын
Do you have here a link to open that spreadsheet that you created? Thanks
@leesnodgrass5708
4 ай бұрын
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
Жыл бұрын
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?
@cwilson6880
8 ай бұрын
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!
@phunt8551
Жыл бұрын
How do you create short 2 with the dividend amt. Whst is the formuls?
@ozcanonal
8 ай бұрын
It’s a pleasure to watch your videos and learn something new every time. Thanks 🙏
@marymilner8144
2 ай бұрын
Just what I am looking for and even better - thanks!
@sartajbhullar3782
6 ай бұрын
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.
@adamporetti5983
Жыл бұрын
That's great but is there a way that the yield data can be populated dynamically with Google Finance or other??
@Gijs9114
Жыл бұрын
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
@stevenleith7237
6 ай бұрын
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?
@Gijs9114
Жыл бұрын
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
Жыл бұрын
Thanks so much, glad you customized it!
@ktran991
2 ай бұрын
Beautiful. Thank you!
@dyendil
4 ай бұрын
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?
@raulmungia7307
Жыл бұрын
Great video! I'd like a copy of this tracker, where's the link?
@strangergranger10
8 ай бұрын
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!
@91210paige
9 ай бұрын
Anyone see the link to this?
@Joe-zu7xx
10 ай бұрын
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.
@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
Жыл бұрын
This is what I was wondering.
@Gijs9114
Жыл бұрын
@@theocratickingdom30 if you guys are talking about Column C in the 2nd Tab (the tab where he enters payment data) this is added manually.
@InfirmierMobileQuebec
Жыл бұрын
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
@kanegs1
8 ай бұрын
Very nice!...well done, love it! Learned a lot!
@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?
@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
Жыл бұрын
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.
@MrMmahesh007
Жыл бұрын
Man you have a amazing taken in Google sheets. Very nice 👍👍
@timelwood2555
Жыл бұрын
Nice job Brian! How do i get a copy of this tracker ?
@djessdark948
Жыл бұрын
up
@Moguiman
Жыл бұрын
Great video - I was able to duplicate it exactly. The pace was fine.
@abdurahiman347
7 ай бұрын
Great Videos, Please explain, how to write 52 week high stocks in excel sheet.
@Thewesrobertson
4 ай бұрын
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?
@TeresaBatica
4 ай бұрын
Great!!!
@picklepete112
Жыл бұрын
Now this was awesome word on the street is that you recorded this in Minella’s room?!!!!😮
@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
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
@peterwilliams6188
Жыл бұрын
Brilliant - thank you
@DynamicsInFinances
2 ай бұрын
Maybe add a field for the # of shares?
@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
@antonekgrycksboskolan5766
8 ай бұрын
Any idea how to do to continue with this in year 2024 in a smart way?
@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
@NikiinCanada
Жыл бұрын
I like it
@bhavneshparikh8283
7 ай бұрын
Can be available portpoliy file ? Means etf share etc all are available in one file?
@babinbabababafredyprakash2836
Жыл бұрын
from where could I download the template
@kgba17580
9 ай бұрын
cant get it to work i get as far as doing googlefinance etc and i get name in but wont put price in
@mr.xernorus4026
10 ай бұрын
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.
@kgba17580
9 ай бұрын
HI can this be done with uk stocks n shares please, thanks in advance
@daepark4681
Жыл бұрын
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.
@malonhermetica
Жыл бұрын
Hola q tal? De donde saco la "dividend list"??? Se puede descargar?
@Sunil.Gidwani
5 ай бұрын
Very nice video can you share sheet link please
@Loveonly56
6 ай бұрын
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 ?
@Loveonly56
6 ай бұрын
AND SHARE THIS COPY SHEET PELASE
@sottovuotospinto
8 ай бұрын
Not possible to share it?
@ddp2049
Жыл бұрын
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
@39lloydb
8 ай бұрын
Where's the template?
@josephglavin2472
9 ай бұрын
Please Slow down. If we knew what we were doing, we wouldn't be here. :)
Пікірлер: 77