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)

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.

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