Nifty RSI Calculation in excel

Here's an example of RSI calculation done in excel spreadsheet with real life data of Nifty index. You can download that from here -

In fact you can understand from the excel sheet how exactly to compute RSI and then you can apply the formulas to data of any stock or indices. Remember each value of RSI takes in an unlimited number of previous values in consideration, therefore it makes sense to have atleast 50 data points before your calculation date so that the values you get are more or less accurate.

No comments: