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?
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.
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
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
Acquiring 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 $160K for some time now, but my major challenge is not knowing the best entry and exit strategies. I would greatly appreciate any suggestions.
Investors should be cautious about their exposure and be wary of new buys, especially during inflation. Such high yields in this recession are only possible under the supervision of a professional or trusted advisor.
Buy Etfs instead of individual stocks. Index etfs are very safe due to diversification and good returns.
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!
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!
Highest level of clarity and competence. Such a pleasure to learn from you. Thank you.
Thank you very much!
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!
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.
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.
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
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?
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.
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.
Amazing work! I reference it often to make small changes to tailor to my needs. Thank you!
Excellent video; I was searching for this only last 2 days; Thank you for doing step by step
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!
Despite the fact that I invest, I am saddened by my inability to evaluate each company's performance and determine whether or not this is the ideal time to purchase stocks. My monetary stockpile is being depleted by inflation. At this stage, I need accurate market trajectory data, but I'm not sure what to do.
Particularly in this weak market, there are several opportunities to generate excellent returns, but such intricate transactions can only be carried out by seasoned market professionals.
I suggest that you look for a mentor or knowledgeable advisor, particularly in light of the current economic climate.
@@marenschmitz I completely agree, which is why I prefer to delegate daily decision-making to an investing coach. It is nearly impossible for them to underperform given their specialized knowledge and research, as well as the fact that every one of their abilities is geared toward utilizing risk for its asymmetrical potential and mitigating it as a buffer against certain bad turns. I've been working with an investment coach for over two years and have made over a quarter million dollar.
@@naomimarink I've been thinking about going that route. I've been holding onto a lot of stocks, but they're starting to lose value, and I'm not sure if I should retain them or sell them. I think hiring your investment coach would help me restructure my portfolio.
Brother I just want to take the time to thank you so much for your videos…I really found what I was looking for 👏🏼👏🏼👏🏼
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
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!
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!
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!
I love to do this dashboards on google spreadsheet too. I learned some tricks from your video. Thanks for sharing!
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.
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.
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!
Your Knowledge & Teaching skill is awesome, also you provide great knowledge. Heartly thanks ...:)
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
This video gives a good practice, awesome! Thanks Brian !
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!
Thanks. Dank je wel. Zeer instructieve en eenduidige presentatie. Perfecte Informatie.🐼
Thank you for sharing this useful chart. Upon recreating it for myself, I have learned more about Google Sheets.
Just found this video. WOW! I never knew there was so much to do with the GOOGLEFINANCE function! 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
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!
This is one of the best videos I watched about google finance formulas
Amazing video! I knew something like this was possible, but had no clue on how to do it. Thanks for the video.
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
One of the best tutorial I have seen on this platform for Stock selection
Kudos to your efforts
Thank you!
Very instructive and easy to follow without being horribly slow.
Thank you!
Amazing Video Brian. Absolutely loved it.
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!
I had a great time following along and creating my own chart! Thanks!
Great video - very concise, clear and helpful.
Excellent presentation!
this is amazing for me too of learning , appreciated so much for your very useful channel and thank you
Fantastic video, lot of information i learned today.
Wishes from india🇮🇳
Thanks Brian. I appreciate you posting this. I learned a bit more things with google sheets. Keep up the good work!
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!
Love it… finally found someone to teach me this
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!
Well done Brian..! Thanks for sharing!!
Thank you for this video man! Very well explained. I learned a lot!
Thank you!
Great job Brian! Thank you! I will improve my own spread sheet with your info.
Thank you!
I’m new to google sheets, this is great info thanks
what a beautiful skill you have, I just learned a lot. Thank u so much
Thank you Brian - please continue making great videos as these.
Thank you Dillon!
Appreciate the effort. Such a nice stock tracker indeed...!
Thank you very much!! This has been alot of help!
Hi Brian, thanks for taking the time to put this video together ❤️
Is there a way to break days into specific times ie to check the the difference from the open @09:30 and say 15min intervals.
Just want to try and review for trends on gap ups and runners
Great learning.. thanks! please continue to make more of such videos.
Your teaching style is so unique and easy, Awesome.
Thank you so much!
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
Spectacular! You are very skilled!
Thank you very much for this useful video. You have explained it very clearly. Could you please help me with the one-hour 200-moving average formula?
Thank you.
Just one word, AMAZING!!!
wow. Simply superb. Thanks for this insight. Appreciated. I am trying to create a weekly high, low, open, and close price data for a select few stocks. Open will be first workday of the week's "open price" and close will be last workday of the week's close price. Correct? What do I use to get High and low for the week?
Just superb👌 complete clean & clear video. Appreciate your hard work.
Thank you!
This nice , man. I will try it myself, even if Im not a excel expert. Thanks for sharing.
Hi Brian, thank you for this great video. It helped a lot and creating a live data watchlist was really fun. I am struggling with the 250 Days Chart. Can you help? I get the initial chart but not the better looking one nor can I change the color. Any ideas?
Hey man, thanks so much for this. I really learned this now and will definitely use this for sure
I like that graph that you added to this. Is it possible to have a graph like that that uses dividend yield over a 5 or 10 year time frame that also shows an average. So that an investor might be able to quickly see which companies are historically over/undervalued compared to their past?
Again, your doing a great job. A very clear explanation.
Amazing! So many little tricks. Thanks for sharing this!
Superb. Was looking to make this for quite some time. Regards from India 🇮🇳
Thank you! Appreciate it
Hey Brian, great vid... love it!! Any chance you could look into doing a vid on a formula, if possible, that could scrape an exchange ie, ASX or NASDAQ etc, and list companies dynamically from highest to lowest based on parameters like % dividend returns etc? Something structured like the top 200, 100, 50 or 10 highest returning companies would be awesome.
why not just pull all the data then slice and dice it yourself?
Soooo exactly what I was looking for, thanks.
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
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?
AMAZING VIDEO. MADE MY DAY. THANK YOU, BRIAN.
Very helpful and I really like the way you explain things, easy to understand. Subbed :)
Thank you, that means a lot!
Great info and video. Clear and concise.
Plenty of good ideas in here; outstanding
amazing.. i am desperately looking for this .. Thankyou So Much
Thank you!
Nice one.. we are expecting few more videos of similar kind
absolutely awesome video! learned so much from watching this!
Thank you!
Thank you. This is an eye opener for me :)
Very easy to Follow. Thank You !
Hey Brian, Thanks for sharing this! Definitely helped me create my own DRIP tracking database
Awesome!
Wow, what a great video. I added a few basics like initial shares and purchases. I added a few basic formulas to show my sample portfolio. Are ETFs and, bonds, and mutual funds handled the same way? If not have you thought about a follow-up vid.
Excellent Brian. Thank you.