Bollinger Bands (BB)

Bollinger Bands are a technical analysis tool developed by John Bollinger, consisting of three lines plotted in relation to a security’s price. The middle line is a Simple Moving Average (SMA), while the upper and lower bands are typically set two standard deviations above and below the SMA. The primary purpose of Bollinger Bands is to measure market volatility by showing how the bands widen during periods of high volatility and contract (or ‘squeeze’) during periods of low volatility.

BOLLINGER_BANDS

=BOLLINGER_BANDS(data, period, multiplier)

Example Usage

=BOLLINGER_BANDS(A2:F500, 20, 2)

Parameters

Parameter Type Description Status
data
Range
The input range of columns containing the Date, Open, High, Low, Close, and Volume data.
 Required
period
Number
The number of periods (days) used to calculate the Simple Moving Average and standard deviation. Typically **20** periods.
 Required
multiplier
Number
The multiplier applied to the standard deviation to set the width of the bands. Typically **2**.
 Required

Returns

A four-column array of dates and their corresponding SMA, Upper Band and Lower Band values.

Bollinger Bands Formula Result in Google Sheets