Messages In This Digest (17 Messages)
- 1a.
- Re: How to insert new element numbers? From: Randy Harmelink
- 2a.
- rchcreatecomment From: wu_ming_sg
- 2b.
- Re: rchcreatecomment From: Randy Harmelink
- 2c.
- Re: rchcreatecomment From: Hong Chong NG
- 2d.
- Re: rchcreatecomment From: Randy Harmelink
- 3a.
- Outsource From: wu_ming_sg
- 3b.
- Re: Outsource From: Randy Harmelink
- 3c.
- Re: Outsource From: Hong Chong NG
- 3d.
- Re: Outsource From: Randy Harmelink
- 3e.
- Re: Outsource From: wu_ming_sg
- 3f.
- Re: Outsource From: Randy Harmelink
- 4a.
- morningstar From: wu_ming_sg
- 4b.
- Re: morningstar From: Randy Harmelink
- 4c.
- Re: morningstar From: Hong Chong NG
- 4d.
- Re: morningstar From: Randy Harmelink
- 5a.
- Extracting CONSENSUS EPS TREND from msn money From: wu_ming_sg
- 5b.
- Re: Extracting CONSENSUS EPS TREND from msn money From: Randy Harmelink
Messages
- 1a.
-
Re: How to insert new element numbers?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Sep 3, 2011 8:59 am (PDT)
See the RCHGetTableCell-Template- Reuters-Analysts .xls for the
RCHGetTableCell() functions to get the data.
See item 9.3.1 of the "Links" area of the group for info on adding your own
element numbers.
On Sat, Sep 3, 2011 at 1:47 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> I am using an example file "SMF-Template-Reuters-Ratios- Comparison. xls'<http://f1.grp. yahoofs.com/ >v1/gN5hTrNWWD_ 7GdOw2c407mOPKjQ R_EO76fsi4BQORvq mBivNxvijWVo6tCs vWeBIgvVSe1ve- ChGOkTX_5m8wyqEo w4UM4pXuw/ Templates% 20and%20Examples /SMF-Template- Reuters-Ratios- Comparison. xls
> ".
> I would like to include the "REVENUES" and "CONCENSUS ESTIMATES ANALYSIS"
> into the file.
>
> You can see them here ,
> http://www.reuters.com/finance/ <http://www.reuters.stocks/financial Highlights? symbol=NTES. O com/finance/ >stocks/financial Highlights? symbol=NTES. O
>
>
> How to I insert new element numbers to achieve this or can I just use
> RCHGetTableCell function ?
>
>
- 2a.
-
rchcreatecomment
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sat Sep 3, 2011 6:54 pm (PDT)
Hi,
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
<http://investing.businessweek. > ? Or from morningstarcom/research/ stocks/snapshot/ snapshot. asp\
?ticker=NTES:US
<http://quicktake.morningstar. >com/stocknet/ printreport. aspx?symbol= ntes
under "What does this company do"? Or even from google finance
<http://www.google.com/finance? > where the description is actually extractedchdnp=1&chdd= 1&chds=1& chdv=1&chvs= maximiz\
ed&chdeh=0&chfdeh=0&chdet=13150972 17392&chddm= 46920&chddi= 86400&chls= Can\
dleStick&q=NASDAQ:NTES&
from reuters?
2. Can I pull the "CONSENSUS EPS TREND chart" off msn money
<http://investing.money.msn. > as well?com/investments/ earnings- estimates? symbol=nt\
es
Can this be done on any website or only restricted to Yahoo as shown in
file RCHCreateComments-Quick-Chart- Review.xls?
Best regards,
- 2b.
-
Re: rchcreatecomment
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Sep 3, 2011 7:41 pm (PDT)
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<http://investing.businessweek. >com/research/ stocks/snapshot/ snapshot. asp?ticker= NTES:US
> ?
> Or from morningstar<http://quicktake.morningstar. > under "Whatcom/stocknet/ printreport. aspx?symbol= ntes
> does this company do"?
> Or even from google finance<http://www.google.com/finance? >chdnp=1&chdd= 1&chds=1& chdv=1&chvs= maximized& chdeh=0&chfdeh= 0&chdet=13150972 17392&chddm= 46920&chddi= 86400&chls= CandleStick& q=NASDAQ: NTES&
> where the description is actually extracted from reuters?
>
> 2. Can I pull the "CONSENSUS EPS TREND chart" off msn money<http://investing.money.msn. > ascom/investments/ earnings- estimates? symbol=ntes
> well?
>
> Can this be done on any website or only restricted to Yahoo as shown in
> file RCHCreateComments-Quick-Chart- Review.xls?
>
>
- 2c.
-
Re: rchcreatecomment
Posted by: "Hong Chong NG" nghongchong@hotmail.com wu_ming_sg
Sat Sep 3, 2011 9:14 pm (PDT)
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?
- 2d.
-
Re: rchcreatecomment
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Sep 3, 2011 9:48 pm (PDT)
As a normal EXCEL process, yes -- just copy and paste. But you won't be able
to use VBA to import the image, because the EXCEL import image process is
the one with the 99-byte limitation on the URL. That's not a limitation of
the add-in, but a limitation set by EXCEL.
On Sat, Sep 3, 2011 at 9:14 PM, Hong Chong NG <nghongchong@hotmail.com >wrote:
>
> 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?
>
- 3a.
-
Outsource
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sat Sep 3, 2011 6:57 pm (PDT)
Do you accept any projects to work on?
I am working on a template but I am too much of a noob to complete it.
Other than being an excel expert, do you work on websites such as converting excel templates into website applications as well?
Best regards,
- 3b.
-
Re: Outsource
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Sep 3, 2011 7:47 pm (PDT)
Not really. However, I do sometimes look at workbooks or ideas and make
comments and/or suggestions if it is something I find of interest. I usually
lose interest quickly if someone cannot explain clearly what they have in
mind -- I don't like having to go back numerous times to ask questions to
clarify the concepts. It just tells me it wasn't thought through properly to
begin with and a waste of my time. I'm also not a big fan of templates that
try to do everything and end up with numerous worksheets.
On Sat, Sep 3, 2011 at 6:57 PM, wu_ming_sg <nghongchong@hotmail.com > wrote:
> Do you accept any projects to work on?
>
> I am working on a template but I am too much of a noob to complete it.
>
> Other than being an excel expert, do you work on websites such as
> converting excel templates into website applications as well?
>
- 3c.
-
Re: Outsource
Posted by: "Hong Chong NG" nghongchong@hotmail.com wu_ming_sg
Sat Sep 3, 2011 9:04 pm (PDT)
Hi,
You might be mistaken. What I meant was if you will accept remuneration working on templates or websites?
best regards,
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Sat, 3 Sep 2011 19:47:21 -0700
Subject: Re: [smf_addin] Outsource
Not really. However, I do sometimes look at workbooks or ideas and make comments and/or suggestions if it is something I find of interest. I usually lose interest quickly if someone cannot explain clearly what they have in mind -- I don't like having to go back numerous times to ask questions to clarify the concepts. It just tells me it wasn't thought through properly to begin with and a waste of my time. I'm also not a big fan of templates that try to do everything and end up with numerous worksheets.
On Sat, Sep 3, 2011 at 6:57 PM, wu_ming_sg <nghongchong@hotmail.com > wrote:
Do you accept any projects to work on?
I am working on a template but I am too much of a noob to complete it.
Other than being an excel expert, do you work on websites such as converting excel templates into website applications as well?
- 3d.
-
Re: Outsource
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Sep 3, 2011 9:46 pm (PDT)
Nope, sorry. As I said, I only choose to work on things I find interesting.
And I don't charge for the work. Money isn't what makes it interesting.
And I don't do websites. I haven't done serious HTML/JavaScript work for
nearly a decade.
On Sat, Sep 3, 2011 at 9:04 PM, Hong Chong NG <nghongchong@hotmail.com >wrote:
>
> What I meant was if you will accept remuneration working on templates or
> websites?
>
>
- 3e.
-
Re: Outsource
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sun Sep 4, 2011 12:42 am (PDT)
I see. I am actually working on a template that would help me to expedite a 10 step Value investing method which I learnt in a recent lesson. Would you like to look at it once I am done with the first revision?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Nope, sorry. As I said, I only choose to work on things I find interesting.
> And I don't charge for the work. Money isn't what makes it interesting.
>
> And I don't do websites. I haven't done serious HTML/JavaScript work for
> nearly a decade.
>
> On Sat, Sep 3, 2011 at 9:04 PM, Hong Chong NG <nghongchong@...>wrote:
>
> >
> > What I meant was if you will accept remuneration working on templates or
> > websites?
> >
> >
>
- 3f.
-
Re: Outsource
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Sep 4, 2011 1:50 am (PDT)
I can take a quick look and see if I want to continue...just attach a copy
to an email when you have it ready.
On Sun, Sep 4, 2011 at 12:42 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
> I see. I am actually working on a template that would help me to expedite a
> 10 step Value investing method which I learnt in a recent lesson. Would you
> like to look at it once I am done with the first revision?
>
- 4a.
-
morningstar
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sun Sep 4, 2011 1:25 am (PDT)
hi,
I can use this successfully
"=RCHGetTableCell("http://quicktake. morningstar. "&Ticker"",1,com/stocknet/ printreport\
.aspx?symbol=">Price/Earnings ")"
I am trying to extract the text from "What Does This company Do?" from
here
<http://quicktake.morningstar. >com/stocknet/ printreport. aspx?symbol= ntes
but the below formula doesn't work.
=RCHGetTableCell("http://quicktake. morningstar. "&Ticker"",1,com/stocknet/ printreport. \
aspx?symbol=">What Does This Company Do?")
For your kind advice please.
- 4b.
-
Re: morningstar
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Sep 4, 2011 1:55 am (PDT)
That's because the table cell you want to extract is in a different row than
your search string. Also, I have no idea why you have a set of double
asterisks after the cell range name. That won't work at all. Try:
=RCHGetTableCell("
http://quicktake.morningstar. com/stocknet/ printreport. aspx?symbol=
"&Ticker,1,
">What Does This Company Do?",,,,1)
On Sun, Sep 4, 2011 at 1:25 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> I can use this successfully "=RCHGetTableCell("
> http://quicktake.morningstar. com/stocknet/ printreport. aspx?symbol=
> "&Ticker"",1,">Price/Earnings ")"
>
> I am trying to extract the text from "What Does This company Do?" from
> here<http://quicktake.morningstar. > butcom/stocknet/ printreport. aspx?symbol= ntes
> the below formula doesn't work.
>
> =RCHGetTableCell("
> http://quicktake.morningstar. "&Ticker"",1,com/stocknet/ printreport. aspx?symbol= ">What
> Does This Company Do?")
>
> For your kind advice please.
>
- 4c.
-
Re: morningstar
Posted by: "Hong Chong NG" nghongchong@hotmail.com wu_ming_sg
Sun Sep 4, 2011 2:16 am (PDT)
hi,
now then I realise that RCHGetTableCell have a variery of parameters and its different for text and table.
Where can I find more info please?
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Sun, 4 Sep 2011 01:55:06 -0700
Subject: Re: [smf_addin] morningstar
That's because the table cell you want to extract is in a different row than your search string. Also, I have no idea why you have a set of double asterisks after the cell range name. That won't work at all. Try:
=RCHGetTableCell("http://quicktake. morningstar. "&Ticker,1,com/stocknet/ printreport. aspx?symbol=
">What Does This Company Do?",,,,1)
On Sun, Sep 4, 2011 at 1:25 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
I can use this successfully "=RCHGetTableCell("http://quicktake. morningstar. "&Ticker"",1,com/stocknet/ printreport. aspx?symbol= ">Price/Earnings ")"
I am trying to extract the text from "What Does This company Do?" from here but the below formula doesn't work.
=RCHGetTableCell("http://quicktake. morningstar. "&Ticker"",1,com/stocknet/ printreport. aspx?symbol= ">What Does This Company Do?")
For your kind advice please.
- 4d.
-
Re: morningstar
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Sep 4, 2011 2:57 am (PDT)
The documentation, of course. In the "Documentation" folder of the files
area.
On Sun, Sep 4, 2011 at 2:16 AM, Hong Chong NG <nghongchong@hotmail.com >wrote:
>
> now then I realise that RCHGetTableCell have a variery of parameters and
> its different for text and table.
>
> Where can I find more info please?
>
- 5a.
-
Extracting CONSENSUS EPS TREND from msn money
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sun Sep 4, 2011 2:12 am (PDT)
Hi,
I am trying to extract the table under CONSENSUS EPS TREND from msn
money.
<http://investing.money.msn. > But it appears to be none table?Kindly help me confirm if it cancom/investments/ earnings- estimates? symbol=nt\
es&
be done please?
Many thanks!
- 5b.
-
Re: Extracting CONSENSUS EPS TREND from msn money
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Sep 4, 2011 2:56 am (PDT)
General form:
=RCHGetTableCell(URL,column, ">Consensus EPS Trend",">Descriptio n",,,row)
...varying "column" from 1 to 5 and "row" from 1 to 5. Or, something like:
=RCHGetTableCell(URL,column, ">Consensus EPS Trend",">Current Estimate")
...varying "column" from 1 to 4.
On Sun, Sep 4, 2011 at 2:12 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> I am trying to extract the table under CONSENSUS EPS TREND from msn money.<http://investing.money.msn. >com/investments/ earnings- estimates? symbol=ntes&
>
> But it appears to be none table?
> Kindly help me confirm if it can be done please?
>
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