Standard Deviation (STDEV)

Standard Deviation is a statistical measure used in technical analysis to quantify market volatility. It works by calculating the dispersion of a security’s closing prices from its Simple Moving Average (SMA). A higher standard deviation value indicates that prices are more spread out, signifying greater volatility and market uncertainty. Conversely, a lower value signifies that prices are tightly clustered around the average, indicating lower volatility. It serves as the fundamental building block for other key indicators, most notably Bollinger Bands, which are plotted at standard deviation levels above and below a moving average.

STDEV_INDICATOR

=STDEV_INDICATOR(data, period)

Example Usage

=STDEV_INDICATOR(A2:F500, 20)

Parameters

Parameter Type Description Status
data
Range
Range of columns containing the date, Open, high, Low, close, volume data.
 Required
period
Number
Number of (periods) days over which to calculate the Standard Deviation.
 Required

Returns

A two-column array of dates and their corresponding Standard Deviation values.

Standard Deviation Formula Result in Google Sheets