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

Easily build a complete stock watchlist in Google Sheets.

Here's my template for this sheet:

Links to referenced videos can be found below:

GOOGLE FINANCE:

CUSTOM # FORMAT (POS. OR NEG.):

CUSTOM # FORMAT (LARGE NUMBERS):

INDEX FUNCTION:

IF ERROR:

ALTERNATING COLORS:

REFERENCE CELLS:

#GoogleFinance #StockWatchlist #StockTracker

[brianturgeon]

Here's the link for my template! Feel free to use it for yourself!

[trazzpalmer]

Acquiring stocks could appear simple, but choosing the right stock without a tested plan can be very difficult. My main barrier to growing my $450K portfolio, which I've been working on for a while, is the absence of well-defined entry and exit plans. Any guidance on this would be highly valued.

[Mongarnsamuel]

Its worse here, our economy is like a flailing fish, fighting for its life. The normal state of the U.S. economy is actually very bad. Because of this it goes into convulsive spasms fighting to grow any way it can out of desperation. Tricks, gimmicks, rule changes try to stimulate the economy and prevent it from falling but they only bring temporary relief to people since, when you factor in inflation we are declining.

[gaynor]

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?

[greenquake]

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.

[ExxonMobilCompany]

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.

[cuddyb]

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.

[stjepanhauser]

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.

[JefferyDuns]

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.

[martinerJuhel]

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

[TheElevenBravo]

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.

[caroamira]

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.

[michaelschiemer]

My portfolio for the past 30 years has always been self managed and I own 3 shares of Berkshire Hathaway Class A stock (BRK:A) which I bought in at about $17, 000 during the mid 90s, I’m currently liquidating some of these positions to incoporate new Gen. Stocks, but am I better off re-investing into Gold as it seems stocks are a little too unstable right now.

[mauriciomule]

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

[shashanksingh]

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

[arlrmr]

Highest level of clarity and competence. Such a pleasure to learn from you. Thank you.

[DonShader]

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?

[AdamMontoya]

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

[ngkenzy]

I really appreciate the hard work you put into this and am so grateful that you shared it with us. Thank you!

[junaidafzal]

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