Price X Min Ago
Returns the stock price from X minutes ago.
Syntax
=RTI_Price_X_Min_Ago(Symbol, MinutesAgo)Parameters
symbolstringRequired
minutesAgonumberRequired
Examples
=RTI_Price_X_Min_Ago("AAPL", 30)When to Use
- Reference price lookup
- Intraday analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Change calculation | RTI_PriceChange_X_Min_Ago() |
Excel Templates Using Price X Min Ago
These ready-made MarketXLS templates call RTI_Price_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:
- Profit Margin (Continuous)
- Quote Date
- Real-Time Intraday Close
- Real-Time Intraday High
- Real-Time Intraday Last
- Real-Time Intraday Low
- Real-Time Intraday Open
- Real-Time Intraday RSI
See RTI_Price_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
▶
How does MarketXLS work?