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_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
|---|---|---|---|
rtd | QuoteListYahoo | ||
rtd | QuotesYahoo | SELECT Code AS Symbol FROM rtd.QuoteListYahoo | |
rtd | QuoteDayHistoryYahoo | SELECT Code AS Symbol FROM rtd.QuoteListYahoo | |
rtd | QuoteTimeHistoryYahoo | SELECT Code AS Symbol FROM rtd.QuoteListYahoo | |
rtd | QuoteTickHistoryYahoo | SELECT Code AS Symbol FROM rtd.QuoteListYahoo | 1 |
MySQL, MariaDB, and PostgreSQL:
| TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
|---|---|---|---|
rtd | quote_list_yahoo | ||
rtd | quotes_yahoo | SELECT CODE AS SYMBOL FROM rtd.quote_list_yahoo | |
rtd | quote_day_history_yahoo | SELECT CODE AS SYMBOL FROM rtd.quote_list_yahoo | |
rtd | quote_time_history_yahoo | SELECT CODE AS SYMBOL FROM rtd.quote_list_yahoo | |
rtd | quote_tick_history_yahoo | SELECT CODE AS SYMBOL FROM rtd.quote_list_yahoo | 1 |
Oracle Database, IBM DB2, and NuoDB:
| TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
|---|---|---|---|
RTD | QUOTE_LIST_YAHOO | ||
RTD | QUOTES_YAHOO | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_YAHOO | |
RTD | QUOTE_DAY_HISTORY_YAHOO | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_YAHOO | |
RTD | QUOTE_TIME_HISTORY_YAHOO | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_YAHOO | |
RTD | QUOTE_TICK_HISTORY_YAHOO | SELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_YAHOO | 1 |
* 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_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|---|---|
rtd | QuotesYahoo | Symbol | =RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"Symbol") | PK |
rtd | QuoteDayHistoryYahoo | Symbol | =RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"Symbol") | PK |
rtd | QuoteDayHistoryYahoo | LastTradeDate | =RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"LastTradeDate") | PK |
rtd | QuoteTimeHistoryYahoo | Symbol | =RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"Symbol") | PK |
rtd | QuoteTimeHistoryYahoo | LastTradeDateTime | =RTD("gartle.rtd",,"YahooFinanceWatchList",[Symbol],"LastTradeDateTime") | PK |
rtd | QuoteTickHistoryYahoo | ID | PK, IDENTITY |
MySQL, MariaDB, and PostgreSQL:
| TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|---|---|
rtd | quotes_yahoo | SYMBOL | =RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"Symbol") | PK |
rtd | quote_day_history_yahoo | SYMBOL | =RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"Symbol") | PK |
rtd | quote_day_history_yahoo | LAST_TRADE_DATE | =RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"LastTradeDate") | PK |
rtd | quote_time_history_yahoo | SYMBOL | =RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"Symbol") | PK |
rtd | quote_time_history_yahoo | LAST_TRADE_DATETIME | =RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"LastTradeDateTime") | PK |
rtd | quote_tick_history_yahoo | ID | PK, IDENTITY |
Oracle Database, IBM DB2, and NuoDB:
| TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|---|---|
RTD | QUOTES_YAHOO | SYMBOL | =RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"Symbol") | PK |
RTD | QUOTE_DAY_HISTORY_YAHOO | SYMBOL | =RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"Symbol") | PK |
RTD | QUOTE_DAY_HISTORY_YAHOO | LAST_TRADE_DATE | =RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"LastTradeDate") | PK |
RTD | QUOTE_TICK_HISTORY_YAHOO | ID | PK, IDENTITY | |
RTD | QUOTE_TIME_HISTORY_YAHOO | SYMBOL | =RTD("gartle.rtd",,"YahooFinanceWatchList",[SYMBOL],"Symbol") | PK |
RTD | QUOTE_TIME_HISTORY_YAHOO | LAST_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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| ID | PK, 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| ID | PK, 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") |