Match counts verified 14 October 2026 against all 4,896 active US-listed tickers
Most screeners make you click through a dozen dropdowns. On DeltaScreener you type the whole screen on one line:
Market Cap > 10000 AND P/E < 20 AND Return on Equity > 15
That sentence returned 189 of 4,896 companies on 14 October 2026. Everything below is the full grammar, the units that catch people out, and six worked screens you can run as they are.
The grammar, in four rules
One condition per filter:metric operator value. Operators are ><>=<==.
Join with AND. Every condition must hold. There is no OR, and no bracketing.
Repeat a metric for a range:P/E > 0 AND P/E < 15.
Metric names are forgiving. Case, spacing and punctuation are normalised, so P/E, pe ratio and Price to Earnings all reach the same field. A name that matches nothing is skipped rather than failing the whole query, so check the result count against what you expected.
Units: the three that catch everyone
Millions of dollars: Market Cap, Sales, Profit after tax, Debt, and the "latest quarter" variants. Market Cap > 10000 means above $10 billion, not above ten thousand dollars.
Percentages as plain numbers: ROE, margins, growth and dividend yield. Dividend Yield > 4 means above 4%, not above 400%.
Unitless ratios: P/E, P/B, debt-to-equity, current ratio, interest coverage. Debt to Equity < 0.5 is half a turn of equity.
Six worked screens
Example 1
Large companies on a modest earnings multiple that also earn well on equity
Market Cap > 10000 AND P/E < 20 AND Return on Equity > 15
Reads as: Market cap above $10B, trailing P/E below 20, return on equity above 15%.
Matched 189 of 4,896 companies on 14 October 2026. The count changes as prices and filings do.
Market Cap is entered in millions, so 10000 means $10 billion. This is the single most common mistake with this field.
Matched 92 of 4,896 companies on 14 October 2026. The count changes as prices and filings do.
Sector takes a text value and matches the stored sector name, so "Technology" works and "Tech" does not. There is no size floor in this query, so micro-caps are included.
Higher-yielding companies that genuinely carry little debt
Dividend Yield > 4 AND Debt to Equity > 0 AND Debt to Equity < 0.5 AND Market Cap > 2000
Reads as: Dividend yield above 4%, debt-to-equity between 0 and 0.5, market cap above $2B.
Matched 41 of 4,896 companies on 14 October 2026. The count changes as prices and filings do.
The "> 0" half is doing real work. Without it the same query returned 51 companies on 14 October 2026, 10 of which had negative shareholders equity — a negative debt-to-equity satisfies any "less than" test while describing more leverage, not less.
A missing field excludes the company. Conditions are not "unknown counts as a pass". Adding a payout-ratio filter to any query cuts the result set to a small fraction of the market, because payout ratio was reported for only 364 of the 4,896 companies on 14 October 2026. Per-field coverage for every metric is published on the methodology page.
Negative values satisfy "less than". Debt-to-equity goes negative when shareholders equity is negative, and P/E is stored as not available rather than negative for exactly this reason. Guard the lower bound: write Debt to Equity > 0 AND Debt to Equity < 0.5, and P/E > 0 AND P/E < 15.
Every metric you can name
Size and price
Market Cap (in $ millions)PriceVolumeAverage Volume52 Week High52 Week LowChange %BetaEnterprise Value
Valuation
P/EP/BP/SPEG RatioEV/EBITDAEV/SalesPrice to Free Cash FlowP/OCFEarnings YieldBook Value Per Share
Dividend YieldPayout RatioEPSSalesProfit after taxSales latest quarterPAT latest quarterSector
Sector takes a text value and must match a stored sector name exactly: Technology, Healthcare, Financial Services, Industrials, Consumer Cyclical, Consumer Defensive, Basic Materials, Energy, Communication Services, Real Estate or Utilities. Company counts and median figures for each are on the US market statistics page.
Ratios that do not exist yet
If the ratio you want is not in the list above, you can define it. A saved custom ratio is a named formula over existing metrics — for example Quality Score = ROE / Debt to Equity — and once saved, the name itself becomes usable in a query: Quality Score > 30 AND Market Cap > 1000.
Two things are worth knowing before you build one. A saved formula is reloaded from its definition and recompiled on the server for every run, so the query you share only ever carries the ratio's name. And because a formula cannot be translated into a database query, it is evaluated across a 2,000-row working set rather than all 4,896 rows — put a market-cap or sector condition alongside it so the working set covers the part of the market you care about. Saved formulas are a paid feature; see what is included.
Frequently Asked Questions
How do I write a stock screen in plain English?
Write one condition per filter in the form "metric operator value", and join them with AND. For example: Market Cap > 10000 AND P/E < 20 AND Return on Equity > 15. Metric names are matched loosely, so P/E, PE Ratio and Price to Earnings all resolve to the same field. The operators are >, <, >=, <= and =.
Why does Market Cap > 10000 not mean ten thousand dollars?
Market Cap, Sales, Profit after tax and Debt are entered in millions of dollars. Market Cap > 10000 therefore means a market capitalisation above $10 billion. Price, EPS and Book Value Per Share are in plain dollars, and ratios such as P/E and debt-to-equity are unitless.
Can I use OR in a query?
No. Conditions are joined with AND only, and every condition must hold. To express a range on one metric, repeat it with two operators — for example P/E > 0 AND P/E < 15.
What happens to companies that do not report a metric I filtered on?
They are excluded. A filter on a sparsely reported field therefore removes far more companies than the threshold alone suggests. Payout ratio, for instance, was present on only 364 of the 4,896 companies in the database on 14 October 2026. Per-field coverage is published on the methodology page.
Can I screen on a ratio that does not exist as a built-in field?
Yes, by saving a custom ratio — a named formula over existing metrics, such as Quality Score = ROE / Debt to Equity — and then using that name in a query like Quality Score > 30 AND Market Cap > 1000. Saved formulas are a paid feature. They are recompiled from the saved definition on the server for every run, and because they cannot be pushed down into the database query they are evaluated across a 2,000-row working set rather than the full universe.
Start from a screen that already works
Every prebuilt screen prints its own query, so you can open one, read the sentence and edit it. How to build a stock screen walks through choosing the filters in the first place.
The example screens are illustrations of the query language, not suggestions about any company. Matching a filter says only that a reported figure crossed a threshold on a given date. See the disclaimer.