2 Messages

Digest #3268

Executive Comp by infinityholdings@ymail.com

Re: Executive Comp by "Randy Harmelink" rharmelink

Messages

1a

Randy
Could you help me capture the table for "key executives" that provides compensation from yahoofinance:
ZMH Profile | Zimmer Holdings, Inc. Common St Stock - Yahoo! Finance https://finance.yahoo.com/q/pr?s=ZMH+Profile

ZMH Profile | Zimmer Holdings, Inc. Common St Stock - Yahoo! Finance https://finance.yahoo.com/q/pr?s=ZMH+Profile See the company profile for Zimmer Holdings, Inc. Common St (ZMH) including business summary, industry/sector information, number of employees, business summary, corporate governance, key executives and their compensation.

View on finance.yahoo.com https://finance.yahoo.com/q/pr?s=ZMH+Profile
Preview by Yahoo

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: Executive Comp

Wed Dec 17, 2014 1:38 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=RCHGetHTMLTable("https://finance.yahoo.com/q/pr?s=ZMH
",">Exercised",-1,"",1)

More detailed data can be gotten from MorningStar:

=RCHGetHTMLTable("
http://insiders.morningstar.com/trading/executive-compensation-list.action?t=ZMH
","",1,"<script>",-1)

Or, by individual:

=RCHGetHTMLTable("
http://insiders.morningstar.com/trading/executive-compensation-list.action?t=ZMH
","",I2,"",I3)

-- For the headers, set I2 and I3 to 1.
-- For the overall summary, set I2 and I3 to 2.
-- For the breakdown of the overall summary, set I2 and I3 to 3.
-- For individual executive summaries, set I2 and I3 to 4, 6, 8, ...
-- For breakdown of the individual executive summaries, set I2 and I3 to 5,
7, 9, ...

On Wed, Dec 17, 2014 at 11:52 AM, coons_adam@... wrote:
>
>
> Could you help me capture the table for "key executives" that provides
> compensation from yahoofinance:
>
> ZMH Profile | Zimmer Holdings, Inc. Common St Stock - Yahoo! Finance
> <https://finance.yahoo.com/q/pr?s=ZMH+Profile>
>
>