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)Examples
=RTI_PriceChangePct_X_Min_Ago("AAPL", 5)=RTI_PriceChangePct_X_Min_Ago("MSFT", 15)=RTI_PriceChangePct_X_Min_Ago("SPY", 30)=RTI_PriceChangePct_X_Min_Ago(A1, 60)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
Q: Why am I getting NA? A: Check that:
- Market is currently open
- MinutesAgo doesn't exceed available intraday data
- Symbol is valid and trading
Q: What time range is supported? A: Typically supports looking back within the current trading day.
Q: Is this real-time data? A: Yes, this uses real-time intraday data.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?