Access MSN Money Intraday Prices in Excel

Overview

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

It supports 1-minute, 5-minute, and 15-minute timeframes, providing detailed insights into market movements throughout the trading day.

Available Providers:

• MsnMoneyIntradayPrices1m – 1-minute intervals
• MsnMoneyIntradayPrices5m – 5-minute intervals
• MsnMoneyIntradayPrices15m – 15-minute intervals

Use the following RTD formulas to retrieve data:

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

Examples:

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

Parameters:

• <Symbol>: The MSN instrument code.
• <DateTime>: An Excel date or a yyyy-mm-dd hh:mm:ss string.
• <Data Field>: One of the available data fields (see list below).

How to Find MSN Symbols

1. Visit MSN Money.
2. Search for a stock (e.g., Apple Inc.).
3. Copy the ID after fi-, such as a1mou2, from the URL:

https://www.msn.com/en-us/money/stockdetails/nas-aapl/fi-a1mou2

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",,"MsnMoneyIntradayPrices1m","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 get the N-th most recent intraday point and build charts with consistent spacing or simulate walk-forward logic.

Data Fields and Excel Formulas

Aggregate Functions

Trading Days