Relative Strength Index (RSI) Calculator
 All 3 popular RSI calculation methods (the original Wilder's RSI, Simple MA RSI, Exponential MA RSI)
 Any period length on each variation
 Charts (scales update automatically)
 Fast and simple – enter data and push a button (and change parameters if you want)
 Intuitive navigation – you can start using it immediately
 PDF guide explaining all the calculation methods
 Works in all versions of Excel

You can find more details about individual features, exact contents of the PDF guide, and screenshots below:
Supported RSI Calculation Methods
The calculator can calculate RSI using any of the 3 most common methods.
The methods differ in the exact formula for average up and down moves (the second step in RSI calculation).
The 3 methods are:
 Simple moving average
 Exponential moving average: a = 2/(n+1)
 Wilder's smoothing method: a = 1/n
The calculation methods are explained in chapter 4 of the PDF guide.
RSI Period Length
You can set any period length on any of the calculation methods.
Note: The original RSI as introduced by J. Welles Wilder Jr. is Wilder's method with period length equal to 14.
RSI Calculator PDF Guide
The PDF guide provides detailed instructions and notes for using the calculator. It also provides detailed explanation of RSI calculation, the differences between individual calculation methods, the effect of parameters, and interpretation of RSI values. You can find an overview of the contents below:

Screenshots – This is How the Calculator Looks:
The main calculation sheet. You can calculate up to 3 different RSI indicators at the same time (columns KM).
Here you can set parameters of the RSI. You can choose from the 3 common calculation methods (simple moving average, exponential moving average, and the original Wilder's smoothing). You can set any period length in the yellow cells (K8M8).
The chart sheet displays 2 charts: the upper chart with price and the lower chart with the indicators.
Here you can set which of the indicators to display. Chart scales are adjusted automatically by a macro.
The sheet where you enter data. Pushing the button on the right will sort the data from oldest to newest, import it into the calculation sheet, and build formulas. The macro will also check your data for any errors, such as missing prices or nonnumeric cells.
Excel Versions and Macros
The default version of the calculator uses Excel macros to make it convenient and easy to use. If you can't or don't want to use macros, there is also a macrofree version available.
All Excel Versions:
 RSI_Calculator.xlsm = the default version (all features, easiest to use)
 RSI_MacroFree.xlsx = macrofree version (if you can't use macros)
 RSI_for_Excel_972003.xls = Excel 972003 version
 RSI_for_Excel_972003_MacroFree.xls = macrofree Excel 972003 version
Every user gets access to all versions plus the PDF guide.

If you have any questions, please see FAQ or .