MSN Money Currencies
Usage
Excel formula:
=RTD("gartle.rtd",,"MsnMoneyCurrencies","<Ticker>","<Data Field>")
Example:
=RTD("gartle.rtd",,"MsnMoneyCurrencies","EUR/USD","Last")
You can get the data for currencies listed at https://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 can get these codes using the Symbol1 - Symbol5 columns.
Data Fields and Excel Formulas
| Excel Column | Excel 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.
| Parameter | Value |
|---|---|
| RefreshInterval | 00:05:00, 5 minutes |
| NextRequestDelay | 1000, one second |
| DataStartTime | 00:00:00 -05:00 |
| DataEndTime | 24:00:00 -05:00 |
| LoadEndTime | 24:00:00 -05:00 |
| LoadOnSaturday | 0, loading as for other days. |
| LoadOnSunday | 0, loading as for other days. |
Data Source
https://www.msn.com/en-us/money/currencyconverter