334 to 48 companies >1000 cr mcap

Getting 334 stocks means your initial net is wide, which is common if you used basic filters. To turn this massive list into an investable shortlist of 10 to 15 high-conviction companies, you must aggressively tighten your parameters to weed out the average performers. Follow this 3-step sequence to cut down your list right now on Screener.in. ------------------------------ ## Step 1: Run the "Super-Quality" Code Go back to your query box on Screener.in, delete your previous query, and copy-paste this highly restrictive formula instead. This forces the system to only show businesses with exceptional capital efficiency, strong pricing power, and real cash generation: Return on Capital Employed > 20% AND Return on Equity > 20% AND Debt to equity < 0.2 AND Sales growth 5years > 15% AND Profit growth 5years > 15% AND Average return on equity 5years > 20% AND Operating profit margin > 15% AND Market Capitalization > 1000 AND Cash flow from operations 5years > (Net profit 5years * 0.9) Why this works to slash your list: * ROCE/ROE > 20%: Eliminates average businesses and highlights companies with a clear competitive advantage ([Matthew Effect](https://en.wikipedia.org/wiki/Matthew_effect)). * Debt to Equity < 0.2: Completely removes companies relying on heavy debt to artificially boost their returns. * OPM > 15%: Eliminates thin-margin businesses vulnerable to raw material cost spikes. * Market Cap > 1,000 Cr: Filters out highly risky, volatile micro-cap and penny stocks. * Cash Flow Check: Automatically filters out companies that have paper profits but no physical cash in the bank. ------------------------------ ## Step 2: Use the "Industry" Filter If your list is still over 40-50 stocks, look at the top of your Screener.in results page and use the "Industry" dropdown filter. Focus your energy on structurally strong, non-cyclical sectors first, such as: * FMCG / Consumer Goods * IT / Software Services * Chemicals / Specialty Chemicals * Pharmaceuticals / Healthcare Avoid sectors like Construction, Textiles, or Metals if you want highly stable, predictable cash flows, as these industries are heavily cyclical. ------------------------------ ## Step 3: Run the "PE vs Median PE" Visual Test Click on the first few companies remaining on your shortened list. Scroll down to the Price Chart section and click on the "PE Fraction" tab. * The Red Flag: If the current PE line is hovering near its historical highest peak (e.g., 5-year maximum), do not buy yet. The business is fundamentally great, but the stock price is too expensive. * The Green Light: Look for fundamentally strong companies whose current PE is close to or below their 5-year median PE line. This indicates a fair or undervalued buying window. ------------------------------ ## Your Next Step Go ahead and update your query box on Screener.in with the "Super-Quality" code above. Tell me: How many stocks did your list drop down to? Paste the names of the top 2 or 3 companies that popped up, and we can check them for any hidden red flags together!

by Ssk VFX g