RSI

  Live
The relative strength index (RSI) is a momentum indicator used in technical analysis that measures the magnitude of recent price changes to evaluate overbought or oversold conditions in the price of a stock or other asset.

How calculated

Relative Strength Index Tehcnical Indicator is calculated daily at the end of the day on MarketXLS servers. The default time period if you do not use any optional period as the second argument is 14. But you can change the time period used for calculation by passing the second argument like =RelativeStrengthindex("MSFT",20) .This technical indicator is calculated on MarketXLS server using the Close Price of the day. It is based on the EOD Prices. The Indicators refreshes at around 5PM EST after markets close

Example usage

=RelativeStrengthIndex("MSFT") - Returns the 14 day RSI for MSFT
=RelativeStrengthIndex("MSFT",20) - Returns the 20 day RSI for MSFT. Similarly you can get x day RSI.
=RelativeStrengthIndex("MSFT",20,"9/1/2021") - Returns RelativeStrengthIndex value for 20 day period with start date 1 September 2021

Notes

An RSI reading of 30 or below indicates an oversold or undervalued condition.

Assets

Stocks ETFs Mutual Funds Currencies Cryptocurrencies

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!