MarketXLS

Highest Price in X Minutes

Returns the highest traded price in the last X minutes.

Parameters

Parameter Type Required Description
Symbol string Yes Stock ticker symbol
MinutesAgo number Yes Number of minutes to look back

Syntax

=RTI_HighestPrice_in_X_Mins(Symbol, MinutesAgo)
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

minutesAgonumberRequired

Number of minutes to look back

Returns

number

Highest price in the last X minutes

Examples

=RTI_HighestPrice_in_X_Mins("AAPL", 30)
Highest in last 30 mins
=RTI_HighestPrice_in_X_Mins("MSFT", 60)
Highest in last hour
=RTI_HighestPrice_in_X_Mins("SPY", 15)
Highest in last 15 mins

When to Use

  • Intraday resistance identification
  • Range breakout analysis
  • Day trading strategies
  • Short-term high detection

When NOT to Use

Scenario Use Instead
Daily high High()
Bar high RTI_High()
Lowest price RTI_LowestPrice_in_X_Mins()

Common Issues & FAQ

What's the maximum lookback?

Typically limited to current trading day data.

Excel Templates Using Highest Price in X Minutes

These ready-made MarketXLS templates call RTI_HighestPrice_in_X_Mins() 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_HighestPrice_in_X_Mins 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 Highest Price in X Minutes and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions