How to Write Queries In Screener.in To List or Filter Stocks

Writing queries in Screener.in can help you filter stocks based on various financial metrics and criteria. Here are some examples of queries to list various Indian stocks based on different criteria:

1. Stocks with High Market Capitalization

Market Capitalization > 10000

This query lists stocks with a market capitalization greater than ₹10,000 crore.

2. High Dividend Yield Stocks

Dividend Yield > 3
This query lists stocks with a dividend yield greater than 3%.

3. Low P/E Ratio Stocks

P/E < 15

This query lists stocks with a price-to-earnings ratio less than 15.

4. High Return on Equity (ROE) Stocks

Return on equity > 20

This query lists stocks with a return on equity greater than 20%.

5. High Growth in Revenue

Sales growth 5Years > 15

This query lists stocks with a 5-year revenue growth rate greater than 15%.

6. High Net Profit Margin

Net Profit Margin > 10

This query lists stocks with a net profit margin greater than 10%.

7. Debt-Free Companies

Debt to equity < 0.1

This query lists companies with a debt-to-equity ratio less than 0.1.

8. High Promoter Holding

Promoter holding > 50

This query lists stocks where the promoters hold more than 50% of the shares.

9. Low Price to Book Value

Price to book value < 1

This query lists stocks with a price-to-book value ratio less than 1.

10. High Current Ratio

Current ratio > 2

This query lists stocks with a current ratio greater than 2.

Combining Multiple Criteria
You can also combine multiple criteria to narrow down your search. For example:
Market Capitalization > 10000 AND Dividend Yield > 3 AND P/E < 15
This query lists stocks with a market capitalization greater than ₹10,000 crore, 
a dividend yield greater than 3%, and a P/E ratio less than 15.

Creating Custom Filters
Screener.in allows you to create custom filters using various financial metrics. 
To create a custom filter:
Go to Screener.in.
Log in to your account.
Click on "Create New Filter."
Enter your query in the provided field.
Save the filter with a relevant name.
These are just a few examples, and you can customize your queries based on the specific 
financial metrics you are interested in. Screener.in provides a wide range of metrics 
that you can use to filter stocks according to your investment criteria.

Here are additional criteria and scenarios you can use to create more refined stock queries 
on Screener.in:
11. High Earnings Per Share (EPS) Growth
EPS growth 5Years > 15
This query lists stocks with an EPS growth rate greater than 15% over the last 5 years.

12. Positive Cash Flow

Cash from operations last year > 0

This query lists companies that generated positive cash flow from operations in the last year.

13. Low Price to Sales Ratio

Price to Sales < 1

This query lists stocks with a price-to-sales ratio less than 1.

14. Consistent Profitability

Net Profit last year > 0 AND Net Profit preceding year > 0 AND Net Profit 3Years back > 0

This query lists companies that have been profitable for the past three years.

15. High Interest Coverage Ratio

Interest Coverage Ratio > 5

This query lists stocks with an interest coverage ratio greater than 5, indicating strong ability 
to meet interest payments.

16. High Return on Assets (ROA)

Return on assets > 10

This query lists stocks with a return on assets greater than 10%.

17. Strong Revenue Growth

Revenue growth 3Years > 15

This query lists stocks with a revenue growth rate greater than 15% over the last three years.

18. High Operating Margin

Operating margin > 15

This query lists stocks with an operating margin greater than 15%.

19. Low Volatility (Beta)

Beta < 1

This query lists stocks with a beta less than 1, indicating lower volatility compared to the market.

20. Low PEG Ratio

PEG Ratio < 1

This query lists stocks with a PEG ratio less than 1, suggesting that the stock is undervalued 
considering its earnings growth.

21. High Price Momentum

Price change 1Year > 20

This query lists stocks that have appreciated more than 20% in price over the last year.

22. High Free Cash Flow Yield

Free cash flow yield > 5

This query lists stocks with a free cash flow yield greater than 5%.

23. High Institutional Holding

Institutional holding > 20

This query lists stocks where institutions hold more than 20% of the shares.

24. Low Inventory Days

Inventory days < 90

This query lists companies that hold inventory for less than 90 days on average.

25. High Quick Ratio

Quick ratio > 1.5

This query lists stocks with a quick ratio greater than 1.5, indicating good short-term liquidity.

26. Consistent Dividend Payer

Dividend payout preceding year > 0 AND Dividend payout 2Years back > 0 AND Dividend 
payout 3Years back > 0

This query lists companies that have paid dividends consistently for the past three years.

27. High Growth in Operating Profit

Operating profit growth 5Years > 20

