gsEasyScript v1.4

Returns the most recent closing price of each ticker.

LastClose() > 10
LastClose() < 500

Percentage change of the last closed candle vs the previous one.

LastPercClose("d") > 3
LastPercClose("d") > 5 OR LastPercClose("d") < -5

Percentage change of the last closed candle vs the previous one. Equivalent to ChangePerc(1, tf) but more readable and optimised for single-bar queries (requires only 2 candles of history).

// Last daily candle up more than 3%
LastPercClose("d") > 3

// Strong move in either direction (big candle scanner)
LastPercClose("d") > 5 OR LastPercClose("d") < -5

// Volume explosion + positive last candle
LastPercClose("d") > 1.5
VolumeProfile(20, "d") > 80

// Weekly candle strong close
LastPercClose("w") > 2

Closing price N bars ago. Close(1,"d") = yesterday's close.

Average closing price over the last N bars.

Checks whether candle N is green (close ≥ open) or red. candleNumber = 1 = most recent.

CandleType(1, "d", "green")
CandleType(2, "d", "red")

Distance in % from the all-time high. Always negative or zero. Alias: DistancePercFromAllTimeMax().

DistancePercFromAllTimeHigh() > -10  // within 10% of ATH
DistancePercFromAllTimeHigh() < -50  // more than 50% below ATH

Distance in % from the all-time low. Always positive or zero. Alias: DistancePercFromAllTimeMin().

Filters tickers whose last candle closed in the upper (strong) or lower (weak) portion of its H-L range.

EvaluateIfStrongClose(75, "d")  // closed in upper 25%
EvaluateIfWeakClose(30, "d")   // closed in lower 30%

Percentage change in volume over the last N bars.

VolumeChangePerc(5, "d") > 50

Compares latest volume to the N-bar average. Returns % difference.

VolumeChangeVsAvg(20, "d") > 100   // double the average
VolumeChangeVsAvg(20, "d") < -30  // quiet consolidation

Similar to VolumeChangeVsAvg but adjusts for time of day (intraday volume explosion detection).

Average daily traded value in USD (price × volume). Essential for liquidity filtering.

AvgCounterValue(20, "d") > 500000    // minimum €500k liquidity
AvgCounterValue(20, "d") > 5000000   // large-cap filter

Volume percentile rank (0–100) of the current bar vs the last N bars. 80 = today's volume is higher than 80% of recent sessions.

VolumeProfile(30, "d") > 80  // top 20% — volume explosion
VolumeProfile(20, "d") < 30  // bottom 30% — silent consolidation

% distance of close from the Simple Moving Average. Positive = above SMA.

DistancePercFromSMA(200, "d") > 0   // above 200-day SMA
DistancePercFromSMA(50, "d") > -3
DistancePercFromSMA(50, "d") < 3    // pullback to 50-day SMA

Same as DistancePercFromSMA but uses an Exponential Moving Average. Alias: DistPercFromEMA.

Detects when the price crosses above or below a given EMA/SMA on the most recent two bars.

CrossEMA(50, "d", "up")    // price just crossed above EMA50
CrossSMA(200, "d", "down") // price just crossed below SMA200

Golden Cross ("up") or Death Cross ("down") between two EMAs.

CrossEMAEMA(20, 50, "d", "up")    // Golden cross EMA20/EMA50
CrossEMAEMA(50, 200, "w", "down") // Death cross EMA50/EMA200 weekly

Slope of the EMA via linear regression on the last 5 EMA values, expressed as % per bar. Positive = rising EMA.

EMASlope(50, "d") > 0       // EMA50 is rising
EMASlope(20, "d") > 0.05    // aggressively rising EMA20

Same as EMASlope but using the Simple Moving Average. Linear regression on the last 5 SMA values, result as % per bar.

SMASlope(20, "d") > 0      // SMA20 rising
SMASlope(50, "d") > 0.05   // SMA50 accelerating upward
SMASlope(200, "d") < 0    // long-term trend turning down

True if the price crossed the EMA within the last bars bars. Unlike CrossEMA which only checks the very last bar, this function catches fresh crossovers that occurred a few bars ago — avoiding missed signals.

CrossedEMAWithin(20, "d", "Up", 5) = 1    // crossed EMA20 upward in last 5 days
CrossedEMAWithin(50, "w", "Down", 3) = 1  // crossed EMA50 downward in last 3 weeks

// Fresh EMA cross + volume confirmation
CrossedEMAWithin(20, "d", "Up", 5) = 1
VolumeChangeVsAvg(20, "d") > 50

True if the fast EMA crossed the slow EMA (Golden/Death Cross) within the last bars bars. Catches fresh crossovers that may have occurred 1–N bars ago.

CrossedEMAEMAWithin(20, 50, "d", "Up", 10) = 1    // golden cross in last 10 days
CrossedEMAEMAWithin(50, 200, "d", "Down", 5) = 1  // death cross in last 5 days
CrossedEMAEMAWithin(12, 26, "d", "Up", 3) = 1     // MACD-EMA cross in last 3 days

Relative Strength Index (0–100). Below 30 = oversold; above 70 = overbought. Wilder smoothing via Skender library.

RSI(14, "d") < 30   // oversold
RSI(14, "d") > 45
RSI(14, "d") < 65   // momentum zone
RSI(14, "d") < 30 OR Stochastic(14,3,"d") < 20

Three functions for the three MACD components. Standard parameters: fast=12, slow=26, signal=9.

MACD(12, 26, 9, "d") > 0           // MACD above zero
MACDHistogram(12, 26, 9, "d") > 0  // histogram positive (bullish cross)

Position within Bollinger Bands: 0 = lower band, 100 = upper band, 50 = middle SMA.

BollingerPosition(20, 2, "d") < 15  // near lower band
BollingerPosition(20, 2, "d") > 85  // near upper band

Band width as % of SMA: (Upper − Lower) / SMA × 100. Low = squeeze; high = volatility.

BollingerWidth(20, 2, "d") < 8   // tight squeeze
BollingerWidth(20, 2, "d") > 20  // high volatility regime

Average True Range — absolute price range in ticker currency. Also adds ATR% column.

ATR expressed as a percentage of the current close: ATR / Close × 100. More useful than raw ATR for comparing volatility across instruments at different price levels.

ATRPerc(14, "d") > 1.5   // at least 1.5% daily range — enough movement
ATRPerc(14, "d") < 5     // not too wild
ATRPerc(14, "d") > 2     // combined: 2–5% sweet spot for swing trading
ATRPerc(14, "d") < 5

Stochastic = %K line; StochasticD = %D smoothed. Both 0–100.

Rate of Change — % price change over N periods via Skender library.

Relative strength vs a benchmark. Value above 1.0 = outperforming.

RelativeStrength(63, "d", "^GSPC") > 1.0

% price change from N bars ago to today.

ChangePerc(63, "d") > 10   // +10% over 3 months
ChangePerc(13, "w") > 8    // +8% over 1 quarter weekly

YTD, MTD and WTD returns. No parameters.

Annualised standard deviation of log returns over N periods (%).

Average High−Low range per candle from the DB intra_volatility field.

Linear regression slope of closing prices over N bars, as % per bar. More robust than a single-bar change.

MomentumSlope(20, "d") > 0.3  // steady upward drift
MomentumSlope(20, "d") > 0    // any positive slope

Ratio of short-term vs long-term momentum (period-normalised). Value > 1 = accelerating.

ChangePercAcceleration(5, 20, "d") > 1   // short-term faster than long-term

Counts consecutive same-colour candles ending at the most recent bar.

ConsecutiveCandles(3, "red", "d") = 3   // exactly 3 red candles
ConsecutiveCandles(4, "green", "d") >= 4

Detects a gap between today's open and the previous close of at least minPercGap%.

Last candle fully contained within the previous candle's range. Classic consolidation signal.

Classic NR-N pattern: last candle has the narrowest range among the last nrBars over a lookback window.

NarrowRangeBar(7, 20, "d")  // classic NR7

Verifies that the last N swing highs (or lows) are progressively higher (or lower). Requires ~N×10 bars of history.

HigherHighs(3, "d")  // 3 rising swing highs
LowerLows(3, "d")   // 3 falling swing lows

Returns the highest High (or lowest Low) value over the last N bars. Useful for absolute price-level filters and breakout reference points.

HighestHigh(52, "w") > 100   // 52-week high above 100
LowestLow(20, "d") > 10    // 20-day low still above 10
HighestHigh(20, "d") < 500  // price cap filter

Distance in % from the highest High of the last N bars. Negative when below the high (the normal case). Use to find stocks near N-period highs.

DistancePercFromHigh(20, "d") > -5   // within 5% of 20-day high — momentum
DistancePercFromHigh(52, "w") > -10  // within 10% of 52-week high
DistancePercFromHigh(20, "d") < -20  // more than 20% off high — deep pullback

Distance in % from the lowest Low of the last N bars. Positive when above the low. Use to find stocks bouncing from N-period lows.

DistancePercFromLow(20, "d") < 10   // within 10% of 20-day low — reversal zone
DistancePercFromLow(52, "w") < 15  // near 52-week low — potential bottom fishing

True (1) if the current close exceeds the highest High (or is below the lowest Low) of the previous N bars, excluding the current bar itself. Classic breakout/breakdown signal.

BreakoutHigh(20, "d") == 1   // 20-day breakout — Donchian-style
BreakdownLow(52, "w") == 1   // 52-week breakdown — weakness signal

// Breakout with volume confirmation
BreakoutHigh(20, "d") == 1
VolumeChangeVsAvg(20, "d") > 50
RSI(14, "d") > 50

A family of functions that expose the individual parts of the most recent candle. All take only timeframe as parameter.

// Hammer candle: small body, large lower wick, small upper wick
BodySize("d") < 1
LowerWick("d") > 2
UpperWick("d") < 0.5
IsBullishCandle("d") == 1

// Wide range bullish day
Range("d") > 3
IsBullishCandle("d") == 1
VolumeChangeVsAvg(20, "d") > 80

Returns true if the current price is within threshold% of any manually-drawn study (trendlines, horizontal lines, Fibonacci retracements) that is active on the chart for that ticker. Studies are drawn by the user in the gsStockAnalyzer chart panel and saved to the database.

// Any manual study within 2% (default)
PriceNearManualStudy()

// Tighter threshold: within 1%
PriceNearManualStudy(1.0)

// Only fibonacci studies, within 2%
PriceNearManualStudy(2.0, "fibonacci")

// Only trendlines, within 1.5%
PriceNearManualStudy(1.5, "trendline")

Returns true if the current price is within threshold% of a manually-drawn trendline. The trendline value is computed via linear interpolation of its two anchor points, projected to today's date — so inclined trendlines are properly supported.

value = price₁ + (today − date₁) / (date₂ − date₁) × (price₂ − price₁)

// Price within 2% of any manual trendline (default)
PriceNearTrendline()

// Tighter: within 1.5%
PriceNearTrendline(1.5)

// Trendline proximity + uptrend context
PriceNearTrendline(2.0)
IsUpTrend(30, "d")
RSI(14, "d") < 50

Returns true if the current price is within threshold% of a level from a manually-drawn Fibonacci retracement on the chart. Supports all standard levels. Optionally filter to a specific level (e.g. "61.8%").

// Near any Fibonacci level within 2%
PriceNearFibonacci()

// Near 61.8% (Golden Ratio) within 1.5%
PriceNearFibonacci(1.5, "61.8%")

// Near 50% level within 2%
PriceNearFibonacci(2.0, "50%")

// Near 38.2% with RSI oversold — classic bounce setup
PriceNearFibonacci(2.0, "38.2%")
RSI(14, "d") < 45

