Quotes from Yahoo! Finance

Quotes from Yahoo! Finance

Overview

The RTD database contains preconfigured tables for getting stock quotes from Yahoo! Finance using RealTimeToExcel.

These data are available and activated by default. Just edit required symbols in the QuoteListYahoo 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
rtdQuoteListYahoo
rtdQuotesYahooSELECT Code AS Symbol FROM rtd.QuoteListYahoo
rtdQuoteDayHistoryYahooSELECT Code AS Symbol FROM rtd.QuoteListYahoo
rtdQuoteTimeHistoryYahooSELECT Code AS Symbol FROM rtd.QuoteListYahoo
rtdQuoteTickHistoryYahooSELECT Code AS Symbol FROM rtd.QuoteListYahoo1

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
rtdquote_list_yahoo
rtdquotes_yahooSELECT CODE AS SYMBOL FROM rtd.quote_list_yahoo
rtdquote_day_history_yahooSELECT CODE AS SYMBOL FROM rtd.quote_list_yahoo
rtdquote_time_history_yahooSELECT CODE AS SYMBOL FROM rtd.quote_list_yahoo
rtdquote_tick_history_yahooSELECT CODE AS SYMBOL FROM rtd.quote_list_yahoo1

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
RTDQUOTE_LIST_YAHOO
RTDQUOTES_YAHOOSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_YAHOO
RTDQUOTE_DAY_HISTORY_YAHOOSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_YAHOO
RTDQUOTE_TIME_HISTORY_YAHOOSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_YAHOO
RTDQUOTE_TICK_HISTORY_YAHOOSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_YAHOO1

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

Task Table Examples

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

Code
AAPL
GOOG

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

CODE
AAPL
GOOG

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

Primary Key Columns

Microsoft SQL Server and Microsoft SQL Server Compact:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
rtdQuotesYahooSymbol=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"Symbol")PK
rtdQuoteDayHistoryYahooSymbol=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"Symbol")PK
rtdQuoteDayHistoryYahooLastTradeDate=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"LastTradeDate")PK
rtdQuoteTimeHistoryYahooSymbol=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"Symbol")PK
rtdQuoteTimeHistoryYahooLastTradeDateTime=RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"LastTradeDateTime")PK
rtdQuoteTickHistoryYahooIDPK, IDENTITY

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
rtdquotes_yahooSYMBOL=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"Symbol")PK
rtdquote_day_history_yahooSYMBOL=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"Symbol")PK
rtdquote_day_history_yahooLAST_TRADE_DATE=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"LastTradeDate")PK
rtdquote_time_history_yahooSYMBOL=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"Symbol")PK
rtdquote_time_history_yahooLAST_TRADE_DATETIME=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"LastTradeDateTime")PK
rtdquote_tick_history_yahooIDPK, IDENTITY

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
RTDQUOTES_YAHOOSYMBOL=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"Symbol")PK
RTDQUOTE_DAY_HISTORY_YAHOOSYMBOL=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"Symbol")PK
RTDQUOTE_DAY_HISTORY_YAHOOLAST_TRADE_DATE=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"LastTradeDate")PK
RTDQUOTE_TICK_HISTORY_YAHOOIDPK, IDENTITY
RTDQUOTE_TIME_HISTORY_YAHOOSYMBOL=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"Symbol")PK
RTDQUOTE_TIME_HISTORY_YAHOOLAST_TRADE_DATETIME=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"LastTradeDateTime")PK

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

rtd.QuotesYahoo

The table contains the last data values of stock quotes from Yahoo! Finance.

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

rtd.QuoteDayHistoryYahoo

The table contains day history of stock quotes from Yahoo! Finance.

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

rtd.QuoteTimeHistoryYahoo

The table contains time history of stock quotes from Yahoo! Finance.

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

rtd.QuoteTickHistoryYahoo

The table contains tick history of stock quotes from Yahoo! Finance.

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

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

rtd.quotes_yahoo

The table contains the last data values of stock quotes from Yahoo! Finance.

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

rtd.quote_day_history_yahoo

The table contains day history of stock quotes from Yahoo! Finance.

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

rtd.quote_time_history_yahoo

The table contains time history of stock quotes from Yahoo! Finance.

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

rtd.quote_tick_history_yahoo

The table contains tick history of stock quotes from Yahoo! Finance.

COLUMN_NAMERTD_FORMULACOMMENT
IDPK, IDENTITY
SYMBOL=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"Symbol")
LAST_TRADE_DATETIME=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"LastTradeDateTime")
LAST_TRADE_DATE=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"LastTradeDate")
LAST_TRADE_TIME=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"LastTradeTime")
LAST=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"Last")
CHANGE=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"Change")
PERCENT_CHANGE=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"ChangeInPercent")
OPEN=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"Open")
HIGH=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"High")
LOW=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"Low")
VOLUME=RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"Volume")