MarketXLS

Real-Time Intraday High

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

Parameters

symbolstringRequired

Stock ticker symbol

intervalstring

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

indexnumber

Bar index (0 = current)

Returns

number

High price for the specified interval

Examples

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

When to Use

  • Intraday resistance analysis
  • Day trading strategies
  • Range breakout analysis
  • Stop placement

When NOT to Use

Scenario Use Instead
Daily high High()
Bar low RTI_Low()
Highest in X minutes RTI_HighestPriceXMin()

Common Issues & FAQ

What intervals are available?

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

Excel Templates Using Real-Time Intraday High

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

Related Functions