Bollinger Band Percent

Correlates current price with high and low Bollinger Band. The Bollinger Band Percent's value 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.

Syntax:

BollingerBandPercent
BollingerBandPercent()
BollingerBandPercent(“Period”,”Deviation”)
BollingerBandPercent(“OutPutStartCell”, ”Period”, ”Deviation”)

Inputs:

'Close' column values

Parameters:

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

Examples:

BollingerBandPercent
BollingerBandPercent()
BollingerBandPercent(“14”,”7”)
BollingerBandPercent(14,7)
BollingerBandPercent(“G2”, “14”,”7”)
BollingerBandPercent(G2,14,7)