Thank you, now my list matches with @visuarchie sir.
But I am curious how did you figure out the price difference for the date?
@stuti_agarwal I have talked about the rules I follow previously also.
-
Yes, the X amount that is available from exits is evenly distributed across the new entrants.
-
I do not make any changes to the stocks that are continuing from the previous week.
Every now and then, I make a lumpsum investment. At that time, my goal is to ensure equal weightage for all stocks in the pf. I distribute the amount across all stocks so that I have equal amounts in all.
1 Like
Thank you so much @visuarchie, I did read through previous messages I must have missed this, i am sorry for making you repeat it, but this is very helpful. 
I manually went through the log data and saw anomaly in one row, then i tracked back the price which was wrongly updated by google finance. So i manually updated it.
1 Like
No issue at all. Happy to clarify.
1 Like
Thank you very much sir. My list matches with you. Please can you guide how to get the 50EMA, can you please share the formula to be used in this google sheet.
1 Like
As quite a few people had asked, I have prepared a short video explaining how the calculation for 50EMA and 200EMA is done. Link given below. Please let me know if the video is clear. Thanks.
8 Likes
Thank you so much for putting your efforts and sharing this video on a busy week start. Really appreciate that
2 Likes
Thanks you very much sir for taking so much effort in helping to understand. Thank you once again sir.
2 Likes
Update for entry on 3rd June 2024
50EMA (15327) > 200EMA (13818); hence we can continue without any change.
Based on ranking:
- JAIBALAJI
- COCHINSHIP
- ANANDRATHI
- HUDCO
- POWERINDIA
- JWL
- INOXWIND
- MOTILALOFS
- SIGNATURE
- BLUESTARCO
- KPIL
- SOBHA
- SCHNEIDER
- HINDCOPPER
- SWSOLAR
- NATIONALUM
- EXIDEIND
- TITAGARH
- APARINDS
- NBCC
Based on A → Z for easy tracking:
- ANANDRATHI
- APARINDS*
- BLUESTARCO*
- COCHINSHIP
- EXIDEIND
- HINDCOPPER
- HUDCO
- INOXWIND
- JAIBALAJI
- JWL
- KPIL
- MOTILALOFS
- NATIONALUM
- NBCC
- POWERINDIA
- SCHNEIDER
- SIGNATURE
- SOBHA
- SWSOLAR
- TITAGARH*
Exit:
CENTURYTEX makes an exit.
EIHOTEL and HBLPOWER stay within the top 25 and hence remain.
Entry:
BLUESTARCO makes an entry.
APARINDS and TITAGARH cannot enter as there is no vacancy.
In the last over 5 weeks that I have been tracking with 70% weightage for 6m performance, I have not seen any significant out-performance. Hence, I will not be monitoring that change going forward.
1 Like
Update for entry on 3rd June 2024
12 months date: 31/05/2023
6 months date: 01/12/2023
BASED ON RANKING:
- JAIBALAJI
- COCHINSHIP
- ANANDRATHI
- HUDCO
- POWERINDIA
- JWL
- INOXWIND
- SIGNATURE
- MOTILALOFS
- KPIL
- SOBHA
- SCHNEIDER
- HINDCOPPER
- SWSOLAR
- BLUESTARCO
- NATIONALUM
- EXIDEIND
- NBCC
- HBLPOWER
- APARINDS
A-Z ORDER:
- ANANDRATHI
- APARINDS
- BLUESTARCO
- COCHINSHIP
- EXIDEIND
- HBLPOWER
- HINDCOPPER
- HUDCO
- INOXWIND
- JAIBALAJI
- JWL
- KPIL
- MOTILALOFS
- NATIONALUM
- NBCC
- POWERINDIA
- SCHNEIDER
- SIGNATURE
- SOBHA
- SWSOLAR
Entry: BLUESTARCO
Exit: CENTURYTEX
Rest for me everything else remains the same.
@visuarchie Is it okay that after 2 weeks, the overall PF is still negative? Mine is currently -3%.
Also, i see you did not get JBL power in your top 25, but I did and you got Titagarh but I didn’t. Can you check if 12 months and 6months date are the same?
Also, I exited bluestarco last week, booked loss in it, now it is again to be added this week, is that ok?
1 Like
@stuti_agarwal Some changes compared to your list.
a. 12m look back date I used is 02/06/2023 - I usually keep the closest Friday.
b. Same date for 6m look back.
c. Week ending 24th May was no profit / no loss for me.
For week ending 31st May, my pf was in loss.
These are the two weeks that you are referring to. It is quite possible to be in negative.
d. HBLPOWER is at 21 for me.
e. BLUESTARCO. Yes, it is fine if the system is saying that. Please note that I am doing exactly what I am saying here. If I say I am exiting, I will exit. If I say I am going to remain, I will remain.
The list of stocks exactly matched. Only difference in my list is Titagarh is in Rank 17 and Exide is in Rank 18 which is interchanged from your ranking. Rest all matched
I keep tracking this interesting excercise. Would you please kind enough state the overall gain or loss in this election volatility of last 2 months?
@james_kerala This smallcap pf has given 2.7% from April 1st to May 31st. The other pf based on microcap index has given around 8% for the same period.
1 Like
Vishwanath - can you please share the microchip PF?
Sir, due to turmoil in market is there any changes required
1 Like
I am not doing anything. My suggestion is to wait and see.
1 Like
What is the Sharpe ratio range you are normally ok with?
1 Like