Build A Fully Functioning STOCK WATCHLIST With Live Data In Google Sheets 

Here's the link for my template! Feel free to use it for yourself! docs.google.com/spreadsheets/d/1lW0SUfsty7qEVJpWuV7ANkBZK027RI_CouSsDM0XfmQ/edit?usp=sharing

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

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.

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?

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.

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.

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.

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.

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

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

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

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!

Highest level of clarity and competence. Such a pleasure to learn from 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!!

Brother I just want to take the time to thank you so much for your videos…I really found what I was looking for 👏🏼👏🏼👏🏼

Amazing work! I reference it often to make small changes to tailor to my needs. Thank you!

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.

Excellent video; I was searching for this only last 2 days; Thank you for doing step by step

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.

El mejor video que he visto en mucho tiempo , excelente maestro y comparte su saber generosamente

You are an amazing teacher - thank you so much for this. I subscribed and can't wait to see more of your videos.

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

Very cool and super useful! You went about the design at the right speed so it was easy to follow. Thanks

This is one of the best videos I watched about google finance formulas

This video gives a good practice, awesome! Thanks Brian !

nice tutorial..building blocks for more advanced setup. thank you for the sharing the template.

Thank you very much!! This has been alot of help!

Just found this video. WOW! I never knew there was so much to do with the GOOGLEFINANCE function! Thanks!

I had a great time following along and creating my own chart! Thanks!

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 :)

Amazing Video Brian. Absolutely loved it.

Appreciate the effort. Such a nice stock tracker indeed...!

I love to do this dashboards on google spreadsheet too. I learned some tricks from your video. Thanks for sharing!

Soooo exactly what I was looking for, thanks.

Love it… finally found someone to teach me this

Thanks. Dank je wel. Zeer instructieve en eenduidige presentatie. Perfecte Informatie.🐼

Your Knowledge & Teaching skill is awesome, also you provide great knowledge. Heartly thanks ...:)

Great info and video. Clear and concise.

I’m new to google sheets, this is great info thanks

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.

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.

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.

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.

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

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

This nice , man. I will try it myself, even if Im not a excel expert. Thanks for sharing.

Brian, you are a treasure, the best spreadsheet tutorial i have ever seen, Excellent. and thank you for your permission to copy your template.

Great video - very concise, clear and helpful.

That's a bad ass spreadsheet! Thank you!

Super! Thanks a lot man! Love this

Well done Brian..! Thanks for sharing!!

Just one word, AMAZING!!!

AMAZING VIDEO. MADE MY DAY. THANK YOU, BRIAN.

Excellent Brian. Thank you.

Brian, You are a life saver :)

Thanks Brian. I appreciate you posting this. I learned a bit more things with google sheets. Keep up the good work!

Thank you for sharing this useful chart. Upon recreating it for myself, I have learned more about Google Sheets.

Amazing video! I knew something like this was possible, but had no clue on how to do it. Thanks for the video.

Great job guy. Really appreciate

Fantastic video, lot of information i learned today. Wishes from india🇮🇳

Excellent presentation!

Spectacular! You are very skilled!

Thank you so much Brian for this outstanding 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?

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 Brian - please continue making great videos as these.

Outstanding presentation! Thank You

Hey man, thanks so much for this. I really learned this now and will definitely use this for sure

Thank you. This is an eye opener for me :)

Thanks for this excellent spreadsheet.

Very instructive and easy to follow without being horribly slow.

Fantastic! Thanks Brian

wooow amazing.. Learnt a lot from this. thanks for this video :)

Thank you SOOOO much...you saved me :):):) love from South Korea

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.

Awesome video, well presented and so useful. Thank you.

Plenty of good ideas in here; outstanding

Awesome!

amazing.. i am desperately looking for this .. Thankyou So Much

Great video, thanks for this tutorial, I learn from it a lot.

Absolutely fantastic video

Amazing! So many little tricks. Thanks for sharing this!

Great learning.. thanks! please continue to make more of such videos.

One of the best tutorial I have seen on this platform for Stock selection Kudos to your efforts

what a beautiful skill you have, I just learned a lot. Thank u so much

this is amazing for me too of learning , appreciated so much for your very useful channel and thank you

I learned a lot. Thank you for this very usefull video.

Really really great video, thank you!

Thank you so much! that makes it so much easier now.

amazing, learned a lot with this

many thanks for sharing the video and also sharing the sheet......👌

Wow, just the thing I need.

Great content Brian. Hope you will expand your subscribers soon, Keep it up.

Just Awesome Brother, Thanks a lot

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.

Great job Brian! Thank you! I will improve my own spread sheet with your info.