Stock screens

Magic Formula stocks. Good businesses at cheap prices.

NSE companies (excluding banks, NBFCs, holding companies with large minority interests and those under ₹1,000 Cr market cap) ranked on two things: earnings yield (operating profit ÷ enterprise value) and return on capital employed. The top 50 by combined rank.

· data for the trading session of Wed 18 Nov 2026

How to use this tool
50 stocks matchPrices: 18 Nov 2026Fundamentals: latest filed quarter
StockPriceMarket capP/ESales YoYProfit YoY1 yearEarnings yield / ROCE
Sun Pharma Advanced Research CompanySPARC₹190.12₹6,169 Cr3.8+282%–+46%34.2% / 115%
Chennai Petroleum CorporationCHENNPETRO₹1,419.70₹21,141 Cr3.7+10%+212%+29%33.9% / 58%
Panama PetrochemPANAMAPET₹423.80₹2,564 Cr3.8+123%+359%+40%36.2% / 49%
NALCONATIONALUM₹308.10₹56,587 Cr7.9+26%+28%+20%21.9% / 43%
Kernex Microsystems (India)KERNEX₹1,693.20₹2,845 Cr9.1––+28%14.9% / 85%
Gandhar Oil Refinery (India)GANDHAR₹260.98₹2,555 Cr5.8+74%+385%+85%26.1% / 40%
Websol Energy SystemWEBELSOLAR₹65.15₹2,829 Cr8.2––-45%16.3% / 56%
Hindustan ZincHINDZINC₹527.00₹2.23 L Cr10.7+77%+142%+11%13.5% / 94%
Savita Oil TechnologiesSOTL₹626.60₹4,295 Cr7.3+59%+422%+63%21.2% / 40%
Coal IndiaCOALINDIA₹388.00₹2.39 L Cr7.2+46%+50%+1%24.7% / 34%
K.P. EnergyKPEL₹172.39₹1,169 Cr6.7+79%-25%-56%20.0% / 36%
Garuda Construction and EngineeringGARUDA₹154.00₹1,433 Cr9.6+47%+50%-35%13.9% / 42%
Mangalore Refinery and PetrochemicalsMRPL₹175.97₹30,841 Cr7.0+37%+203%-1%20.7% / 32%
Arrow GreentechARROWGREEN₹672.50₹1,015 Cr13.9+40%+60%+17%12.4% / 41%
ModisonMODISONLTD₹338.70₹1,101 Cr9.7+92%+100%+121%12.6% / 39%
GE Power IndiaGVPIL₹570.70₹3,837 Cr14.4+11%-14%+53%9.7% / 73%
CrizacCRIZAC₹150.61₹2,636 Cr12.6-37%-25%-47%10.9% / 42%
KamdhenuKAMDHENU₹36.70₹1,035 Cr11.4+12%+27%+35%16.6% / 30%
InfosysINFY₹1,108.80₹4.49 L Cr14.6+11%+6%-25%10.3% / 42%
MstcMSTCLTD₹693.10₹4,879 Cr18.6+29%+58%+36%12.7% / 33%
Sharda Motor IndustriesSHARDAMOTR₹935.05₹5,367 Cr15.0+54%+33%-5%11.0% / 37%
Indiamart IntermeshINDIAMART₹1,549.20₹9,311 Cr18.6+10%+10%-37%12.0% / 33%
Jeena Sikho LifecareJSLL₹296.35₹3,684 Cr17.2+24%-38%-58%8.9% / 69%
Emmvee Photovoltaic PowerEMMVEE₹270.12₹18,702 Cr13.0+39%+61%+23%9.4% / 45%
The Great Eastern Shipping CompanyGESHIP₹1,530.60₹21,568 Cr4.9+47%+118%+35%33.6% / 26%
Petronet LNGPETRONET₹325.50₹48,825 Cr10.5-35%+51%+18%17.3% / 28%
Tata Consultancy ServicesTCS₹2,379.50₹8.61 L Cr16.7+11%+15%-23%8.7% / 62%
D-Link (India)DLINKINDIA₹401.40₹1,425 Cr12.9+20%+11%-11%11.8% / 32%
NMDCNMDC₹68.24₹59,995 Cr8.1+4%-2%-10%19.9% / 26%
BLS International ServicesBLS₹227.75₹9,376 Cr13.1+32%+6%-30%11.0% / 33%
Sharda CropchemSHARDACROP₹698.75₹6,304 Cr9.8+13%+23%-9%14.7% / 28%
Chaman Lal Setia ExportsCLSEL₹279.05₹1,388 Cr8.5+20%+197%+4%24.9% / 25%
Gulshan PolyolsGULPOLY₹160.48₹1,001 Cr5.9+14%+150%+8%22.2% / 25%
GK EnergyGKENERGY₹97.81₹1,984 Cr8.4+1%+5%-49%16.0% / 27%
Expleo SolutionsEXPLEOSOL₹765.00₹1,187 Cr8.8+4%-8%-30%19.3% / 25%
SKM Egg Products Export (India)SKMEGGPROD₹216.31₹1,139 Cr10.9-6%-28%+1%13.1% / 27%
Bhansali Engineering PolymersBEPL₹111.22₹2,768 Cr12.5+24%+54%+17%12.1% / 28%
Indraprastha Medical CorporationINDRAMEDCO₹358.00₹3,282 Cr17.1+8%+8%-31%9.0% / 36%
VST IndustriesVSTIND₹194.54₹3,304 Cr12.7+87%-31%-23%12.9% / 27%
Waaree Renewable TechnologiesWAAREERTL₹705.95₹7,370 Cr15.8+37%-36%-37%8.2% / 43%
Castrol IndiaCASTROLIND₹190.38₹18,831 Cr18.6+27%-23%-0%7.7% / 72%
Indian Energy ExchangeIEX₹115.00₹10,245 Cr19.6+9%+13%-16%7.9% / 49%
Sandur Manganese & Iron OresSANDUMA₹172.57₹8,389 Cr10.0+22%+88%-20%13.5% / 26%
Manali PetrochemicalsMANALIPETC₹78.53₹1,351 Cr6.0+59%+250%+16%41.0% / 22%
Canara Robeco Asset Management CompanyCRAMC₹228.99₹4,567 Cr19.9––-22%7.9% / 41%
Gulf Oil Lubricants IndiaGULFOILLUB₹1,150.00₹5,698 Cr14.1+46%+35%-2%11.6% / 27%
Navneet EducationNAVNETEDUL₹122.80₹2,702 Cr7.0+31%–-22%19.6% / 22%
Gujarat Pipavav PortGPPL₹174.72₹8,447 Cr15.3+13%-5%-0%9.7% / 30%
eClerx ServicesECLERX₹1,500.10₹13,763 Cr19.1+18%-2%-33%8.0% / 36%
R Systems InternationalRSYSTEMS₹243.05₹2,880 Cr13.0+23%+82%-40%12.0% / 25%
Greenblatt’s idea

Rank every company on how cheap it is (earnings yield) and how good it is (return on capital), then buy the best combined ranks.

Meant as a basket

The method is about holding many of them for a year, not picking one.

Trailing numbers

Uses the last four quarters of operating profit and the latest balance sheet, not forecasts.

Questions

What is the Magic Formula?
Joel Greenblatt’s ranking: earnings yield (EBIT ÷ enterprise value) plus return on capital, each ranked across companies; the lowest combined rank is best.
Why are banks excluded?
Banks and NBFCs borrow as their business, so enterprise value and return on capital do not mean the same thing for them.

From NSE’s results filings, shareholding patterns and daily price files. A screen is a starting list for your own research, not a recommendation; ChartMine is not a SEBI-registered adviser.

See it live on your chart.ChartMine for TradingView.