Bollinger Band

Bollinger Bands are similar to moving average envelopes. The difference between Bollinger Bands and envelopes is envelopes are plotted at a fixed percentage above and below a moving average, whereas Bollinger Bands are plotted at standard deviation levels above and below a moving average. Since standard deviation is a measure of volatility, the bands are self-adjusting: widening during volatile markets and contracting during calmer periods.

Bollinger Bands were created by John Bollinger.

Bollinger Bands are usually displayed on top of security prices, but they can be displayed on an indicator. These comments refer to bands displayed on prices.

As with moving average envelopes, the basic interpretation of Bollinger Bands is that prices tend to stay within the upper- and lower-band. The distinctive characteristic of Bollinger Bands is that the spacing between the bands varies based on the volatility of the prices. During periods of extreme price changes (i.e., high volatility), the bands widen to become more forgiving. During periods of stagnant pricing (i.e., low volatility), the bands narrow to contain prices.

Mr. Bollinger notes the following characteristics of Bollinger Bands.

• Sharp price changes tend to occur after the bands tighten, as volatility lessens.
• When prices move outside the bands, a continuation of the current trend is implied.
• Bottoms and tops made outside the bands followed by bottoms and tops made inside the bands call for reversals in the trend. 
• A move that originates at one band tends to go all the way to the other band. This observation is useful when projecting price targets.

Syntax:

BollingerBand
BollingerBand()
BollingerBand(“Method”)
BollingerBand(“Period”, ”Deviation”, “Method”)
BollingerBand(“OutPutStartCell”, ”Period”, ”Deviation”, “Method”)

Inputs:

'Close' column values

Parameters:

• Period (default=14)
• Deviation (default=7)
• Method (default=MvAvg)
• OutPutStartCell (default=the next blank column in the worksheet)

Examples:

BollingerBand
BollingerBand()
BollingerBand(“MvAvg”)
BollingerBand(MvAvg)
BollingerBand(“LinWgtMvAvg”)
BollingerBand(LinWgtMvAvg)
BollingerBand(“ExpMvAvg”)
BollingerBand(ExpMvAvg)
BollingerBand(“14”, ”7”,”MvAvg”)
BollingerBand(14, 7, MvAvg)
BollingerBand(“14”, 7, ExpMvAvg)
BollingerBand(“G2”, ”14”, ”7”, ”MvAvg”)
BollingerBand(G2, 14, 7,”MvAvg”)
BollingerBand(“G2”, 14, 7,MvAvg”)
BollingerBand(G2,”14”, 7, ExpMvAvg)