3 New Messages
Digest #2569
Messages
Mon Apr 1, 2013 9:58 am (PDT) . Posted by:
"Marty" mtopper
Randy
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
Marty
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.
=RCHGetHTMLTable(
thanks
Marty
Mon Apr 1, 2013 3:43 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
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).
>
you're really after?
This retrieved the table fine:
=RCHGetHTMLTable(
https://www.
Prices"
Or, is this the table you wanted?
=RCHGetHTMLTable(
https://www.
as of ",-1,"
Or, if you'd like more history:
=RCHGetHTMLTable(
https://www.
","
Or, to just get just the "as of" price:
=RCHGetTableCell(
https://www.
as of ")
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.
>
> =RCHGetHTMLTable(
> is array entered (for three separate urls over 3 col and 3 rows).
>
Mon Apr 1, 2013 6:25 pm (PDT) . Posted by:
"Sean" mighty.quaker
Thanks. I will give it a try. I assume your example means that the formula will pull two spaces before the "trending_" reference.
Thanks again,
Sean
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> When you don't use search strings to position yourself, you leave your
> extraction vulnerable to any change they might make to the web page. For
> example, if all they do is insert a little advertisement code that contains
> a span tag, your count of 29 will be off. And that advertisement code might
> change with every refresh of the web page.
>
> How about something like:
>
> =smfGetTagContent("http://www.bloomberg.com/quote/rty:ind
> ","span",-2,"trending_")
>
> On Sun, Mar 31, 2013 at 4:59 AM, Sean <Sean.McLaughlin@...> wrote:
>
> > I have been pulling data from Bloomberg.com for about 18 months using this
> > command. Here's an example:
> >
> > smfGetTagContent("http://www.bloomberg.com/quote/rty:ind ","span",29)
> >
> > However, it does not seem to work anymore. My Windows and Excel version
> > have not changed.
> >
> > From time to time, it will return the Value# message in the cell. In the
> > past, I've had to alter the Span number (ie change 29 to 28 or 27) and that
> > did the trick. That does not seem to work this time. I'm not sure how to
> > fix it this time. Any help is appreciated.
> >
> >
>
Thanks again,
Sean
--- In smf_addin@yahoogrou
>
> When you don't use search strings to position yourself, you leave your
> extraction vulnerable to any change they might make to the web page. For
> example, if all they do is insert a little advertisement code that contains
> a span tag, your count of 29 will be off. And that advertisement code might
> change with every refresh of the web page.
>
> How about something like:
>
> =smfGetTagContent(
> ","
>
> On Sun, Mar 31, 2013 at 4:59 AM, Sean <Sean.McLaughlin
>
> > I have been pulling data from Bloomberg.com for about 18 months using this
> > command. Here's an example:
> >
> > smfGetTagContent(
> >
> > However, it does not seem to work anymore. My Windows and Excel version
> > have not changed.
> >
> > From time to time, it will return the Value# message in the cell. In the
> > past, I've had to alter the Span number (ie change 29 to 28 or 27) and that
> > did the trick. That does not seem to work this time. I'm not sure how to
> > fix it this time. Any help is appreciated.
> >
> >
>
Tidak ada komentar:
Posting Komentar