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_SCHEMA	TABLE_NAME	LOAD_CODE	IS_HISTORY
`rtd`	CurrenciesListYahoo
`rtd`	CurrenciesYahoo	`SELECT Code AS Symbol FROM rtd.CurrenciesListYahoo`
`rtd`	CurrenciesDayHistoryYahoo	`SELECT Code AS Symbol FROM rtd.CurrenciesListYahoo`
`rtd`	CurrenciesTimeHistoryYahoo	`SELECT Code AS Symbol FROM rtd.CurrenciesListYahoo`
`rtd`	CurrenciesTickHistoryYahoo	`SELECT Code AS Symbol FROM rtd.CurrenciesListYahoo`	1

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMA	TABLE_NAME	LOAD_CODE	IS_HISTORY
`rtd`	currencies_list_yahoo
`rtd`	currencies_yahoo	`SELECT CODE AS SYMBOL FROM rtd.currencies_list_yahoo`
`rtd`	currencies_day_history_yahoo	`SELECT CODE AS SYMBOL FROM rtd.currencies_list_yahoo`
`rtd`	currencies_time_history_yahoo	`SELECT CODE AS SYMBOL FROM rtd.currencies_list_yahoo`
`rtd`	currencies_tick_history_yahoo	`SELECT CODE AS SYMBOL FROM rtd.currencies_list_yahoo`	1

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMA	TABLE_NAME	LOAD_CODE	IS_HISTORY
`RTD`	CURRENCIES_LIST_YAHOO
`RTD`	CURRENCIES_YAHOO	`SELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_YAHOO`
`RTD`	CURRENCIES_DAY_HISTORY_YAHOO	`SELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_YAHOO`
`RTD`	CURRENCIES_TIME_HISTORY_YAHOO	`SELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_YAHOO`
`RTD`	CURRENCIES_TICK_HISTORY_YAHOO	`SELECT CODE AS SYMBOL FROM RTD.CURRENCIES_LIST_YAHOO`	1

* 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_SCHEMA	TABLE_NAME	COLUMN_NAME	RTD_FORMULA	COMMENT
`rtd`	CurrenciesYahoo	Symbol	`=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Symbol")`	`PK`
`rtd`	CurrenciesDayHistoryYahoo	Symbol	`=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Symbol")`	`PK`
`rtd`	CurrenciesDayHistoryYahoo	LastTradeDate	`=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"LastTradeDate")`	`PK`
`rtd`	CurrenciesTimeHistoryYahoo	Symbol	`=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"Symbol")`	`PK`
`rtd`	CurrenciesTimeHistoryYahoo	LastTradeDateTime	`=RTD("gartle.rtd",,"YahooFinanceCurrencies",[Symbol],"LastTradeDateTime")`	`PK`
`rtd`	CurrenciesTickHistoryYahoo	ID		`PK, IDENTITY`

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	RTD_FORMULA	COMMENT
`rtd`	currencies_yahoo	SYMBOL	`=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Symbol")`	`PK`
`rtd`	currencies_day_history_yahoo	SYMBOL	`=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Symbol")`	`PK`
`rtd`	currencies_day_history_yahoo	LAST_TRADE_DATE	`=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"LastTradeDate")`	`PK`
`rtd`	currencies_time_history_yahoo	SYMBOL	`=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Symbol")`	`PK`
`rtd`	currencies_time_history_yahoo	LAST_TRADE_DATETIME	`=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"LastTradeDateTime")`	`PK`
`rtd`	currencies_tick_history_yahoo	ID		`PK, IDENTITY`

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	RTD_FORMULA	COMMENT
`RTD`	CURRENCIES_YAHOO	SYMBOL	`=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Symbol")`	`PK`
`RTD`	CURRENCIES_DAY_HISTORY_YAHOO	SYMBOL	`=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Symbol")`	`PK`
`RTD`	CURRENCIES_DAY_HISTORY_YAHOO	LAST_TRADE_DATE	`=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"LastTradeDate")`	`PK`
`RTD`	CURRENCIES_TICK_HISTORY_YAHOO	ID		`PK, IDENTITY`
`RTD`	CURRENCIES_TIME_HISTORY_YAHOO	SYMBOL	`=RTD("gartle.rtd",,"YahooFinanceCurrencies",[SYMBOL],"Symbol")`	`PK`
`RTD`	CURRENCIES_TIME_HISTORY_YAHOO	LAST_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_NAME	RTD_FORMULA	COMMENT
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_NAME	RTD_FORMULA	COMMENT
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_NAME	RTD_FORMULA	COMMENT
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_NAME	RTD_FORMULA	COMMENT
ID		`PK, 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_NAME	RTD_FORMULA	COMMENT
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_NAME	RTD_FORMULA	COMMENT
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_NAME	RTD_FORMULA	COMMENT
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_NAME	RTD_FORMULA	COMMENT
ID		`PK, 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")`