Stock Data from Yahoo! Finance

Stock Data from Yahoo! Finance

Overview

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

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

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
rtdStocksYahooSELECT Code AS Symbol FROM rtd.QuoteListStocks

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
rtdstocks_yahooSELECT CODE AS SYMBOL FROM rtd.quote_list_stocks

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
RTDSTOCKS_YAHOOSELECT CODE AS SYMBOL FROM RTD.QUOTE_LIST_STOCKS

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

Task Table Examples

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

Code
AAPL
GOOG

quote_list_stocks 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
rtdStocksYahooSymbolPK

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
rtdstocks_yahooSYMBOLPK

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
RTDSTOCKS_YAHOOSYMBOLPK

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

rtd.StocksYahoo

The table contains stock data from Yahoo! Finance.

COLUMN_NAMERTD_FORMULACOMMENT
SymbolPK
CompanyName=RTD("gartle.rtd",,"YahooFinanceStocks",[Symbol],"CompanyName")
Sector=RTD("gartle.rtd",,"YahooFinanceStocks",[Symbol],"Sector")
Industry=RTD("gartle.rtd",,"YahooFinanceStocks",[Symbol],"Industry")
FullTimeEmployees=RTD("gartle.rtd",,"YahooFinanceStocks",[Symbol],"FullTimeEmployees")
TradeStart=RTD("gartle.rtd",,"YahooFinanceStocks",[Symbol],"Start")
TradeEnd=RTD("gartle.rtd",,"YahooFinanceStocks",[Symbol],"End")
LastUpdateTimeStamp

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

The table contains stock data from Yahoo! Finance.

rtd.stocks_yahoo

COLUMN_NAMERTD_FORMULACOMMENT
SYMBOLPK
COMPANY_NAME=RTD("gartle.rtd",,"YahooFinanceStocks",[SYMBOL],"CompanyName")
SECTOR=RTD("gartle.rtd",,"YahooFinanceStocks",[SYMBOL],"Sector")
INDUSTRY=RTD("gartle.rtd",,"YahooFinanceStocks",[SYMBOL],"Industry")
FULLTIME_EMPLOYEES=RTD("gartle.rtd",,"YahooFinanceStocks",[SYMBOL],"FullTimeEmployees")
TRADE_START=RTD("gartle.rtd",,"YahooFinanceStocks",[SYMBOL],"Start")
TRADE_END=RTD("gartle.rtd",,"YahooFinanceStocks",[SYMBOL],"End")
LAST_UPDATE_TIMESTAMP