1 Message

Digest #3022

Re: businessweek data by "Randy Harmelink" rharmelink

Message

1a

I'm not sure what to tell you. I copied and pasted both of your formulas
and they both worked fine for me.

I would go with a simpler version of the formula, and pick up the ticker
cell from a worksheet cell. For example:

=RCHGetTableCell("
http://investing.businessweek.com/research/stocks/financials/pensions.asp?ticker="&C27,1,"options
outstanding")

On Wed, Mar 26, 2014 at 5:35 PM, <navelhunt@yahoo.com> wrote:

> I use your formula to successfully get some stock option data from
> businessweek:
> =rchgettablecell("
> http://investing.businessweek.com/research/stocks/financials/pensions.asp?ticker=AMAG",1,"W/avg.
> Exercise price of options outstanding",,,,0,0,0,0)
> will result in the number 21.31
> However, replacing the ticker with another one will result in an error, or
> 0 in this case.
> =rchgettablecell("
> http://investing.businessweek.com/research/stocks/financials/pensions.asp?ticker=GILD",1,"W/avg.
> Exercise price of options outstanding",,,,0,0,0,0)
> I dont quite know what is wrong here since the actual website shows that
> the number 19.34 should come up with this formula.
> Is there some other way to retrieve this number from that page? Any
> thoughts why one works and the other one doesnt?
>