Returns true if the price has crossed a manually-drawn trendline in the last candle. The engine checks whether the close was on one side of the trendline yesterday and on the opposite side today (both bullish breakout ↑ and bearish breakdown ↓ are detected).

// Any trendline breakout, default tolerance 0.5%
TrendlineBreakout()

// Tighter confirmation: must cross by at least 1%
TrendlineBreakout(1.0)

// Trendline breakout + volume confirmation
TrendlineBreakout()
VolumeChangeVsAvg(20, "d") > 30

// Breakout + RSI exiting oversold — strong reversal signal
TrendlineBreakout()
RSI(14, "d") > 30
RSI(14, "d") < 55

Price within distPerc% of a manually specified level.

Price within distPerc% of any saved level in tickers_pivot_point.

Delta: ChangePerc(ticker) − ChangePerc(benchmark). Positive = outperforming.

RelativePerformance(63, "d", "^GSPC") > 5

Returns true if the ticker is in a confirmed uptrend over the last N bars. No comparison operator needed — it's a boolean filter.

// Uptrend over the last 30 daily bars
IsUpTrend(30, "d")

// Uptrend over the last 52 weekly bars (1 year)
IsUpTrend(52, "w")

// Multi-timeframe: confirmed uptrend on both daily and weekly
IsUpTrend(30, "d")
IsUpTrend(52, "w")

// Combine with RSI for a pullback entry in an uptrend
IsUpTrend(63, "d")
RSI(14, "d") < 45
AvgCounterValue(20, "d") > 500000

Returns true if the ticker is in a confirmed downtrend over the last N bars. Uses the same three-criteria engine as IsUpTrend but with inverted conditions (negative slope, price below EMA, R² ≥ 0.3).

// Downtrend over the last 30 daily bars
IsDownTrend(30, "d")

// Quarterly downtrend on weekly chart (13 weeks = 3 months)
IsDownTrend(13, "w")

// Downtrend with volume surge — possible capitulation / short squeeze
IsDownTrend(30, "d")
VolumeProfile(20, "d") > 90
CandleType(1, "d", "green")

// Find stocks to avoid: weekly downtrend AND daily downtrend
IsDownTrend(26, "w")
IsDownTrend(30, "d")

Checks whether the ticker was in an uptrend (or downtrend) N bars ago, using the same three-criteria engine as IsUpTrend/IsDownTrend. Designed for pullback and reversal strategies: first confirm a prior trend, then apply current-state filters.

// Was in uptrend 10 days ago, now pulling back — classic re-entry setup
WasUpTrend(30, "d", 10) == 1
RSI(14, "d") < 45
DistancePercFromHigh(20, "d") < -5   // has pulled back at least 5%
DistancePercFromHigh(20, "d") > -15  // but not more than 15%

// Was in downtrend, now showing recovery signs
WasDownTrend(20, "d", 5) == 1
IsUpTrend(10, "d")              // trend has now turned up
VolumeProfile(20, "d") > 80    // high volume on the reversal

WasUpTrend(30, "d", 15) == 1  // was up 15 days ago
IsDownTrend(10, "d")           // now confirmed down — trend broken

Finds a recent, still-valid trendline that may be useful for a trading setup. The detector searches for support through recent lows, resistance through recent highs, or both when using closing prices.

Unlike IsUpTrend/IsDownTrend, this function projects the detected line to the current bar and keeps the ticker only when the current close is near that projected level.

// Recent support: at least 3 touches, last touch within 15 bars
LookForTrendline("Low", "d", 100, 3, 15, 1.5) > 70

// Recent resistance on weekly highs
LookForTrendline("High", "w", 52, 3, 8, 2.0) > 65

// Either support or resistance near the current close
LookForTrendline("Close", "d", 80, 3, 10, 2.0) > 70

// Trading setup: recent support plus a bullish candle
LookForTrendline("Low", "d", 120, 3, 12, 1.5) > 75
IsBullishCandle("d") == 1
RSI(14, "d") < 55

