5 New Messages
Digest #2570
4b
Re: http://financials.morningstar.com/ratios/r.html?t=ETR®ion=USA by "Randy Harmelink" rharmelink
Messages
Tue Apr 2, 2013 10:02 am (PDT) . Posted by:
"Martin Topper" mtopper
Thanks Randy. Sorry I was unclear. Your invocation of the RCHGetTableCell (below) worked as I wanted.
Thanks again
________________________________
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Monday, April 1, 2013 6:43 PM
Subject: Re: [smf_addin] Retreiving a price form the attached page?
I don't know what your "2,4,2" parameters are for. I'm not even sure what you're really after?
This retrieved the table fine:
=RCHGetHTMLTable("https://www.nysaves.com/nytpl/fundperform/fundPerformance.do?fundid=1003020 ",">Historical Prices",1,"",1)
Or, is this the table you wanted?
=RCHGetHTMLTable("https://www.nysaves.com/nytpl/fundperform/fundPerformance.do?fundid=1003020 "," as of ",-1,"",1)
Or, if you'd like more history:
=RCHGetHTMLTable("https://www.nysaves.com/nytpl/fundperform/fundHistorySearch.do?fundid=1003020&startDate=03/01/2013&endDate=03/31/2013 ",">Date",-1,"",1)
Or, to just get just the "as of" price:
=RCHGetTableCell("https://www.nysaves.com/nytpl/fundperform/fundPerformance.do?fundid=1003020 ",1," as of ")
On Mon, Apr 1, 2013 at 9:58 AM, Marty <mtopper@yahoo.com > wrote:
>Can the Unit Price as of...... still be retrieved using RCHGetHTMLTable? Or is there a better way? The formula I used to use no longer works (not sure why). url is in a47. Formula is array entered.
>
>https://www.nysaves.com/nytpl/fundperform/fundPerformance.do?fundid=1003020
>
>=RCHGetHTMLTable(A47,"> Historical Prices",2,4,2) url is in a47. Formula is array entered (for three separate urls over 3 col and 3 rows).
>
Thanks again
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Monday, April 1, 2013 6:43 PM
Subject: Re: [smf_addin] Retreiving a price form the attached page?
I don't know what your "2,4,2" parameters are for. I'm not even sure what you're really after?
This retrieved the table fine:
=RCHGetHTMLTable(
Or, is this the table you wanted?
=RCHGetHTMLTable(
Or, if you'd like more history:
=RCHGetHTMLTable(
Or, to just get just the "as of" price:
=RCHGetTableCell(
On Mon, Apr 1, 2013 at 9:58 AM, Marty <mtopper@yahoo.
>Can the Unit Price as of...... still be retrieved using RCHGetHTMLTable? Or is there a better way? The formula I used to use no longer works (not sure why). url is in a47. Formula is array entered.
>
>https://www.
>
>=RCHGetHTMLTabl
>
Tue Apr 2, 2013 10:21 am (PDT) . Posted by:
"Sharon McAllister" sharonnraymc
Thank you, Randy.
I understand your concerns related to bulk use of data access through the add-in features. I would hate for websites I use through the add-in to revoke access to the add-in by re-writing their underlying web interface to eliminate data access via the add-in.
--Sharon
I understand your concerns related to bulk use of data access through the add-in features. I would hate for websites I use through the add-in to revoke access to the add-in by re-writing their underlying web interface to eliminate data access via the add-in.
--Sharon
Tue Apr 2, 2013 1:35 pm (PDT) . Posted by:
"rr76012" rr76012
Yes, Like you, I like to use RCHgetelementnumber (), but it seems like a 50/50 hit and miss, with the different stocks that I am trying to analyze to buy.
Everyday, I feel like it is just me, having this problem with MSN element numbers. I am glad to hear someone else is facing my same problem. I understand your disappointment and frustration.
Randy is the best, he is so patient and helpful. I hope you get your problem resolved.
Best Wishes,
rr76012
--- In smf_addin@yahoogroups.com , अननà¥à¤¤: <1998chemie@...> wrote:
>
> Can you please give the link to fix this issue, I went to the links section
> but could not find anything.
> I would really appreciate your help
> Au
>
>
> On Fri, Mar 29, 2013 at 1:47 PM, Randy Harmelink <rharmelink@...>wrote:
>
> > **
> >
> >
> > Without examples of ticker symbols and element numbers, it's hard to help.
> > Could be a website is down, or has changed the format of their web page.
> >
> > If AdvFN elements, you may need the fix mentioned in the LINKS area of the
> > group...
> >
> >
> > On Fri, Mar 29, 2013 at 10:29 AM, foolishblisterbutt <fgschack@...>wrote:
> >
> >>
> >> I have used the RCHGetElementNumber() heavily, but today it started
> >> failing at most stocks, not all of them, but most? It just shows "Error" in
> >> the field.
> >>
> >> I use the latest version of the SMF plugin.
> >>
> >> Anybody else having the same problem?
> >>
> >>
> >
> >
>
Everyday, I feel like it is just me, having this problem with MSN element numbers. I am glad to hear someone else is facing my same problem. I understand your disappointment and frustration.
Randy is the best, he is so patient and helpful. I hope you get your problem resolved.
Best Wishes,
rr76012
--- In smf_addin@yahoogrou
>
> Can you please give the link to fix this issue, I went to the links section
> but could not find anything.
> I would really appreciate your help
> Au
>
>
> On Fri, Mar 29, 2013 at 1:47 PM, Randy Harmelink <rharmelink@
>
> > **
> >
> >
> > Without examples of ticker symbols and element numbers, it's hard to help.
> > Could be a website is down, or has changed the format of their web page.
> >
> > If AdvFN elements, you may need the fix mentioned in the LINKS area of the
> > group...
> >
> >
> > On Fri, Mar 29, 2013 at 10:29 AM, foolishblisterbutt <fgschack@
> >
> >>
> >> I have used the RCHGetElementNumber
> >> failing at most stocks, not all of them, but most? It just shows "Error" in
> >> the field.
> >>
> >> I use the latest version of the SMF plugin.
> >>
> >> Anybody else having the same problem?
> >>
> >>
> >
> >
>
Tue Apr 2, 2013 1:48 pm (PDT) . Posted by:
"rr76012" rr76012
Hello Randy,
Do you know the best way to access the key ratios for this morningstar site?
http://financials.morningstar.com/ratios/r.html?t=ETR®ion=USA&culture=en-us
I wish I could just download all this webpage Financials & Key Ratios info for just 1 stock, in one download?
I have looked to see if there is a template in files, I did not find one? maybe I just missed it?
What would you suggest, thanks.
Do you know the best way to access the key ratios for this morningstar site?
http://financials.
I wish I could just download all this webpage Financials & Key Ratios info for just 1 stock, in one download?
I have looked to see if there is a template in files, I did not find one? maybe I just missed it?
What would you suggest, thanks.
Tue Apr 2, 2013 4:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
As they say, your wish...
From the LINKS area of the group:
http://finance.groups.yahoo.com/group/smf_addin/message/19776
It's the output from the "Export" button on the web page...
On Tue, Apr 2, 2013 at 1:48 PM, rr76012 <rr76012@yahoo.com > wrote:
>
> Do you know the best way to access the key ratios for this morningstar
> site?
>
>
> http://financials.morningstar.com/ratios/r.html?t=ETR®ion=USA&culture=en-us
>
> I wish I could just download all this webpage Financials & Key Ratios info
> for just 1 stock, in one download?
>
> I have looked to see if there is a template in files, I did not find one?
> maybe I just missed it?
>
From the LINKS area of the group:
http://finance.
It's the output from the "Export" button on the web page...
On Tue, Apr 2, 2013 at 1:48 PM, rr76012 <rr76012@yahoo.
>
> Do you know the best way to access the key ratios for this morningstar
> site?
>
>
> http://financials.
>
> I wish I could just download all this webpage Financials & Key Ratios info
> for just 1 stock, in one download?
>
> I have looked to see if there is a template in files, I did not find one?
> maybe I just missed it?
>
Tidak ada komentar:
Posting Komentar