Relative Strength Index RSI

The RSI is a technical indicator based on the relationship of the average of recent gains to recent losses. It attempts to determine overbought and oversold conditions of the stock or future that is being tracked.

Because this is an oscillator style indicator the value always "oscillates" between two extremes which are 0 and 100. Values in the upper band, between 70 and 100 indicate an overbought situation. Values in the lower band, between 30 and 0 represent oversold values.

The formula for the RSI is:

RSI = 100 - (100 / (1 + RS))

RS = Average Gain / Average Loss

The default and most common number of periods to average for the RSI is 14.

[file]0285eec8-b118-4fe6-a13b-4cc335fe227d[/file]

In the above chart for IBM the RSI remains mostly between the lower 30 band marked with a green horizontal line and the upper 70 band marked with a red line.

[file]afa362f1-7410-41f2-a399-01e9dfaa9c71[/file]

Above is an image of the spreadsheet that you can download below to play around with and try different values of RSI.

[file]1f472e15-09fe-482e-8a4e-20eab154f06c[/file]