@barathmukhi/@phreakv6,
I track my portfolio after customizing this Google sheet here from investmentmoats.

1. Stock quotes are received near real-time using Googlefinance function.
2. One enters trades and stock position/portfolio value is automatically calculated.
3. Portfolio can also automatically track historical values including money invested, cost sunk, (un)realized gain/loss etc.,
4. Google sheets has a history feature where one can traverse back in time to check a version – so it’s easy to simply go back 1 year and check corresponding portfolio including stocks and respective values today.

p.s: will delete in 1-2 days as my message doesn’t add value to main topic.

Point b) in letter Anything alarming
c31988b3-bfb9-426d-b139-7b698000b5ef.pdf (362.2 KB)

Hi Hitesh
Sorry for unsolicited advise from my side. But hope this helps as I was in similar situations as you in the past

It’s okay if you the companies you evaluate to be good. For all I know the cos you’ve mentioined are probably good. We may think we have good investment opportunities if we don’t look at enough cos. You’ve mentioined 3 cos which you found good. But, if you look at 10 more cos you will find some of them are better than others. Once you have enough research and have your own estimate you may find some of these to give 15% CAGR over next 2-3 years and 25% for some others. Once you find the cos with 25% CAGR expectations the one which looked good earlier may not seem as good as earlier.

Please look at the following factors while evaluating

1. Are the earnings cyclical ? Am I able to predict with fair degree of confidence ?
2. How much is the downside risk from CMP ? Look in the context of historical valuations (and also technicals)
3. Does this co seem like a good investment when compared to other cos in my PF or tracking universe ?

Success, Failures and learning of CY 2023:

Total no, of stocks held: 107
This is the total no. of stocks I see when I look at the Combined (Realized and unrealized P&L for the year). This includes all the stocks that I held atleast for one day including the stock carried forward from CY2022 and stocks that I’m carrying forward to CY24. This number is looking high and I should control the no. of stocks I trade in and out of so as to reduce churn and charges. I’ve subscried a smallcase and also participated in multiple buybacks/OFS which may have added ~30 to this number. Else this number could’ve been around 70, which is not too good either. I would consider it a win if I could keep this no. below 70 for CY2024

Winners: 67

Losers: 40

Total sum of Win/Total Sum of Loss: 7. This is a result of the whole year being good for the smallcap index. The Profit and Loss includes the unrealized Profit and loss existing at the end of last FY. So, all the profit can’t be attributed to the current year and same goes for the loss.

XIRR: 82%

Biggest Losers and Assessment in abs terms:

Biggest Winners in abs terms

Most of the ideas came from twitter and some from VP. Thanks to Sahil sharma, SOIC Finance, Chinmay (chins) and VP community. I have made my own study in limited capability to invest in these cos

Observations:

1. BIggest winners came where starting valuations are cheap along with improvement in earnings (Angelone, Ujjivan, Equitas, Pitti, Krsnaa)
2. Biggest learnings came where I didn’t respect the valuation like Nazara tech, Symphony. Some other reasons are cyclicality of earnign and my inability to hold the stocks through. So I should either limit my allocation where the it’s difficult to predict (Chemicals, Pharma, cyclicals) or should have the discipline/gut to hold the stocks through the recovey in earnings/stock price. After all I believe the best returns could be made in cyclicals
3. Evaluate more cos to improve returns. Take more ideas from twitter, VP and do own research to make better returns.

Areas to improve:

1. Allocate higher where I could predict the earnings (difficult to do so in Chem, Pharma etc.). Undervaluation to start and growth in earnings are the key for good returns
2. If allocated to cyclicals buy during bottom of cycle or at the start of upcycle and hold till the cycle recovers
3. Evaluate more opportunities to find better opportunities and make better returns. Currently most of these ideas are coming from twitter and VP. Could use some technical screener to find opportunities to start with
4. There’s no substitute for hard work. Work hard and smartly. Spend time where it matters

Readings for CY2023:

1. Read Buffet Partnership Letters
2. Spent significant time on VP reading. Started writing as well. Long way to go
3. Joined a Whatsapp group with like minded people (based out of pune). Have people to discuss ideas

Targets for next years (CY2024):

1. Read Berkshire Hathaway Letter to shareholders (ongoing)
2. Read Bulls Bear and other Beasts
3. Read Masterclass with Super investors
4. Read Secrets from profiteering from bull and bear markets
5. Look at the charts posted by Chartist and VVV on twitter. Learn and improve the understanding of technicals
6. Start sharing thoughts and learnings on twitter. Helps to network with people and work better

Targets for Tracking Universe and Portfolio:

1. Reduce the no. of holdings in the PF to close to or below 20
2. Alreadyb have a list of cos I track and have estimates on earnings and fair P/E or P/B multiple for most of the tracking universe. Cross check the estimates against the actual results when after the target time frame (Fy25, Fy26 etc.)
3. Evaluate and participate in short term opportuniteis llike OFS, Buyback etc… (started in early 2023 had fair success)
4. Maintain better returns over Nifty smallcap 250 index
5. Create a Paper trading momentum portfolio as a combination of technical and fundamentals or either of them (Create one technical based recently. Need to keep working and improving)
6. Learn and implement technical based exit system for portfolio stocks. Could have helped with Angelone, MCX etc

Writing this post helped me make some observations on my PF and investment process. I believe this would help me understand the areas where I need to improve, Make plan for improvement with set targets and hold myself accountable for future progress

I recommend fellow VPers to consider writing a similar post, Learn and grow

Thanks for reading
Praveen

Disc: Have/had positions in almost all the cos mentioned. No reco to buy or sell