StockVyze

What Are Formulas?

SKIF formulas are expressions for stock analysis. Use them when the visual condition builder is not enough. A formula can define:

A condition: which stocks to include.
A calculated column: which value to display for each stock.

One formula contains one expression.

Quick Wins

Oversold:

rsi(14) < 30

Uptrend with liquidity:

c > sma(c, 50) and v > 1M

Large caps with positive momentum:

f.market_cap > 10B and rsi(14) > 50

SKIF expressions do not support comments. Put notes outside the formula; # is part of trailing-window syntax, not a comment marker.

Basic Building Blocks

Candle fields

c or close — Close price
o or open — Open price
h or high — High price
l or low — Low price
v or volume — Volume

Indicator calls

rsi(14)

sma(c, 20)

Many moving-average calls also accept a period by itself and use close price:

sma(20)

Fundamental fields

f.market_cap

Fundamental fields are available only in hosts that provide fundamentals.

Comparison Operators

rsi(14) < 30

f.market_cap >= 1B

f.country == "United States"

The comparison operators are:

< Less than
> Greater than
<= Less than or equal
>= Greater than or equal
== Equal to
!= Not equal to
=~ Regular-expression or string-pattern match
!~ Does not match

Single = is not an equality operator.

Logical Operators

Use and when both conditions must be true:

rsi(14) < 30 and f.market_cap > 1B

Use or when either condition may be true:

rsi(14) < 30 or rsi(14) > 70

Use not to invert a condition:

not (rsi(14) > 50)

Use parentheses to make combinations clear:

(rsi(14) < 30 or rsi(14) > 70) and f.market_cap > 1B

Math Operators

(c - sma(c, 20)) / sma(c, 20) * 100

The math operators are +, -, *, /, and %. % returns the remainder with the dividend's sign. Division or remainder by zero produces a missing column value, not zero.

Series History

Use @N to read a value N bars ago:

c > c@1

Use #N.method for a trailing window. The available methods are sum, mean, max, min, and stddev:

v > v#20.mean * 1.5

Lag sizes range from 0 through 5000. Window sizes range from 1 through 5000. Write both as whole numbers.

Common Functions

Price and volume

roc(N) — Close-price rate of change over N bars, in percentage points
change(x, N) — Absolute change in any series
sma(x, N) — Simple moving average
ema(x, N) — Exponential moving average
rvol(N) — Relative volume
vwap — Default volume-weighted average price

Momentum

rsi(N) — Relative Strength Index
macd_line(fast, slow) — MACD line
macd_signal(fast, slow, signal) — MACD signal line
macd_histogram — Default MACD line minus signal
cross_up(a, b) — a crosses above b on the current bar
cross_down(a, b) — a crosses below b on the current bar

Volatility

atr(N) — Average True Range
atrp(N) — ATR as a percentage of price
bb_upper(N, k) — Upper Bollinger Band
bb_middle(N, k) — Middle Bollinger Band
bb_lower(N, k) — Lower Bollinger Band

Fundamentals

f.market_cap — Market capitalization
f.pe — Price-to-earnings ratio
f.ps — Price-to-sales ratio
f.revenue_ttm — Trailing-12-month revenue
f.revenue_growth_yoy — Year-over-year revenue growth as a fraction
f.eps_growth_yoy — Year-over-year EPS growth as a fraction
f.gross_margin — Gross margin percentage
f.operating_margin — Operating margin percentage
f.debt_to_ebitda — Debt divided by EBITDA
f.dividend_yield — Annual dividend yield in percentage points
f.fcf_yield — Free-cash-flow yield in percentage points
f.rule_of_40 — Rule of 40 score

For example, this finds stocks yielding between 2% and 6%:

f.dividend_yield >= 2 and f.dividend_yield <= 6

The in-product function catalog is the complete list. It is more reliable than guessing a name from another charting language.

Numeric Literals

Standard and scientific notation work. _ may separate digits. Finance suffixes are case-insensitive:

K — Thousand
M or MM — Million
B or BN — Billion
T or TN — Trillion

f.market_cap > 1.5B

String and Regex Matching

Use == for exact string equality:

f.country == "United States"

Use a regular-expression literal for more flexible matching. The supported flags are i for case-insensitive matching and m for multiline matching:

f.sector =~ /^tech/i

A string pattern with * or ? performs case-insensitive wildcard matching:

f.industry =~ "Software*"

Crossovers

cross_up(c, sma(c, 50))

cross_down(rsi(14), 30)

Crossovers detect the event on the current bar, not the sustained state after the crossing.

Operator Precedence

From highest to lowest:

Literals, fields, calls, and parentheses
Postfix lag, window, and member access: @N, #N.method, .member
Unary not, !, and -
Multiplication, division, and remainder: *, /, %
Addition and subtraction: +, -
Ordering: <, >, <=, >=
Equality and matching: ==, !=, =~, !~
and
or

When in doubt, use parentheses:

(rsi(14) < 30) and (f.market_cap > 1B)

Common Errors

Unsupported function name

rsi14()

Fix: use the catalog name and arguments: rsi(14).

Mismatched parentheses

(rsi(14) < 30

Fix: close the expression: (rsi(14) < 30).

Invalid function arguments

sma()

Fix: provide a period or series and period: sma(20) or sma(c, 20).

Inline comment

rsi(14) < 30 # oversold

Fix: remove the comment from the expression.

Formula Patterns

Oversold bounce

rsi(14) < 30 and c > sma(c, 200) and f.market_cap > 1B

Fundamental growth

f.revenue_growth_yoy > 0.15 and f.eps_growth_yoy > 0.20 and f.gross_margin > 50 and f.pe < 25

Momentum breakout

c > sma(c, 20) and sma(c, 20) > sma(c, 50) and v > sma(v, 20) * 1.5

Volatility contraction

atrp(14) < 2 and f.market_cap > 500M

MACD bullish crossover

cross_up(macd_line(12, 26), macd_signal(12, 26, 9)) and c > sma(c, 200)

Tips

Start with one condition and confirm it before adding another.
Use explicit periods in formulas you intend to save or share.
Read validation errors; unsupported names do not fall back to a different implementation.
Test a complex formula on a small watchlist before running a large universe.

What's Next?

Cookbook Recipes — Ready-made strategies
Your First Scan — Apply your formulas
Troubleshooting — Common issues

Custom chart indicators use SKIF expressions inside a small chart-only document. input, let, and output define calculations; a final view {} selects a price, volume, or oscillator pane. Each rendered layer uses a named primitive whose header names the output and whose direct properties describe its chart behavior. The server evaluates the outputs and the chart draws the resulting series. See the in-product indicator editor for validation at exact line and column locations.