RealTimeToExcel Views for Google Finance

RealTimeToExcel Views for Google Finance

Preconfigured Views

SQL Server and SQL Server CompactMySQL, MariaDB, and PostgreSQLOracle Database, IBM DB2, and NuoDB
OptionDayHistoryGoogleoption_day_history_googleOPTION_DAY_HISTORY_GOOGLE
OptionsGoogleoptions_googleOPTIONS_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_NAMEEXCEL 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_NAMEEXCEL 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_NAMEEXCEL 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_NAMEEXCEL 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")
This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.