Option Data from Yahoo! Finance

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 http://finance.yahoo.com/ to find option tickers.

Real-Time Data Tables

Table Configurations

Microsoft SQL Server and Microsoft SQL Server Compact:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
rtdOptionListYahoo
rtdOptionsYahooSELECT Code FROM rtd.OptionListYahoo
rtdOptionDayHistoryYahooSELECT Code FROM rtd.OptionListYahoo
rtdOptionTickHistoryYahooSELECT Code FROM rtd.OptionListYahoo1

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
rtdoptions_yahooSELECT CODE FROM rtd.option_list_yahoo
rtdoption_day_history_yahooSELECT CODE FROM rtd.option_list_yahoo
rtdoption_list_yahoo
rtdoption_tick_history_yahooSELECT CODE FROM rtd.option_list_yahoo1

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
RTDOPTION_LIST_YAHOO
RTDOPTIONS_YAHOOSELECT CODE FROM RTD.OPTION_LIST_YAHOO
RTDOPTION_DAY_HISTORY_YAHOOSELECT CODE FROM RTD.OPTION_LIST_YAHOO
RTDOPTION_TICK_HISTORY_YAHOOSELECT CODE FROM RTD.OPTION_LIST_YAHOO1

* 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_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
rtdOptionsYahooCodePK
rtdOptionDayHistoryYahooDateTime=RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"rtd_LastUpdate")Formula
rtdOptionDayHistoryYahooCodePK
rtdOptionDayHistoryYahooDate=RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"rtd_LastUpdateDate")PK
rtdOptionTickHistoryYahooIDPK, IDENTITY

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
rtdoptions_yahooCODEPK
rtdoption_day_history_yahooDATETIME=RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"rtd_LastUpdate")Formula
rtdoption_day_history_yahooCODEPK
rtdoption_day_history_yahooDATE=RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"rtd_LastUpdateDate")PK
rtdoption_tick_history_yahooIDPK, IDENTITY

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
RTDOPTIONS_YAHOOCODEPK
RTDOPTION_DAY_HISTORY_YAHOODATETIME=RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"rtd_LastUpdate")Formula
RTDOPTION_DAY_HISTORY_YAHOOCODEPK
RTDOPTION_DAY_HISTORY_YAHOODATE=RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"rtd_LastUpdateDate")PK
RTDOPTION_TICK_HISTORY_YAHOOIDPK, 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_NAMERTD_FORMULACOMMENT
CodePK
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_NAMERTD_FORMULACOMMENT
DateTime=RTD("gartle.rtd",,"YahooFinanceOptions",[Code],"rtd_LastUpdate")Formula
CodePK
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_NAMERTD_FORMULACOMMENT
IDPK, 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_NAMERTD_FORMULACOMMENT
CODEPK
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_NAMERTD_FORMULACOMMENT
DATETIME=RTD("gartle.rtd",,"YahooFinanceOptions",[CODE],"rtd_LastUpdate")Formula
CODEPK
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_NAMERTD_FORMULACOMMENT
IDPK, 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")