Help · Screener

Advanced queries: compare metrics, arithmetic, industry medians and OR

Beyond metric > number, a condition can compare two expressions. All of these are valid lines:

LineMeaning
ROE > ROAOne metric against another.
Market Cap / Sales < 2Arithmetic with + - * /. This one is price-to-sales computed from the two amounts.
(EPS growth + Sales growth) / 2 > 15Parentheses group as usual.
P/E < Industry P/EBelow the median P/E of the company's own industry.
ROE > Sector ROE * 1.2At least 20% above its sector's median ROE. Sector median ROE is also accepted.
Dividend Yield > 3 OR FCF Yield > 5Either condition.
(ROE > 20 OR ROCE > 20) AND P/E < 30OR inside parentheses, then AND with the next condition.
Sector = Technology OR Sector = HealthcareText metrics with OR.
Price > 52 Week Low * 1.5At least 50% above the 52-week low.
Total Cash > Total DebtMore cash than debt.

Rules

  • AND outside parentheses separates lines; OR binds inside a line. A OR B AND C is read as (A OR B) and C. Use parentheses whenever you mix them.
  • Units inside arithmetic are the metric's stored units (see units): Market Cap and Sales are both in $ millions, so Market Cap / Sales is a true ratio. Mixing a $-millions metric with a plain-dollar one (Free Cash Flow / Market Cap) is off by a factor of a million; a size suffix such as 2B on the number side is converted to the unit of the amounts it is compared with.
  • Industry and Sector medians exist for most numeric metrics that the database can compute directly; the metrics list marks them "peer median". Metrics without the mark, for example PEG, EPS, Sales and most growth figures (EPS growth is the exception), have no median. The median is taken over companies in the same industry (or sector) that report the metric.
  • Missing values: a comparison involving a missing value is false. Under AND the row is excluded; under OR the other branch can still match. Division by zero counts as missing.
  • Limits: up to 20 expression lines per query, 400 characters per line and 8 levels of nesting.

When a line cannot be read

The line is listed under the query with the reason (unknown metric, unbalanced parentheses, a text metric used with >, a metric with no peer median) and the rest of the query runs without it. Nothing is guessed silently.

Saved screens and their alerts use exactly the same rules; see saved screens.

More in Screener

All help articles · Data methodology · Contact

Data for information only, not investment advice. Figures may be delayed or inaccurate; verify against company filings. See our disclaimer.