RSI Calculator

Download Now
  • $25 one-time payment
  • Instant download from sesyixo.ru

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:

RSI Calculator Guide table of contents
Download Now
  • $25 one-time payment
  • Instant download from sesyixo.ru

Screenshots – This is How the Calculator Looks:

RSI Calculator

The main calculation sheet. You can calculate up to 3 different RSI indicators at the same time (columns K-M).

RSI Calculator

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 (K8-M8).

RSI Calculator

The chart sheet displays 2 charts: the upper chart with price and the lower chart with the indicators.

RSI Calculator

Here you can set which of the indicators to display. Chart scales are adjusted automatically by a macro.

RSI Calculator

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 non-numeric 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 macro-free version available.

All Excel Versions:

  • RSI_Calculator.xlsm = the default version (all features, easiest to use)
  • RSI_Macro-Free.xlsx = macro-free version (if you can't use macros)
  • RSI_for_Excel_97-2003.xls = Excel 97-2003 version
  • RSI_for_Excel_97-2003_Macro-Free.xls = macro-free Excel 97-2003 version

Every user gets access to all versions plus the PDF guide.

Download Now
  • $25 one-time payment
  • Instant download from sesyixo.ru

If you have any questions, please see FAQ or ask us.


Related pages


portfolio var calculationexcel exp functionnormdist in excelyahoo share prices historyshort strangle strategyimplied volatility calculation formulaspreadsheets formulasc# exponential moving averageformulas on profit and lossblack scholes 1973define rsihedge fund tradersgoal seek formula in excel 2010simple average method of inventory valuationwhat is a good sharpe ratioweighted average cost of capital formula exampleblack scholes formulasoros holdingscalculating standard deviation of returnsghi stockkurtosis in excelsample variance formula statisticshistorical stock calculators&p 500 futures bloombergexcel logarithmhow to use natural log in excelacceptable skewness and kurtosis valuesvix spotstandard deviation of monthly returnsequation for dividendsdefinitional formula for variancepopulation covariance formulaput and calls for dummiesnotepad with fontsipath s&p 500 vix short term futuresdividend calculator spreadsheetvix realtime13f sec filing13f reportsblack scholes put option formulausing waccunderstanding vixmedian function in exceldjia calculationkurtosis definition in statisticsmean and standard deviation calculatorcboevixgeometric mean return calculatormerits and demerits of central tendencyexcel option pricing modelimplied volatility standard deviationblack scholes optionharmonic mean of 3 numbersmerits and demerits of mean median modes&p 500 methodologyvolatility calculation black scholeswhat does oversold mean in stocksmacd calculationstandard deviation calculation in excelsharp measurepi formula in excelvariance sigma squaredannualized return formula excelhistorical vixoptions calls and puts for dummiesshort call payoff diagramvix futures expirationoptions long straddlevix bloombergskewness statistics definitionshort vxx etfapple stock history graphhow to measure skewnesssquaring numbers calculatornorm s dist excelpayoff diagrams for call and put optionspopulation and sample variancepayoff of put optionmeasure of skewness and kurtosiscalculating standard deviation of returnsoptions greeks calculatorvix option