ARTICLE SYNOPSIS...CALCULATING BOLLINGER BANDS An Excel spreadsheet is used to calculate Bollinger Bands for the DJIA. The actual formula for each cell is shown at the bottom of the column; the formula presented is specific for the location of that cell.
ARTICLE SYNOPSIS...Calculating Bollinger Bands by Technical Analysis, Inc. Bollinger band formulas for an Excel spreadsheet.