Option Data from Google Finance

Option Data from Google Finance

Overview

The RTD database contains preconfigured tables for getting option data from Google Finance using RealTimeToExcel.

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

Google Finance data are delayed.

Use https://www.google.com/finance/ to find option tickers.

Real-Time Data Tables

Table Configurations

Microsoft SQL Server and Microsoft SQL Server Compact:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
rtdOptionListGoogle
rtdOptionsGoogleSELECT Code FROM rtd.OptionListGoogle
rtdOptionDayHistoryGoogleSELECT Code FROM rtd.OptionListGoogle
rtdOptionTickHistoryGoogleSELECT Code FROM rtd.OptionListGoogle1

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
rtdoption_list_google
rtdoptions_googleSELECT CODE FROM rtd.option_list_google
rtdoption_day_history_googleSELECT CODE FROM rtd.option_list_google
rtdoption_tick_history_googleSELECT CODE FROM rtd.option_list_google1

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMATABLE_NAMELOAD_CODEIS_HISTORY
RTDOPTION_LIST_GOOGLE
RTDOPTIONS_GOOGLESELECT CODE FROM RTD.OPTION_LIST_GOOGLE
RTDOPTION_DAY_HISTORY_GOOGLESELECT CODE FROM RTD.OPTION_LIST_GOOGLE
RTDOPTION_TICK_HISTORY_GOOGLESELECT CODE FROM RTD.OPTION_LIST_GOOGLE1

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

Task Table Examples

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

Code
.AAPL160115C100
.AAPL160115C200
AAPL160115P00100000
AAPL160115P00200000

rtd.option_list_google for MySQL, MariaDB, Oracle Database, IBM DB2, NuoDB, and PostgreSQL:

CODE
.AAPL160115C100
.AAPL160115C200
AAPL160115P00100000
AAPL160115P00200000

Task tables can contain option codes in thinkDesktop and Google Finance formats as shown above.

The result OptionCode column in data tables contains option codes in Google Finance format.

Primary Key Columns

Microsoft SQL Server and Microsoft SQL Server Compact:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
rtdOptionsGoogleCodePK
rtdOptionDayHistoryGoogleDateTime=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"rtd_LastUpdate")Formula
rtdOptionDayHistoryGoogleCodePK
rtdOptionDayHistoryGoogleDate=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"rtd_LastUpdateDate")PK
rtdOptionTickHistoryGoogleIDPK, IDENTITY

MySQL, MariaDB, and PostgreSQL:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
rtdoptions_googleCODEPK
rtdoption_day_history_googleDATETIME=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"rtd_LastUpdate")Formula
rtdoption_day_history_googleCODEPK
rtdoption_day_history_googleDATE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"rtd_LastUpdateDate")PK
rtdoption_tick_history_googleIDPK, IDENTITY

Oracle Database, IBM DB2, and NuoDB:

TABLE_SCHEMATABLE_NAMECOLUMN_NAMERTD_FORMULACOMMENT
RTDOPTIONS_GOOGLECODEPK
RTDOPTION_DAY_HISTORY_GOOGLEDATETIME=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"rtd_LastUpdate")Formula
RTDOPTION_DAY_HISTORY_GOOGLECODEPK
RTDOPTION_DAY_HISTORY_GOOGLEDATE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"rtd_LastUpdateDate")PK
RTDOPTION_TICK_HISTORY_GOOGLEIDPK, IDENTITY

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

rtd.OptionsGoogle

The table contains the last values of option data from Google Finance.

COLUMN_NAMERTD_FORMULACOMMENT
CodePK
OptionCode=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"OptionCode")
Symbol=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Symbol")
DateTime=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"rtd_LastUpdate")
Date=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"rtd_LastUpdateDate")
Time=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"rtd_LastUpdateTime")
OptionSymbol=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"OptionSymbol")
ExpDate=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Exp")
Strike=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Strike")
Type=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Type")
Last=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Last")
Change=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Change")
PercentChange=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"PercentChange")
Mark=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Mark")
Bid=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Bid")
Ask=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Ask")
Volume=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Volume")
OpenInt=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"OpenInt")
LastUpdateTimeStamp

rtd.OptionDayHistoryGoogle

The table contains day history of option data from Google Finance.

COLUMN_NAMERTD_FORMULACOMMENT
DateTime=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"rtd_LastUpdate")Formula
CodePK
OptionCode=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"OptionCode")
Symbol=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Symbol")
Date=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"rtd_LastUpdateDate")PK
Time=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"rtd_LastUpdateTime")
OptionSymbol=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"OptionSymbol")
ExpDate=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Exp")
Strike=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Strike")
Type=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Type")
Last=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Last")
Change=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Change")
PercentChange=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"PercentChange")
Mark=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Mark")
Bid=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Bid")
Ask=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Ask")
Volume=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Volume")
OpenInt=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"OpenInt")
LastUpdateTimeStamp

rtd.OptionTickHistoryGoogle

The table contains tick history of option data from Google Finance.

COLUMN_NAMERTD_FORMULACOMMENT
IDPK, IDENTITY
Code
OptionCode=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"OptionCode")
Symbol=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Symbol")
DateTime=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"rtd_LastUpdate")
Date=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"rtd_LastUpdateDate")
Time=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"rtd_LastUpdateTime")
OptionSymbol=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"OptionSymbol")
ExpDate=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Exp")
Strike=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Strike")
Type=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Type")
Last=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Last")
Change=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Change")
PercentChange=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"PercentChange")
Mark=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Mark")
Bid=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Bid")
Ask=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Ask")
Volume=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"Volume")
OpenInt=RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"OpenInt")

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

rtd.options_google

The table contains the last values of option data from Google Finance.

COLUMN_NAMERTD_FORMULACOMMENT
CODEPK
OPTION_CODE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"OptionCode")
SYMBOL=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Symbol")
DATETIME=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"rtd_LastUpdate")
DATE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"rtd_LastUpdateDate")
TIME=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"rtd_LastUpdateTime")
OPTION_SYMBOL=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"OptionSymbol")
EXP_DATE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Exp")
STRIKE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Strike")
TYPE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Type")
LAST=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Last")
CHANGE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Change")
PERCENT_CHANGE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"PercentChange")
MARK=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Mark")
BID=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Bid")
ASK=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Ask")
VOLUME=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Volume")
OPEN_INT=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"OpenInt")
LAST_UPDATE_TIMESTAMP

rtd.option_day_history_google

The table contains day history of option data from Google Finance.

COLUMN_NAMERTD_FORMULACOMMENT
DATETIME=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"rtd_LastUpdate")Formula
CODEPK
OPTION_CODE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"OptionCode")
SYMBOL=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Symbol")
DATE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"rtd_LastUpdateDate")PK
TIME=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"rtd_LastUpdateTime")
OPTION_SYMBOL=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"OptionSymbol")
EXP_DATE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Exp")
STRIKE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Strike")
TYPE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Type")
LAST=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Last")
CHANGE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Change")
PERCENT_CHANGE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"PercentChange")
MARK=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Mark")
BID=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Bid")
ASK=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Ask")
VOLUME=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Volume")
OPEN_INT=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"OpenInt")
LAST_UPDATE_TIMESTAMP

rtd.option_tick_history_google

The table contains tick history of option data from Google Finance.

COLUMN_NAMERTD_FORMULACOMMENT
IDPK, IDENTITY
CODE
OPTION_CODE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"OptionCode")
SYMBOL=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Symbol")
DATETIME=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"rtd_LastUpdate")
DATE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"rtd_LastUpdateDate")
TIME=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"rtd_LastUpdateTime")
OPTION_SYMBOL=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"OptionSymbol")
EXP_DATE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Exp")
STRIKE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Strike")
TYPE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Type")
LAST=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Last")
CHANGE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Change")
PERCENT_CHANGE=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"PercentChange")
MARK=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Mark")
BID=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Bid")
ASK=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Ask")
VOLUME=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"Volume")
OPEN_INT=RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"OpenInt")