Access Yahoo Finance Intraday Prices in Excel

Overview

The YahooFinanceIntradayPrices family of data providers loads OHLCV intraday price data from Yahoo Finance directly into Microsoft Excel.

It supports timeframes from 1 minute to 60 minutes, offering detailed insights into market movements throughout the trading day.

Available Providers

• YahooFinanceIntradayPrices1m – 1-minute intervals
• YahooFinanceIntradayPrices5m – 5-minute intervals
• YahooFinanceIntradayPrices15m – 15-minute intervals
• YahooFinanceIntradayPrices30m – 30-minute intervals
• YahooFinanceIntradayPrices60m – 60-minute intervals

RTD Formulas

Use the following RTD formulas to retrieve data:

=RTD("market.rtd",,"YahooFinanceIntradayPrices1m","<Symbol>",[<DateTime>],"<Data Field>")

Examples:

=RTD("market.rtd",,"YahooFinanceIntradayPrices1m","AAPL","2024-12-31 10:00:00","Close")
=RTD("market.rtd",,"YahooFinanceIntradayPrices1m","AAPL",,"Close")

• <Symbol>: A stock or ETF ticker, such as AAPL
• <DateTime>: An Excel date or a yyyy-mm-dd hh:mm:ss string
• <Data Field>: The name of the data column (e.g., Close, Volume)

If DateTime is omitted or set to 0, the formula returns the most recent available value.

Use the Formula Builder to simplify formula generation and layout options.

By default, data refreshes at the interval defined by the data provider (e.g., every minute). To customize the refresh rate, use:

=RTD("market.rtd",,"YahooFinanceIntradayPrices1m","rtd_RefreshInterval",60)

Notes on Calculated Fields

• AverageVolume returns the average intraday volume for the specified number of past periods.
  This helps evaluate current volume activity relative to recent historical averages.

• TradingDay enables retrieval of intraday timestamps by index, starting from the latest.
  You can use it to obtain the N-th most recent intraday point, allowing for consistent chart spacing or simulating walk-forward logic.

Data Fields and Excel Formulas

Aggregate Functions

Trading Days