2 Messages

Digest #3031

Google option quotes by sheydon

Re: Google option quotes by "Randy Harmelink" rharmelink

Messages

1a

With the recent (and overly complex) Google stock split, I can no longer get option quotes on Google.

I'm using the smfGetOptionQuotes function and it used to work, but now doesn't. Here's my specific formula:

=smfGetOptionQuotes("GOOG 1/15 2016 900. Call", "a", 0, "G")

Also, on a related note, assuming I can get this working, what symbols should one use for all the various classes of Google stock and regular versus mini's? Here are the various symbols I see on the NASDQ website, but not sure which options they map to:
GOOG
GOOG7
GOOGL
GOLG1
GOLG8

Thanks in advance. Couldn't live without this tool :)

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: Google option quotes

Thu Apr 3, 2014 5:13 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's because Google currently has no option chains available for GOOG (or
IWM).

Currently, only the Yahoo data source is set up to allow the non-standard
contracts. And they are identified by a numeric suffix on the ticker symbol.

On Thu, Apr 3, 2014 at 4:59 PM, <scott.heydon.tu97@alum.dartmouth.org>wrote:

>
> With the recent (and overly complex) Google stock split, I can no longer
> get option quotes on Google.
>
> I'm using the smfGetOptionQuotes function and it used to work, but now
> doesn't. Here's my specific formula:
>
> =smfGetOptionQuotes("GOOG 1/15 2016 900. Call", "a", 0, "G")
>
> Also, on a related note, assuming I can get this working, what symbols
> should one use for all the various classes of Google stock and regular
> versus mini's? Here are the various symbols I see on the NASDQ website,
> but not sure which options they map to:
> GOOG
> GOOG7
> GOOGL
> GOLG1
> GOLG8
>
> Thanks in advance. Couldn't live without this tool :)
>