Bollinger Band

Bollinger Band Down

Calculates the bottom Bollinger Band of using moving average as calculation method and shifted downward DEVIATION standard deviations.

Bollinger Band Down(Parameters)

1. Range. Any range of data, e.g. array of Close, Low prices, Volume, etc.
2. Output range. The cell reference for the range of output data.
3. Period. Number of values used for calculation.
4. Deviations. Number of standard deviations by which shifting the lower band.

Bollinger Band Down(Syntax)

BollingerBandDown(RANGE;PERIOD;DEVIATIONS;DIRECTION)

Example
=BollingerBandDown(F1:F10;10;3;1)

Bollinger Band Percent

Correlates current price with high and low Bollinger Band. The value %B reflects current price position calculated in percents of bandwidth. The values greater than 100% shows the price is above the high band. The values lower than 0% shows the price is under the low band. The values between 0% and 100% shows the price is within the Bollinger Bands.

Bollinger Band Percent(Parameters)

1. Range. Any range of data, e.g. array of Close, Low prices, Volume, etc.
2. Output range. The cell reference for the range of output data.
3. Period. Number of values used for calculation.
4. Deviations. Number of standard deviations by which shifting the lower and upper bands.

Bollinger Band Percent(Syntax)

BollingerBandPercent(RANGE;PERIOD;DEVIATIONS;DIRECTION)

Example
=BollingerBandPercent(C1:C6;6;2;0)

Bollinger Band Up

Calculates the bottom Bollinger Band of using moving average as calculation method and shifted downward DEVIATION standard deviations.

Bollinger Band Up(Parameters)

1. Range. Any range of data, e.g. array of Close, Low prices, Volume, etc.
2. Output range. The cell reference for the range of output data.
3. Period. Number of values used for calculation.
4. Deviations. Number of standard deviations by which shifting the upper band.

Bollinger Band Up(Syntax)

BollingerBandUp(RANGE;PERIOD;DEVIATIONS;DIRECTION)

Example
=BollingerBandUp(B1:B7;7;3;1)

Bollinger Band Width

The width of Bollinger Band shows middle price value in percent for the last PERIOD time periods. Sharp price changes tend to occur after the bandwidths tighten. You must be careful after the bandwidth’s tighten, because upon the historical experience, the market often starts the false movement just before the big price changes in another direction.

Bollinger Band Width(Parameters)

1. Range. Any range of data, e.g. array of Close, Low prices, Volume, etc.
2. Output range. The cell reference for the range of output data.
3. Period. Number of values used for calculation.
4. Deviations. Number of standard deviations by which shifting the lower and upper bands.

Bollinger Band Width(Syntax)

BollingerBandWidth(RANGE;PERIOD;DEVIATIONS;DIRECTION)

Example
=BollingerBandWidth(D2:D7;6;2;0)