Wow, this is some list!
10/06/2024
RANKING ORDER->
HERITGFOOD
KPIGREEN
KIRLOSENG
RTNPOWER
PURVA
IFCI
NETWEB
CHOICEIN
GANESHHOUC
TVSHLTD
ARVIND
TECHNOE
WOCKPHARMA
KESORAMIND
AZAD
STAR
JYOTICNC
VOLTAMP
JKIL
KIRLOSBROS
IIFLSEC
ITDCEM
THOMASCOOK
MOIL
ELECTCAST
A-Z ORDER->
ARVIND
AZAD
CHOICEIN
ELECTCAST
GANESHHOUC
HERITGFOOD
IFCI
IIFLSEC
ITDCEM
JKIL
JYOTICNC
KESORAMIND
KIRLOSBROS
KIRLOSENG
KPIGREEN
MOIL
NETWEB
PURVA
RTNPOWER
STAR
TECHNOE
THOMASCOOK
TVSHLTD
VOLTAMP
WOCKPHARMA
According to my list:
ENTERS: HERITGFOOD, GANESHHOUC
EXITS: ANANTRAJ, JPPOWER
STAYS because in top 30: MSTCLTD, TARC
Waiting for your list to see if it matches mine @visuarchie
I am travelling this weekend. Some issues with Google Finance fetching price. List is changing randomly. Will need some time to check.
Not planning any update today or tomorrow.
2 Likes
I am back. Checked the sheet today. Sheet appears to be stable now. People can check and confirm.
Check price for some stocks and dates, google finance returning same price.
Some notes on the above.
- I continue to see the values extracted by Google Finance changing.
- I had to download bhav copies.
- Last 2 days bhav copies available on NSE site.
- From 10th to 12th June, I had to download the bhav copies from samco.in
- I then integrated values from bhav copy into our sheet.
Therefore, I am confident of data from 10th to 14th. The previous week make still have some errors; I will try and fix it the same way over the next few days. I don’t think it will materially change the list very much.
Will check again coming weekend to see if the problem still persists.
Once we learn how to do this, the entire process is not too difficult. If people are interested, I can do a quick video to capture this process.
4 Likes
yes sir please make a video …
3 Likes
Definitely yes sir. Very good thought.
=INDEX(GOOGLEFINANCE(“NSE:”&C$4,“price”,$B7-1), ROWS(GOOGLEFINANCE(“NSE:”&C$4,“price”,$B7-1)), 2)
This was the formula suggested by @Anand_Jain. After a bit of struggle it is working for me. Please note that C$4 refers to the cell where the stock name is written. $B7 in this formula is the place where the date is written. Please make the correct reference.
For some reason copying did not work. I entered the formula and then it started to.
I will still make the video on how to integrate bhav copy. Might be helpful to some.
Hi Vishwanth Sir,
I am getting a significant difference in the Microcap momentum list as well as the ranking of stocks in due to google finance fluctuations. Approx 4 stocks mentioned above are not coming up in Top 30 itself.
In Small Cap momentum portfolio, i am getting the same list, though there is a slight change in ranking of few stocks.
I couldn’t catch / map above formula’s in to my sheet to calibrate. Will wait for the video for way forward.
One thing that I forgot to mention at the end of the video is that, once the data has been populated, you can do a copy and paste of values in the same location.
I have updated from 3rd to 7th and now confident of the data. I will post the updated version. Shall I delete the previous update so that there is no confusion?
1 Like
Yes Sir. That will be great if you can post the latest updated list based on the new data.
1 Like
Sure, sir to avoid ambiguity.
Update for entry on 18th June 2024
50 EMA (20713) > 200 EMA (18572); hence we can continue without any change.
Based on ranking:
- KIRLOSENG
- KPIGREEN
- IFCI
- RTNPOWER
- PURVA
- KIRLOSBROS
- TECHNOE
- HERITGFOOD
- AZAD
- JYOTICNC
- CHOICEIN
- NETWEB
- GANESHHOUC
- STAR
- KESORAMIND
- TVSHLTD
- ARVIND
- HGINFRA
- MOIL
- ITDCEM
- ASTRAMICRO
- EMUDHRA
- VOLTAMP
- BASF
- WABAG
Based on A → Z for easy tracking:
- ARVIND
- ASTRAMICRO*
- AZAD*
- BASF*
- CHOICEIN
- EMUDHRA*
- GANESHHOUC*
- HERITGFOOD*
- HGINFRA*
- IFCI
- ITDCEM*
- JYOTICNC
- KESORAMIND
- KIRLOSBROS
- KIRLOSENG
- KPIGREEN
- MOIL
- NETWEB
- PURVA
- RTNPOWER
- STAR
- TECHNOE
- TVSHLTD*
- VOLTAMP
- WABAG*
Exits:
IIFLSEC, JKIL, MSTCLTD, SCI, THOMASCOOK and WOCKPHARMA make an exit.
ANANTRAJ, ELECTCAST, TIMETECHNO and TARC stay within the top 30 and hence remain.
Entries:
ASTRAMICRO, GANESHHOUC, HERITGFOOD, HGINFRA, ITDCEM and TVSHLTD make an entry.
BASF, EMUDHRA and WABAG cannot enter as there is no vacancy.
AZAD is less than 6m on the bourses and hence not considered.
Last week I had written about how I had not included AZAD as it was less than 6m on the stock exchange. I had made another mistake of including JYOTICNC. As I had not rebalanced for 2 weeks, JYOTICNC was already 2 weeks in this pf. Therefore, I have retained JYOTICNC, but still not including AZAD. When JYOTICNC goes out, 6m rule will be applied.
Audio hardly audible if you could do something.
With Earbuds its audible (not loud though but its understandable)
Please find below link to the video. I have done some post processing to enhance the voice. Please see if it helps.
4 Likes
Below is the list i am getting this week (Top 30) but i am sure that Ranking will differ from Vishwanath sir’s list (as i have used Google sheet as i didn’t see fluctuations today)
50EMA 15801> 200 EMA 14150
Also i observed significant difference in TVSHLTD values since Apr-24 which i have corrected in the sheet and hence it moved up in the rank.
KIRLOSENG
AZAD* (< 6 months)
IFCI
JYOTICNC* (< 6 months)
KIRLOSBROS
TECHNOE
RTNPOWER
PURVA
CHOICEIN
KPIGREEN
NETWEB
GANESHHOUC
TVSHLTD
BASF
THOMASCOOK
HERITGFOOD
ITDCEM
WABAG
ASHOKA
VOLTAMP
KESORAMIND
ZENTEC
IIFLSEC
JKIL
HGINFRA
ELECTCAST
EMUDHRA
KSCL
MOIL
ANANTRAJ
@visuarchie request you to provide Gsheet here also as did, in case of small cap PF thread, thank you, sir.