MSN Money Quotes2

MSN Money Quotes2

Usage

Excel formula:

=RTD("gartle.rtd",,"MsnMoneyQuotes2","<Ticker>","<Data Field>")

Example:

=RTD("gartle.rtd",,"MsnMoneyQuotes2","MSFT","Last")

Use http://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 may get data for any stock or ETF available on MSN like this:

Data Fields and Excel Formulas

Excel ColumnExcel 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.

See Data provider settings.

ParameterValue
RefreshInterval00:15:00, 15 minutes
NextRequestDelay1000, one second
DataStartTime00:00:00 -05:00
DataEndTime24:00:00 -05:00
LoadEndTime24:00:00 -05:00
LoadOnSaturday1, loading Friday's data once.
LoadOnSunday1, loading Friday's data once.

Data Source

MSN Money web services