Price Change From Minute
Returns the absolute price change from a specific time of the trading day.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| Symbol | string | Yes | Stock ticker symbol |
| Time | string | Yes | Time in HH:MM format (24-hour) |
Syntax
=RTI_PriceChangeFromMin(Symbol, Time)Parameters
symbolstringRequired
Stock ticker symbol
timestringRequired
Time in HH:MM format
Returns
number
Price change from specified time
Examples
=RTI_PriceChangeFromMin("AAPL", "09:30")=RTI_PriceChangeFromMin("MSFT", "10:00")=RTI_PriceChangeFromMin("SPY", "12:00")When to Use
- Track change from market open
- Monitor intraday price movements
- Specific time-based analysis
- Day trading metrics
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Change from X mins ago | RTI_PriceChange_X_Min_Ago() |
| Percentage change | RTI_PriceChangePctFromMin() |
| Price at specific time | RTI_PriceAtMin() |
Common Issues & FAQ
What time format is used?
24-hour format HH:MM (e.g., 09:30 for market open, 16:00 for market close).
Related Formulas
More MarketXLS MarketXLS Analytics formulas you can use in the same worksheet:
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?