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

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

Q: What's the maximum lookback? A: Typically limited to current trading day data.

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