Pulling options prices from Yahoo

In order to have the option price update live on my “Position Summary” tab I have had to pull it from yahoo finance. The GoogleFinance function does not support option prices. I have used the bid price – the actual realisable price may be somewhere between the bid and the ask but the bid is fine for my purposes here. The formula I used in the cell is…

=Index(importHTML(“http://finance.yahoo.com/q?s=CHTP120218C00005000”; “table”;2),3,2)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s