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)

Examples

=RTI_PriceChangeFromMin("AAPL", "09:30")
Change from market open
=RTI_PriceChangeFromMin("MSFT", "10:00")
Change from 10:00 AM
=RTI_PriceChangeFromMin("SPY", "12:00")
Change from noon

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

Q: What time format is used? A: 24-hour format HH:MM (e.g., 09:30 for market open, 16:00 for market close).

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 From Minute and Other Financial Formulas
How does MarketXLS work?