3 New Messages

Digest #2548

Re: few question of extracting data from multiple sources by "Randy Harmelink" rharmelink

Re: few question of extracting data from multiple sources by "weekeewawa" weekeewawa

error in Effective Tax Rate 5 Year Average by "weekeewawa" weekeewawa

Messages

1a

Re: few question of extracting data from multiple sources

Fri Mar 15, 2013 10:14 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

What did you try? I can't spoon-feed every extraction formula everyone
needs. Then no one learns how to do it themselves.

"Market Pulse" is not a table, so it would not be a trivial extraction.

For the rest of (1) and (2), you can try some permutations of parameters on
the smfGetTagContent-Quick-Webpage-Examination.xls workbook -- it has a
table extraction template page. But, just as an example:

=RCHGetHTMLTable("http://finance.yahoo.com/marketpulse/"&A1,">Trending
Tickers",1,"",1)

Items (3) and (4) can be found in the message archives of the Yahoo Group
if you do a search.

On Fri, Mar 15, 2013 at 9:16 PM, weekeewawa <weekeewawa@yahoo.com> wrote:

> hi, i have a few problems in extract data from certain yahoo sources
>
> how do i extract the table data from
>
> 1) http://finance.yahoo.com/marketpulse/IBM
>
> ''Market Pulse for IBM'' and ''Trending Tickers on Market Pulse'' tables?
>
> 2) http://biz.yahoo.com/ic/l/pip.html
> ''Leaders in Price Performance (Intraday)'' and ''Laggards in Price
> Performance (Intraday)'' data?
>
> 3) http://finance.yahoo.com/q/h?s=IBM+Headlines
> where i can extract headlines data to the excel sheet
>
> 4) http://finance.yahoo.com/q/co?s=IBM+Competitors
> where ''Computer Hardware (US) Ranked by Sales'' table may vary depending
> on the industry such as for perhaps GM, it will show ''Auto (US) Ranked By
> Sales
>
> and i would like to point the ticker to a specific cell A1 instead of IBM
>

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

1b

Re: few question of extracting data from multiple sources

Sat Mar 16, 2013 12:04 am (PDT) . Posted by:

"weekeewawa" weekeewawa

i am trying to combined the market pulse latest updates and the news into one worksheet so as to receive the latest up to date news for it

it just seems the documentation at times seems fuzzy

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> What did you try? I can't spoon-feed every extraction formula everyone
> needs. Then no one learns how to do it themselves.
>
> "Market Pulse" is not a table, so it would not be a trivial extraction.
>
> For the rest of (1) and (2), you can try some permutations of parameters on
> the smfGetTagContent-Quick-Webpage-Examination.xls workbook -- it has a
> table extraction template page. But, just as an example:
>
> =RCHGetHTMLTable("http://finance.yahoo.com/marketpulse/"&A1,">Trending
> Tickers",1,"",1)
>
> Items (3) and (4) can be found in the message archives of the Yahoo Group
> if you do a search.
>
> On Fri, Mar 15, 2013 at 9:16 PM, weekeewawa <weekeewawa@...> wrote:
>
> > hi, i have a few problems in extract data from certain yahoo sources
> >
> > how do i extract the table data from
> >
> > 1) http://finance.yahoo.com/marketpulse/IBM
> >
> > ''Market Pulse for IBM'' and ''Trending Tickers on Market Pulse'' tables?
> >
> > 2) http://biz.yahoo.com/ic/l/pip.html
> > ''Leaders in Price Performance (Intraday)'' and ''Laggards in Price
> > Performance (Intraday)'' data?
> >
> > 3) http://finance.yahoo.com/q/h?s=IBM+Headlines
> > where i can extract headlines data to the excel sheet
> >
> > 4) http://finance.yahoo.com/q/co?s=IBM+Competitors
> > where ''Computer Hardware (US) Ranked by Sales'' table may vary depending
> > on the industry such as for perhaps GM, it will show ''Auto (US) Ranked By
> > Sales
> >
> > and i would like to point the ticker to a specific cell A1 instead of IBM
> >
>

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

2 error in Effective Tax Rate 5 Year Average

Sat Mar 16, 2013 12:18 am (PDT) . Posted by:

"weekeewawa" weekeewawa

hi,

as i was inputting reuters Effective Tax Rate 5 Year Average, it seems that there is error shown on Effective Tax Rate 5 Year Average (company,industry,sector and S&P500)

could the rch element of 13774-13777 be invalid?

thanks