Currencies from Yahoo! Finance

Currencies from Yahoo! Finance

Overview

The RTD database contains preconfigured tables for getting currency rates from Yahoo! Finance using RealTimeToExcel.

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

Yahoo! Finance data are delayed.

Use https://finance.yahoo.com/ to find tickers.

Real-Time Data Tables

Table Configurations

Microsoft SQL Server and Microsoft SQL Server Compact:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
rtdCurrenciesListYahoo
rtdCurrenciesYahooSELECT Code AS Symbol FROM rtd.CurrenciesListYahoo
rtdCurrenciesDayHistoryYahooSELECT Code AS Symbol FROM rtd.CurrenciesListYahoo
rtdCurrenciesTimeHistoryYahooSELECT Code AS Symbol FROM rtd.CurrenciesListYahoo
rtdCurrenciesTickHistoryYahooSELECT Code AS Symbol FROM rtd.CurrenciesListYahoo1

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
rtdcurrencies_list_yahoo
rtdcurrencies_yahooSELECT CODE AS SYMBOL FROM rtd.currencies_list_yahoo
rtdcurrencies_day_history_yahooSELECT CODE AS SYMBOL FROM rtd.currencies_list_yahoo
rtdcurrencies_time_history_yahooSELECT CODE AS SYMBOL FROM rtd.currencies_list_yahoo
rtdcurrencies_tick_history_yahooSELECT CODE AS SYMBOL FROM rtd.currencies_list_yahoo1

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
RTDCURRENCIES_LIST_YAHOO
RTDCURRENCIES_YAHOOSELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_YAHOO
RTDCURRENCIES_DAY_HISTORY_YAHOOSELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_YAHOO
RTDCURRENCIES_TIME_HISTORY_YAHOOSELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_YAHOO
RTDCURRENCIES_TICK_HISTORY_YAHOOSELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_YAHOO1

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

Task Table Examples

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

Code
EURUSD
GBPUSD
USDCAD
AUDUSD
NZDUSD
USDJPY
USDCHF
USDSEK

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

CODE
EURUSD
GBPUSD
USDCAD
AUDUSD
NZDUSD
USDJPY
USDCHF
USDSEK

Use https://finance.yahoo.com/ to find tickers.

Primary Key Columns

Microsoft SQL Server and Microsoft SQL Server Compact:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
rtdCurrenciesYahooSymbol=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Symbol")PK
rtdCurrenciesDayHistoryYahooSymbol=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Symbol")PK
rtdCurrenciesDayHistoryYahooLastTradeDate=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"LastTradeDate")PK
rtdCurrenciesTimeHistoryYahooSymbol=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Symbol")PK
rtdCurrenciesTimeHistoryYahooLastTradeDateTime=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"LastTradeDateTime")PK
rtdCurrenciesTickHistoryYahooIDPK, IDENTITY

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
rtdcurrencies_yahooSYMBOL=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Symbol")PK
rtdcurrencies_day_history_yahooSYMBOL=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Symbol")PK
rtdcurrencies_day_history_yahooLAST_TRADE_DATE=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"LastTradeDate")PK
rtdcurrencies_time_history_yahooSYMBOL=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Symbol")PK
rtdcurrencies_time_history_yahooLAST_TRADE_DATETIME=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"LastTradeDateTime")PK
rtdcurrencies_tick_history_yahooIDPK, IDENTITY

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
RTDCURRENCIES_YAHOOSYMBOL=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Symbol")PK
RTDCURRENCIES_DAY_HISTORY_YAHOOSYMBOL=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Symbol")PK
RTDCURRENCIES_DAY_HISTORY_YAHOOLAST_TRADE_DATE=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"LastTradeDate")PK
RTDCURRENCIES_TICK_HISTORY_YAHOOIDPK, IDENTITY
RTDCURRENCIES_TIME_HISTORY_YAHOOSYMBOL=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Symbol")PK
RTDCURRENCIES_TIME_HISTORY_YAHOOLAST_TRADE_DATETIME=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"LastTradeDateTime")PK

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

rtd.CurrenciesYahoo

The table contains the last data values of currency rates from Yahoo! Finance.

