Real-Time Intraday SMA

Calculates a Simple Moving Average using intraday data at specified intervals.

Parameters

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

Notes

  • Real-time intraday data
  • Updates during market hours

Examples

=RTI_SMA("AAPL")
20-period 5m SMA
=RTI_SMA("MSFT", "5m", 20)
Explicit 20-period 5m SMA
=RTI_SMA("SPY", "15m", 50)
50-period 15m SMA
=RTI_SMA("AAPL", "1m", 10, "high")
10-period 1m SMA of highs

When to Use

  • Intraday trend analysis
  • Day trading signals
  • Scalping strategies
  • Real-time technical analysis

When NOT to Use

Scenario Use Instead
Daily SMA SMA()
Intraday RSI RTI_RSI()
Exponential MA EMA() functions

Common Issues & FAQ

Q: What intervals are supported? A: 1m, 5m, 15m, 30m, 60m are common intervals.

Q: Why is data not updating? A: Ensure market is open and symbol is actively trading.

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 SMA and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions