17 Comments

From time to time i am reading your old articles, which by no means are old when it comes to meaning.

This particular one helped me to improve my tables where i write down the companies' numbers.

If I may propose something really minor, cosmetically - in the cells where there is #DIV/0! you can put IFERROR(<CURRENT_FORMULA>,""), where the string between "" will be shown in the cell, while the input cells in the <CURRENT_FORMULA> are empty. If you want blank just use "". Once the input sales of the <CURRENT_FORMULA> are fulfilled you will get the result.

Cheers and thank you for spending time for enlightening us!

Expand full comment
Sep 10, 2020Liked by TheStockNovice

Hi StockNovice, Amazing work, and amazing success since Dec 2018. You have educated all of us a lot and interestingly the way you are looking at the financial number using this sheet, I have pretty much similar approach after reading a bunch of fool board articles. I am thinking that there is so much of this information that so many of us are doing repetitively. Have you thought about doing some collaboration on maintaining this, it will definitely help the broader community as well.

Expand full comment
Sep 9, 2020Liked by TheStockNovice

Hi StockNovice. Thanks for sharing you portfolio, strategy, thoughts, etc with the world. I've learned so much from you. I do have a question about your spreadsheet from this post. I've been reading your write-ups for the past several years (including Saul's board), so I know you are always concentrated. I struggle tremendously in this area. I think part of the reason is because my notes have always been scattered and unorganized. I've decided I need to take it more seriously so I have recreated your spreadsheet in hopes it will give me a higher conviction to allocate more money to my winners. My question is multi-part:

1. On average how many companies do you keep track of? I have a problem trying to push the limits and follow everything. The detriment is two-fold. One, I end up buying small pieces of companies I vaguely follow and two, my knowledge of my top holdings is more shallow than I would like.

2. How do you prioritize companies/When do you stop keeping track of a company? For example, I know you sold out of AYX this month. I'm sure you will be interested in Snowflake, Palantir, your current holdings and watch-list etc, so you will need to allocate your time accordingly. Will AYX make the cut? Based on your comments (getting back on board in 2021) I assume it will, but how do you decide?

Any advice on your process is greatly appreciated. Thanks again for everything. It has changed my life.

Expand full comment
Aug 14, 2020Liked by TheStockNovice

great post...very helpful insight...

Expand full comment

Excellent exposition of a clear methodology for investment analysis. Its not Graham & Dodd nor Burton Malkiel nor John Bogle but it works for the sector you appear to be most interested in. SaaS and related companies. In a way I envy your diligence in carrying out this program. For my own investments I review the same information but tend to be more intuitive in coming to a, conclusion about purchase or sale. This can be problematic. So I applaud your approach as well as your generosity in sharing your results with others.

One suggestion. Change your name. You are no novice.

Expand full comment
Aug 13, 2020Liked by TheStockNovice

What a good summary of how to put in the work. I believe this is the hardest thing to do as an investor. The transition from trader to owner and from disinterested to interested should require a more informed view with more consideration of the information at hand.

This is going back to college to work for yourself, vs. an offer or promise of a promotion in somebody else's company. Great article.

Expand full comment