Price At Minute

Returns the stock price at a specific time during 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_Price_At_Min("AAPL", "09:30")
Price at market open
=RTI_Price_At_Min("MSFT", "10:00")
Price at 10:00 AM
=RTI_Price_At_Min("SPY", "12:00")
Price at noon

When to Use

  • Look up price at specific time
  • Reference price for calculations
  • Intraday analysis
  • Gap analysis

When NOT to Use

Scenario Use Instead
Price X mins ago RTI_Price_X_Min_Ago()
Change from time RTI_PriceChangeFromMin()
Volume at time RTI_VolumeAtMin()

Common Issues & FAQ

Q: What time format? A: 24-hour format HH:MM (09:30 for open, 16:00 for 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 At Minute and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions