Real-Time Intraday Time

Returns the timestamp for a specific intraday bar.

Parameters

Parameter Type Required Description
Symbol string Yes Stock ticker symbol
Interval string No Time interval
Index number No Bar index

Syntax

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

Examples

=RTI_Time("AAPL")
Current bar time
=RTI_Time("MSFT", "15m")
15-min bar time

When to Use

  • Get bar timestamps
  • Verify data freshness
  • Synchronize with other data

When NOT to Use

Scenario Use Instead
Last trade time LastTradeTime()

Common Issues & FAQ

What timezone?

Exchange local time.

Excel Templates Using Real-Time Intraday Time

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

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