Bollinger Bands (BB)

Measures volatility using an SMA and upper and lower bands based on standard deviations.

Function Syntax

=BOLLINGER_BANDS(data, period, mutiplier )  

• data (array):
  Range of columns containing the date, Open, high, Low, close, volume data.
• period (number):
  The number of periods (days) used to calculate the Simple Moving Average and standard deviation. Typically 20 periods.
• multiplier (number):
  The multiplier applied to the standard deviation to set the width of the bands. Typically 2.

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

Output Example

Below is an example of the resulting array when applying the custom =BOLLINGER_BANDS() function.