Google Finance Options - Market RTD Documentation

Important Notice
The GoogleFinanceOptions provider is no longer functional due to changes on the Google Finance website.
Google has discontinued access to options data through this method.

Please use the working alternative:
• Yahoo Finance Options

This provider offers real-time option quotes and full OCC-style support directly in Excel.

Overview

The GoogleFinanceOptions provider previously offered access to real-time options data from Google Finance.

Use the following generic RTD formula:

=RTD("market.rtd",,"GoogleFinanceOptions","<Option Symbol>","<Data Field>")

Example:

=RTD("market.rtd",,"GoogleFinanceOptions","AAPL260116C00200000","Last")

In this example, <Option Symbol> is a full OCC-style option symbol (e.g., AAPL260116C00200000), and <Data Field> is one of the supported fields listed below.

To find option symbols, use https://www.google.com/finance/.

Use the Formula Builder to generate and copy formulas into Excel. It also allows you to customize separators and layout settings.

By default, the refresh interval is six hours. You can modify it using the following formula:

=RTD("market.rtd",,"GoogleFinanceOptions","rtd_RefreshInterval",66060)

Note that Market RTD loads one page to retrieve data for all options of the month.

Option Part Formats

Option code format:

[.]<Option Symbol><Expiration Date><Option Type Char><Strike>

Expiration date format: yymmdd
Option type char: C or P

Strike formats:

• 8 digits with leading zero as strike — 1000
• 7 digits with leading zero as strike — 100
• 6 digits with leading zero as strike — 10
• Strike as is, with or without decimal part (common format)

Examples:

=RTD("market.rtd",,"GoogleFinanceOptions","YHOO170120C00050000","OpenInt")
=RTD("market.rtd",,"GoogleFinanceOptions","YHOO170120C00050","OpenInt")
=RTD("market.rtd",,"GoogleFinanceOptions","YHOO170120C50","OpenInt")
=RTD("market.rtd",,"GoogleFinanceOptions","YHOO170120C50.0","OpenInt")
=RTD("market.rtd",,"GoogleFinanceOptions",".YHOO170120C50.0","OpenInt")

The last formula uses the thinkorswim format.

To find options, visit https://www.google.com/finance/.

Note: Options data is available for US exchanges and may not be available for other global exchanges.

Using Option Specifications

Excel formula format:

=RTD("market.rtd",,"GoogleFinanceOptions","<Symbol>", <Expiration Date>, <Strike>, "<Option Type>", "<Data Field>")

Expiration date formats:

• yymmdd
• yyyy-mm-dd
• mmmdd,yy
• mmmdd'yy

Option type format: C or CALL, P or PUT

Examples:

=RTD("market.rtd",,"GoogleFinanceOptions","YHOO", "170120", 50, "CALL","OpenInt")
=RTD("market.rtd",,"GoogleFinanceOptions","YHOO", "2017-01-20", 50, "C","OpenInt")
=RTD("market.rtd",,"GoogleFinanceOptions","YHOO", "JAN20,17", 50, "PUT","OpenInt")
=RTD("market.rtd",,"GoogleFinanceOptions","YHOO", "JAN20'17", 50, "P","OpenInt")

Special Notes

• Symbol, OptionSymbol, Exp, Strike, and Type are parsed automatically from the option code.
• OptionCode follows the standard OCC format.
• OptionSymbol ends with 7 for mini options and with 1 for some pre-split options.
• ChangeInPercent, ChangePercent, and Percent are equivalent and calculated by Market RTD.
• Mark is calculated as (Bid + Ask) / 2.

To assist with filtering and lookup:

• Use Strike~0 to find the ATM strike.
• Use Strike+0 or Strike-0 to find equal or nearest strikes.
• Use Strike+1 and Strike-1 to find strikes just above or below.

Data Fields and Excel Formulas

Formulas for getting data by option codes:

Data Fields and Excel Formulas by Option Contract Specifications