• 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 EMA (Exponential Moving Average) in Excel

How to Calculate EMA (Exponential Moving Average) in Excel

  • Posted by admin22
  • Date April 28, 2019

In the earlier post we have seen how to calculate SMA using excel. But the problem with SMA is that it allocates equal weightage to all the observations. This increases a lag in the indicator which responds slowly to the price movement. To reduce this lag, traders have come up with another indicator called Exponential Moving Average.

Exponential Moving Average (EMA) allocates highest weightage to the latest closing price and least weightage to the historical closing prices. 

Formula:

Multiplier: (2 / (Time periods + 1) ) 
EMA: {Close - EMA(previous day)} x multiplier + EMA(previous day).
Here Time period is the number of days you want to look back.

Download EMA Excel Sheet Calculation 

In the sheet attached, we have considered EMA for 10 days, so the look back period / Time Period will be 10 days.

Column ‘E’ contains the “close price” and Column ‘F’ contains the EMA itself. Since we have taken EMA 10, first 10 days won’t have any EMA. If you look at the formula of EMA above, EMA of current day will depend on the EMA of yesterday. But, since we don’t have EMA for the first time, we just take simple moving average on the 10th day. From 11th day onwards we start calculating EMA.

  • Share:
author avatar
admin22

Previous post

How to Calculate SMA ( Simple Moving Average) in Excel
April 28, 2019

Next post

How to Calculate Bollinger Bands 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.