@Mudit.Kushalvardhan In our list from last week, only Godfrey Philips was present. Sobha, Bombay Burmah and First Source were not present. So, we are not missing much really.
Similarly, in our microcap pf, Sarda and Zentec are not present. So, we have not lost anything.
@Sudhakar_Subramanian i need create small cap list manually , which will take time.
once i done i will share.
Update for entry on 30th September 2024 (lookback dates: 29/09/2023 and 28/03/2024)
50EMA (17956) > 200EMA (15992); hence, we can continue without any change.
Based on ranking:
Based on A → Z for easy tracking:
Exits:
COCHINSHIP and POWERINDIA leave the index and are excluded.
CONCORDBIO, ERIS, KAYNES and QUESS exit.
CENTURYTEX stays within the top 25 and hence remains.
Entries:
ANANTRAJ, BASF, BLUESTARCO, GET&D, NEWGEN and TECHNOE make an entry.
NETWEB cannot enter as there is no vacancy.
@kuldeep_agarwal NSE notification attached.
ind_prs23082024.pdf (770.4 KB)
Hi @visuarchie,
am trying to modify the spreadsheet ( your template )after NSE rejig. For the new stocks, example AADHARHFC getting an error : #N/A, when evaluating GGOGLEFINANCE the query for the symbol AADHARHFC returned no data.
Used the same formula from previous week, except AADHARHFC was typed in a cell which became empty after rejig. What am i missing ? Please help. Thanks
Hello @nil You can check two things.
The earliest available date for AADHARHFC is 15/05/2024. Any earlier date show info as NA. Please check the dates for returns and SD calculation and ensure they are correct.
Second point that I have noticed is that Google Finance does not like to move columns or replace names in columns. It will typically throw up some errors. Instead, if you want to remove a scrip, delete the column and if you want to introduce a new scrip, insert a column for it. This will keep the data clean.
@visuarchie Sir , list is matching with mine except MOTILALOFS
Can you please check your data for MOTILALOFS ( Motilal Oswal Financial Services Ltd).
there is a Bonus issue
2024 Jun 10 Bonus Issue
Bonus Issue 3:1
@VeeraBrahmam Ok. You may wish to recheck because MOTILALOFS entered the pf on 24/08/2024 and has remained since then.
Update for entry on 7th October 2024 (look back dates: 06/10/2023 and 05/04/2024)
50EMA (18004) > 200EMA (16082); hence, we can continue without any change.
Based on ranking:
Based on A → Z for easy tracking:
Exits:
DOMS makes an exit.
CENTURYTEX stays within the top 25 and hence remains.
Entries:
NETWEB makes an entry.
ERIS cannot enter as there is not vacancy.
hi @visuarchie sir and other contributors on this thread,
First of all thanks a lot for sharing your valuable knowledge.
I have two doubts.
Thanks,
Bhagath.M
@bhagath Hello, I have talked about these points previously also.
When we invest and create the portfolio, we start with equal allocation. Therefore, as you mentioned, if you had BASF in your list, you would need to start with 8200 x 10 or 20 or 25 depending on the number of stocks in your pf. If you do not want to start with this amount, you can ignore this stock and go to the next one in rank.
Check out the message on the work done by @VeeraBrahmam on automating this. He did it using yfinance as Google Finance would not allow python programming. We found some issues in the closing price of stocks as compared to NSE or GFin. I think he has managed to overcome as he is able to get the same ranking of stocks. He might be able to elaborate on how he did it.
Update for entry on 14th October 2024 (lookback dates: 13/10/2023 and 12/04/2024)
50EMA (18,000) > 200EMA (16,174); hence, we can continue without any change.
Based on ranking:
Based on A → Z for easy tracking:
Exits:
ABREL (old symbol CENTURYTEX) and BIKAJI make an exit.
Entries:
ERIS and KAYNES make an entry.
Other notes:
While checking the indices, I found that IDFC has been excluded as trading stopped for this stock.
EMCURE has been added.
CENTRALBNK expulsion has been revoked.
PRSMJOHNSN has been excluded.
However, none of these changes have any impact on the pf.
Is it possible to share what kind of return you have generated since you have started this activity?
(In general momentum strategy gives you a big hit when market is sideways… and it is very difficult to recognise it… I had backtested some strategies & mostly gave bad returns in 2018-2019… Have you tried to backtest in such market? Just curious how to avoid such cases.)
I see that you have 2 portfolios, SmallCap & MicroCap (another thread)… Any reason to not having MidCap?
@Keyur_Joshi Not sure how I missed your question.
I started this pf end of November 2022 and since then my performance has been an XIRR of 49.8% as of last weekend. The returns have dropped significantly in the last one month.
I have not done any backtest as I do not have the resources for that.
I have a midcap 150 pf also. Started in Sep 2022 and I am at XIRR of 46.5% until last weekend.
Hi, this is my first post in any of the VP forums. This thread has caught my attention all day and I have tried to replicate the Google Sheet. After almost getting there, I felt that the following method may be much easier and faster.
Although, it doesn’t take care of the Daily volatility, which is being accounted by you.
1.Screener Nifty SmallCap 250 page
2.Export the data into excel capturing with 1 yr return and 6 months return
3.Add 1 yr return plus 6 month return and filter it in descending order
The list as on today(13.10.24) looks like this.
|1|GE T&D India|
|2|Inox Wind|
|3|Godfrey Phillips|
|4|Anant Raj|
|5|BASF India|
|6|Techno Elec.Engg|
|7|Motil.Oswal.Fin.|
|8|Newgen Software|
|9|Multi Comm. Exc.|
|10|Netweb Technol.|
|11|Himadri Special|
|12|Jubilant Pharmo|
|13|PCBL Ltd|
|14|PTC Industries|
|15|Kaynes Tech|
|16|Garden Reach Sh.|
|17|Nuvama Wealth|
|18|SignatureGlobal|
|19|NBCC|
|20|Bombay Burmah|
|21|Glenmark Pharma.|
|22|Suven Pharma|
|23|KFin Technolog.|
|24|Piramal Pharma|
|25|IFCI|
Only Eris was at a surprisingly odd 60th Rank in this list, whereas Eris entered your list today. Rest all were within 25. Since we are anyways giving equal weightage to all the stocks, it will not make much of a difference. But I am very curious to see how Eris got into, is it because of very low volatility?
thanks!
Hi Visuarchie, can you share the link to the madcap 150 PF please?
Just to compare…Tata Midcap 150 momentum 50 fund also started in october 2022, almost at the same time, when u started your midcap fund. Their returns are 41% while you got 46% , so 5% more.
Nippon SmallCap 250 index has given 41% in last 2 years, comoarable to your period , so alpha of 7% compared to index fund.
Is this net of transaction costs and more importantly STCG costs?
I think there are pros & cons with MF even if its same return.
Good thing is you don’t have to worry about taxation & transaction cost a lot (Obviously saving time is another good thing)
The not so good thing is when MF becomes bigger, these returns drop. Also when you do your own, you are learning, which “may” be useful to take a leap.
(Regarding Nippon Small Cap, I think they stopped lumpsum amount option now… Only SIP is possible… that too with minimum of 12 months if its monthly)
