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_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
|---|---|---|---|
rtd | StocksYahoo | SELECT Code AS Symbol FROM rtd.QuoteListStocks |
MySQL, MariaDB, and PostgreSQL:
| TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
|---|---|---|---|
rtd | stocks_yahoo | SELECT CODE AS SYMBOL FROM rtd.quote_list_stocks |
Oracle Database, IBM DB2, and NuoDB:
| TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
|---|---|---|---|
RTD | STOCKS_YAHOO | SELECT 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_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|---|---|
rtd | StocksYahoo | Symbol | PK |
MySQL, MariaDB, and PostgreSQL:
| TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|---|---|
rtd | stocks_yahoo | SYMBOL | PK |
Oracle Database, IBM DB2, and NuoDB:
| TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|---|---|
RTD | STOCKS_YAHOO | SYMBOL | PK |
Real-Time Formulas for Microsoft SQL Server and Microsoft SQL Server Compact
rtd.StocksYahoo
The table contains stock data from Yahoo! Finance.
| COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| Symbol | PK | |
| 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| SYMBOL | PK | |
| 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 |