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_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
|---|---|---|---|
rtd | OptionListGoogle | ||
rtd | OptionsGoogle | SELECT Code FROM rtd.OptionListGoogle | |
rtd | OptionDayHistoryGoogle | SELECT Code FROM rtd.OptionListGoogle | |
rtd | OptionTickHistoryGoogle | SELECT Code FROM rtd.OptionListGoogle | 1 |
MySQL, MariaDB, and PostgreSQL:
| TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
|---|---|---|---|
rtd | option_list_google | ||
rtd | options_google | SELECT CODE FROM rtd.option_list_google | |
rtd | option_day_history_google | SELECT CODE FROM rtd.option_list_google | |
rtd | option_tick_history_google | SELECT CODE FROM rtd.option_list_google | 1 |
Oracle Database, IBM DB2, and NuoDB:
| TABLE_SCHEMA | TABLE_NAME | LOAD_CODE | IS_HISTORY |
|---|---|---|---|
RTD | OPTION_LIST_GOOGLE | ||
RTD | OPTIONS_GOOGLE | SELECT CODE FROM RTD.OPTION_LIST_GOOGLE | |
RTD | OPTION_DAY_HISTORY_GOOGLE | SELECT CODE FROM RTD.OPTION_LIST_GOOGLE | |
RTD | OPTION_TICK_HISTORY_GOOGLE | SELECT CODE FROM RTD.OPTION_LIST_GOOGLE | 1 |
* 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_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|---|---|
rtd | OptionsGoogle | Code | PK | |
rtd | OptionDayHistoryGoogle | DateTime | =RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"rtd_LastUpdate") | Formula |
rtd | OptionDayHistoryGoogle | Code | PK | |
rtd | OptionDayHistoryGoogle | Date | =RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"rtd_LastUpdateDate") | PK |
rtd | OptionTickHistoryGoogle | ID | PK, IDENTITY |
MySQL, MariaDB, and PostgreSQL:
| TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|---|---|
rtd | options_google | CODE | PK | |
rtd | option_day_history_google | DATETIME | =RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"rtd_LastUpdate") | Formula |
rtd | option_day_history_google | CODE | PK | |
rtd | option_day_history_google | DATE | =RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"rtd_LastUpdateDate") | PK |
rtd | option_tick_history_google | ID | PK, IDENTITY |
Oracle Database, IBM DB2, and NuoDB:
| TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | RTD_FORMULA | COMMENT |
|---|---|---|---|---|
RTD | OPTIONS_GOOGLE | CODE | PK | |
RTD | OPTION_DAY_HISTORY_GOOGLE | DATETIME | =RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"rtd_LastUpdate") | Formula |
RTD | OPTION_DAY_HISTORY_GOOGLE | CODE | PK | |
RTD | OPTION_DAY_HISTORY_GOOGLE | DATE | =RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"rtd_LastUpdateDate") | PK |
RTD | OPTION_TICK_HISTORY_GOOGLE | ID | PK, 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| Code | PK | |
| 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| DateTime | =RTD("gartle.rtd",,"GoogleFinanceOptions",[Code],"rtd_LastUpdate") | Formula |
| Code | PK | |
| 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| ID | PK, 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| CODE | PK | |
| 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| DATETIME | =RTD("gartle.rtd",,"GoogleFinanceOptions",[CODE],"rtd_LastUpdate") | Formula |
| CODE | PK | |
| 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_NAME | RTD_FORMULA | COMMENT |
|---|---|---|
| ID | PK, 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") |