MarketXLS

Price Change Percent X Minutes Ago

Returns the percentage price change from X minutes ago compared to the current price. This function is useful for intraday momentum analysis and tracking short-term price movements.

Parameters

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

Notes

  • Returns percentage as decimal (0.01 = 1%)
  • Data is based on intraday price data
  • Only available during market hours

Syntax

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

Parameters

symbolstringRequired

Stock ticker symbol

minutesAgonumberRequired

Number of minutes ago to compare

Returns

number

Price change percentage from X minutes ago

Examples

=RTI_PriceChangePct_X_Min_Ago("AAPL", 5)
Price change % from 5 minutes ago
=RTI_PriceChangePct_X_Min_Ago("MSFT", 15)
Price change % from 15 minutes ago
=RTI_PriceChangePct_X_Min_Ago("SPY", 30)
Price change % from 30 minutes ago
=RTI_PriceChangePct_X_Min_Ago(A1, 60)
Price change % from 1 hour ago

When to Use

  • Intraday momentum analysis
  • Short-term price change tracking
  • Building intraday trading dashboards
  • Monitoring quick price movements
  • Scalping and day trading analysis

When NOT to Use

Scenario Use Instead
Need absolute price change RTI_PriceChange_X_Min_Ago()
Need price at specific time RTI_Price_X_Min_Ago()
Need daily percentage change Change() or ChangePercent()
Need historical daily change Close_Historical()

Common Issues & FAQ

Why am I getting NA?

Check that:

  • Market is currently open
  • MinutesAgo doesn't exceed available intraday data
  • Symbol is valid and trading

What time range is supported?

Typically supports looking back within the current trading day.

Is this real-time data?

Yes, this uses real-time intraday data.

Excel Templates Using Price Change Percent X Minutes Ago

These ready-made MarketXLS templates call RTI_PriceChangePct_X_Min_Ago() 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_PriceChangePct_X_Min_Ago 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 Price Change Percent X Minutes Ago and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions