MSN Money Quotes2
Usage
Excel formula:
=RTD("gartle.rtd",,"MsnMoneyQuotes2","<Ticker>","<Data Field>")
Example:
=RTD("gartle.rtd",,"MsnMoneyQuotes2","MSFT","Last")
Use https://www.msn.com/en-us/money to find tickers.
Unlike the MsnMoneyQuotes provider, this provider allows using MSN codes to get data like 151.1.GLEN.LON.
So, you can get data for any stock or ETF available on MSN like this:
Data Fields and Excel Formulas
| Excel Column | Excel Formula |
|---|---|
| Symbol | |
| Symbol | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Symbol") |
| MSN Symbol | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"MSN Symbol") |
| Company Name | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Company Name") |
| Short Name | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Short Name") |
| Stock Exchange | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Stock Exchange") |
| Market | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Market") |
| Currency | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Currency") |
| Type | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Type") |
| TimeZone | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"TimeZone") |
| UTC Offset | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"UTC Offset") |
| Last Trade Date | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Last Trade Date") |
| Last Trade Time | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Last Trade Time") |
| Last Trade DateTime | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Last Trade DateTime") |
| Bid | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Bid") |
| Ask | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Ask") |
| Bid Size | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Bid Size") |
| Ask Size | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Ask Size") |
| BidX | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"BidX") |
| AskX | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"AskX") |
| Last | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Last") |
| Change | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Change") |
| Change In Percent | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Change In Percent") |
| Open | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Open") |
| High | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"High") |
| Low | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Low") |
| Volume | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Volume") |
| Previous Close | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Previous Close") |
| Days Range | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Days Range") |
| 52-Week High | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"52-Week High") |
| 52-Week Low | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"52-Week Low") |
| 52-Week Range | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"52-Week Range") |
| Change from 52-Week High | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Change from 52-Week High") |
| Change from 52-Week Low | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Change from 52-Week Low") |
| % Change from 52-Week High | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"% Change from 52-Week High") |
| % Change from 52-Week Low | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"% Change from 52-Week Low") |
| Average Daily Volume | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Average Daily Volume") |
| Market Cap | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Market Cap") |
| P/E | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"P/E") |
| Dividend/Share | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Dividend/Share") |
| Dividend Yield | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"Dividend Yield") |
| rtd_LastError | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"rtd_LastError") |
| rtd_LastMessage | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"rtd_LastMessage") |
| rtd_LastUpdate | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"rtd_LastUpdate") |
| rtd_LastUpdateDate | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"rtd_LastUpdateDate") |
| rtd_LastUpdateTime | =RTD("gartle.rtd",,"MsnMoneyQuotes2",[Symbol],"rtd_LastUpdateTime") |
See Copying formulas about inserting formulas into Excel spreadsheets.
Data Provider Settings
The data provider is configured to loading data every 15 minutes when the Excel workbook is open.
| Parameter | Value |
|---|---|
| RefreshInterval | 00:15:00, 15 minutes |
| NextRequestDelay | 1000, one second |
| DataStartTime | 00:00:00 -05:00 |
| DataEndTime | 24:00:00 -05:00 |
| LoadEndTime | 24:00:00 -05:00 |
| LoadOnSaturday | 1, loading Friday's data once. |
| LoadOnSunday | 1, loading Friday's data once. |
Data Source
MSN Money web services