RealTimeToExcel Views for Google Finance
Preconfigured Views
| SQL Server and SQL Server Compact | MySQL, MariaDB, and PostgreSQL | Oracle Database, IBM DB2, and NuoDB |
|---|---|---|
| OptionDayHistoryGoogle | option_day_history_google | OPTION_DAY_HISTORY_GOOGLE |
| OptionsGoogle | options_google | OPTIONS_GOOGLE |
* Click on the view name to go to the view description.
Real-Time Views for Microsoft SQL Server and Microsoft SQL Server Compact
OptionDayHistoryGoogle
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Code | |
| Date | |
| Time | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryGoogle",[Code],[Date],"Time") |
| OptionCode | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryGoogle",[Code],[Date],"OptionCode") |
| Symbol | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryGoogle",[Code],[Date],"Symbol") |
| OptionSymbol | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryGoogle",[Code],[Date],"OptionSymbol") |
| ExpDate | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryGoogle",[Code],[Date],"ExpDate") |
| Strike | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryGoogle",[Code],[Date],"Strike") |
| Type | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryGoogle",[Code],[Date],"Type") |
| Last | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryGoogle",[Code],[Date],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryGoogle",[Code],[Date],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryGoogle",[Code],[Date],"PercentChange") |
| Mark | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryGoogle",[Code],[Date],"Mark") |
| Bid | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryGoogle",[Code],[Date],"Bid") |
| Ask | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryGoogle",[Code],[Date],"Ask") |
| Volume | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryGoogle",[Code],[Date],"Volume") |
| OpenInt | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryGoogle",[Code],[Date],"OpenInt") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryGoogle",[Code],[Date],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mssql","OptionDayHistoryGoogle",[Code],[Date],"RTD_LastMessage") |
OptionsGoogle
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Code | |
| Date | =RTD("gartle.rtd",,"rtd-mssql","OptionsGoogle",[Code],"Date") |
| Time | =RTD("gartle.rtd",,"rtd-mssql","OptionsGoogle",[Code],"Time") |
| OptionCode | =RTD("gartle.rtd",,"rtd-mssql","OptionsGoogle",[Code],"OptionCode") |
| Symbol | =RTD("gartle.rtd",,"rtd-mssql","OptionsGoogle",[Code],"Symbol") |
| OptionSymbol | =RTD("gartle.rtd",,"rtd-mssql","OptionsGoogle",[Code],"OptionSymbol") |
| ExpDate | =RTD("gartle.rtd",,"rtd-mssql","OptionsGoogle",[Code],"ExpDate") |
| Strike | =RTD("gartle.rtd",,"rtd-mssql","OptionsGoogle",[Code],"Strike") |
| Type | =RTD("gartle.rtd",,"rtd-mssql","OptionsGoogle",[Code],"Type") |
| Last | =RTD("gartle.rtd",,"rtd-mssql","OptionsGoogle",[Code],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mssql","OptionsGoogle",[Code],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mssql","OptionsGoogle",[Code],"PercentChange") |
| Mark | =RTD("gartle.rtd",,"rtd-mssql","OptionsGoogle",[Code],"Mark") |
| Bid | =RTD("gartle.rtd",,"rtd-mssql","OptionsGoogle",[Code],"Bid") |
| Ask | =RTD("gartle.rtd",,"rtd-mssql","OptionsGoogle",[Code],"Ask") |
| Volume | =RTD("gartle.rtd",,"rtd-mssql","OptionsGoogle",[Code],"Volume") |
| OpenInt | =RTD("gartle.rtd",,"rtd-mssql","OptionsGoogle",[Code],"OpenInt") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mssql","OptionsGoogle",[Code],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mssql","OptionsGoogle",[Code],"RTD_LastMessage") |
Real-Time Views for MySQL, MariaDB, Oracle Database, IBM DB2, NuoDB, and PostgreSQL
option_day_history_google
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Code | |
| Date | |
| Time | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_google",[Code],[Date],"Time") |
| OptionCode | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_google",[Code],[Date],"OptionCode") |
| Symbol | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_google",[Code],[Date],"Symbol") |
| OptionSymbol | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_google",[Code],[Date],"OptionSymbol") |
| ExpDate | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_google",[Code],[Date],"ExpDate") |
| Strike | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_google",[Code],[Date],"Strike") |
| Type | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_google",[Code],[Date],"Type") |
| Last | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_google",[Code],[Date],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_google",[Code],[Date],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_google",[Code],[Date],"PercentChange") |
| Mark | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_google",[Code],[Date],"Mark") |
| Bid | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_google",[Code],[Date],"Bid") |
| Ask | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_google",[Code],[Date],"Ask") |
| Volume | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_google",[Code],[Date],"Volume") |
| OpenInt | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_google",[Code],[Date],"OpenInt") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_google",[Code],[Date],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mysql","option_day_history_google",[Code],[Date],"RTD_LastMessage") |
options_google
| COLUMN_NAME | EXCEL FORMULA |
|---|---|
| Code | |
| Date | =RTD("gartle.rtd",,"rtd-mysql","options_google",[Code],"Date") |
| Time | =RTD("gartle.rtd",,"rtd-mysql","options_google",[Code],"Time") |
| OptionCode | =RTD("gartle.rtd",,"rtd-mysql","options_google",[Code],"OptionCode") |
| Symbol | =RTD("gartle.rtd",,"rtd-mysql","options_google",[Code],"Symbol") |
| OptionSymbol | =RTD("gartle.rtd",,"rtd-mysql","options_google",[Code],"OptionSymbol") |
| ExpDate | =RTD("gartle.rtd",,"rtd-mysql","options_google",[Code],"ExpDate") |
| Strike | =RTD("gartle.rtd",,"rtd-mysql","options_google",[Code],"Strike") |
| Type | =RTD("gartle.rtd",,"rtd-mysql","options_google",[Code],"Type") |
| Last | =RTD("gartle.rtd",,"rtd-mysql","options_google",[Code],"Last") |
| Change | =RTD("gartle.rtd",,"rtd-mysql","options_google",[Code],"Change") |
| PercentChange | =RTD("gartle.rtd",,"rtd-mysql","options_google",[Code],"PercentChange") |
| Mark | =RTD("gartle.rtd",,"rtd-mysql","options_google",[Code],"Mark") |
| Bid | =RTD("gartle.rtd",,"rtd-mysql","options_google",[Code],"Bid") |
| Ask | =RTD("gartle.rtd",,"rtd-mysql","options_google",[Code],"Ask") |
| Volume | =RTD("gartle.rtd",,"rtd-mysql","options_google",[Code],"Volume") |
| OpenInt | =RTD("gartle.rtd",,"rtd-mysql","options_google",[Code],"OpenInt") |
| LastUpdateTimeStamp | =RTD("gartle.rtd",,"rtd-mysql","options_google",[Code],"LastUpdateTimeStamp") |
| RTD_LastMessage | =RTD("gartle.rtd",,"rtd-mysql","options_google",[Code],"RTD_LastMessage") |