Real-Time Intraday Last

Returns the last traded price for a specific intraday bar.

Syntax

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

Examples

=RTI_Last("AAPL")
=RTI_Last("MSFT", "15m")

When to Use

  • Real-time price tracking
  • Intraday analysis

When NOT to Use

Scenario Use Instead
Daily last Last()

Common Issues & FAQ

Difference from RTI_Close?

RTI_Last is most recent tick, RTI_Close is bar close.

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