Finds an actionable price channel near the current bar by fitting a support line on recent lows and a resistance line on recent highs. The detector keeps only channels that are still valid, reasonably parallel, and close enough to current price to matter for a trade setup.

// Any valid channel near current price
LookForChannel("d", 120, 3, 20, 1.5, 18) > 65

// Rising channel only
LookForRisingChannel("d", 120, 3, 20, 1.5, 18) > 70

// Horizontal channel on weekly bars
LookForHorizontalChannel("w", 52, 3, 12, 2.0, 15) > 65

FILTER Keeps only tickers whose current price is within tolerance% of a Fibonacci retracement level detected from a meaningful recent swing.

FiboNearLevel(63, "d", 61.8, 2)   // near Golden Ratio ±2%
FiboNearLevel(52, "w", 38.2, 2)   // weekly 38.2% level

Finds an actionable Fibonacci retracement setup around a significant recent swing and returns a quality score. Unlike FiboNearLevel, this function is meant to rank the setup, not just confirm proximity.

LookForBullishFibonacci keeps low-to-high swings followed by a pullback; LookForBearishFibonacci keeps high-to-low swings followed by a rebound.

// About 3 months of daily data
LookForFibonacci(63, "d", 61.8, 2) > 60

// Better when you want a more important daily swing (about 6 months)
IsUpTrend(60, "d")
LookForBullishFibonacci(126, "d", 61.8, 1.5) > 65

// Weekly bearish retracement into resistance
LookForBearishFibonacci(52, "w", 61.8, 2.5) > 58

EXPLORE Does not filter — shows nearest Fibonacci level, distance, 0–100% position in the swing range.

Distance in % from a Fibonacci level. Consider using FiboNearLevel for new scripts.

Last candle has a very small body relative to its total range (body < 10% of range). Signals indecision. Combine with BollingerPosition or RSI at extremes for reversal setups.

IsDoji("d") == 1
BollingerPosition(20, 2, "d") > 80

IsHammer: small body in upper half of range, long lower wick (≥ 2× body). Bullish reversal signal after a downtrend.
IsShootingStar: same shape inverted — long upper wick. Bearish reversal after an uptrend.

// Hammer on support
IsHammer("d") == 1
DistancePercFromEMA(50, "d") > -3

The body of the last candle completely engulfs the body of the previous candle. One of the most reliable two-candle reversal signals.

// Bullish engulfing on EMA support
IsBullishEngulfing("d") == 1
DistancePercFromEMA(200, "d") > -3

3-candle patterns. Morning Star: bearish candle + small indecision candle + bullish candle closing above midpoint of first. Stronger than single-candle signals.
Evening Star: the bearish mirror pattern.

IsMorningStar("w") == 1
RSI(14, "w") < 40

3 consecutive bullish (or bearish) candles, each opening within the previous body and closing higher (or lower). Strong continuation signal after a breakout.

IsThreeWhiteSoldiers("d") == 1
VolumeChangeVsAvg(20, "d") > 20

A candle where the body occupies ≥ 95% of the total range (almost no wicks). Signals strong conviction in the direction of the move.

A small candle whose body is contained within the body of the previous (opposite-color) candle. Weaker than Engulfing but still a valid reversal hint.

Two-candle reversal patterns: Piercing Line is the bullish version after a bearish candle; Dark Cloud Cover is its bearish mirror. The second candle must close beyond the midpoint of the first body.

Tweezer patterns use near-equal lows/highs with opposite candle direction. Outside Bar is a full range expansion beyond the preceding candle. NR7 flags the narrowest range of the latest seven bars, a useful volatility-compression alert. IsBullishPinBar / IsBearishPinBar are directional hammer/shooting-star variants; IsGapUp, IsGapDown and IsGapFilled identify material overnight gaps and fills.

Detects continuation flags: a strong directional pole followed by a controlled pullback channel. The current detector now prefers the best valid setup in the recent window instead of the first one found, and scores the pattern using pole strength, pullback depth, channel geometry, volume contraction, and current distance from the breakout line.

LookForBullFlag keeps bullish continuation setups only; LookForBearFlag keeps bearish ones.

// Any continuation flag near breakout
LookForFlag(80, "d") > 60

// Bull flag for second-leg momentum entries
IsNotPriceLocked(20, "d") == 1
AvgCounterValue(20, "d") > 500000
IsUpTrend(30, "d")
LookForBullFlag(80, "d") > 68
VolumeChangeVsAvg(20, "d") > 0

// Weekly bear flag
LookForBearFlag(52, "w") > 65

Detects bullish parabolic runs: price is not just trending up, but accelerating. The detector compares the first half of the move against the second half, checks whether a quadratic curve fits the price action better than a straight line, and keeps only setups that remain tight near the highs.

// Fast daily momentum leaders
IsNotPriceLocked(20, "d") == 1
AvgCounterValue(20, "d") > 500000
LookForParabolicRun(60, "d") > 62

// Weekly leaders that are still close to the highs
LookForParabolicRun(40, "w") > 68

Detects rounded reversal structures: a rounded bottom is a U-shaped base where price stabilizes, bottoms out, and then recovers toward the right rim; a rounded top is the bearish mirror image, where the advance loses momentum and rolls over gradually instead of failing in a sharp spike.

// Rounded accumulation base close to the right rim breakout
LookForRoundedBottom(90, "d") > 62

// Weekly rounded bottom inside a larger uptrend
IsUpTrend(40, "w")
LookForRoundedBottom(52, "w") > 68

// Rounded distribution / topping scan
LookForRoundedTop(80, "d") > 60
RSI(14, "d") > 55

Detects converging wedges: both support and resistance move in the same direction, but one side advances faster so the structure compresses toward an apex. LookForWedge returns any valid wedge; the directional variants filter the geometry.

// Any wedge nearing decision point
LookForWedge(80, "d") > 58

// Falling wedge inside a broader uptrend
IsUpTrend(40, "d")
LookForFallingWedge(90, "d") > 62

// Rising wedge as an exhaustion / breakdown watchlist
LookForRisingWedge(70, "d") > 60

Classic double-top (bearish reversal) and double-bottom (bullish reversal). Returns a quality score based on peak symmetry, depth of the middle valley/peak, and timing between the two extremes.

// Double bottom + recovery
LookForDoubleBottom(200, "d") > 50
IsUpTrend(20, "d")

Detects a rounded cup followed by a shallow, contracting handle. The inverted version is the bearish mirror. Both return a 0–100 quality score and expose breakout/support, width, volume ratio and pattern length as AdvancedPattern* result data.

LookForCupWithHandle(100, "d") > 60

Advanced compression, base and reversal detectors. LookForVCP (also LookForVolatilityContraction) requires progressively narrower ranges and contracting volume. Rectangle/FlatBase/DarvasBox identify tight horizontal bases; TripleTop/Bottom identify three aligned pivots; Broadening identifies a megaphone structure. All return a 0–100 quality score.

// Tight VCP close to a breakout
LookForVCP(60, "d") > 65

// A high-quality flat base
LookForFlatBase(40, "d") > 60

Detects both classic bearish Head & Shoulders tops and bullish Inverse Head & Shoulders bottoms. The score reflects shoulder symmetry, how clearly the head stands out, the time balance between left/right side, and the neckline structure. Clicking a scanner result can open chart.html with the shoulders/head profile and neckline already drawn.

• LookForHeadAndShoulders finds the bearish top-reversal version.
• LookForInverseHS finds the bullish bottom-reversal version.
• LookForInverseHeadAndShoulders is an alias of LookForInverseHS.

// Inverse H&S with RSI confirmation
LookForInverseHS(120, "d") > 55
RSI(14, "d") > 50

