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)

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

Q: Difference between RTI_Close and RTI_Last? A: RTI_Close is bar close, RTI_Last is most recent tick price.

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