--
You received this message because you are subscribed to the Google Groups "Google Finance" group.
To post to this group, send email to google-...@googlegroups.com.
To unsubscribe from this group, send email to google-financ...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-finance?hl=en.
=index ( importhtml("http://finance.yahoo.com/q?s=GE160115C00025000","table",0),3,2)
I know this is a few years late, but I ran into this same problem today. Google has not yet updated the GoogleFinance call to work for options. For those new people searching for a solution, I have found a relatively simple work-around using ImportHTML:=index ( importhtml("http://finance.yahoo.com/q?s=GE160115C00025000","table",0),3,2)GE160115C00025000 is the option ticker for the Jan 16, 2015 call on GE with a strike of 25. The 3 and 2 reference row and column, respectively, in table 0...the bid price in this case. Change those values if you want other table data.
Using a round about way I was also able to extract the delta and theta values from nasdaq.com's options page. Let me know if want to know how to do that. It's not pretty but at least works.
On Thursday, April 14, 2011 3:21:43 PM UTC-5, Marlin Cobb wrote:
Glad it helped out. The formula is still working for me as well. It should continue until Yahoo changes the page layout. Then, we'll just have to play around with the row/table until it works again.
I gave up on the Nasdaq version of the formula. It worked for a few weeks and then Nasdaq must have changed something on the website to break it.
From: Brian Sherman Sent: Tuesday, August 1, 2017 11:36 PM To: Google Finance Reply To: google-...@googlegroups.com Subject: Re: Options Quotes using =googleFinance("") on google spreadsheet |
The formula seems to work most of the time. There are certainly times when marketwatch.com has incomplete options chains, but even when they're complete, I've had sporadic issues that I've yet to be able to troubleshoot.
--
You received this message because you are subscribed to the Google Groups "Google Finance" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-financ...@googlegroups.com.
To post to this group, send email to google-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-finance/f46c3012-2080-462c-962c-b0ef2ef19a1b%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-finance/CAJ-1-22pBoiDWd1ju_U0B_RKNJVtWsm_%2Bs8GFna2Uy1uOmUCmw%40mail.gmail.com.