COLUMN_NAMERTD_FORMULACOMMENT
Symbol=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Symbol")PK
LastTradeDateTime=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"LastTradeDateTime")
LastTradeDate=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"LastTradeDate")
LastTradeTime=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"LastTradeTime")
Last=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Last")
Change=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Change")
PercentChange=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"PercentChange")
Open=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Open")
High=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"High")
Low=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Low")
LastUpdateTimeStamp

rtd.CurrenciesDayHistoryYahoo

The table contains day history of currency rates from Yahoo! Finance.

COLUMN_NAMERTD_FORMULACOMMENT
Symbol=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Symbol")PK
LastTradeDate=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"LastTradeDate")PK
LastTradeTime=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"LastTradeTime")
Last=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Last")
Change=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Change")
PercentChange=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"PercentChange")
Open=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Open")
High=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"High")
Low=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Low")
LastUpdateTimeStamp

rtd.CurrenciesTimeHistoryYahoo

The table contains time history of currency rates from Yahoo! Finance.

COLUMN_NAMERTD_FORMULACOMMENT
Symbol=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Symbol")PK
LastTradeDateTime=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"LastTradeDateTime")PK
LastTradeDate=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"LastTradeDate")
LastTradeTime=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"LastTradeTime")
Last=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Last")
Change=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Change")
PercentChange=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"PercentChange")
Open=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Open")
High=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"High")
Low=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Low")
LastUpdateTimeStamp

rtd.CurrenciesTickHistoryYahoo

The table contains tick history of currency rates from Yahoo! Finance.

COLUMN_NAMERTD_FORMULACOMMENT
IDPK, IDENTITY
Symbol=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Symbol")
LastTradeDateTime=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"LastTradeDateTime")
LastTradeDate=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"LastTradeDate")
LastTradeTime=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"LastTradeTime")
Last=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Last")
Change=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Change")
PercentChange=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"PercentChange")
Open=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Open")
High=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"High")
Low=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Low")

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

rtd.currencies_yahoo

The table contains the last data values of currency rates from Yahoo! Finance.

COLUMN_NAMERTD_FORMULACOMMENT
SYMBOL=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Symbol")PK
LAST_TRADE_DATETIME=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"LastTradeDateTime")
LAST_TRADE_DATE=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"LastTradeDate")
LAST_TRADE_TIME=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"LastTradeTime")
LAST=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Last")
CHANGE=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Change")
PERCENT_CHANGE=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"PercentChange")
OPEN=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Open")
HIGH=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"High")
LOW=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Low")
LAST_UPDATE_TIMESTAMP

rtd.currencies_day_history_yahoo

The table contains day history of currency rates from Yahoo! Finance.

COLUMN_NAMERTD_FORMULACOMMENT
SYMBOL=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Symbol")PK
LAST_TRADE_DATE=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"LastTradeDate")PK
LAST_TRADE_TIME=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"LastTradeTime")
LAST=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Last")
CHANGE=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Change")
PERCENT_CHANGE=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"PercentChange")
OPEN=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Open")
HIGH=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"High")
LOW=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Low")
LAST_UPDATE_TIMESTAMP

rtd.currencies_time_history_yahoo

The table contains time history of currency rates from Yahoo! Finance.

COLUMN_NAMERTD_FORMULACOMMENT
SYMBOL=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Symbol")PK
LAST_TRADE_DATETIME=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"LastTradeDateTime")PK
LAST_TRADE_DATE=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"LastTradeDate")
LAST_TRADE_TIME=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"LastTradeTime")
LAST=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Last")
CHANGE=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Change")
PERCENT_CHANGE=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"PercentChange")
OPEN=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Open")
HIGH=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"High")
LOW=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Low")
LAST_UPDATE_TIMESTAMP

rtd.currencies_tick_history_yahoo

The table contains tick history of currency rates from Yahoo! Finance.

COLUMN_NAMERTD_FORMULACOMMENT
IDPK, IDENTITY
SYMBOL=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Symbol")
LAST_TRADE_DATETIME=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"LastTradeDateTime")
LAST_TRADE_DATE=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"LastTradeDate")
LAST_TRADE_TIME=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"LastTradeTime")
LAST=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Last")
CHANGE=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Change")
PERCENT_CHANGE=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"PercentChange")
OPEN=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Open")
HIGH=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"High")
LOW=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Low")
This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.