MSN Money Currencies

MSN Money Currencies

Usage

Excel formula:

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

Example:

=RTD("gartle.rtd",,"MsnMoneyCurrencies","EUR/USD","Last")

You may get the data for currencies listed at http://www.msn.com/en-us/money/currencyconverter.

Supported ticker formats, on the EURUSD pair example:

EURUSD, UER/USD, EUR-USD, EUR_USD, EURUSD=X

You may get these codes using the Symbol1 - Symbol5 columns.

Data Fields and Excel Formulas

Excel ColumnExcel Formula
Symbol 
LastTradeDateTime=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"LastTradeDateTime")
LastTradeDate=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"LastTradeDate")
LastTradeTime=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"LastTradeTime")
Last=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Last")
Change=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Change")
ChangeInPercent=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"ChangeInPercent")
ChangePercent=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"ChangePercent")
PercentChange=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"PercentChange")
Open=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Open")
High=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"High")
Low=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Low")
Symbol1=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Symbol1")
Symbol2=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Symbol2")
Symbol3=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Symbol3")
Symbol4=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Symbol4")
Symbol5=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Symbol5")
rtd_LastError=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"rtd_LastError")
rtd_LastMessage=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"rtd_LastMessage")
rtd_LastUpdate=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"rtd_LastUpdate")
rtd_LastUpdateDate=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"rtd_LastUpdateDate")
rtd_LastUpdateTime=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"rtd_LastUpdateTime")

Synonyms: ChangeInPercent, ChangePercent, and PercentChange.

See Copying formulas about inserting formulas into Excel spreadsheets.

The ChangeInPercent value is calculated by RealTimeToExcel.

Data Provider Settings

The data provider is configured to loading data every 5 minutes when the Excel workbook is open.

See Data provider settings.

ParameterValue
RefreshInterval00:05:00, 5 minutes
NextRequestDelay1000, one second
DataStartTime00:00:00 -05:00
DataEndTime24:00:00 -05:00
LoadEndTime24:00:00 -05:00
LoadOnSaturday0, loading as for other days.
LoadOnSunday0, loading as for other days.

Data Source

http://www.msn.com/en-us/money/currencyconverter