This query lists stocks with an operating profit growth rate greater than 20% over the last five 
years.

28. Strong Asset Turnover Ratio

Asset turnover ratio > 1

This query lists stocks with an asset turnover ratio greater than 1, indicating efficient use of 
assets to generate sales.

Combining Multiple Advanced Criteria
You can combine multiple advanced criteria to create a comprehensive filter. For example:
Market Capitalization > 5000 AND Return on equity > 15 AND Debt to equity < 0.5 AND EPS 
growth 5Years > 20 AND Dividend Yield > 2

This query lists stocks with a market capitalization greater than ₹5,000 crore, return on equity 
greater than 15%, debt-to-equity ratio less than 0.5, EPS growth rate greater than 20% over 
the last five years, and a dividend yield greater than 2%.
By using these advanced queries, you can tailor your stock screening process to match your 
investment strategy and preferences on Screener.in.

here are some advanced queries for more sophisticated stock screening on Screener.in:

29. Consistent Revenue and Profit Growth

Sales growth 5Years > 10 AND EPS growth 5Years > 10

This query lists stocks with both revenue and EPS growth rates greater than 10% over the last 
five years.

30. High Free Cash Flow (FCF) Growth

Free cash flow growth 5Years > 15

This query lists stocks with a free cash flow growth rate greater than 15% over the last five 
years.

31. Low Debt and High Cash Reserves

Debt to equity < 0.5 AND Cash and cash equivalents > 100

This query lists stocks with a debt-to-equity ratio less than 0.5 and cash and cash equivalents 
greater than ₹100 crore.

32. High Return on Capital Employed (ROCE)

ROCE > 15

This query lists stocks with a return on capital employed greater than 15%.

33. Positive Earnings Growth and Low Valuation

EPS growth 3Years > 15 AND P/E < 10

This query lists stocks with an EPS growth rate greater than 15% over the last three years 
and a P/E ratio less than 10.

34. Strong Cash Flow and Low Valuation

Cash from operations last year > 50 AND P/FCF < 15

This query lists stocks with cash flow from operations greater than ₹50 crore and a 
price-to-free-cash-flow ratio less than 15.

35. High Piotroski F-Score

Piotroski score > 7

This query lists stocks with a Piotroski F-Score greater than 7, indicating strong financial health.

36. Graham Number Criteria

Current price < Graham Number

This query lists stocks trading below their Graham Number, which is a measure of intrinsic 
value.

37. High Altman Z-Score

Altman Z score > 3

This query lists stocks with an Altman Z-Score greater than 3, indicating financial stability.

38. High Earnings Yield and Low Enterprise Value

Earnings yield > 10 AND EV/EBITDA < 10

This query lists stocks with an earnings yield greater than 10% and an EV/EBITDA ratio less 
than 10.

39. Low Volatility and High Dividend

Beta < 0.8 AND Dividend Yield > 4

This query lists stocks with a beta less than 0.8 and a dividend yield greater than 4%.

40. Strong Management Efficiency

Return on equity > 20 AND Return on assets > 10 AND Return on capital employed > 15
This query lists stocks with strong management efficiency metrics: ROE greater than 20%, 
ROA greater than 10%, and ROCE greater than 15%.

41. Undervalued Stocks with Strong Balance Sheets

Price to book value < 1 AND Current ratio > 2 AND Debt to equity < 0.3

This query lists undervalued stocks with a price-to-book ratio less than 1, a current ratio 
greater than 2, and a debt-to-equity ratio less than 0.3.

42. High Growth Potential and Earnings Stability

Sales growth 3Years > 15 AND Net Profit growth 3Years > 15 AND Standard deviation of 
operating income < 10

This query lists stocks with sales and net profit growth rates greater than 15% over the last 
three years and low volatility in operating income.

43. High Efficiency and Low Cost Structure

Operating margin > 20 AND Gross profit margin > 30 AND Asset turnover ratio > 1.5

This query lists stocks with an operating margin greater than 20%, a gross profit margin greater
than 30%, and an asset turnover ratio greater than 1.5.

44. High Insider Buying

Insider buying last 6Months > 0
This query lists stocks with insider buying activity in the last six months, indicating confidence 
from company insiders.

45. High Free Cash Flow and Strong Profitability

Free cash flow > 50 AND Net Profit Margin > 15 AND ROCE > 20
This query lists stocks with free cash flow greater than ₹50 crore, a net profit margin greater 
than 15%, and a return on capital employed greater than 20%.
These advanced queries incorporate multiple financial metrics to help you identify stocks that 
meet specific, sophisticated investment criteria on Screener.in.

