Beyond metric > number, a condition can compare two expressions. All of these are valid lines:
| Line | Meaning |
|---|---|
ROE > ROA | One metric against another. |
Market Cap / Sales < 2 | Arithmetic with + - * /. This one is price-to-sales computed from the two amounts. |
(EPS growth + Sales growth) / 2 > 15 | Parentheses group as usual. |
P/E < Industry P/E | Below the median P/E of the company's own industry. |
ROE > Sector ROE * 1.2 | At least 20% above its sector's median ROE. Sector median ROE is also accepted. |
Dividend Yield > 3 OR FCF Yield > 5 | Either condition. |
(ROE > 20 OR ROCE > 20) AND P/E < 30 | OR inside parentheses, then AND with the next condition. |
Sector = Technology OR Sector = Healthcare | Text metrics with OR. |
Price > 52 Week Low * 1.5 | At least 50% above the 52-week low. |
Total Cash > Total Debt | More cash than debt. |
Rules
- AND outside parentheses separates lines; OR binds inside a line.
A OR B AND Cis read as(A OR B)andC. 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 / Salesis 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 as2Bon 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.