Messages In This Digest (15 Messages)
- 1a.
- Getting data - which function From: agdalban
- 1b.
- Re: Getting data - which function From: Randy Harmelink
- 2a.
- Recent problems From: t
- 2b.
- Re: Recent problems From: Randy Harmelink
- 2c.
- Re: Recent problems From: t
- 2d.
- Re: Recent problems From: Randy Harmelink
- 2e.
- Re: Recent problems From: t
- 2f.
- Re: Recent problems From: Randy Harmelink
- 2g.
- Re: Recent problems From: t
- 3a.
- how to clean up the desc tag? From: wu_ming_sg
- 3b.
- Re: how to clean up the desc tag? From: Randy Harmelink
- 3c.
- Re: how to clean up the desc tag? From: wu_ming_sg
- 4a.
- Re: smfRecalculation From: wu_ming_sg
- 4b.
- Re: smfRecalculation From: Randy Harmelink
- 4c.
- Re: smfRecalculation From: wu_ming_sg
Messages
- 1a.
-
Getting data - which function
Posted by: "agdalban" work@astridhome.net agdalban
Sun Nov 6, 2011 8:16 am (PST)
Hello,
First, many thanks for this wonderful add-in. Have been using it for a while for a variety of websites, works very well, and to date I never needed to post.
My question: I have been trying to extract the table data from this page:
"http://bourse.votreargent. "lexpress. fr/cours- sicav-fcp/ cours-AMUNDI+ INTERNATIONAL+ A+USD+CAP- LU0068578508/ graphique_ evolutions# histo_anchor
I can tell from the page source code that all the data I need is there, and it doesn't look that different from the Yahoo type of coding to me... but I am unable to retrieve it with the GetHTMLTable function, and I have not been able to tweak GetWebData or GetTableCell templates to get it either (am not proficient with these...).
Could someone please point me in the right direction? Maybe give me a formula to at least get one of the datapoints in there, and I'll build on it...
This is unfortunately the only website that will provide this data on a historical basis, so I really need it.
Many thanks in advance
- 1b.
-
Re: Getting data - which function
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Nov 6, 2011 8:32 am (PST)
I'm not having a problem with it -- just tried both:
=RCHGetHTMLTable("
http://bourse.votreargent. lexpress. fr/cours- sicav-fcp/ cours-AMUNDI+ INTERNATIONAL+ A+USD+CAP- LU0068578508/ graphique_ evolutions
",">Dernier",-1,"",1)
=RCHGetTableCell("
http://bourse.votreargent. lexpress. fr/cours- sicav-fcp/ cours-AMUNDI+ INTERNATIONAL+ A+USD+CAP- LU0068578508/ graphique_ evolutions
",1,">Dernier",,,,1)
...but I did drop the anchor specification from the URL. Not sure why I get
different results with it and without it -- it should only be a browser
directive, not a web page parameter.
On Sun, Nov 6, 2011 at 2:26 AM, agdalban <work@astridhome.net > wrote:
>
> My question: I have been trying to extract the table data from this page:
> "
> http://bourse.votreargent. lexpress. fr/cours- sicav-fcp/ cours-AMUNDI+ INTERNATIONAL+ A+USD+CAP- LU0068578508/ graphique_ evolutions# histo_anchor
> "
>
> I can tell from the page source code that all the data I need is there,
> and it doesn't look that different from the Yahoo type of coding to me...
> but I am unable to retrieve it with the GetHTMLTable function, and I have
> not been able to tweak GetWebData or GetTableCell templates to get it
> either (am not proficient with these...).
>
> Could someone please point me in the right direction? Maybe give me a
> formula to at least get one of the datapoints in there, and I'll build on
> it...
> This is unfortunately the only website that will provide this data on a
> historical basis, so I really need it.
>
> Many thanks in advance
>
- 2a.
-
Recent problems
Posted by: "t" tnmc77@yahoo.com tnmc77
Sun Nov 6, 2011 4:36 pm (PST)
Randy,
I have few worksheets where I have tisker symbols, dates and SMF formulae. IN the past, every time I opened or updated, the geotes will get updated. However, recently, when I open the file I get #NAME and #VALUE errors. I have also installed and reinstalled add-in. Sometimes that works and other times it does not. I have also noted that seae times the add-in comes up under the add-in list as "Stock Market Function Add-In". However, sometimes it is listed as "RCH_Stock Market Function Add-In".
Your help will be greatly appreciated.
Shashank
- 2b.
-
Re: Recent problems
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Nov 6, 2011 4:41 pm (PST)
Are your #NAME? errors simply location errors? See the "Links" area of the
group for a pointer about the issue.
On Sun, Nov 6, 2011 at 5:36 PM, t <tnmc77@yahoo.com > wrote:
>
> I have few worksheets where I have tisker symbols, dates and SMF formulae.
> IN the past, every time I opened or updated, the geotes will get updated.
> However, recently, when I open the file I get #NAME and #VALUE errors. I
> have also installed and reinstalled add-in. Sometimes that works and other
> times it does not. I have also noted that seae times the add-in comes up
> under the add-in list as "Stock Market Function Add-In". However, sometimes
> it is listed as "RCH_Stock Market Function Add-In".
>
- 2c.
-
Re: Recent problems
Posted by: "t" tnmc77@yahoo.com tnmc77
Sun Nov 6, 2011 4:43 pm (PST)
I don't believe so. Sometimes the same file works so I do not believe it is a location problem.
Shashank
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Are your #NAME? errors simply location errors? See the "Links" area of the
> group for a pointer about the issue.
>
> On Sun, Nov 6, 2011 at 5:36 PM, t <tnmc77@...> wrote:
>
> >
> > I have few worksheets where I have tisker symbols, dates and SMF formulae.
> > IN the past, every time I opened or updated, the geotes will get updated.
> > However, recently, when I open the file I get #NAME and #VALUE errors. I
> > have also installed and reinstalled add-in. Sometimes that works and other
> > times it does not. I have also noted that seae times the add-in comes up
> > under the add-in list as "Stock Market Function Add-In". However, sometimes
> > it is listed as "RCH_Stock Market Function Add-In".
> >
>
- 2d.
-
Re: Recent problems
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Nov 6, 2011 4:48 pm (PST)
Try:
http://finance.groups.yahoo. com/group/ smf_addin/ message/14672
On Sun, Nov 6, 2011 at 5:43 PM, t <tnmc77@yahoo.com > wrote:
> I don't believe so. Sometimes the same file works so I do not believe it
> is a location problem.
>
- 2e.
-
Re: Recent problems
Posted by: "t" tnmc77@yahoo.com tnmc77
Sun Nov 6, 2011 5:16 pm (PST)
Actually, I had not read that message but that is exactly what I have been doing for a month now. Even that did not work so I just rebooted the computer and redid the whole thing and it worked. Will have to keep doing this?
Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Try:
>
> http://finance.groups.yahoo. com/group/ smf_addin/ message/14672
>
> On Sun, Nov 6, 2011 at 5:43 PM, t <tnmc77@...> wrote:
>
> > I don't believe so. Sometimes the same file works so I do not believe it
> > is a location problem.
> >
>
- 2f.
-
Re: Recent problems
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Nov 6, 2011 5:21 pm (PST)
I hope not. But at this point, I have no idea what the problem might be. Is
it possible you actually have two versions of the add-in installed? Or just
two versions on your machine in different locations?
On Sun, Nov 6, 2011 at 6:16 PM, t <tnmc77@yahoo.com > wrote:
> Actually, I had not read that message but that is exactly what I have been
> doing for a month now. Even that did not work so I just rebooted the
> computer and redid the whole thing and it worked. Will have to keep doing
> this?
>
- 2g.
-
Re: Recent problems
Posted by: "t" tnmc77@yahoo.com tnmc77
Sun Nov 6, 2011 5:26 pm (PST)
No. Thanks for your help.
Shashank
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I hope not. But at this point, I have no idea what the problem might be. Is
> it possible you actually have two versions of the add-in installed? Or just
> two versions on your machine in different locations?
>
> On Sun, Nov 6, 2011 at 6:16 PM, t <tnmc77@...> wrote:
>
> > Actually, I had not read that message but that is exactly what I have been
> > doing for a month now. Even that did not work so I just rebooted the
> > computer and redid the whole thing and it worked. Will have to keep doing
> > this?
> >
>
- 3a.
-
how to clean up the desc tag?
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Mon Nov 7, 2011 12:06 am (PST)
hi,
I am using the below formula in a cell.
(=RCHGetTableCell("http://investing. businessweek. "&$A$3&"&dataset=com/businessweek /research/ stocks/financial s/financials. asp?ticker= incomeStatement& period=Q& currency= US%20Dollar" ,6,">")
The output is "Jun 302011PressReleaseUSD"
Do you an idea to "clean up the output" so that it will shows "Jun 30 2011"
the webpage is here.
http://investing.businessweek. com/businessweek /research/ stocks/financial s/financials. asp?ticker= NTES:US&dataset= incomeStatement& period=Q& currency= native
thank you.
- 3b.
-
Re: how to clean up the desc tag?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 7, 2011 12:17 am (PST)
If the day portion is always two digits (end of month?), then something
like this should work to convert it to a date -- then you can assign it any
date format you want:
=DATEVALUE(LEFT(B43,6)&", "&MID(B43,7, 4))
On Mon, Nov 7, 2011 at 1:06 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> I am using the below formula in a cell.
>
> (=RCHGetTableCell("
> http://investing.businessweek. com/businessweek /research/ stocks/financial s/financials. asp?ticker=
> "&$A$3&"&dataset=incomeStatement& period=Q& currency= US%20Dollar" ,6,">")
>
> The output is "Jun 302011PressReleaseUSD"
>
> Do you an idea to "clean up the output" so that it will shows "Jun 30 2011"
>
> the webpage is here.
>
>
> http://investing.businessweek. com/businessweek /research/ stocks/financial s/financials. asp?ticker= NTES:US&dataset= incomeStatement& period=Q& currency= native
>
>
- 3c.
-
Re: how to clean up the desc tag?
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Mon Nov 7, 2011 2:27 am (PST)
Thank you. Your knowledge is incredible!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> If the day portion is always two digits (end of month?), then something
> like this should work to convert it to a date -- then you can assign it any
> date format you want:
>
> =DATEVALUE(LEFT(B43,6)&", "&MID(B43,7, 4))
>
> On Mon, Nov 7, 2011 at 1:06 AM, wu_ming_sg <nghongchong@...> wrote:
>
> >
> > I am using the below formula in a cell.
> >
> > (=RCHGetTableCell("
> > http://investing.businessweek. com/businessweek /research/ stocks/financial s/financials. asp?ticker=
> > "&$A$3&"&dataset=incomeStatement& period=Q& currency= US%20Dollar" ,6,">")
> >
> > The output is "Jun 302011PressReleaseUSD"
> >
> > Do you an idea to "clean up the output" so that it will shows "Jun 30 2011"
> >
> > the webpage is here.
> >
> >
> > http://investing.businessweek. com/businessweek /research/ stocks/financial s/financials. asp?ticker= NTES:US&dataset= incomeStatement& period=Q& currency= native
> >
> >
>
- 4a.
-
Re: smfRecalculation
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Mon Nov 7, 2011 12:14 am (PST)
Is smfRecalculation the same as smfForceRecalculation?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> ALL open workbooks and worksheets.
>
> On Thu, Jan 13, 2011 at 12:13 PM, lexstar <lexstar@...> wrote:
>
> > Just curious. When I run a smfRecalculation, does it only recalculate in
> > my "active" worksheet only, or does it run all my "open" worksheets and
> > workbooks?
> >
>
- 4b.
-
Re: smfRecalculation
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 7, 2011 12:23 am (PST)
The first you mention doesn't exist.
On Mon, Nov 7, 2011 at 1:14 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> Is smfRecalculation the same as smfForceRecalculation?
>
- 4c.
-
Re: smfRecalculation
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Mon Nov 7, 2011 2:25 am (PST)
Is there a way to update the file calculations without getting the data
from the website again as in SMFForceRecalculation?
I have a step where I manually input some growth rates to calculate the
fair value. This fair value will change depending on the input growth
rates.
Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...>
wrote:
>
> The first you mention doesn't exist.
>
> On Mon, Nov 7, 2011 at 1:14 AM, wu_ming_sg nghongchong@... wrote:
>
> >
> > Is smfRecalculation the same as smfForceRecalculation?
> >
>
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