Messages In This Digest (9 Messages)
- 1a.
- Extract header From: wu_ming_sg
- 1b.
- Re: Extract header From: Randy Harmelink
- 2a.
- RCHGetTableCell to extract from source code From: wu_ming_sg
- 2b.
- Re: RCHGetTableCell to extract from source code From: Randy Harmelink
- 3a.
- Re: rchcreatecomment From: greenaces555@yahoo.com
- 3b.
- Re: rchcreatecomment From: Randy Harmelink
- 4a.
- Extract text? From: wu_ming_sg
- 4b.
- Re: Extract text? From: Randy Harmelink
- 4c.
- Re: Extract text? From: Hong Chong NG
Messages
- 1a.
-
Extract header
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sun Sep 4, 2011 9:18 am (PDT)
How do I extract the header data from here
<http://investing.businessweek. > ?com/businessweek /research/ stocks/financia\
ls/financials.asp?ticker= APOL:US&dataset= incomeStatement& period=A& curren\
cy=native
example:As of:Aug 31
2007
USDAug 31
2008
Restated
USDAug 31
2009
Restated
USDAug 31
2010
USD4-Year
Trend
I tried
"=RCHGetTableCell("http://investing. businessweek. "&$C$3&"&dataset=com/businessweek /resear\
ch/stocks/financials/financials. asp?ticker= incomeStatem\
ent&period=A¤cy= native",3, ">")" but it gave me the below with the
words closed up.
eg. Dec 312007CNY, Dec 312008RestatedCNY
Is there a beter way?
regards,
- 1b.
-
Re: Extract header
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Sep 4, 2011 9:41 am (PDT)
Sorry, but that's how the add-in is extracting that particular data, because
of the way they are using HTML to present the data.
On Sun, Sep 4, 2011 at 9:18 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> How do I extract the header data from here<http://investing.businessweek. >com/businessweek /research/ stocks/financial s/financials. asp?ticker= APOL:US&dataset= incomeStatement& period=A& currency= native
> ?
>
> example:
> As of:Aug 31
> 2007
> USDAug 31
> 2008
> Restated
> USDAug 31
> 2009
> Restated
> USDAug 31
> 2010
> USD4-Year
> Trend
>
> I tried "=RCHGetTableCell("
> http://investing.businessweek. "&$C$3&"&dataset=com/businessweek /research/ stocks/financial s/financials. asp?ticker= incomeStatement& period=A& currency= native",3, ">")"
> but it gave me the below with the words closed up.
>
> eg. Dec 312007CNY, Dec 312008RestatedCNY
>
> Is there a beter way?
>
- 2a.
-
RCHGetTableCell to extract from source code
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sun Sep 4, 2011 10:08 am (PDT)
How do I use RCHGetTableCell to extract 25.89 % from the below source
code? Its taken off here
<http://investing.businessweek. > .com/research/ stocks/financial s/ratios. asp\
?ticker=APOL:US
I am interested in the ROE.
<td class="top"> <div class="floatL"> <p
class="bold">Return on Equity</p> <div class="smGreyTxt" >Industry
Comparison</div> </div> <div class="floatR"
style="text-align:right; "> <div>25.89%< /div> <div
class="smGreyTxt">Not meaningful</ div> </div> <div
class="clear"></div> </td>
- 2b.
-
Re: RCHGetTableCell to extract from source code
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Sep 4, 2011 10:54 am (PDT)
Using RCHGetTableCell(), you'd need to manually extract the number yourself,
because the table cell contain things other than the number itself. For
example:
=smfStrExtr(RCHGetTableCell( "
http://investing.businessweek. com/research/ stocks/financial s/ratios. asp?ticker= APOL:US
",
0,">Return on Equity"),"Comparison","%")/100
Another option would be to use the smfGetTagContent() function:
=0+smfGetTagContent("
http://investing.businessweek. com/research/ stocks/financial s/ratios. asp?ticker= APOL:US
",
"div",3,">Return on Equity")
On Sun, Sep 4, 2011 at 10:08 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> How do I use RCHGetTableCell to extract 25.89 % from the below source code?
> Its taken off here <http://investing.businessweek. >com/research/ stocks/financial s/ratios. asp?ticker= APOL:US
> .
>
> I am interested in the ROE.
>
> <td class="top">
> <div class="floatL">
> <p class="bold">Return on Equity</p>
> <div class="smGreyTxt">Industry Comparison</ div>
> </div>
> <div class="floatR" style="text-align:right; ">
> <div>25.89%</div>
> <div class="smGreyTxt">Not meaningful</ div>
> </div>
> <div class="clear"></div>
> </td>
>
- 3a.
-
Re: rchcreatecomment
Posted by: "greenaces555@yahoo.com" greenaces555@yahoo.com greenaces555
Sun Sep 4, 2011 10:48 am (PDT)
Does this 99 character limitation apply when using a url shortener such as bit.ly, or does it take the underlying link which has been shortened as the input? Thanks for clarifying.
Sent wirelessly from my BlackBerry device on the Bell network.
Envoyé sans fil par mon terminal mobile BlackBerry sur le réseau de Bell.
-----Original Message-----
From: Hong Chong NG <nghongchong@hotmail.com >
Sender: smf_addin@yahoogroups.com
Date: Sun, 4 Sep 2011 12:14:06
To: <smf_addin@yahoogroups.com >
Reply-To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] rchcreatecomment
Hi,
My apologies, I thought RCHCreateComment() can pull in text and chart as well. Thanks for your clarification.
Instead of displaying the chart as a comment in the sample file RCHCreateComments-Quick-Chart- Review.xls, is it possible to just extract the chart and paste it in the excel file?
Best regards
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Sat, 3 Sep 2011 19:41:13 -0700
Subject: Re: [smf_addin] rchcreatecomment
I'm confused by your subject line, RCHCreateComment(), followed by a
reference to textual data, since the primary purpose of
RCHCreateComment() is to pull in images. It doesn't extract text data from a web page.
The biggest limitation I've found for pulling in an image using RCHCreateComment() is that EXCEL only allows the length of an imported URL to be 99 characters or fewer. The removes the ability for charts that have a number of parameters in the URL. That would apply to the MSN Money extraction you asked about -- all of the parameters to generate the chart are in the URL, so it is longer than 99 bytes. You just extract the data and create your own chart.
Did you search the message archives for other messages about RCHCreateComment()?
The general purpose add-in functions are not limited to Yahoo. Whether the add-in can grab any data, image or text, is dependent on how a web site presents the data. The add-in extracts text from the source code of the web page, so if the data isn't in the original source code of the web page, the add-in can't get to it.
On Sat, Sep 3, 2011 at 6:54 PM, wu_ming_sg <nghongchong@hotmail.com > wrote:
I saw the sample file and was very impressed with the ability to pull the chart off yahoo!
I am very interested in using rchcreatecomment to pull some data off from websites.
1. Is it possible for one to extract Company description from businessweek ? Or from morningstar under "What does this company do"?
Or even from google finance where the description is actually extracted from reuters?
2. Can I pull the "CONSENSUS EPS TREND chart" off msn money as well?
Can this be done on any website or only restricted to Yahoo as shown in file RCHCreateComments-Quick-Chart- Review.xls?
- 3b.
-
Re: rchcreatecomment
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Sep 4, 2011 10:55 am (PDT)
I don't know how EXCEL would handle the URL redirection. I suspect it won't
like it.
On Sun, Sep 4, 2011 at 10:25 AM, <greenaces555@yahoo.com > wrote:
> **
>
> Does this 99 character limitation apply when using a url shortener such as
> bit.ly, or does it take the underlying link which has been shortened as
> the input?
>
- 4a.
-
Extract text?
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sun Sep 4, 2011 2:37 pm (PDT)
Hi,
What is the best way to extract text from here
<http://investing.money.msn. >com/investments/ stock-ratings/ ?symbol=ntes
?
Example:
OWNERSHIPGrade: C
Insider trading information is unavailable or inconsistent.
Shares are neither being accumulated heavily nor sold heavily by
financial institutions. Neutral for a large company like NTES
Regards,
- 4b.
-
Re: Extract text?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Sep 4, 2011 4:38 pm (PDT)
Try something like:
=smfGetTagContent("
http://investing.money.msn. ",com/investments/ stock-ratings/ ?symbol=ntes
"div",1,">Quick Summary",">Ownership")
On Sun, Sep 4, 2011 at 2:37 PM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> What is the best way to extract text from here<http://investing.money.msn. >com/investments/ stock-ratings/ ?symbol=ntes
> ?
>
> Example:
>
> OWNERSHIP
> Grade: C
>
> Insider trading information is unavailable or inconsistent.
>
>
- 4c.
-
Re: Extract text?
Posted by: "Hong Chong NG" nghongchong@hotmail.com wu_ming_sg
Mon Sep 5, 2011 3:18 am (PDT)
How do I get it to extract the text nicely?
Example:OWNERSHIPGrade: CInsider trading information is unavailable or inconsistent. Shares are neither being accumulated heavily nor sold heavily by financial institutions. Neutral for a large company like NTES
I used =smfGetTagContent("http://investing. money.msn. ", "div",2,">Quick Summary",">Ownershicom/investments/ stock-ratings/ ?symbol=ntes p")but got the below text with tags.
"<p>Insider
trading information is unavailable or inconsistent.</p> <p>Shares are neither being
accumulated heavily nor sold heavily by financial institutions.
<B>Neutral</B> for a large company like NTES</p>"
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Sun, 4 Sep 2011 16:38:36 -0700
Subject: Re: [smf_addin] Extract text?
Try something like:
=smfGetTagContent("http://investing. money.msn. ",com/investments/ stock-ratings/ ?symbol=ntes
"div",1,">Quick Summary",">Ownership")
On Sun, Sep 4, 2011 at 2:37 PM, wu_ming_sg <nghongchong@hotmail.com > wrote:
What is the best way to extract text from here ?
Example:
OWNERSHIPGrade: CInsider trading information is unavailable or inconsistent.
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar