Option Data from Yahoo! Finance
Overview
The RTD database contains preconfigured tables for getting option data from Yahoo! Finance using RealTimeToExcel.
These data are available and activated by default. Just edit required symbols in the OptionListYahoo table.
Yahoo! Finance data are delayed.
Use https://finance.yahoo.com/ to find option tickers.
Real-Time Data Tables
Table Configurations
Microsoft SQL Server and Microsoft SQL Server Compact:
| TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
|---|---|---|---|
rtd | OptionListYahoo | ||
rtd | OptionsYahoo | SELECT Code FROM rtd.OptionListYahoo | |
rtd | OptionDayHistoryYahoo | SELECT Code FROM rtd.OptionListYahoo | |
rtd | OptionTickHistoryYahoo | SELECT Code FROM rtd.OptionListYahoo | 1 |
MySQL, MariaDB, and PostgreSQL:
| TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
|---|---|---|---|
rtd | options_yahoo | SELECT CODE FROM rtd.option_list_yahoo | |
rtd | option_day_history_yahoo | SELECT CODE FROM rtd.option_list_yahoo | |
rtd | option_list_yahoo | ||
rtd | option_tick_history_yahoo | SELECT CODE FROM rtd.option_list_yahoo | 1 |
Oracle Database, IBM DB2, and NuoDB:
| TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
|---|---|---|---|
RTD | OPTION_LIST_YAHOO | ||
RTD | OPTIONS_YAHOO | SELECT CODE FROM RTD.OPTION_LIST_YAHOO | |
RTD | OPTION_DAY_HISTORY_YAHOO | SELECT CODE FROM RTD.OPTION_LIST_YAHOO | |
RTD | OPTION_TICK_HISTORY_YAHOO | SELECT CODE FROM RTD.OPTION_LIST_YAHOO | 1 |
* Click on the table name to go to the table description.
Task Table Examples
rtd.OptionListYahoo for Microsoft SQL Server and Microsoft SQL Server Compact:
| Code |
|---|
| .AAPL160115C100 |
| .AAPL160115C200 |
| AAPL160115P00100000 |
| AAPL160115P00200000 |
rtd.option_list_yahoo for MySQL, MariaDB, Oracle Database, IBM DB2, NuoDB, and PostgreSQL:
| CODE |
|---|
| .AAPL160115C100 |
| .AAPL160115C200 |
| AAPL160115P00100000 |
| AAPL160115P00200000 |
Task tables can contain option codes in thinkDesktop and Yahoo! Finance formats as shown above.
The result OptionCode column in data tables contains option codes in Yahoo! Finance format.
Primary Key Columns
Microsoft SQL Server and Microsoft SQL Server Compact:
| TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|---|---|
rtd | OptionsYahoo | Code | PK | |
rtd | OptionDayHistoryYahoo | DateTime | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"rtd_LastUpdate") | Formula |
rtd | OptionDayHistoryYahoo | Code | PK | |
rtd | OptionDayHistoryYahoo | Date | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"rtd_LastUpdateDate") | PK |
rtd | OptionTickHistoryYahoo | ID | PK, IDENTITY |
MySQL, MariaDB, and PostgreSQL:
| TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|---|---|
rtd | options_yahoo | CODE | PK | |
rtd | option_day_history_yahoo | DATETIME | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"rtd_LastUpdate") | Formula |
rtd | option_day_history_yahoo | CODE | PK | |
rtd | option_day_history_yahoo | DATE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"rtd_LastUpdateDate") | PK |
rtd | option_tick_history_yahoo | ID | PK, IDENTITY |
Oracle Database, IBM DB2, and NuoDB:
| TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|---|---|
RTD | OPTIONS_YAHOO | CODE | PK | |
RTD | OPTION_DAY_HISTORY_YAHOO | DATETIME | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"rtd_LastUpdate") | Formula |
RTD | OPTION_DAY_HISTORY_YAHOO | CODE | PK | |
RTD | OPTION_DAY_HISTORY_YAHOO | DATE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"rtd_LastUpdateDate") | PK |
RTD | OPTION_TICK_HISTORY_YAHOO | ID | PK, IDENTITY |
Real-Time Formulas for Microsoft SQL Server and Microsoft SQL Server Compact
rtd.OptionsYahoo
The table contains the last values of option data from Yahoo! Finance.
| COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| Code | PK | |
| OptionCode | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"OptionCode") | |
| Symbol | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Symbol") | |
| DateTime | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"rtd_LastUpdate") | |
| Date | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"rtd_LastUpdateDate") | |
| Time | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"rtd_LastUpdateTime") | |
| OptionSymbol | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"OptionSymbol") | |
| ExpDate | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Exp") | |
| Strike | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Strike") | |
| Type | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Type") | |
| Last | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Last") | |
| Change | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Change") | |
| PercentChange | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"ChangeInPercent") | |
| Mark | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Mark") | |
| Bid | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Bid") | |
| Ask | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Ask") | |
| Volume | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Volume") | |
| OpenInt | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"OpenInt") | |
| ImpliedVol | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"ImpliedVol") | |
| LastUpdateTimeStamp |
rtd.OptionDayHistoryYahoo
The table contains day history of option data from Yahoo! Finance.
| COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| DateTime | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"rtd_LastUpdate") | Formula |
| Code | PK | |
| OptionCode | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"OptionCode") | |
| Symbol | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Symbol") | |
| Date | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"rtd_LastUpdateDate") | PK |
| Time | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"rtd_LastUpdateTime") | |
| OptionSymbol | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"OptionSymbol") | |
| ExpDate | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Exp") | |
| Strike | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Strike") | |
| Type | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Type") | |
| Last | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Last") | |
| Change | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Change") | |
| PercentChange | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"ChangeInPercent") | |
| Mark | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Mark") | |
| Bid | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Bid") | |
| Ask | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Ask") | |
| Volume | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Volume") | |
| OpenInt | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"OpenInt") | |
| ImpliedVol | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"ImpliedVol") | |
| LastUpdateTimeStamp |
rtd.OptionTickHistoryYahoo
The table contains tick history of option data from Yahoo! Finance.
| COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| ID | PK, IDENTITY | |
| Code | ||
| OptionCode | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"OptionCode") | |
| Symbol | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Symbol") | |
| DateTime | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"rtd_LastUpdate") | |
| Date | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"rtd_LastUpdateDate") | |
| Time | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"rtd_LastUpdateTime") | |
| OptionSymbol | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"OptionSymbol") | |
| ExpDate | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Exp") | |
| Strike | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Strike") | |
| Type | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Type") | |
| Last | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Last") | |
| Change | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Change") | |
| PercentChange | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"ChangeInPercent") | |
| Mark | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Mark") | |
| Bid | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Bid") | |
| Ask | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Ask") | |
| Volume | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"Volume") | |
| OpenInt | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"OpenInt") | |
| ImpliedVol | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"ImpliedVol") |
Real-Time Formulas for MySQL, MariaDB, Oracle Database, IBM DB2, NuoDB, and PostgreSQL
rtd.options_yahoo
The table contains the last values of option data from Yahoo! Finance.
| COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| CODE | PK | |
| OPTION_CODE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"OptionCode") | |
| SYMBOL | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Symbol") | |
| DATETIME | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"rtd_LastUpdate") | |
| DATE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"rtd_LastUpdateDate") | |
| TIME | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"rtd_LastUpdateTime") | |
| OPTION_SYMBOL | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"OptionSymbol") | |
| EXP_DATE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Exp") | |
| STRIKE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Strike") | |
| TYPE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Type") | |
| LAST | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Last") | |
| CHANGE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Change") | |
| PERCENT_CHANGE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"ChangeInPercent") | |
| MARK | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Mark") | |
| BID | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Bid") | |
| ASK | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Ask") | |
| VOLUME | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Volume") | |
| OPEN_INT | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"OpenInt") | |
| IMPLIED_VOL | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"ImpliedVol") | |
| LAST_UPDATE_TIMESTAMP |
rtd.option_day_history_yahoo
The table contains day history of option data from Yahoo! Finance.
| COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| DATETIME | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"rtd_LastUpdate") | Formula |
| CODE | PK | |
| OPTION_CODE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"OptionCode") | |
| SYMBOL | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Symbol") | |
| DATE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"rtd_LastUpdateDate") | PK |
| TIME | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"rtd_LastUpdateTime") | |
| OPTION_SYMBOL | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"OptionSymbol") | |
| EXP_DATE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Exp") | |
| STRIKE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Strike") | |
| TYPE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Type") | |
| LAST | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Last") | |
| CHANGE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Change") | |
| PERCENT_CHANGE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"ChangeInPercent") | |
| MARK | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Mark") | |
| BID | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Bid") | |
| ASK | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Ask") | |
| VOLUME | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Volume") | |
| OPEN_INT | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"OpenInt") | |
| IMPLIED_VOL | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"ImpliedVol") | |
| LAST_UPDATE_TIMESTAMP |
rtd.option_tick_history_yahoo
The table contains tick history of option data from Yahoo! Finance.
| COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| ID | PK, IDENTITY | |
| CODE | ||
| OPTION_CODE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"OptionCode") | |
| SYMBOL | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Symbol") | |
| DATETIME | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"rtd_LastUpdate") | |
| DATE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"rtd_LastUpdateDate") | |
| TIME | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"rtd_LastUpdateTime") | |
| OPTION_SYMBOL | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"OptionSymbol") | |
| EXP_DATE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Exp") | |
| STRIKE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Strike") | |
| TYPE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Type") | |
| LAST | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Last") | |
| CHANGE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Change") | |
| PERCENT_CHANGE | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"ChangeInPercent") | |
| MARK | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Mark") | |
| BID | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Bid") | |
| ASK | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Ask") | |
| VOLUME | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"Volume") | |
| OPEN_INT | =RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"OpenInt") | |
| IMPLIED_VOL | =RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"ImpliedVol") |