• Home
  • Courses
    • NSE Academy Certified Courses
      • Capital Market Analytics
      • Certified Program on Intraday Trading Strategies
      • Advanced Technical Analysis
      • Advanced Options
      • Advanced Algo Trading
      • Advanced Fundamental Analysis
      • Advanced Risk Management
      • Algorithmic Trading & Computational Finance using Python & R
    • TC Courses
      • Beginners Technical Analysis Course
      • Beginners Option Course
      • Technical Analysis Master Course
      • Options Analysis Master Course
    • NISM Courses
      • NISM Series I – Currency Derivatives Course
      • NISM Series IV – Interest Rate Derivatives Course
      • NISM Series VIII – Equity Derivatives Course
      • NISM Series XV – Research Analyst
    • Free Courses
  • Learning Center
    • Financial Education
    • IPO Issues
    • Fundamental Analysis
    • Technical Corner
    • Options Corner
    • Risk Management
  • Screener
  • Emerging Leaders
  • Terminal
  • Subscribe
Have any question?
7718989954
info@tradingcampus.in
Login
Trading CampusTrading Campus
  • Home
  • Courses
    • NSE Academy Certified Courses
      • Capital Market Analytics
      • Certified Program on Intraday Trading Strategies
      • Advanced Technical Analysis
      • Advanced Options
      • Advanced Algo Trading
      • Advanced Fundamental Analysis
      • Advanced Risk Management
      • Algorithmic Trading & Computational Finance using Python & R
    • TC Courses
      • Beginners Technical Analysis Course
      • Beginners Option Course
      • Technical Analysis Master Course
      • Options Analysis Master Course
    • NISM Courses
      • NISM Series I – Currency Derivatives Course
      • NISM Series IV – Interest Rate Derivatives Course
      • NISM Series VIII – Equity Derivatives Course
      • NISM Series XV – Research Analyst
    • Free Courses
  • Learning Center
    • Financial Education
    • IPO Issues
    • Fundamental Analysis
    • Technical Corner
    • Options Corner
    • Risk Management
  • Screener
  • Emerging Leaders
  • Terminal
  • Subscribe

Technical Corner

  • Home
  • Blog
  • Technical Corner
  • How to Calculate Bollinger Bands in Excel

How to Calculate Bollinger Bands in Excel

  • Posted by admin22
  • Date April 28, 2019

Bollinger Bands belong to Volatility category of Indicators. It consists of three bands – upper band, lower band and middle band. As per Bell Curve, 68% of the observations lie in the 1STD (Standard Deviation) from Mean, 95% observations lie in the 2STD from Mean and 99.7% observations lie in 3STD from Mean Values

The bands automatically widen when volatility increases and contract when volatility decreases. Theoretically when price touches upper band / lower band it reverses to average. That means upper bollinger band acts as resistance and lower band acts as support.

Middle Band = 20-day simple moving average (SMA)
Upper Band = 20-day SMA + (20-day standard deviation of price x 2) 
Lower Band = 20-day SMA - (20-day standard deviation of price x 2)

Download Bollinger Band Excel Template

In the Excel sheet attached, Column ‘E’ contains the close price, Column ‘F’ contains Standard Deviation, Column ‘G’ contains 20 SMA which is the middle band, Column ‘H’ contains Upper Bollinger Band which is (20SMA+2STD) and lower Bollinger Band contains (20SMA-2STD).

  • Share:
author avatar
admin22

Previous post

How to Calculate EMA (Exponential Moving Average) in Excel
April 28, 2019

Next post

How to Calculate MACD ( Moving Average Convergence Divergence) in Excel
April 28, 2019

You may also like

Arithmetic Operators
12 May, 2021

There are around 7 arithmetic operators available in python. These are called as binary operators because they act on two operators. a = 13, b = 5 Operator Meaning Example …

Operators in Python
11 May, 2021

An operator is a symbol that performs an operation. Some examples of operations are addition, subtraction, multiplication etc. a + b is an operation where a,b are operands and ‘+’ …

Bear Call Spread
23 December, 2020

Bear call spread is an option strategy used by traders to cap their maximum loss. At first, a trader is bearish with the downside capped, so he initiates a sell …

emerging leader

  • Basics of Python
  • Emerging Leaders
  • Financial Education
  • Fundamental Analysis
  • Investment Ideas
  • IPO Issues
  • Nifty 50
  • Options Corner
  • Risk Management
  • Technical Corner
  • Uncategorized

Past Batches

December 2018 – Completed

March 2019 – Completed

July 2019 – Completed

November 2019 – Completed

January  2020 – Running

Get Updates

Subscribe to our mailing list and get learning stuff and updates to your email inbox
Loading

Accordions

Company Summary

Bajaj Electricals Limited is engaged in engineering and projects; power distribution, illumination and consumer durables businesses.

It has a range of domestic and kitchen appliances comprising water heaters, room heaters, coolers, irons, mixers, induction cookers, toasters, kettles, microwave, rice cookers, gas stoves, non-electrical kitchen aids and pressure cookers.

It offers ceiling, table, pedestal, wall, fresh air and industrial fans, and lighting solutions, such as light sources, light emitting diode-based lighting products, domestic luminaires, torches and lanterns.

Key Highlights of Company Business

Segments and Products

The Company's business segments consist of

  1. Lighting;
  2. Consumer Durables;
  3. Engineering & Projects,

The Lighting segment includes lamps, tubes and luminaries.

The Consumer Durables segment includes appliances and fans.

The Engineering & Projects segment includes transmission line towers, telecommunications towers, highmast, poles and special projects.

The Others segment includes diecasting and wind energy.

Financial Performance

Financial Ratios

Trading Campus

7718989954

info@tradingcampus.in

Company

  • About Us
  • Gallery
  • Team
  • Contact Us
  • Careers

Courses

  • Technical Analysis
  • Algo Trading
  • Options
  • Fundamental Analysis
  • Risk Management
  • Algo Trading using Python

Support

  • Learning Center
  • Forum
  • Login
  • Videos

Education WordPress Theme by ThimPress. Powered by WordPress.

Copyright © 2018 Trading Campus. All rights reserved.