Help · Screener

Writing screener queries

A query is a list of conditions joined by AND. The basic condition is metric, operator, number:

P/E < 20 AND ROE > 15 AND Market Cap > 10B

Run this query. Conditions can sit on separate lines as long as AND stands between them. Upper and lower case do not matter.

Operators

> >= < <= = work on every line. != (not equal) works in expressions and on text metrics such as Sector != Utilities.

Metric names

Use any name from the metrics list. Common shorthand is understood: pe, p/e ratio, mcap, d/e, roe, div yield, 3 year sales growth. When a short name could mean more than one metric, the Running: line says how it was read: margin is read as Net Margin, yield as Dividend Yield, growth as Sales growth. If a name is not recognised, the screener suggests the closest real metric ("Did you mean …?").

Units

  • Percentages are plain numbers: ROE > 15 means 15%, not 0.15.
  • Market Cap, Sales, Profit after tax, the latest-quarter figures and Debt are in $ millions: Market Cap > 2000 is $2 billion.
  • Enterprise Value, EBITDA, Free Cash Flow, Operating Cash Flow, Total Debt, Total Cash and Net Debt are in plain dollars: Free Cash Flow > 1000000000 is $1 billion.
  • Size suffixes avoid the confusion: k, M, B, T (and mn, bn, million, billion) are converted into the metric's own unit. Market Cap > 2B and Free Cash Flow > 1B both mean what they say.

A number that is almost certainly in the wrong unit (for example Market Cap > 2000000000, which would be $2,000 trillion) still runs as typed, but the Running line flags it.

Text metrics

Sector, Country and Exchange take a name instead of a number: Sector = Technology, Exchange = NASDAQ, Country = US. Matching ignores case.

Custom ratios (Pro)

Pro accounts can save a named formula and use it like a built-in metric on its own line, e.g. Quality Score > 30. A custom ratio cannot be used inside an arithmetic expression yet.

Missing values

A company with no value for a metric never passes a condition on that metric. Adding a filter on a sparsely reported field (payout ratio, EV/EBITDA) therefore removes more rows than its threshold suggests. Coverage per field is published on the methodology page.

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.