46. Low Debt with High Cash Flow Yield

Debt to equity < 0.5 AND Free cash flow yield > 8

This query lists stocks with a debt-to-equity ratio less than 0.5 and a free cash flow yield 
greater than 8%.

47. High Growth with Strong ROE and Low Valuation

Sales growth 3Years > 20 AND Return on equity > 25 AND P/E < 20

This query lists stocks with sales growth greater than 20% over the last three years, return on
equity greater than 25%, and a P/E ratio less than 20.

48. High Dividend Growth

Dividend growth 5Years > 10

This query lists stocks with a dividend growth rate greater than 10% over the last five years.

49. High Margin of Safety

Current price < Intrinsic value AND Margin of safety > 30

This query lists stocks trading below their intrinsic value with a margin of safety greater than 
30%.

50. High Piotroski F-Score and Low P/E

Piotroski score > 7 AND P/E < 15

This query lists stocks with a Piotroski F-Score greater than 7 and a P/E ratio less than 15.

51. High Interest Coverage and Low Debt

Interest Coverage Ratio > 10 AND Debt to equity < 0.3

This query lists stocks with an interest coverage ratio greater than 10 and a debt-to-equity 
ratio less than 0.3.

52. High Operating Cash Flow to Earnings

Operating cash flow / Net profit > 1.5

This query lists stocks where operating cash flow is more than 1.5 times the net profit, 
indicating high-quality earnings.

53. Low Enterprise Value to Sales

EV/Sales < 1

This query lists stocks with an enterprise value to sales ratio less than 1.

54. Consistent EBITDA Growth

EBITDA growth 5Years > 15

This query lists stocks with an EBITDA growth rate greater than 15% over the last five years.

55. High R&D to Sales Ratio

R&D to sales > 5

This query lists stocks where the research and development expenditure is greater than 5% 
of sales, indicating a focus on innovation.

56. Low Valuation with High ROIC

EV/EBIT < 10 AND Return on invested capital > 15

This query lists stocks with an enterprise value to EBIT ratio less than 10 and a return on 
invested capital greater than 15%.

57. High Cash Conversion Cycle Efficiency

Cash conversion cycle < 60

This query lists stocks with a cash conversion cycle of less than 60 days, indicating efficient 
working capital management.

58. Low Price to Research Ratio

Market Capitalization / R&D expenses < 10

This query lists stocks with a market capitalization to R&D expenses ratio less than 10.

59. High Free Cash Flow Conversion

Free cash flow / Net profit > 1

This query lists stocks where free cash flow is greater than net profit, indicating efficient cash 
flow management.

60. High EBIT Margin and Low P/S Ratio

EBIT margin > 15 AND P/S < 2

This query lists stocks with an EBIT margin greater than 15% and a price-to-sales ratio less 
than 2.

61. High Strategic Assets

Goodwill > 500

This query lists stocks with goodwill greater than ₹500 crore, indicating significant intangible 
assets.

62. High Accruals to Assets Ratio

Accruals to Assets < 0.1

This query lists stocks with an accruals to assets ratio less than 0.1, indicating low earnings 
manipulation.

63. Strong Buyback Yield

Buyback yield > 2

This query lists stocks with a buyback yield greater than 2%, indicating shareholder-friendly 
management.

64. High Asset Utilization

Asset turnover ratio > 2

This query lists stocks with an asset turnover ratio greater than 2, indicating efficient use of 
assets to generate revenue.

65. Low Price to Cash Flow

Price to cash flow < 10

This query lists stocks with a price-to-cash-flow ratio less than 10.

66. High Economic Moat

Economic moat = Wide

This query lists stocks with a wide economic moat, indicating sustainable competitive 
advantages.

67. High Green Energy Investment

Green energy investment / Total assets > 5

This query lists stocks where green energy investments constitute more than 5% of total 
assets, indicating a focus on sustainable practices.

68. Strong Capital Allocation

Reinvestment rate > 20 AND ROIC > 20

This query lists stocks with a reinvestment rate greater than 20% and a return on invested 
capital greater than 20%.

69. High Environmental, Social, and Governance (ESG) Score

ESG score > 70

This query lists stocks with an ESG score greater than 70, indicating strong environmental, 
social, and governance practices.

70. High Technology Adoption

Technology expenditure / Total assets > 5

This query lists stocks where technology expenditure constitutes more than 5% of total assets, 
indicating a focus on technological advancements.

These advanced queries provide a deeper and more nuanced approach to stock screening, 
allowing you to identify companies that meet specific, sophisticated investment criteria on 
Screener.in.