Build A Fully Functioning STOCK WATCHLIST With Live Data In Google Sheets
ฝัง
- เผยแพร่เมื่อ 16 มิ.ย. 2024
- Easily build a complete stock watchlist in Google Sheets.
Here's my template for this sheet:
docs.google.com/spreadsheets/...
Links to referenced videos can be found below:
GOOGLE FINANCE:
• USING GOOGLE FINANCE T...
CUSTOM # FORMAT (POS. OR NEG.):
• FORMAT POSITIVE AND NE...
CUSTOM # FORMAT (LARGE NUMBERS):
• CUSTOM NUMBER FORMATTI...
INDEX FUNCTION:
• INDEX FUNCTION TUTORIA...
IF ERROR:
• FIXING ERROR MESSAGES ...
ALTERNATING COLORS:
• ADDING ALTERNATING COL...
REFERENCE CELLS:
• REFERENCE CELLS With T...
#GoogleFinance #StockWatchlist #StockTracker
Here's the link for my template! Feel free to use it for yourself!
docs.google.com/spreadsheets/d/1lW0SUfsty7qEVJpWuV7ANkBZK027RI_CouSsDM0XfmQ/edit?usp=sharing
Hello. Can You tell me, please? Is it possible to do it with CRYPTOCURRENCIES... Can You Help Me PLEASE?
Pretty cool, thanks!
i cant edit it
Question: can you tell or show, how to make the cell change color (red or green) based on days progress? The green or red text is fine but it would be much easier to follow when the entire cell is either red or green. thanks much
This file shared can not be copied for own use
While this provide an actual explanation of the market and how you value stocks. After buying stocks for just over 10 years, i'm still struggling to make gains. How do i adjust or revamp my $2M portfolio? should i consider some defensive investments?
In this current unstable markets, It is advisable to diversify while retaining 70-80% in secure investments. looking at the worth of your portfolio, you should consider financial advisory.
Agreed, my portfolio is well-matched for every market season yielding 85% from early last year to date. I and my advisr are working on a 7 figure ballpark goal, tho this could take another year. IMO, financial advisors are the most sought-after professionals after doctors.
great gains there! mind sharing details of your advisor pleas? i've started gaining more cash flow with my employment and looking at putting money into stocks and alternative assets that can help build wealth over time
She goes by ‘’Jennifer Leigh Hickman’ I suggest you look her up. To be honest, I almost didn't buy the idea of letting someone handle growing my finance, but so glad I did.
Thank you for sharing, I must say, Jennifer appears to be quite knowledgeable. After coming across her web page, I went through her resume and it was quite impressive. I reached out and scheduled a call
The key to big returns is not big moving stocks. It's managing risk in relationship to reward. Having the correct size on and turning your edge as many times as necessary to reach your goal. That holds true from long term investing to day trading.
May I ask which stocks are good? I've been looking at a few different ones but want other opinions as well.
@@helenoliver4838
@@theresagarcia1218 Are you in touch with a Financial-Adviser ? is your experience much better than investing on your own?
@@helenoliver4838 Yes I am in touch with a Financial Adviser and for the past 6months, I've been able to stay afloat the market crashes and I've watched my portfolio grow by over 40% these past few months.
@@theresagarcia1218 Wow, that's remarkable, who is your FA and how do you suggest I reach out to him/her?
These market uncertainties, which got the best of me in 2020 and left me holding worthless positions in the market, are the reason I don't base my market judgments and decisions on rumors and heresays. I had to completely revamp my portfolio with the help of an advisor before I started seeing any notable results in my portfolio, and I've been working with the same advisor and have scaled up 750k.
Do not forget to keep this in mind. There are happy and unhappy days. Although it's a zero-sum game, remember to diversify your holdings so that when one performs poorly, the others do as well. Furthermore, spend carefully and invest wisely. Hiring a skilled specialist with a platform that offers a variety of investing possibilities can help you do this. You may even get more by doing this, and you leave little space for regrets.
@@jamesvigor6409 Will you kindly suggest a professional with a range of investment options? This is very unusual, and I look forward to hearing from you.
@@jamesvigor6409 Insightful... I curiously looked up her name on the internet and I found her site, thanks for sharing
Roughly £120k in my portfolio are in tech/TSLA stocks, can I get an advice on any other stocks that I can acquire to diversify my reserve across multiple markets while creating a comprehensive portfolio allocation that balances my concerns of risk aversion and returns that meet yearly inflation.
You need to hire a financial advisor to help you diversify your portfolio by including Mutual Funds, Etf's, the 11 GICS groups, inflation-indexed bonds, and stocks of companies with reliable cash flows rather than growth stocks, where prices were based on future prospective earnings.
Buying a stock is easy, but buying the right stock without a time-tested strategy is incredibly hard. Hence what are the best stocks to buy now or put on a watchlist? I’ve been trying to grow my portfolio of $260K for sometime now, my major challenge is not knowing the best entry and exit strategies... I would greatly appreciate any suggestions.
TIMSYKES
I'm mostly in cash and waiting for the stock market to re-level on the reality of our situation. Or is gold the best pick to avoid a crunch and maximize my savings I'd love to hear your opinions.
we are living in a command economy. no way I'm buying into a market where the indexes are at all time highs
reminds me of the guy who sold all his stocks in like 1928 and everyone was calling him a chump, then the market crashed and he bought back in after a few years and made a killing, whereas many people got burnt
The issue is most people have the “I want to do it myself mentality” but not equipped for a crash. Ideally, advisors are perfect reps for investing jobs and at first-hand experience, my portfolio has yielded over 300%, summing up nearly $1m, since covid outbreak to date.
massive gains! mind sharing details of your financial advisr please? i've started gaining more cash flow with my employment and looking at putting money into stocks and alternative assets that can help build wealth over time
“Melissa Rose Francks’’ You can easily look her up, she has years of financiaI market experience.
amazing! I was looking for this kind of a video only and you explained it very nicely. And the red and green colour in change was like a cherry on top. can't believe only so less people have watched it
Thank you so much!
I feel sad that even though I am investing, I don't have the brain power to dig through how each company is doing, is this a good time to buy stocks or not, my reserve of $450K is laying waste to inflation and I don't know what to do at this point tbh, I need solid data on market trajectory
It all depends on how long you're willing to hold for
stocks might likely tank further, but making serious gains in this downtrend wouldn't be a problem if you're an expert
@@freddiethesoundboy4 think you could recommend this coach that guides you,
I've been looking into advisors myself and I'd really need guidance to scale through
Invest in real estate and earn passive income.
Be a private lender, register your security interest. earn HIGH interest payments for 1 year. get paid out. I dont know much about finances take it with a grain of salt..
cars and women
Great video, great narration, great insights! - No BS fillers, straight-to-the-point instructions!
Truly amazing work, sir, and I thank you so much for it, Brian.
Thank you!
This is amazing Brian. Only few weeks back I tried using Google sheets for stock screening. I have been struggling. This video helped me make my customised sheet. Thanks again. Looking forward to more educational videos from you.
Thank you!
This was great. I'm 72 years old and even though it took a couple days, I managed to follow along, find my own mistakes and ultimately made it work as instructed. This was fun and it will be very useful. What's next?
The video on the stock dashboard is outstanding, offering detailed and clear explanations. I found your presentation to be highly informative and educational. Thank you for this exceptional video
Highest level of clarity and competence. Such a pleasure to learn from you. Thank you.
Thank you very much!
Wow! That's great!
I was trying to work with free API and outdated stock stats. Never knew it was possible to produce such an amazing thing with Google Sheets.
Thanks a lot.
This was a great video. Your voice and tempo were on point. The content was great, and the explanation of the "how-to" was detailed enough. Great job, and thank you for the video.
Genius, thanks Brian. I started off following along, but struggled with the more complex bits, and ended up using the one you kindly made available.
I really appreciate the hard work you put into this and am so grateful that you shared it with us. Thank you!
Thank you!
I loved this video. I was using the stock function in Excel and was not getting all data elements. Thanks!! nice tutorial!!
My brother, you have done something in a short video that numerous other videos and training classes could never do for me. You taught me how to create a spreadsheet! Oh, my God! Thanks I appreciate it now I can actually do this with other things too. Wow! Lol.
Brother I just want to take the time to thank you so much for your videos…I really found what I was looking for 👏🏼👏🏼👏🏼
Excellent video; I was searching for this only last 2 days; Thank you for doing step by step
Man, thank you and then some. I had over 170 stocks in various watch lists in my TD Ameritrade account and trying to scroll and find was painful. With what I built from your guidance I'm golden and life is so much simpler.
Thank you! So glad it could help!
You are an amazing teacher - thank you so much for this. I subscribed and can't wait to see more of your videos.
Thank you so much!
Amazing work! I reference it often to make small changes to tailor to my needs. Thank you!
25 mins, worth spending on a very useful video. very accurate and up to the mark for anybody who has zero knowledge of programming/coding.
sub and liked the video :)
Thanks so much!
Duuuude thanks so much. So grateful this appeared in my videos, I had created a spreadsheet a year ago for my portfolio that I use almost daily but learned so much to improve it now
Thanks
Thank you! Glad it helped
Thanks Brian. I have been trying to do the same task for the last month or so. You solved it except yours is much better than the results I was looking for. I would like to see a video on a good method for sorting the results so I can quickly see all my target stocks trending up. Keep up the great work.
Thank you so much!
Just found this video. WOW! I never knew there was so much to do with the GOOGLEFINANCE function! Thanks!
While watching the movie "DUMP MONEY" i saw google sheet of Roaring kitty. I wanted to make the somewhat similar portfolio dashboards and I found your video. Thank you for sharing such a wonderful information.
Very cool and super useful! You went about the design at the right speed so it was easy to follow. Thanks
Thank you!
This is one of the best videos I watched about google finance formulas
Your Knowledge & Teaching skill is awesome, also you provide great knowledge. Heartly thanks ...:)
This is an excellent tutorial on Google Sheets and importing data from Google Finance.. Was able to follow it to the T and create a stock sheet for myself..
Thanks ever so much for creating and posting such and wonderful tutorial... Really like the 250 day chart idea and the capability to change it to whatever I want.
Have a good and safe day..... All the best to you...
Thank you so much! Really appreciate it
Thank-you so much Brian for putting together this incredible video (learned a lot) and sharing your template. As a tip to my fellow Canadians, if you want to track Canadian stocks use the prefix TSE for your ticker symbol e.g. TSE:TD (for Toronto Dominion bank). If you just use ticker TD without the TSE ... you will get TD in USD from NYSE. My 2 cents
I love to do this dashboards on google spreadsheet too. I learned some tricks from your video. Thanks for sharing!
Amazing video! I knew something like this was possible, but had no clue on how to do it. Thanks for the video.
Appreciate it!
This is amazing! I loved it and learned a lot! Weird that brokerage platforms don't have something like this built in such as the 250 day chart.
Thank you!
@@brianturgeon Brian, would you have an email address, I have a question..?
@@brianturgeon Very IMPRESSED with this sheet. Shame it was hard to see the input boxes while you were working. Is there a way to make them bigger so we see exactly what your typing in?
@@nriqueog Thank you and that's a great idea. I'll try to make that happen in future videos and possibly an adapted version of this one
@@brianturgeon That would be really cool to see in an updated one. Thnx!
Thank you for sharing this useful chart. Upon recreating it for myself, I have learned more about Google Sheets.
This video gives a good practice, awesome! Thanks Brian !
Very instructive and easy to follow without being horribly slow.
Thank you!
Brian, you are a treasure, the best spreadsheet tutorial i have ever seen, Excellent. and thank you for your permission to copy your template.
Thank you!
One of the best tutorial I have seen on this platform for Stock selection
Kudos to your efforts
Thank you!
Great videos. I have implemented most of your suggestions into my stock tracker.
In watching this video, it struck me how telling the last part of it is. When you extend the look back to 500 days, you comment about how most of the charts reflect when the pandemic hit.
It's interesting to look at the companies you chose and how their charts responded to the pandemic.
Amazon, Tesla, Facebook, Microsoft and Apple took off.
Delta, United and Spirit fell off the face of a cliff and have struggled to make it halfway back to where they were.
I didn't read all the other comments, so I'm not sure if somebody else already pointed this out.
In any case, keep up the great work.
Great comment, it is really interesting when you compare all those companies over that span. Thanks for watching!
Thanks. Dank je wel. Zeer instructieve en eenduidige presentatie. Perfecte Informatie.🐼
Just wantd to say thanks for creating this. I had another google sheet that wasn't as feature rich, but this added a few really nice touches.
Thank you!
very practical and useful, even though I do not have mathematic or computer science background, it is amazing to know so many spreadsheet functions
Thank you!
Thanks Brian. I appreciate you posting this. I learned a bit more things with google sheets. Keep up the good work!
Thank you!
Fantastic video, lot of information i learned today.
Wishes from india🇮🇳
Love it… finally found someone to teach me this
I had a great time following along and creating my own chart! Thanks!
Amazing Video Brian. Absolutely loved it.
Superb. Was looking to make this for quite some time. Regards from India 🇮🇳
Thank you! Appreciate it
Great to find this. And thanks for explaining it so well, and the video is very well made too.
Could you compare it with Excel Power Query getting data from live pages, and how relevant doing it on Google would be. If anyone else has any views, would love to hear. Cheers!
Thank you Brian - please continue making great videos as these.
Thank you Dillon!
Great video - very concise, clear and helpful.
Great job Brian! Thank you! I will improve my own spread sheet with your info.
Thank you!
Thank you for this video man! Very well explained. I learned a lot!
Thank you!
Thank you so much for this wonderful video. It was so simple and gave a good amount of knowledge. Hope you continue to make more videos.
Thank you! Glad you enjoyed
Great videos. I have implemented most of your suggestions into my stock tracker.
Thank you!
Any chance you can share a public link for it?
Just one word, AMAZING!!!
Well done Brian..! Thanks for sharing!!
Excellent presentation!
I will be forever grateful to you, you changed my entire life and I will continue to preach on your behalf for the whole world to hear you saved me from huge financial debt with just a small investment, thank you Anna Williams
The first step to successful investing is figuring out your goals and risk tolerance either on your own or with the help of a financial professional but is very advisable you make use of a professional.
Wow. I'm a bit perplexed seeing her been mentioned here also Didn’t know she has been good to so many people too this is wonderful, i'm in my fifth trade with her and it has been super.
What impresses me most about Anna Williams is how well she explains basic concept of winning before actually letting you use her trade signals. This goes a long way to ensure winning trades.
Isn't that the same Mrs Anna Williams that my neighbours are talking about, she has to be a perfect expert for people to talk about her so well
I'm new at this, please how can I reach her?
Your teaching style is so unique and easy, Awesome.
Thank you so much!
Just superb👌 complete clean & clear video. Appreciate your hard work.
Thank you!
this is amazing for me too of learning , appreciated so much for your very useful channel and thank you
Soooo exactly what I was looking for, thanks.
I’m new to google sheets, this is great info thanks
Brian, thanks for sharing this. Great functionality. Have you played with any related speadsheet forms, or mobile type interfaces to these sheets? I'd like to have an easy to open form that I cold summarized daily gains and losses in a quick view type format on my phone.
Very good information....i am seeing this video by clicking back again and taking photos of formulas by mobile.....
That's awesome! Thank you
El mejor video que he visto en mucho tiempo , excelente maestro y comparte su saber generosamente
Appreciate the effort. Such a nice stock tracker indeed...!
This nice , man. I will try it myself, even if Im not a excel expert. Thanks for sharing.
Hey man, thanks so much for this. I really learned this now and will definitely use this for sure
what a beautiful skill you have, I just learned a lot. Thank u so much
Great info and video. Clear and concise.
Really very good quality informative video, after searching many videos I got your chennal. Thank you for your help
Thank you so much!
Spectacular! You are very skilled!
Super super nice. Learnt so much from this single video. Thanks a lot for sharing your knowledge to the world
Thank you!
AMAZING VIDEO. MADE MY DAY. THANK YOU, BRIAN.
Great learning.. thanks! please continue to make more of such videos.
Thank you very much!! This has been alot of help!
absolutely awesome video! learned so much from watching this!
Thank you!
Just awesome! Thanks so much. Learned a lot. Now I have great watchlist. : )
Thank you!
Thank you SOOOO much...you saved me :):):) love from South Korea
Thank you! 🇰🇷
Excelente dashboard. Solo una observacion, en el precio o porcentaje de los ultimos 5 o 10 dias en realidad se esta calculando el valor de los ultimos 5 o 10 dias de mercado. si se introduce por ejemplo el valor 365 no comieza desde 7-2020 sino desde 3-2020 lo que puede confundir un poco.
Very helpful and I really like the way you explain things, easy to understand. Subbed :)
Thank you, that means a lot!
amazing.. i am desperately looking for this .. Thankyou So Much
Thank you!
I like this tutorial … thanks so much! I was able to follow along and create the same spread sheet for myself. I am curious if or how it might be possible to have both green spark lines like you have but if they depict a downtrend they turned red all depending upon what the trend was over the past 250 days. brilliant tutorial!
take just pct_change + or - sign as colour switch. Just Not sure hot to implement it in the sheets yet w/o creating additional column for switches, but that would be what I could do in python :D
Plenty of good ideas in here; outstanding
Amazing! So many little tricks. Thanks for sharing this!
Great content Brian. Hope you will expand your subscribers soon, Keep it up.
Thank you so much!
Thanks Bud...Love from India.
Thank you!
Hey Brian, Thanks for sharing this! Definitely helped me create my own DRIP tracking database
Awesome!
Thank you. This is an eye opener for me :)
That's a bad ass spreadsheet! Thank you!
Thank you!
Very easy to Follow. Thank You !
God-level explanation.
Awesome.
Excellent Brian. Thank you.