MarketXLS

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

Syntax

=RTI_SMA(Symbol, [Interval], [Lookback], [Field], [Index])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

intervalstring

Time interval (1m, 5m, 15m, etc.)

lookbacknumber

Number of periods for SMA

fieldstring

Price field (close, open, high, low)

indexnumber

Bar index (0 = current)

Returns

number

Simple Moving Average value

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

What intervals are supported?

1m, 5m, 15m, 30m, 60m are common intervals.

Why is data not updating?

Ensure market is open and symbol is actively trading.

Excel Templates Using Real-Time Intraday SMA

These ready-made MarketXLS templates call RTI_SMA() in their worksheet formulas. Open one to see the function working inside a complete model.

Related Formulas

More MarketXLS MarketXLS Analytics formulas you can use in the same worksheet:

See RTI_SMA used in a complete workbook: RTI Functions: Real-Time Streaming Technical Indicators in Excel (Complete Guide 2026)

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