Technical analysis

Bollinger Bands Trading Strategy

Written by admin
Sat Aug 26 2017
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →

Bollinger BandsNamed after famous technical analyst John Bollinger in 1983, Bollinger Bands are a notable technical analysis technique used by many investors. Traders use this technique to determine whether a stock is being overbought or oversold. When prices move near the upper band, the more overbought the security is and when the price reaches the lower band, the more oversold it is. Bollinger has 22 rules to follow when using this technique. Here we will discuss some of the prominent factors.

Breakouts Breakouts are often times misunderstood by investors. The great majority of price action occurs within the two bands. Breakouts are when prices are above or below the bands; however, this does not constitute a trade action. Neither direction is a signal to buy or sell; rather the breakout is an anomaly and does not provide a path towards the future movement of the stock.

Double BottomThe double bottom approach can be a highly successful strategy when performed correctly. To execute the double bottom, you mark the first time the price touches the lower band, and then wait to see where the next low point occurs. A price that is near or at the low can be a sign of a buying opportunity. With this technique, the second low can express that this is a good time to buy. Then the stock may experience an uptick soon and you were able to buy it at a low price point.

The SqueezeConsidered the most fundamental component of the Bollinger Bands, the squeeze, occurs when the bands come together narrowing the moving average. Traders consider this period a potential opportunity to make trades as a squeeze signals a time of low volatility with the expectation there is greater volatility later. On the other hand, when the bands widen apart the volatility levels subside and traders typically close out of trades.

bollinger bands squeeze

The Classic M TopThe classic M top certainly received its name based on how the price movement creates the letter “M” on a chart. It occurs when a price soars high just before a sell-off, and then a push towards its previous high. When a chart depicts the classic M top, it is hard for traders to simply predict whether the stock is going to trend upwards or down. However, for many traders, once a stock reaches its second high it is almost always a signal to sell.

Using Bollinger Bands

Bollinger Bands can be used in several ways to determine the current volatility of a stock, its price movement in relation to its moving average, and as a way of finding a trade opportunity. It is important to remember that when the price touches the upper band that does not robotically mean to sell. This also goes for prices touching the lower band, not automatically displaying a buy signal. On occasions, the price may break out of the upper band and if you sold once the price touched the upper band, then you have missed out on profits. Sometimes it is wiser to wait for a double bottom or a classic M top to form to better gauge its potential trend.

Calculate Bollinger Band Values with MarketXLLS and plot it

Step 1) Get the Historical prices as shown below…

Bollinger Bands

Step 2) Select Bollinger Bands from the menu and pass the Close price values.Bollinger Bands

Step 3) Select a cell to post the results and the bollinger band series will be calculated.Bollinger Bands

Bollinger Bands

Once, you have the Bollinger band series, you can simply plot it or backtest your trading strategy based on Bollinger Bands.

With MarketXLS, you can simply plot your Excel data and add Bollinger bands while customizing your charts as shown below…Bollinger Bands

When the price line crosses the either of the higher or the lower band it generally refers to a reversal of the tred.

This technique can also be an indicator of beginning and ending of strong trends. Strong trends can cause a rapid increase in volatility. When bands move far apart or incredibly narrow, traders find it necessary to wait out the trend. This interim high volatility can cause major losses on trades.

A trader’s sole system of decision making is not meant to be based on Bollinger Bands. Bands work as a tool to determine price volatility and price trend analysis.  Investors should view Bollinger Bands as a method to reveal opportunities of greater chances of trading success.

Since Bollinger Bands are a pure price indicator, using them with other technical analysis, such as volume indicators and market trends, will make this technique much more effective. Certainly, there is no one technique that will provide the very bottom price to buy or top price to sell. However,  Bollinger Bands can help maximize your trading decisions.

References :

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates

Top 100 Gainers Today

Top 100 losers Today

Real gdpReal personal consumption expReal private investmentReal govt expenditureReal net exportsReal exportsReal importsFederal receiptsFederal outlaysFederal surplus or deficitFederal debtReal private investment nonresidentialReal private investment residentialReal potential gdpReal personal incomeReal personal consumption exp monthlyRpce durable goodsRpce nondurable goodsRpce servicesPersonal savings rateMonetary baseCurrency in circulationBank reservesMoney supply m1Money supply m2Sp500DjiaWilshire indexVixFinancial stress indexCorporate bond index aaCorporate bond index bbbFederal funds rateTreasury rate 3mTreasury rate 1yTreasury rate 5yTreasury rate 10yTips 5yTips 10yBond yield aaaBond yield baaMortgage rate 15yMortgage rate 30yUs dollar weighted averageUsdollar to euroUsdollar to poundYuan to usdollarCanadiandollar to usdollarYen to usdollarCpiCpi wo food energyCpi foodCpi energyChain price indexChain price index wo food energyGdp price deflatorPpi final demandPpi finished goodsPpi materialPpi crude goodsPpi final demand wo food energyPpi finished goods wo food energyHouse price indexHouse price index 20cityCrude oil priceGasoline priceNatural gas priceIndustrial productionCapacity utilisationInventoriesSales retail foodVehicle sales light weightManufacture orders durablesManufacture orders capital goodsLoansConsumer credit outstandingCorporate profitsHousing startsBuilding permitsResidential constructionEmployees nonfarmEmployees privateEmployees goods producingEmployees service providingEmployees governmentUnemployment rateInitial cliamsAverage weeks unemployedJob openingsHiresSeparationsQuitsLayoffs dischargesHours of productionHourly earningsReal outputPopulationLabor forceLabor force participation rate
Search for a stock

Top MarketXLS Rank stocks

Cowen Inc. logo

Cowen Inc.

Optionable: Yes
Market Cap: 859 M
Industry: Capital Markets
52 week range    
Booz Allen Hamilton Holding Corporation logo

Booz Allen Hamilton Holding Corporation

Optionable: Yes
Market Cap: 11,928 M
Industry: Business Services
52 week range    
Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

Optionable: No
Market Cap: 2,846 M
Industry: Auto & Truck Dealerships
52 week range    
Amdocs Limited logo

Amdocs Limited

Optionable: Yes
Market Cap: 10,201 M
Industry: Software - Infrastructure
52 week range    
NBT Bancorp Inc. logo

NBT Bancorp Inc.

Optionable: Yes
Market Cap: 1,640 M
Industry: Banks - Regional - US
52 week range    
CRA InternationalInc. logo

CRA InternationalInc.

Optionable: Yes
Market Cap: 661 M
Industry: Business Services
52 week range    
CatchMark Timber Trust Inc. Class A logo

CatchMark Timber Trust Inc. Class A

Optionable: Yes
Market Cap: 504 M
Industry: REIT - Diversified
52 week range    
America's Car-Mart Inc. logo

America's Car-Mart Inc.

Optionable: Yes
Market Cap: 683 M
Industry: Auto & Truck Dealerships
52 week range    
ManTech International Corporation logo

ManTech International Corporation

Optionable: Yes
Market Cap: 3,917 M
Industry: Software - Application
52 week range    
CACI International Inc. Class A logo

CACI International Inc. Class A

Optionable: Yes
Market Cap: 6,536 M
Industry: Information Technology Services
52 week range    

More Features

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to to avail the extention

From all of us at MarketXLS, thank you!