Google Docs

[Munger_Disciple]

I am trying to include stock option price in Google Docs. I know Google Docs supports stock prices, but I am not sure if it supports option symbols.

 

TIA for your help.

[Munger_Disciple]

Any ideas?

[treasurehunt]

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),"*",""))

 

 

[Munger_Disciple]

Thanks treasurehunt! I will try it out.

[Grenville]

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!