A query is a list of conditions joined by AND. The basic condition is metric, operator, number:
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 > 15means 15%, not 0.15. - Market Cap, Sales, Profit after tax, the latest-quarter figures and Debt are in $ millions:
Market Cap > 2000is $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 > 1000000000is $1 billion. - Size suffixes avoid the confusion:
k,M,B,T(andmn,bn,million,billion) are converted into the metric's own unit.Market Cap > 2BandFree Cash Flow > 1Bboth 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.