Build A Fully Functioning STOCK WATCHLIST With Live Data In Google Sheets
904,959
Publicado 2021-07-02
Here's my template for this sheet:
docs.google.com/spreadsheets/d/1lW0SUfsty7qEVJpWuV…
Links to referenced videos can be found below:
GOOGLE FINANCE:
• USING GOOGLE FINANCE TO ANALYZE STOCK...
CUSTOM # FORMAT (POS. OR NEG.):
• FORMAT POSITIVE AND NEGATIVE NUMBERS ...
CUSTOM # FORMAT (LARGE NUMBERS):
• CUSTOM NUMBER FORMATTING OF MILLIONS ...
INDEX FUNCTION:
• INDEX FUNCTION TUTORIAL IN GOOGLE SHEETS
IF ERROR:
• FIXING ERROR MESSAGES IN GOOGLE SHEETS
ALTERNATING COLORS:
• ADDING ALTERNATING COLORS INTO GOOGLE...
REFERENCE CELLS:
• REFERENCE CELLS With The Dollar Sign ...
#GoogleFinance #StockWatchlist #StockTracker
Todos los comentarios (21)
-
Here's the link for my template! Feel free to use it for yourself! docs.google.com/spreadsheets/d/1lW0SUfsty7qEVJpWuV…
-
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.
-
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.
-
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?
-
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.
-
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
-
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?
-
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.
-
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.
-
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.
-
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
-
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
-
Brother I just want to take the time to thank you so much for your videos…I really found what I was looking for 👏🏼👏🏼👏🏼
-
Highest level of clarity and competence. Such a pleasure to learn from you. 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.
-
I really appreciate the hard work you put into this and am so grateful that you shared it with us. Thank you!
-
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.
-
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.
-
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.