HsQuality
HsType
HsStrength
HsNeckline
HsTargetPrice
HsLeftShoulder / HsHead / HsRightShoulder
HsLeftNeckline / HsRightNeckline
HsLeftShoulderBarsAgo / HsHeadBarsAgo / HsRightShoulderBarsAgo
HsLeftNecklineBarsAgo / HsRightNecklineBarsAgo
HsLeftShoulderDate / HsHeadDate / HsRightShoulderDate
HsLeftNecklineDate / HsRightNecklineDate
HsTimeframe

Ascending triangle: flat resistance + rising support lows. Bullish continuation. Returns quality score based on R² of trendlines and number of touch points.

Descending triangle: flat support + declining highs. Bearish continuation or breakdown setup.

LookForDescendingTriangle(60, "d") > 50
RSI(14, "d") < 50

Symmetric triangle: converging highs and lows with no directional bias. Indicates a compression before a breakout. Use with DaysToConvergence logic to catch imminent breakouts.

// Symmetric triangle + squeeze
LookForSymmetricTriangle(60, "d") > 55
BollingerWidth(20, 2, "d") < 5

Any triangle breakout. Set showOnlyBreakout to true for confirmed breakouts only.

Rising trendline connecting at least 2 swing lows.

Detects tickers with frozen prices — typically caused by OPA (takeover bid), delisting, or trading suspension. The function calculates the (max − min) / min × 100 range of closing prices over the last period sessions.

• IsNotPriceLocked(20, "d") == 1 — passes only tickers with a price range > 0.5% over 20 days. Recommended as the first filter in every scanner.
• IsPriceLocked(20, "d") < 0.5 — shows only locked tickers (range < 0.5%).
• IsPriceLocked(20, "d") > 1.0 — equivalent to IsNotPriceLocked with custom threshold.

// Always put this first to skip OPA/delisted tickers
IsNotPriceLocked(20, "d") == 1
AvgCounterValue(20, "d") > 500000
LookForBullFlag(80, "d") > 60

Reloads the ticker list using a SQL WHERE clause on the tickers table. Use as the first line to define your universe.

FilterTickers(country = 'IT')
FilterTickers(type = 'COMM')
FilterTickers(watchlist LIKE '%MyWatchlist%')
FilterTickers(exchange = 'XETRA' AND type = 'STOCK')

Fetches a fundamental metric from the DB. Use 0 for year/quarter to get the most recent value.

QuantMetric(pe_ratio, 0, 0) < 15
QuantMetric(market_cap, 0, 0) > 1000000000

Writes a text signal to the signals table for all tickers in the current result set.

Appends a label to tickers.filters for every surviving ticker. Additive — never overwrites existing values.

Writes value to a column of the tickers table for every surviving ticker. Overwrites the existing value.

SetTickerField("notes", "Breakout candidate Apr26")
SetTickerField("watchlist", "MyPortfolio")

Appends a watchlist name to tickers.watchlist (or watchlist_user) for every surviving ticker. Additive — existing watchlists are preserved. Skips tickers where the name already exists.

AddToWatchlist("Breakout")
AddToWatchlist("MyFavourites", "user")

Removes the specified watchlist name from tickers.watchlist (or watchlist_user) for every surviving ticker. Other watchlists on the same ticker are preserved.

// Remove downtrend tickers from watchlist
IsDownTrend(30, "d")
RemoveFromWatchlist("Breakout")

Returns the number of calendar days elapsed since the last available quote bar for the given timeframe. Use this function to exclude tickers whose price data is not up to date — for example, stale feeds, suspended instruments, or exotic markets with irregular trading calendars.

A low value means fresh data. A high value means the last quote is old. The function reads only the most recent bar (limit = 3), so it is very fast and ideal as a first filter to quickly shrink the universe.

// Strict: only tickers updated in the last 3 calendar days
QuoteAge("d") < 3

// Recommended: covers weekends and single holidays
QuoteAge("d") < 5

// Weekly timeframe — accept up to 2 weeks old
QuoteAge("w") < 14

// Combine with IsPriceLocked for maximum data-quality pre-filtering
QuoteAge("d") < 5
IsNotPriceLocked(20, "d") == 1