MarketXLS

Real-Time Intraday Close

Returns the closing price for a specific intraday time interval bar.

Parameters

Parameter Type Required Description
Symbol string Yes Stock ticker symbol
Interval string No Time interval (1m, 5m, 15m, 30m, 60m)
Index number No Bar index (0 = current, 1 = previous)

Syntax

=RTI_Close(Symbol, [Interval], [Index])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

intervalstring

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

indexnumber

Bar index (0 = current)

Returns

number

Close price for the specified interval

Examples

=RTI_Close("AAPL")
Current 5m bar close
=RTI_Close("MSFT", "15m")
15-minute bar close
=RTI_Close("SPY", "5m", 1)
Previous bar close

When to Use

  • Intraday OHLC analysis
  • Candlestick pattern analysis
  • Day trading strategies
  • Real-time charting

When NOT to Use

Scenario Use Instead
Daily close Close() or PreviousClose()
Bar open RTI_Open()
Last price RTI_Last()

Common Issues & FAQ

Difference between RTI_Close and RTI_Last?

RTI_Close is bar close, RTI_Last is most recent tick price.

Excel Templates Using Real-Time Intraday Close

These ready-made MarketXLS templates call RTI_Close() 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_Close 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 Close and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions