Access Live MSN Money Quotes in Excel
Overview
The MsnMoneyQuotes provider delivers live market quotes and related trading data from MSN Money for a wide range of global financial instruments.
It supports:
- Last price, open, high, low
- Bid/ask prices and sizes
- Volume, market cap, change, and percent change
Use this RTD formula to retrieve values into Excel:
=RTD("market.rtd",,"MsnMoneyQuotes","<Symbol>","<Data Field>")
Example:
=RTD("market.rtd",,"MsnMoneyQuotes","a1mou2","Last")
Here:
<Symbol>is the MSN instrument code<Data Field>is one of the available data fields (see the list below)
How to Find MSN Symbols
- Visit MSN Money.
- Search for a stock (e.g., Apple Inc.).
- Copy the ID after
fi-, such asa1mou2, from the URL:
https://www.msn.com/en-us/money/stockdetails/nas-aapl/fi-a1mou2
Use the Formula Builder to quickly generate Excel formulas and adjust separators or layout preferences.
By default, the refresh interval is set to 15 minutes. You can change it using the following formula:
=RTD("market.rtd",,"MsnMoneyQuotes","rtd_RefreshInterval",15*60)
Tip: This provider is a valuable complement to Yahoo Finance, especially for international or hard-to-find instruments.
Data Fields and Excel Formulas
| Data Field | Excel Formula |
|---|---|
| Symbol | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"Symbol") |
| price | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"price") |
| priceChange | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"priceChange") |
| priceDayHigh | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"priceDayHigh") |
| priceDayLow | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"priceDayLow") |
| timeLastTraded | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"timeLastTraded") |
| priceDayOpen | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"priceDayOpen") |
| pricePreviousClose | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"pricePreviousClose") |
| datePreviousClose | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"datePreviousClose") |
| priceAsk | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"priceAsk") |
| askSize | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"askSize") |
| priceBid | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"priceBid") |
| bidSize | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"bidSize") |
| accumulatedVolume | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"accumulatedVolume") |
| averageVolume | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"averageVolume") |
| peRatio | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"peRatio") |
| priceChangePercent | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"priceChangePercent") |
| price52wHigh | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"price52wHigh") |
| price52wLow | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"price52wLow") |
| pricePostMarket | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"pricePostMarket") |
| priceChangePostMarket | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"priceChangePostMarket") |
| priceChangePostMarketPercent | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"priceChangePostMarketPercent") |
| pricePreMarket | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"pricePreMarket") |
| priceChangePreMarket | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"priceChangePreMarket") |
| priceChangePreMarketPercent | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"priceChangePreMarketPercent") |
| priceClose | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"priceClose") |
| yieldPercent | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"yieldPercent") |
| priceChange1Week | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"priceChange1Week") |
| priceChange1Month | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"priceChange1Month") |
| priceChange3Month | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"priceChange3Month") |
| priceChange6Month | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"priceChange6Month") |
| priceChangeYTD | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"priceChangeYTD") |
| priceChange1Year | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"priceChange1Year") |
| return1Week | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"return1Week") |
| return1Month | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"return1Month") |
| return3Month | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"return3Month") |
| return6Month | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"return6Month") |
| returnYTD | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"returnYTD") |
| return1Year | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"return1Year") |
| sourceExchangeCode | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"sourceExchangeCode") |
| sourceExchangeName | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"sourceExchangeName") |
| icon | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"icon") |
| preMarketTradeTime | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"preMarketTradeTime") |
| postMarketTradeTime | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"postMarketTradeTime") |
| marketCap | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"marketCap") |
| marketCapCurrency | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"marketCapCurrency") |
| exchangeId | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"exchangeId") |
| exchangeCode | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"exchangeCode") |
| exchangeName | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"exchangeName") |
| offeringStatus | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"offeringStatus") |
| displayName | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"displayName") |
| shortName | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"shortName") |
| securityType | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"securityType") |
| instrumentId | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"instrumentId") |
| country | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"country") |
| market | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"market") |
| localizedAttributes_en-us_displayName | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"localizedAttributes_en-us_displayName") |
| timeLastUpdated | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"timeLastUpdated") |
| currency | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"currency") |
| _p | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"_p") |
| id | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"id") |
| _t | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"_t") |
| RTD server values: | |
| rtd_LastUpdate | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastUpdate") |
| rtd_LastUpdateDate | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastUpdateDate") |
| rtd_LastUpdateTime | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastUpdateTime") |
| rtd_LastError | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastError") |
| rtd_LastMessage | =RTD("market.rtd",,"MsnMoneyQuotes",[Symbol],"rtd_LastMessage") |