• 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
Seminar on live trading strategy (Seminar on live trading strategy (11th Feb 2023, 11 am)
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
  • Calculation of RSI using EXCEL

Calculation of RSI using EXCEL

  • Posted by Trading Campus
  • Date February 19, 2017
  • Comments 168 comments

You can download the following excel sheet, to take a look at how RSI is calculated.

RSI calculation uses close price of a stock.

“Column E” has all closing prices.

“Column F” calculates change in price by subtracting current row from previous row.

If “Column F” value is greater than zero, value will be copied to Column G. If value is less than zero, value will be copied to “Column H”.

“Column I” calculates the average Gain over the specified period, example 14.

“Column J” calculates the average Losses over the specified period, example 14.

“Column K” calculates the value of Relative Strength (RS).

“Column L” calculates the value of Relative Strength Index(RSI).

You can download the excel file from the following link.

RSI calculation

  • Share:
author avatar
Trading Campus
We provide courses in Share Market Training certified by NSE Academy. Get Adequate knowledge through our classroom courses.

Previous post

Introduction to RSI
February 19, 2017

Next post

Moving Average Convergence Divergence
February 19, 2017

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 …

    168 Comments

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.