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| Stock | Price | Market cap | P/E | Sales YoY | Profit YoY | 1 year | Earnings yield / ROCE |
|---|---|---|---|---|---|---|---|
| Sun Pharma Advanced Research CompanySPARC | ₹190.12 | ₹6,169 Cr | 3.8 | +282% | – | +46% | 34.2% / 115% |
| Chennai Petroleum CorporationCHENNPETRO | ₹1,419.70 | ₹21,141 Cr | 3.7 | +10% | +212% | +29% | 33.9% / 58% |
| Panama PetrochemPANAMAPET | ₹423.80 | ₹2,564 Cr | 3.8 | +123% | +359% | +40% | 36.2% / 49% |
| NALCONATIONALUM | ₹308.10 | ₹56,587 Cr | 7.9 | +26% | +28% | +20% | 21.9% / 43% |
| Kernex Microsystems (India)KERNEX | ₹1,693.20 | ₹2,845 Cr | 9.1 | – | – | +28% | 14.9% / 85% |
| Gandhar Oil Refinery (India)GANDHAR | ₹260.98 | ₹2,555 Cr | 5.8 | +74% | +385% | +85% | 26.1% / 40% |
| Websol Energy SystemWEBELSOLAR | ₹65.15 | ₹2,829 Cr | 8.2 | – | – | -45% | 16.3% / 56% |
| Hindustan ZincHINDZINC | ₹527.00 | ₹2.23 L Cr | 10.7 | +77% | +142% | +11% | 13.5% / 94% |
| Savita Oil TechnologiesSOTL | ₹626.60 | ₹4,295 Cr | 7.3 | +59% | +422% | +63% | 21.2% / 40% |
| Coal IndiaCOALINDIA | ₹388.00 | ₹2.39 L Cr | 7.2 | +46% | +50% | +1% | 24.7% / 34% |
| K.P. EnergyKPEL | ₹172.39 | ₹1,169 Cr | 6.7 | +79% | -25% | -56% | 20.0% / 36% |
| Garuda Construction and EngineeringGARUDA | ₹154.00 | ₹1,433 Cr | 9.6 | +47% | +50% | -35% | 13.9% / 42% |
| Mangalore Refinery and PetrochemicalsMRPL | ₹175.97 | ₹30,841 Cr | 7.0 | +37% | +203% | -1% | 20.7% / 32% |
| Arrow GreentechARROWGREEN | ₹672.50 | ₹1,015 Cr | 13.9 | +40% | +60% | +17% | 12.4% / 41% |
| ModisonMODISONLTD | ₹338.70 | ₹1,101 Cr | 9.7 | +92% | +100% | +121% | 12.6% / 39% |
| GE Power IndiaGVPIL | ₹570.70 | ₹3,837 Cr | 14.4 | +11% | -14% | +53% | 9.7% / 73% |
| CrizacCRIZAC | ₹150.61 | ₹2,636 Cr | 12.6 | -37% | -25% | -47% | 10.9% / 42% |
| KamdhenuKAMDHENU | ₹36.70 | ₹1,035 Cr | 11.4 | +12% | +27% | +35% | 16.6% / 30% |
| InfosysINFY | ₹1,108.80 | ₹4.49 L Cr | 14.6 | +11% | +6% | -25% | 10.3% / 42% |
| MstcMSTCLTD | ₹693.10 | ₹4,879 Cr | 18.6 | +29% | +58% | +36% | 12.7% / 33% |
| Sharda Motor IndustriesSHARDAMOTR | ₹935.05 | ₹5,367 Cr | 15.0 | +54% | +33% | -5% | 11.0% / 37% |
| Indiamart IntermeshINDIAMART | ₹1,549.20 | ₹9,311 Cr | 18.6 | +10% | +10% | -37% | 12.0% / 33% |
| Jeena Sikho LifecareJSLL | ₹296.35 | ₹3,684 Cr | 17.2 | +24% | -38% | -58% | 8.9% / 69% |
| Emmvee Photovoltaic PowerEMMVEE | ₹270.12 | ₹18,702 Cr | 13.0 | +39% | +61% | +23% | 9.4% / 45% |
| The Great Eastern Shipping CompanyGESHIP | ₹1,530.60 | ₹21,568 Cr | 4.9 | +47% | +118% | +35% | 33.6% / 26% |
| Petronet LNGPETRONET | ₹325.50 | ₹48,825 Cr | 10.5 | -35% | +51% | +18% | 17.3% / 28% |
| Tata Consultancy ServicesTCS | ₹2,379.50 | ₹8.61 L Cr | 16.7 | +11% | +15% | -23% | 8.7% / 62% |
| D-Link (India)DLINKINDIA | ₹401.40 | ₹1,425 Cr | 12.9 | +20% | +11% | -11% | 11.8% / 32% |
| NMDCNMDC | ₹68.24 | ₹59,995 Cr | 8.1 | +4% | -2% | -10% | 19.9% / 26% |
| BLS International ServicesBLS | ₹227.75 | ₹9,376 Cr | 13.1 | +32% | +6% | -30% | 11.0% / 33% |
| Sharda CropchemSHARDACROP | ₹698.75 | ₹6,304 Cr | 9.8 | +13% | +23% | -9% | 14.7% / 28% |
| Chaman Lal Setia ExportsCLSEL | ₹279.05 | ₹1,388 Cr | 8.5 | +20% | +197% | +4% | 24.9% / 25% |
| Gulshan PolyolsGULPOLY | ₹160.48 | ₹1,001 Cr | 5.9 | +14% | +150% | +8% | 22.2% / 25% |
| GK EnergyGKENERGY | ₹97.81 | ₹1,984 Cr | 8.4 | +1% | +5% | -49% | 16.0% / 27% |
| Expleo SolutionsEXPLEOSOL | ₹765.00 | ₹1,187 Cr | 8.8 | +4% | -8% | -30% | 19.3% / 25% |
| SKM Egg Products Export (India)SKMEGGPROD | ₹216.31 | ₹1,139 Cr | 10.9 | -6% | -28% | +1% | 13.1% / 27% |
| Bhansali Engineering PolymersBEPL | ₹111.22 | ₹2,768 Cr | 12.5 | +24% | +54% | +17% | 12.1% / 28% |
| Indraprastha Medical CorporationINDRAMEDCO | ₹358.00 | ₹3,282 Cr | 17.1 | +8% | +8% | -31% | 9.0% / 36% |
| VST IndustriesVSTIND | ₹194.54 | ₹3,304 Cr | 12.7 | +87% | -31% | -23% | 12.9% / 27% |
| Waaree Renewable TechnologiesWAAREERTL | ₹705.95 | ₹7,370 Cr | 15.8 | +37% | -36% | -37% | 8.2% / 43% |
| Castrol IndiaCASTROLIND | ₹190.38 | ₹18,831 Cr | 18.6 | +27% | -23% | -0% | 7.7% / 72% |
| Indian Energy ExchangeIEX | ₹115.00 | ₹10,245 Cr | 19.6 | +9% | +13% | -16% | 7.9% / 49% |
| Sandur Manganese & Iron OresSANDUMA | ₹172.57 | ₹8,389 Cr | 10.0 | +22% | +88% | -20% | 13.5% / 26% |
| Manali PetrochemicalsMANALIPETC | ₹78.53 | ₹1,351 Cr | 6.0 | +59% | +250% | +16% | 41.0% / 22% |
| Canara Robeco Asset Management CompanyCRAMC | ₹228.99 | ₹4,567 Cr | 19.9 | – | – | -22% | 7.9% / 41% |
| Gulf Oil Lubricants IndiaGULFOILLUB | ₹1,150.00 | ₹5,698 Cr | 14.1 | +46% | +35% | -2% | 11.6% / 27% |
| Navneet EducationNAVNETEDUL | ₹122.80 | ₹2,702 Cr | 7.0 | +31% | – | -22% | 19.6% / 22% |
| Gujarat Pipavav PortGPPL | ₹174.72 | ₹8,447 Cr | 15.3 | +13% | -5% | -0% | 9.7% / 30% |
| eClerx ServicesECLERX | ₹1,500.10 | ₹13,763 Cr | 19.1 | +18% | -2% | -33% | 8.0% / 36% |
| R Systems InternationalRSYSTEMS | ₹243.05 | ₹2,880 Cr | 13.0 | +23% | +82% | -40% | 12.0% / 25% |
Rank every company on how cheap it is (earnings yield) and how good it is (return on capital), then buy the best combined ranks.
The method is about holding many of them for a year, not picking one.
Uses the last four quarters of operating profit and the latest balance sheet, not forecasts.
Questions
What is the Magic Formula?
Why are banks excluded?
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.
