Bollinger Band was developed by a technical trader John Bollinger in A band plotted two standard deviations away from a simple moving average is Bollinger Band.

Guide To Excel For Finance: Technical Indicators

The price of the stock is banded by an upper and lower band along with a day simple moving average. Bollinger Bands are a volatility indicator for the Stock prices. Bollinger band is an effective strategy.

Interpreting the Bollinger Band will help in finding the stock volatility to make Buy or Sell decisions.

Sell is considered when Bollinger Bands are far apart. Buy is considered when the Bollinger Bands are close together. These bands are useful in comparing stock price by the action of indicators to make trading decisions. Bollinger Bands are used widely among traders.

Few traders buy when price touches the lower Bollinger Band. They exit when price touches the moving average in the center of the bands. Other than Finance Experts, The International Civil Aviation Organization is also using Bollinger bands as a safety indicator to measure efficiency of safety by determining the accident rate.

In this example we are taking sample data from January to March. The four values recorded are Open, High, Low and Close. Bollinger Bands consist of a middle band with two outer bands. The middle band is a simple moving average that is usually set at 20 day moving average Purple Color. The outer bands are usually set 2 standard deviations above and below the middle band.

The upper Bollinger band is indicated in Green color.

The lower Bollinger band is indicated in Red color. The close price is indicated with Blue in color. As shown in the image below. Select the required Standard deviation multiplier from the dropdown provided in the Excel file free download link at the end of the blog. Based on the standard deviation and the multiplier, the Lower Bollinger and Upper Bollinger values gets updated. We can decide whether to buy or sell based on the graph. These are considered as sell periods.

Selling at those periods will turn out to be profitable.

How to Calculate Bollinger Bands in Excel | eHow

This period is considered as Buy period as the price is low and is apt time to invest. Download the free Bollinger Bands template here: Your email address will not be published.

You may use these HTML tags and attributes: Home About Us Services Our Blog Contact Us. How to interpret Bollinger Band? Target Users These bands are useful in comparing stock price by the action of indicators to make trading decisions.

Leave a Reply Cancel reply Your email address will not be published. Quick Contact Info callexcelexpert US: Bollinger Bands using Excel California Sales Template with Heat Map in Excel Time Card Calculator - Payroll template with California Overtime rules.

Tags Dependent dropdown dget difference between activex and form controls dmax dmin Dropdown value Dynamic Charts in Excel Dynamic dropdown Excel Consultant Excel Expert Excel Keyboard Shortcuts ExcelSolver Goal Seek grouping checkboxes in excel heat map in excel Hlookup Index indirect function in excel instring function investment tool Lookup macros mail merge Match Merge cells monte carlo simulation multiple lookup Offset Payroll template sales template Scenario Manager Solveraddin Sort horizontally in Excel split function stock investment tool sumif sumifs SumProduct Text to Columns Time card vba Vlookup waterfall chart What-if analysis in excel Wrap text.

No task is too small to us.

Bollinger band excel calculation?

We work on small applications to developing CRM, Accounting systems. We are a consulting and service based firm, independent of technology.

We think each business has its own challenges, so we first understand your business needs and come up with a solution as per your requirement using technology.

It is not necessary that we use Excel and Access alone for development. We can even convert your existing third party utility software to your own custom software. Contact Info callexcelexpert US: Excel and other words on this site may be registered trademarks of Microsoft Corporation. We are in no way affiliated with Microsoft Corporation.