Screen DSL Help
Basics
- Write boolean expressions in the WHERE box.
- Use comparisons: =, !=, >, >=, <, <=
- Combine with logical operators: and, or, not
- Group with parentheses: ( ... )
- Refer to metrics by name (see list below).
- Example:
close > 50 and volume_sma_20 > 2_000_000
Tag Filtering
- Filter by tags using:
tag = 'tagname'
- Filter by multiple tags:
tag IN ('tag1', 'tag2')
- Only accessible tags (global or your own) will work
- Built-in watchlist is a tag named
'watchlist'
. Usetag = 'watchlist'
to filter to starred symbols. You can toggle the star on any card or on the detail page. - Tag names are case-insensitive but must be quoted with single quotes in expressions.
- Example:
tag = 'sp500' and rsi_14 < 30
- Example:
tag IN ('tech', 'healthcare') and close > 100
Functions
lag(metric, k)
ormetric[-k]
— value from k rows back (past only, k ≥ 1). Example:close > lag(close, 1)
max(metric, n)
— rolling maximum over the previous n rows (excluding current). Example:close > max(close, 200)
matches new 200‑day highs.min(metric, n)
— rolling minimum over the previous n rows (excluding current). Example:low < min(low, 20)
matches new 20‑day lows.- Tip: to include ties with the prior max/min (i.e., when the current value equals the previous extreme), use
>=
or<=
accordingly. - Limits: window sizes are capped by system configuration (default 100). Larger values will be rejected.
Available Metrics
Loading…
Save Screen
Used on initial create. Not editable when overwriting.
Limit
Date
— ▼
Price
$0 – $0 ▼
Volume
— ▼
Editing:
SQL Preview
Loading…