Jump to content

Google Docs


Munger_Disciple

Recommended Posts

The GoogleFinance function doesn't support options the last I checked (at least it did not support the options I cared about). But you can get around this by importing the value from yahoo. Here is an example:

 

To get the current price of the WFC Jan 2011 $35 put:

=Value(Substitute(Index(importHTML("http://finance.yahoo.com/q?s=WFC110122P00035000";"table";1),1,2),"*",""))

 

 

Link to comment
Share on other sites

Sreenr,

 

Thanks for asking the question. I would like to pull up the warrants and this looks like the best way to do it.

 

Treasurehunt,

 

How did you figure this out? Is there a guide somewhere or just programming knowledge? How about the syntax of pulling data out of a webpage like that?

 

Thanks in advance!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...