Real-Time Intraday RSI

Calculates the Relative Strength Index using intraday data.

Parameters

Parameter Type Required Description
Symbol string Yes Stock ticker symbol
Interval string No Time interval (1m, 5m, 15m, etc.)
Lookback number No Number of periods (default 14)
Field string No Price field: close, open, high, low
Index number No Bar index (0 = current)

Interpretation

  • RSI > 70: Overbought
  • RSI < 30: Oversold
  • RSI = 50: Neutral

Examples

=RTI_RSI("AAPL")
14-period 5m RSI
=RTI_RSI("MSFT", "5m", 14)
Explicit 14-period 5m RSI
=RTI_RSI("SPY", "15m", 14)
15-minute RSI
=RTI_RSI("AAPL", "1m", 9)
Short-term 9-period RSI

When to Use

  • Intraday overbought/oversold analysis
  • Day trading momentum signals
  • Scalping setups
  • Real-time technical analysis

When NOT to Use

Scenario Use Instead
Daily RSI RSI()
Intraday SMA RTI_SMA()
Price data RTI_Last(), RTI_Close()

Common Issues & FAQ

Q: What does RSI above 70 mean? A: RSI above 70 typically indicates overbought conditions and potential for price pullback.

Q: What lookback period should I use? A: 14 is the standard period. Shorter periods (9) are more sensitive, longer periods (21) are smoother.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Real-Time Intraday RSI and Other Financial Formulas
How does MarketXLS work?