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'. Use tag = '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) or metric[-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