3 Messages

Digest #3117

Marketwatch Valuation Extraction by ridgebacksexcel

Re: Marketwatch Valuation Extraction by "Randy Harmelink" rharmelink

Re: Marketwatch Valuation Extraction by ridgebacksexcel

Messages

1a

Marketwatch Valuation Extraction

Fri Jul 11, 2014 6:59 am (PDT) . Posted by:

ridgebacksexcel

Randy,

I would like to extract the data from the Valuation section of Marketwatch for AAPL for instance.
Here is the page URL:

http://www.marketwatch.com/investing/stock/aapl/profile http://www.marketwatch.com/investing/stock/aapl/profile

Under the Valuation header for instance, what is the best formula to get:
Enterprise Value to EBITDA

Also this page seems to have the same data. Would the formula work on this one as well?

http://quotes.wsj.com/AAPL/financials/Ratios http://quotes.wsj.com/AAPL/financials/Ratios

Thanks.

Tom.

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

1b

Re: Marketwatch Valuation Extraction

Fri Jul 11, 2014 9:03 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Both are pretty straight-forward:

=smfConvertData(smfGetTagContent("
http://www.marketwatch.com/investing/stock/aapl/profile",
"p",1,">Enterprise Value to EBITDA"))

=RCHGetTableCell("http://quotes.wsj.com/AAPL/financials/Ratios",1,">Enterprise
Value to EBITDA")

But you do need to look at the source code of the web page to find out
which function to use and what the best search strings will be.

On Fri, Jul 11, 2014 at 6:59 AM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I would like to extract the data from the Valuation section of
> Marketwatch for AAPL for instance.
>
> Here is the page URL:
>
> http://www.marketwatch.com/investing/stock/aapl/profile
>
> Under the Valuation header for instance, what is the best formula to get:
>
> Enterprise Value to EBITDA
>
> Also this page seems to have the same data. Would the formula work on this
> one as well?
>
> http://quotes.wsj.com/AAPL/financials/Ratios
>
>