Joel Greenblatt's MAGIC FORMULA Screen for Indian Stocks with Additional filtering for Quality.

#Thread

5th Upd -08Nov2020

Added HOW TO USE Magic Formula & some more updates, so do read till end.

#MagicFormula #Stocks #Indianstocks #JoelGreenblatt

1 Image
📌Magic formula =Good Stocks At Attractive Prices

Higher Earnings Yield = Undervalued Stock

Higher ROIC/ROCE= Better Quality

Rank stocks on ROIC/ROCE (1 for Highest ROIC/ROCE)

Rank on Earning Yields (1 for Highest EY)

SUM the Ranks

RE-RANK on Combined score(1 for Lowest)

2
Additonal Filtering -

Good ROCE/ROIC over a period of time. Min 22%.

Attractive Earnings Yield > 10YrGSec(5.88%).

Good Operating Cash Flow over a period of time.

Good Asset turnover ratio/Management Efficiency.

Stable Promoter holding.

3
Eliminated Financials & Utilities Stocks

Eliminated Stocks with too much fluctuation in Year on Year (YOY) Qrtrly Sales & Profit Growth(<-150% combined)

Took ROIC & ROCE & listed both rankings combined with Earnings Yield. Choose either as per your comfort.

Explanation -

4
ROIC = Net Operating Profit After Tax(NOPAT)/Invested Capital
= Return from Core Business
= Profitability relative to capital actually invested

ROCE = Net Operating Profit(EBIT)/Capital Employed
= Profitability relative to total capital employed

5
Scope of ROCE is more extensive than ROIC.

ROCE is pre-tax measure while ROIC is post-tax measure.

Capital employed = Share capital + Reserves + Borrowings

Invested Capital = Capital employed - Non-operating assets (like Cash or Cash equivalents)

6
Earnings Yield = Net Operating Profit(EBIT) / Enterprise value.

How to Use Magic Formula ?

As per Greenblatt - Invest in Top 30 with 2-3 positions each month over a year

Each year, Re-balance Portfolio

Re-balancing Explanation ->

7
Sell off losers one week before the year-term ends (Tax-loss harvesting)

Sell off winners one week after the year mark (Long term gain Tax-harvesting)

Repeat for 5 - 10 yrs.

8
Please refer Previous Series Update in below link -

16Aug2020



9

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Screening Stocks Enjoy 'My StressBusters'

Screening Stocks Enjoy 'My StressBusters' Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @Coolfundoo

10 Sep
Q&A 162

#personalized #screener discussion !

⚡️Take away
- What should be Promoter Holding ?
- How much Debt ? Should we only invest in low debt companies ?
- Should we only invest in less Debtor days ? When can be High Debtor days companies be good investment ?

1
How much Debt ? Should we only invest in low debt companies ?

2
Promoter Holding = 0
There are around 90 companies which are run by Board & hence Zero Promoter Holding !

Don't forget them, some are really great compounders !

3
Read 7 tweets
7 Sep
Q&A 161

Read this 🧵to understand ROE, PE & relationship between them.👇

PE expansion to bridge the Gap (if any) between ROE & PE.

RT if you find this helpful.

1
ROE is PE's brother from another mother / Half-brother (Sautela Bhai)

@Atulsingh_asan

2
ROE & PE definition continued..

Keep an eye on Equations !

3
Read 9 tweets
20 Aug
Q&A 157

Q-> How to filter stocks so that PE is below median line and EPS is going up as shown in graph ?

1
You can use this #thread of mine to learn how to use EPS formula quarterly YoY ->


For Historical EPS parameters like how we have for Profit Growth, I would request @screener_in team @ayushmitt @faltoo to consider adding it.

2
Possible workaround - Use Profit Growth instead of EPS.

For PE below 5yrs Median PE you can write following query at @screener_in ->

Price to Earning < Historical PE 5Years

3
Read 4 tweets
16 Jul
Q&A 148

📢Study this short 🧵

🌟If you wish to know how to build your #thoughts in to a meaningful #screener Step-by-step ⁉️

🌟How to deal with a tricky scenario in @screener_in ⁉️

#screener #transformation #tips #tricks #workaround

Retweet to help others !

1
Situation / Problem / Bottleneck !

Try to brain-storm yourself before you proceed to next steps in the 🧵

2 Image
Step 1 - Identifying the problem correctly. Don't assume everything presented to you is correct.
Most people fail at this step. Sometimes there are data errors in examination paper as well. It's rare but it does happen !

3 Image
Read 8 tweets
12 Jul
My SCREENING TECHNIQUE Based #hypothetical #Portfolio
5th Upd - 12Jul2021 🧵

📍Purely based on my Financial Data Screening !

NO TIPS !
NO MEDIA!

🚩This Rally isn't a fade. Several NEW Names Popped up due to build up in financials/Fundamentals !

Not a recommendation! 👇

1 ImageImageImageImage
Stocks & Screening Technique Methodologies !

@Coolfundoo🌟23 , 22, 20, 19

2 ImageImageImageImage
Stocks & Screening Technique Methodologies !

@Coolfundoo 🌟 17, 16, 15, 14

3 ImageImageImage
Read 10 tweets
5 Jun
Q&A 134

Q-> If some stock comes in #personalized #screener you have created for me ->
How should I interpret it ?
Should I just buy it ?
What are my options ?
Can you explain !

1 ImageImage
Steps to be taken !

2 ImageImage
Here is how R Systems stands on my various #screeners.

An example how one can interpret just by glancing at them !

Similarly you can interpret from your #screeners I have built for you !

Here is the link for the #screenshot


3 ImageImage
Read 4 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!

Follow Us on Twitter!

:(