How to BEAT THE INDEX by 10% Annually over 45 Years | Trending Value Strategy on Indian Stocks
Вставка
- Опубліковано 2 чер 2024
- 👉 Subscribe to my newsletter at shankarnath.com
In this video, we're diving into a strategy that's beaten the broader market index by a remarkable 10% over a 45-year period garnering a CAGR of 21.19% from 1964 to 2009 - turning $10,000 into over $69 million. This wealth creation powerhouse is known as the "Trending Value Strategy," first introduced by James O'Shaughnessy in his book "What Works on Wall Street."
In our exploration, we'll uncover how this strategy surpasses the index, beats individual factor strategies, and keeps volatility in check. We'll dissect the key metrics, from price-to-earnings to dividend yield, that shape the Value Composite Score. Step by step, we'll learn how to construct this portfolio, sifting through companies and assigning value scores to build a robust investment strategy. We'll then apply momentum factors on top of this data to produce a 25-stock portfolio which when rebalanced annually, harnesses the combined power of value and momentum.
👉 Access the worksheet used in this video by clicking this link: docs.google.com/spreadsheets/...
👉 Video Chapters:
00:00 What Works on Wall Street by James O'Shaughnessy
01:06 Calculating the Value Composite Score
05:50 Applying the Momentum Score
08:54 Capital Mind Study on Trending Value Strategy
10:41 Shankar's Viewpoint
👉 Additional Resources/Readings:
▸ What Works on Wall Street (book link): amzn.to/3Raa0aH
▸ Article by Capital Mind: www.capitalmind.in/2023/07/tr...
#investingstrategy #trendingvalue #shankarnath
Disclaimer: I am not a SEBI registered investment advisor or research analyst. I am not registered with PFRDA or IRDA either. The content posted on this platform is purely for educational purposes and none of it constitutes investing or trading advice. Viewers should do their own research and diligence before investing or acting on the information presented. Some of the links I have posted in the video, the description, the comments and other related resources might be affiliate links
Thanks for knowledge share and backed by data and research
Thank you very much, Bhavesh for this wonderful gratuity and for your appreciation, I am happy you are liking my work.
Please do subscribe to my newsletter at shankarnath.substack.com aswell where I look at specific opportunities in the stock market (the recent issue had a 18% profit opportunity via the TCS buyback). I'm starting with a once-a-fortnight newsletter and over time, this becomes a weekly one.
@@shankarnathit shows page not found. Pls check.
Pls try again. shankarnath.substack.com
@@shankarnath Subscribed to Newsletter. Your analysis and content is as good as Harsha Bhogle to Cricket if not better. One advice please, what paid screener is good to get ratios , vwap , charts etc ? I understand this is not financial advice 😃
@@bhaveshpatel498 Thank you very much. I can never replicate Harsha's immortal words "Are we onto something here? .. but I'll try :)
I don't use paid screeners for now but I'll certainly subscribe to one or two soon enough. Screener.in is something I use & see a lot of value in. Another one that Ishmohit (SOIC) recommended when I last met him is Tijori.
Hes so aligned & organized in his approach.
You are trending man! The credit goes to your study and passion. Hats off.
Thank you Charanjeet 🙌
For some reason, instead of just watching this one as an educational video, I'm really excited about this strategy and seriously considering creating a small satellite portfolio using this strategy. Unfortunately, I'm very low on investible cash as of now. Hopefully I'll accumulate some more soon enough and get started with this. Thanks a lot for the insights and introducing me to this concept!
Most welcome. I'm glad you found this strategy relevant
Define SHANKAR NATH in one word ? The answer is: AWESOME - the very very best in FINANCE - yet another impressive video - what makes him the best is his ability to be simple, articulate and a no-frills way of presentation - Thanks yet again!
Agree 👍
Thank you so much for the kind words, Sridhar ji. It's great to receive support and encouragement - that's the fuel for content creators to do better in their chosen profession. I paused a bit, when I wrote "profession" :) .. could have been working in my office now earning a few lakhs a months, but here I am .. earning too little, working too much and "professing" to Indians allover about investing :) .. life's turning tales, I guess. Thx again!
@@shankarnath Not sure what to say reading your response - discovered you during your time at ET Channel and followed you as you created your own channel - your passion in creating content and educating Indians on finance and investing - HUGE RESPECT SIR 🙏
Sir, I Have made 58% return(profit- Rs. 1.7 lakh)in 1 year by making 1 Small case inspired by your Video " Peter Lynch 3 times in 3 years". I admire you.
Can you please share the video
Search " RePeter lynch Shankar nath" it will come. It was broadcasted 11 month ago
Thank you very much. I'm glad it was helpful. Please read/watch videos on multiple strategies and customize your approach. In the months and years of researching and making these videos, I've discovered there is no single silver bullet and different strategies work better in specific situations. The videos on my channel has covered momentum, growth, value, deep value, cash-rich, microcaps, factors and more .. please absorb as much as you can and remember, since everyone can make mistakes incl. me .. always Trust But Verify. Wishing you the best!
@@shankarnath yes Sir, I am learning as much as possible by reading, video, Economic Times, Twitter etc.
I have also made 88% in ndr auto buying price was 814 but company annouced bonus 1:1 i got 10 shares and their value was adjusted 407 now making 88% profit
Only when one buys progressively more quantites during continuous dips , one can easily achieve 18 to 20 percent xirr over a long run
This is unbelievable to see such a gem of info available free of cost. May God bless u. Thanks a lot.
Most welcome
I do the same thing influenced by Sheridan titman research. I call it value momentum investing
@shankar: Please keep the same level of research and passion going forward. I sincerely hope you reach the top of the fin educators in India. I would never understand people like Akshat, Rachana having more followers than you, hope you gain followers for the effort that you are putting. Appreciate it.
Thank you for your good wishes
Agreed
You continue to just give these gems for free! Thank you so much Shankar Sir.
My pleasure. So nice to you
I love the way everything is backed by backtested data and scoring. You just love numbers, dont you? I invest in canada (since I live there) but your calculations are valid across markets
If there was a metric for an undervalued youtube account, you would make the list, Shankar.
Thank you very much 🙌 I love numbers and a good story .. it just happened that UA-cam offered both via an investing channel :)
Shankar you are the best UA-cam presenter related to stocks in India. Very rich and knowledgeable topics. Keep it up
So nice of you. Thanks a ton, Gopal ji
@Shankarnath - I tried to calculate the returns for 6 months for the stocks in the sheet shared since this video was released by you on 22-Nov-2023 (stock price taken on 10-Nov-2023). It has given staggering 52% returns. Nifty50 has given 16% for the same time period. Thank you for sharing this (and many more) strategies for winning stocks / portofolio. 🙏
Thank you very much for sharing this, Vikrant ji
Fantastic video Shankar! Even after 10 years in the market, trending value is a completely new investment philosophy for m and I'm already racking my brains how I can use this. My only feedback on the video will be the somewhat misleading comparison between the strategy returns and the Nifty returns as the strategy has 80% small cap stocks. So the comparison should be with small cap index.
Sincerely appreciate all your great work and sharing all this wonderful content with everyone. You deserve a million subscribers 😊!!!
Hi Gurjot .. thank you very much. Actually I too thought about it .. but came to the conclusions that if not Nifty then the Nifty 500 or the Nifty 750 should be the ideal benchmark (not Nifty small cap).
The reason I feel so is because before the exercise started (by O'Shaughnessy or CapitalMind), none knew the list of stocks that will come out. It just so happened that smallcaps came out because large caps didn't ascribe to it. But if valuations were damp like it was the case in 2003 or 2008, then maybe large caps could also have been a part of trending value. In that context, I feel the total market index will be a more appropriate benchmark. Yes, the smallcap can be a secondary benchmark.
Thanks for your good wishes and support as always, Gurjot. I continue reading your tweets and get inspired.
Excellent sir, better you make a screener to use full strategy ie on chartink.I will also try .❤
Very well put together video.. kudos!
Thanks a ton!
Thanks for the insights. As always your videos are always easy to understand and thanks for sharing the work sheet. Surely that will act as a starting point
Thank you very much, Naveen ji. I'm glad the research is understandable and implementable. Honestly, my own investing framework has improved by leaps and bounds after studying all this stuff .. and I'm happy it's helping you aswell.
hello sir, using kotak stock case, we can create basket and simulate over 5 y and 1 year , or 10 years
Thank you so much for taking out the time and makinh such knowledge enriching videos for us.
My pleasure! So nice of you, I'm happy you liked it
Your presentations consistently astound me with fresh and valuable content. I eagerly anticipate your videos.
Happy to hear that, Prashant! The creation of these videos have been helping me upgrade my own knowledge of investing and the selective application of what I'm learning is improving my own investing framework and result.
Very interesting and informative! Thanks Shankar :)
My pleasure! Glad you liked it, Anup!
Instant subscribed - thank you sir
I'm very new to this ecosystem, loved the way you have explained
Welcome aboard! Thank you for the kind words
Thank you for enlightening us ❤
You are so welcome
Shankar Sir ! Thank you so much.
You're most welcome
Thank you for delving into these investment strategies and offering such insightful analysis. The valuable insights from these videos will undoubtedly benefit the investor community.
Thank you very much. I'm glad you found it useful
Hi Shankar sir, thanks for posting this video! Greatly enriching. I wanted point one thing, instead of hard pasting the numbers, can we get formulas in the excel, it helps in better understanding the numbers and would be more uselful. Thank you. ALso Congrats on hitting the 100K being following you since ET money days.
Thanks for the appreciation and the suggestion
Very informative & in-depth analysis
Glad it was helpful! Thanks
Great Shankar sir ❤ awesome content every time
Thank you very much 🙌
Hello sir
Huge congratulations on hitting 100K. You are the person who i look up to for any questions and can expect a reply!!
Sir what do you think about the future of small caps in the next 10 years
I am actually building up a corpus to pay for my term insurance till the end of maturity period
Instead of choosing return on premium,its wise to invest the difference premium amount into a mutual fund that will earn returns for you as well as pay for future premium
What is best should i invest in a nifty 50 or is small cap safe and atleast generate annualized returns close to nifty benchmark.
Please guide me on this Sir!!!
no reply to this?
Great content as usual
Glad you enjoyed it
I wait for your videos sir, great job.❤
Thank you Prashant ji
Again hit with valuable contact
Hatsoff to you
Thank you very much
Thanks a lot sir for this valuable content.
I have few queries,
1)Once 25 stocks are obtained from the raw data, how to decide what portion of the total investment should be dedicated to each of these stock.
2)How to go about rebalancing every year
Most welcome
1. Go for equal weighting - 4% to each stock
2. Please read on how to do rebalancing over the Internet. The concept is simple although execution is a bit tougher.
Thanks for sharing another informative Video and keep learners gaining knowledge
My pleasure. Glad it helped
Your channel is underrated sir 😮. You actually deserve millions of subscriber . I also found useful this channel nd immediately subscribed it 😊😮
Thank you so much. I'm glad you like my work
Thank you so much for sharing this valuable information
My pleasure 🙌
Just imagine all your strategies taught to the AI along with the knowledge of technical & fundamental analysis with knowing the market new & current affairs 🤯 you’ve created a cash printing machine 🎰
I am awestruck with the quality and variety of content and the amount of research and hardwork that has been put into each of your videos. Truly inspiring.
Great to hear! Thank you
Hi, thanks for the video. One question: what is your strategy of selecting top 25 stocks based value and returns on 150 stocks. In the excel, you mentioned as Power Fin Corpn as 1st of 25. Why Jindal Saw is not selected when it has highest returns from the 150 stock list.
The criteria of selection was not historical highest return. The selection was to be done on the basis of the value composite score as per O' Shaughnessy's method
Thank you very much.
You are welcome! 🙌
Shankar sir 🙏 THANK YOU
Most welcome
Suggest you to start a small case for 2 or 3 different strategies. So we can join you on the actual team.
I am definitely loving this momentum and value theme
Thanks
Great suggestion. Shankar bhai, please consider.
Your videos very helpful and understanding. I was going through the excel shared. The missing values have been assigned a rank of 700 and decile value 5. Is there any reason for why it is done like that?
Thank you! Yes, these are unknown values and hence decile 5 was taken. I read somewhere that this approach was used by O'Shaughnessy so I too implemented that
Hi Shankar, thanks for the video, collective information and the excel sheet. 1 question I had was the 'price to operating cash flow' ratio was throwing negative values for companies with negative cash flows. and the excel shows we use it as better -centile for calculations. Can you please recommend on how to handle negative cashflow in the excel?
Hello. I don't have an answer for you on how to handle it in an excel sheet. Over time, my own weight towards this metric has weakened as I see many instances where a negative cash flow can be justified or might be necessary.
For instance:
1. Investment phase wherein growing companies have to invest heavily in expansion and R&D. This investment is a driver in their future success
2. Strategic expansion like new markets, new products etc. Again, it helps in future growth and profitability.
3. Seasonal variations also affects cashflows temporarily for some indutsries
4. Debt repayment cycles can also lead to negative cash flow
etc.
@@shankarnath thanks for the reply. So will use less weightage for this metric as lower can be better but there are cases where negative might not be good.
@shankarnath Some sectors have low PE and others have high. For this reason, you may never get stocks from those sectors would it not be better if the ratios are considered with respect to the sector itself?
Yes ofcourse. I for one prefer relative PE (i.e. comparison within sector) as compared to absolute PE ratio
❤❤ very informative video
Glad you liked it
Hi shankar.... Needless to say, it is a greatly informative video.
Can this strategy be used to invest as in an SIP mode, instead of investing a lump sum amount, and if not, which strategy do you think would be best suited to make investments in SIP mode?
Thank you very much. I guess this can be used as an SIP but please note, the strategy requires an annual rejig in portfolio. So you can buy a stock every month (12 month SIP) from say, the 1st the Jan. But come next year 1st Jan, that stock might have to exit and replaced with a new stock SIP.
Hi Sir, I noted that stocks with negative Price/X ratio have been given a lower rank than the ones with a low positive values. Is this right? Isn't a negative Price/(earnings/cash flow) bad?
Unfortunately there is no literature on these practical issues so it's upto ones assessment of what is right or wrong or acceptable. Pls feel free to modify the worksheet per your assessment.
Hi Shankar, Kudos for such a great video. Pls provide an excel with formulas!
It will help us with future rebalancing.
Thanks for the suggestion
Good strategy.
Thank you!
Hi Shankar, This is very interesting,
I am wondering is there any mutual fund available in market which follows this strategy? If not then why?
If I have to follow what is simplest way to do it?
Thanks
1. I have not come across any MF around this strategy
2. I'm not sure why that is the case. The fund houses have to be asked individually this, not very practical
3. The simplest way to do this is way I have shown it. It takes 15-20 mins to compile the table and has to be done once a year
Please tell me how to did you backtested this strategy.
How did you get historical data
Hi, you'll have to connect with the folks at Capitalmind who backtested the strategy. They can give more specifics. I'm sure they would have the required software that can extract data at particular points in the history. Unfortunately the screeners I use are all present-day trailing
Thanks a lot Shankar Sir for such informative, data driven, content rich videos. Chole BHATURE par bhi video karna hai hamey!! ❤ Please keep the content coming. A Video on ELSS funds will be very useful.
So nice of you, Ravi. Yes, chole bhature is still pending but unfortunately I have too much on my plate (metaphorically speaking) :)
I am just surprised how this was not told by anyone
Combination of momentum and value index funds gives the good returns?
Pls watch my video on this: ua-cam.com/video/aYHRTPTDtNk/v-deo.html
Hi Shankar, Thank you for such a great video. Is it possible to have this excel with formulas?
Most welcome. I didn't apply formulas when I created that worksheet, thats why it isnt there
@@shankarnath Would it be possible to share an Excel with formulas?
Thanks so much
@@abhijeetmukherjee4883 As soon I come up with a formula-based excel for this, I will pin it in the comments
I am not able to download excel myself, do I need to subscribe to the premium plan on screener?
I'm able to do that. Go to File, and the only highlighted option is "Download". Please try in a different browser or take help from a friend.
Frequency of collecting data, and how to invest is so many stocks? How part is very difficult here.. Why mutual funds don't do this..?
1. Frequency is once a year (its annual rebalancing)
2. Investment can be done via an broker (online or offline), will take 10 minutes to put in 25 orders
I guess MFs can't do this because the methodology is a neither an active strategy not a passive strategy. It's designed more as a point to point strategy which suits individuals.
Great Video. Are there any mutual funds that invest as per this strategy?
Thx. I havent come across any
Hi Shankar, I was thinking of including the following conditions during preliminary screening to narrow the universe even further: -
Market Capitalization > 500 AND
Debt to equity < 0.5 AND
Profit growth 5Years > 10 AND
Profit growth 3Years > 10 AND
Profit growth > 10 AND
Sales growth 5Years > 10 AND
Sales growth 3Years > 10 AND
Sales growth > 10 AND
Average return on capital employed 5Years > 15 AND
Average return on capital employed 3Years > 15 AND
Return on capital employed > 15 AND
Average return on equity 5Years > 15 AND
Average return on equity 3Years > 15 AND
Return on equity > 15 AND
Price to Earning < Industry PE AND
Book value 5years back < Book value 3years back AND
Book value 3years back < Book value
As of today (17-01-2024) this screen is giving 34 results.
Sir are there any companies that can do option trading on our behalf while charging some fee?
I'm not aware of any but I won't be surprised if there are dozens of such outfits who will do it. Just try out some telegram channels .. but please be careful. The proportion of gainers from options trading is quite low from what I have heard
@shankar, thanks for this video. A request: could you please update this sheet with the script symbol instead of the name? that would be great. Or you can guide me from where I can get the list of >500 market cap for free. Thanks!
Pls use screener.in
@@shankarnath it's not free to export :( It's asking for subscription.
@@janusalex Same for me, I simply copy paste the numbers on an excel sheet
alright then, thanks for the quick response!@@shankarnath
Liked and subscribed 👍
Welcome aboard
Thanks
Thank you very much Anurag ji for your kind appreciation and for this gratuity. I am glad you loved the content and found it informative
Any ready made EFT or Mutual fund available for this strategy ?
Sorry, I'm not aware of any
Alpha prime smallcase. I already have 1 month ago
Hi, what is the software or website that you are using to find companies with valuations above 500 crores. Thanks
I use screener.in
@@shankarnath Thanks a lot for your reply.
Another great video from Shankar sir
Thank you very much. I'm glad you liked it 🙌
Hi sir
Very informative video.
Can you tell how you was able to get data of companies ?
Thanks. The process is exactly the way I explained in the video using screener.in
@@shankarnath Thanks for responding. It is paid or unpaid ?
Sir, have a question. Why have the stocks whose PE Ratio is empty assigned a PE ratio rank of 700 ? I can see stocks with PE Ratio (Greater than 0) having ranks above and below 700.
Thats because I wanted to give BLANK values a 5 decile. 700 is half of the universe so automatically it would comes as 5 decile
@@shankarnath - Thanks for your reply. I did some digging and these stocks have -ve PE ratio (EPS might have been -ve for these). I used tickertape screener. Shouldn't these be tagged to 10th or 11th decile, rather than plotting them in the middle.
Btw, love your content and the data backed approach is a USP that i have not seen other content creators bank upon
Smallcase Value and Momentum ; does this follow the same strategy .??
Sorry, I'm not sure
Is there any smallcase which follows this strategy?
Not sure. There is one titled" Value & Momentum", managed by Windmill Capital but the methodology might be a little tweaked.
how does the trending strategy not cover stocks in the mid to large cap space except very few.
do they necessarily pick small caps.
The filter's don't allow. Mid to large caps have higher PE ratios (as a % to their universe), higher PB ratio, higher PS ratio and lower dividend yields. Please refer to my worksheet (link in description) and create a slab using the market capitalization column I have provided there for a better understanding
@@shankarnath thanks. one last point. these 25 stocks have show a sudden spike over last 5 -6 months. when does the trend reversal happen in such a case. is it the end of the rally for all these stocks.
technical/ fundamental indicators to identify the rally ending
@@gnayak18 Hi, please connect it with two related points:
1. the definition of momentum that I've explained in previous videos
2. the rebalancing logic explained in this video
So momentum rules says that the trend will continue and rebalancing rules say that there will be a change of holdings after a year
One of the most underrated finance channel..!! ❤️
Glad you are finding my work useful
Nice video, thank you for getting this in an understandable format, will this sheet be refreshed on a regularly basis?
I plan to update information in this worksheet and my other videos in a separate section of my newsletter (website). The idea is to have everything in one place.
Sir yet another good analysis and video to the investors.. Thank you sir.
Always welcome 🙌
Namaste Mr. Shankar- Appreciate your view on sustainable evolution of ‘Carbon Neutrality’ theme on medium-long term basis, it’s relevance and significance from EMs (like India) growth’s perspective? Can you please suggest names of few listed stocks which we should research/study?
Namaste. I'm sorry, I have not tracked this sector. May I circle back to you once I have gone through this?
@@shankarnath appreciate and thank you
Sir Please make a detailed video in Tata Midcap momentum index
Thanks for the suggestion
is there any Mutual fund that follows this strategy?
I've not come across any
Sir I have a Qustion......
Can Doing SIP in Momentum and Value Fund in Ratio of 70% : 30% Respectively Can Beat Allocation Strategy of 50% :50%
Apologies, I have no basis of predicting if a 70:30 will be better or worse than a 50:50. Momentum and value although not opposing strategies have a different style factor.
Hi Shankar, shouldn’t we also add PE/G ratio as the 7th metric?
The author (O'Shaughnessy) didn't add PEG ratio in his study
Yes Shankar, but we can add no and do regression analysis/back testing.
Yes Shankar, but we can add no and do regression analysis/back testing.
Yes Shankar, but we can add no and do regression analysis/back testing.
Yes Shankar, but we can add no and do regression analysis/back testing.
Sir make videos on sectorial analysis of auto sector
Thanks for the suggestion
What tool do you use to fetch the data?
screener.in
How are you calculating PE ratio-Rank?? PB ration rank??
In excel sheet using the RANK functionality
Thank you@@shankarnath
Good 🙂
Thanks!
Hi Shankar, you sound almost like Rajeev Masand 😃
Thank you from me & Rajeev
Simply you should invest in midcap fund or index, isn't it more simple?
Yes, definitely more simple if simplicity is what you seek
Nice
Thx
Sadly these type of videos don't get views.
People need Zero to Hero expiry strategy 😢
can u share google sheet which automatically makes this list each year
Sorry, I don't know how to make an automatic one. The process itself doesn't take long to implement, maybe 15-20 minutes
@@shankarnath thanks for the prompt reply. Can u share screener filters u have used. The video is great I am already using ur MF idea of momentum and value funds
Hello sir, excellent video as always, I'm a regular viewer of your channel since inspection of this UA-cam channel
Please let me know whether the article of capital mind which u have provided in the link has all the back tested information which u hv shown in 9:10 segment
I tried with the link, i couldn't able to read those information which u hv shown in the video, pls help me with it
If possible, please download that article, convert that into PDF format & add in the description or comment section will be very helpful of u do this favour
Hope u consider my request, thanks in advance! 😊
Hello, thank you for your continued patronage. The Capitalmind article is a premium article and is behind a paywall. Perhaps you can write to Deepak Shenoy or to the author (Krishna Appala) for a copy of the same. If I get an opportunity to talk to Deepak or Krishna, I will certainly verify if the methodology they used and I am using is the same - although personally, I don't see much variations here. Afterall, this is how Capitalmind explains it (www.capitalmind.in/wp-content/uploads/2023/06/9C8D030A-0417-43A9-8CD1-56CF4866FD85.jpeg) which is similar to the process I explained
Just curious to know, won't investing in Momentum index fund + Alpha Low Volatility Index fund give similar returns at lower expenses ..?
Interesting. If you have tried it out or are going to, please do share the results incl. the combination of momentum & alpha low vol .. and the rebalancing rule is also important. Thanks!
Hello sir, in my MF portfolio i have mix of mid small flexi cap funds.. is it necessary to have separate index fund since most of large cap are already covered in my parag Parekh flexi fund
No use portfolio overlap tools to analyse
Sorry, I don't have a view on your quandary. Personally, I don't bother much about overlap and prefer to focus on my asset allocation (both - market cap and strategy)
Sir if you do complete vedio in Hindi it will be more helpful
I will try. Thanks!
Sir, what about negative p/cfo ratio? You ranked them better than those with positive p/cfo ratio
It's a good point. I might have ignored that rule, my mistake
Sir, I've used the ticker tape screener. The data has no values where a negative cfo is considered. Would it be wise to assign them a 5 decile or a 10 decile?
Sir, I've used the ticker tape screener. The data has no values where a negative cfo is considered. Would it be wise to assign them a 5 decile or a 10 decile?
@@paawanangra7666 I have no prior reference on the handling of negative CFO. Left to me, I would put them in decile 10
DECILE CALCULATION FORMULA IN EXCEL SIR?
Sorry. I don't know how to calculate it in Excel. If you know it or find the process, pls share it with me aswell
Use The Rank Formula To Rank the P/E Value (=RANK(E5,$E$5:$E$30,1)) In My Sheet the P/E Values are in the E column, Now For The Decile We will use the following formula =CEILING(F5/((COUNT($F$5:$F$30)+1)/10),1)
Also Note My data starts from 5th Row Hence F5.
Let Me Know if this is helpful and if there is an error please feel free to point out
Like & Comment first then watch. quality content guaranteed.
Ha ha .. thank you very much for your continued support and patronage
What is the reason for comparing with Nifty, If trending value strategy is mid and small cap?
Computer with corresponding index.
Thanks for the suggestion. In my view, it should not be the smallcap & microcap index .. and it should have been the Nifty Total Market index (750 stocks) because when Capital Mind started the activity, they didn't know it will be smallcaps that will turn up. Even when I did it with 1521 companies, it included large, mid, small & microcaps. The strategy just happened to favour small/microcaps; ergo; the comparison with the all-market index is the fair way to look at it. If I meet Deepak or Krishna, I'll pass this feedback to them
Any MF scheme having this theme ? Plz advise
I haven't come across one yet but if upto it, please examine the presentations of some of the value/contra funds. Maybe one of the schemes might be ascribing to this strategy. Also, I found something on MarketSmith but it's behind a paywall so I'm not sure what this might have (marketsmithindia.com/mstool/list/guru-screens/james-p-oshaughnessy/idealists.jsp#/)
yes statergy is good, but to implement mutual fund is best option. better AMC's can think of starting one :)
There is a smallcase "Value and Momentum" managed by Windmill Capital. I haven't seen the methodology. Please explore that
Thanks a lot sir for this valuable content.
But i have an issue with data presented by you in the excel sheet. The P/CFO rank is give totally on the basis of its value which is wrong. The company with worst negative Cash flow from Operation will be given better rank than a company with positive Cash Flow.
This issue in ranking will effect the whole process after that which may give wrong info to audience. Please take a look
Thanks for letting me know