• 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
      • FSM 1.0
      • FSM 2.0
      • Mentorship Program
  • 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
      • FSM 1.0
      • FSM 2.0
      • Mentorship Program
  • 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 MACD ( Moving Average Convergence Divergence) in Excel

How to Calculate MACD ( Moving Average Convergence Divergence) in Excel

  • Posted by admin22
  • Date April 28, 2019

MACD ( Moving Average Convergence Divergence) is also known as a Hybrid Indicator since it inculcates Trend and Momentum concepts.

The most common moving average values used in the calculation of the MACD Line are the 26 period and 12
period exponential moving averages. The Signal Line is commonly created by using a 9 period exponential
moving average of the MACD values. Where as the histogram is the distance between MACD line and the signal line.

Formula:

MACD: (12-day EMA - 26-day EMA) 

Signal Line: 9-day EMA of MACD

MACD Histogram: MACD - Signal Line

MACD can generate buy and sell signals using crossovers, crossunders and divergences. Zone above the zero line is bullish and the zone below it is bearish

Download MACD Excel Sheet

  • Share:
author avatar
admin22

Previous post

How to Calculate Bollinger Bands in Excel
April 28, 2019

Next post

How to Calculate Stochastic Oscillator 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.