MarketXLS

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)

Syntax

=RTI_Price_At_Min(Symbol, Time)
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

timestringRequired

Time in HH:MM format

Returns

number

Price at the specified time

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

What time format?

24-hour format HH:MM (09:30 for open, 16:00 for close).

Excel Templates Using Price At Minute

These ready-made MarketXLS templates call RTI_Price_At_Min() 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:

See RTI_Price_At_Min 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
MarketXLS Excel Add-in Tutorial - How to Use Price At Minute and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions