Currencies from MSN Money

Currencies from MSN Money

Overview

The RTD database contains preconfigured tables for getting currency rates from MSN Money using RealTimeToExcel.

These data are available and activated by default. Just edit required symbols in the CurrenciesListMsnMoney table.

MSN Money data are delayed.

Use https://www.msn.com/en-us/money to find tickers.

Real-Time Data Tables

Table Configurations

Microsoft SQL Server and Microsoft SQL Server Compact:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
rtdCurrenciesListMsnMoney
rtdCurrenciesMsnMoneySELECT Code AS Symbol FROM rtd.CurrenciesListMsnMoney
rtdCurrenciesDayHistoryMsnMoneySELECT Code AS Symbol FROM rtd.CurrenciesListMsnMoney
rtdCurrenciesTimeHistoryMsnMoneySELECT Code AS Symbol FROM rtd.CurrenciesListMsnMoney
rtdCurrenciesTickHistoryMsnMoneySELECT Code AS Symbol FROM rtd.CurrenciesListMsnMoney1

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
rtdcurrencies_list_msnmoney
rtdcurrencies_msnmoneySELECT CODE AS SYMBOL FROM rtd.currencies_list_msnmoney
rtdcurrencies_day_history_msnmoneySELECT CODE AS SYMBOL FROM rtd.currencies_list_msnmoney
rtdcurrencies_time_history_msnmoneySELECT CODE AS SYMBOL FROM rtd.currencies_list_msnmoney
rtdcurrencies_tick_history_msnmoneySELECT CODE AS SYMBOL FROM rtd.currencies_list_msnmoney1

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
RTDCURRENCIES_LIST_MSNMONEY
RTDCURRENCIES_MSNMONEYSELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_MSNMONEY
RTDCURRENCIES_DAY_HISTORY_MSNMONEYSELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_MSNMONEY
RTDCURRENCIES_TIME_HISTORY_MSNMONEYSELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_MSNMONEY
RTDCURRENCIES_TICK_HISTORY_MSNMONEYSELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_MSNMONEY1

* Click on the table name to go to the table description.

Task Table Examples

rtd.CurrenciesListMsnMoney for Microsoft SQL Server and Microsoft SQL Server Compact:

Code
EURUSD
GBPUSD
USDCAD
AUDUSD
NZDUSD
USDJPY
USDCHF
USDSEK

rtd.currencies_list_msnmoney for MySQL, MariaDB, Oracle Database, IBM DB2, NuoDB, and PostgreSQL:

CODE
EURUSD
GBPUSD
USDCAD
AUDUSD
NZDUSD
USDJPY
USDCHF
USDSEK

Use https://www.msn.com/en-us/money to find tickers.

Primary Key Columns

Microsoft SQL Server and Microsoft SQL Server Compact:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
rtdCurrenciesMsnMoneySymbol=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Symbol")PK
rtdCurrenciesDayHistoryMsnMoneySymbol=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Symbol")PK
rtdCurrenciesDayHistoryMsnMoneyDate=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"rtd_LastUpdateDate")PK
rtdCurrenciesTimeHistoryMsnMoneySymbol=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Symbol")PK
rtdCurrenciesTimeHistoryMsnMoneyDateTime=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"rtd_LastUpdate")PK
rtdCurrenciesTickHistoryMsnMoneyIDPK, IDENTITY

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
rtdcurrencies_msnmoneySYMBOL=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"Symbol")PK
rtdcurrencies_day_history_msnmoneySYMBOL=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"Symbol")PK
rtdcurrencies_day_history_msnmoneyDATE=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"rtd_LastUpdateDate")PK
rtdcurrencies_time_history_msnmoneySYMBOL=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"Symbol")PK
rtdcurrencies_time_history_msnmoneyDATETIME=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"rtd_LastUpdate")PK
rtdcurrencies_tick_history_msnmoneyIDPK, IDENTITY

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
RTDCURRENCIES_MSNMONEYSYMBOL=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"Symbol")PK
RTDCURRENCIES_DAY_HISTORY_MSNMONEYSYMBOL=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"Symbol")PK
RTDCURRENCIES_DAY_HISTORY_MSNMONEYDATE=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"rtd_LastUpdateDate")PK
RTDCURRENCIES_TICK_HISTORY_MSNMONEYIDPK, IDENTITY
RTDCURRENCIES_TIME_HISTORY_MSNMONEYSYMBOL=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"Symbol")PK
RTDCURRENCIES_TIME_HISTORY_MSNMONEYDATETIME=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"rtd_LastUpdate")PK

Real-Time Formulas for Microsoft SQL Server and Microsoft SQL Server Compact

rtd.CurrenciesMsnMoney

The table contains the last data values of currency rates from MSN Money.

COLUMN_NAMERTD_FORMULACOMMENT
Symbol=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Symbol")PK
DateTime=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"rtd_LastUpdate")
Date=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"rtd_LastUpdateDate")
Time=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"rtd_LastUpdateTime")
Last=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Last")
Change=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Change")
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")
LastUpdateTimeStamp

rtd.CurrenciesDayHistoryMsnMoney

The table contains day history of currency rates from MSN Money.

COLUMN_NAMERTD_FORMULACOMMENT
Symbol=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Symbol")PK
Date=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"rtd_LastUpdateDate")PK
Time=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"rtd_LastUpdateTime")
Last=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Last")
Change=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Change")
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")
LastUpdateTimeStamp

rtd.CurrenciesTimeHistoryMsnMoney

The table contains time history of currency rates from MSN Money.

COLUMN_NAMERTD_FORMULACOMMENT
Symbol=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Symbol")PK
DateTime=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"rtd_LastUpdate")PK
Date=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"rtd_LastUpdateDate")
Time=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"rtd_LastUpdateTime")
Last=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Last")
Change=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Change")
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")
LastUpdateTimeStamp

rtd.CurrenciesTickHistoryMsnMoney

The table contains tick history of currency rates from MSN Money.

COLUMN_NAMERTD_FORMULACOMMENT
IDPK, IDENTITY
Symbol=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Symbol")
DateTime=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"rtd_LastUpdate")
Date=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"rtd_LastUpdateDate")
Time=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"rtd_LastUpdateTime")
Last=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Last")
Change=RTD("gartle.rtd",,"MsnMoneyCurrencies",[Symbol],"Change")
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")

Real-Time Formulas for MySQL, MariaDB, Oracle Database, IBM DB2, NuoDB, and PostgreSQL

rtd.currencies_msnmoney

The table contains the last data values of currency rates from MSN Money.

COLUMN_NAMERTD_FORMULACOMMENT
SYMBOL=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"Symbol")PK
DATETIME=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"rtd_LastUpdate")
DATE=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"rtd_LastUpdateDate")
TIME=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"rtd_LastUpdateTime")
LAST=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"Last")
CHANGE=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"Change")
PERCENT_CHANGE=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")
LAST_UPDATE_TIMESTAMP

rtd.currencies_day_history_msnmoney

The table contains day history of currency rates from MSN Money.

COLUMN_NAMERTD_FORMULACOMMENT
SYMBOL=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"Symbol")PK
DATE=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"rtd_LastUpdateDate")PK
TIME=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"rtd_LastUpdateTime")
LAST=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"Last")
CHANGE=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"Change")
PERCENT_CHANGE=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")
LAST_UPDATE_TIMESTAMP

rtd.currencies_time_history_msnmoney

The table contains time history of currency rates from MSN Money.

COLUMN_NAMERTD_FORMULACOMMENT
SYMBOL=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"Symbol")PK
DATETIME=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"rtd_LastUpdate")PK
DATE=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"rtd_LastUpdateDate")
TIME=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"rtd_LastUpdateTime")
LAST=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"Last")
CHANGE=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"Change")
PERCENT_CHANGE=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")
LAST_UPDATE_TIMESTAMP

rtd.currencies_tick_history_msnmoney

The table contains tick history of currency rates from MSN Money.

COLUMN_NAMERTD_FORMULACOMMENT
IDPK, IDENTITY
SYMBOL=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"Symbol")
DATETIME=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"rtd_LastUpdate")
DATE=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"rtd_LastUpdateDate")
TIME=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"rtd_LastUpdateTime")
LAST=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"Last")
CHANGE=RTD("gartle.rtd",,"MsnMoneyCurrencies",[SYMBOL],"Change")
PERCENT_CHANGE=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")