MarketXLS

Real-Time Intraday Open

Returns the opening 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_Open(Symbol, [Interval], [Index])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

intervalstring

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

indexnumber

Bar index (0 = current)

Returns

number

Open price for the specified interval

Examples

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

When to Use

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

When NOT to Use

Scenario Use Instead
Daily open Open()
Bar close RTI_Close()
Last price RTI_Last()

Common Issues & FAQ

What intervals are available?

Common intervals: 1m, 5m, 15m, 30m, 60m.

Excel Templates Using Real-Time Intraday Open

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

Related Functions