Rabu, 17 April 2013

[smf_addin] Digest Number 2587

5 New Messages

Digest #2587
2a
Just won't work by "liedoglie" liedoglie
2b
Re: Just won't work by "Randy Harmelink" rharmelink
2c
Re: Just won't work by "liedoglie" liedoglie

Messages

Tue Apr 16, 2013 9:14 pm (PDT) . Posted by:

"bobmikejohn1" bobmikejohn1



Hi,
I can't seem to figure out how to pull the Liabilities-to-Equity Ratio
from this url: http://www.theglobeandmail.com/globe-investor/markets/stocks/summary/?q=GE-N

When I try:
=RCHGetTableCell("http://www.theglobeandmail.com/globe-investor/markets/stocks/summary/?q=GE-N",1,"Liabilities-to-Equity Ratio")

I get back: "Event" I was expecting a value of "4.33"

Is there something I'm doing wrong?

Thank you.

Tue Apr 16, 2013 9:29 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It won't work because the data you want is not in an HTML table. Try:

=0+smfGetTagContent("
http://www.theglobeandmail.com/globe-investor/markets/stocks/summary/?q=GE-N
",
"span",1,"Liabilities-to-Equity Ratio")

On Tue, Apr 16, 2013 at 9:14 PM, bobmikejohn1 <en905a@gmail.com> wrote:

>
> I can't seem to figure out how to pull the Liabilities-to-Equity Ratio
> from this url:
> http://www.theglobeandmail.com/globe-investor/markets/stocks/summary/?q=GE-N
>
> When I try:
> =RCHGetTableCell("
> http://www.theglobeandmail.com/globe-investor/markets/stocks/summary/?q=GE-N",1,"Liabilities-to-Equity
> Ratio")
>
> I get back: "Event" I was expecting a value of "4.33"
>
> Is there something I'm doing wrong?
>

Tue Apr 16, 2013 9:26 pm (PDT) . Posted by:

"liedoglie" liedoglie

Excel 2010.
Every function returns an error message.
The latest add-in is correctly installed. All the functions appear as I begin to type. Then "error" appears in the cell when I press enter.
It doesn't seem that an internet connection is ever attempted.
Assume my calls are correct, as I have copied some from the templates.
Occasionally one of the templates works after I delete the incorrect add-in file location information. Then later it doesn't work.
I have changed the error message to TIME_SUCKER, since that is what this has become for me. My spreadsheet is full of TIME_SUCKER cells.
I have spent a couple of hours trying to find a similar problem in these messages but I can't.

Tue Apr 16, 2013 9:37 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

What do you get with:

=RCHGetElementNumber("Version&quot;)
=RCHGetElementNumber("MMM";,972)
=RCHGetTableCell("http://finance.yahoo.com/q/ks?s=MMM",1,">Beta")
=RCHGetWebData("http://finance.yahoo.com/q/ks?s=MMM",1,22)

Do you have a firewall up that prevents EXCEL from going to the web? For
example, can you use the EXCEL Web Query to bring in data from a web page?

On Tue, Apr 16, 2013 at 8:57 PM, liedoglie <annzillion@gmail.com> wrote:

> Excel 2010.
> Every function returns an error message.
> The latest add-in is correctly installed. All the functions appear as I
> begin to type. Then "error" appears in the cell when I press enter.
> It doesn't seem that an internet connection is ever attempted.
> Assume my calls are correct, as I have copied some from the templates.
> Occasionally one of the templates works after I delete the incorrect
> add-in file location information. Then later it doesn't work.
> I have changed the error message to TIME_SUCKER, since that is what this
> has become for me. My spreadsheet is full of TIME_SUCKER cells.
> I have spent a couple of hours trying to find a similar problem in these
> messages but I can't.
>

Tue Apr 16, 2013 10:04 pm (PDT) . Posted by:

"liedoglie" liedoglie

All these worked fine, and then they worked when I substituted other tickers. It is MSDN element numbers that aren't working.

Before, RCHGetURLData2 was the only one of the RCHGetURLData functions that worked, with the hidden IE. Now all the RCHGetURLData functions work. I don't get it.

Thanks for this excellent add-in and your reply. I'm blaming Microsoft for the time wasting since they won't care.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> What do you get with:
>
> =RCHGetElementNumber("Version&quot;)
> =RCHGetElementNumber("MMM";,972)
> =RCHGetTableCell("http://finance.yahoo.com/q/ks?s=MMM",1,">Beta")
> =RCHGetWebData("http://finance.yahoo.com/q/ks?s=MMM",1,22)
>
> Do you have a firewall up that prevents EXCEL from going to the web? For
> example, can you use the EXCEL Web Query to bring in data from a web page?
>
> On Tue, Apr 16, 2013 at 8:57 PM, liedoglie <annzillion@...> wrote:
>
> > Excel 2010.
> > Every function returns an error message.
> > The latest add-in is correctly installed. All the functions appear as I
> > begin to type. Then "error" appears in the cell when I press enter.
> > It doesn't seem that an internet connection is ever attempted.
> > Assume my calls are correct, as I have copied some from the templates.
> > Occasionally one of the templates works after I delete the incorrect
> > add-in file location information. Then later it doesn't work.
> > I have changed the error message to TIME_SUCKER, since that is what this
> > has become for me. My spreadsheet is full of TIME_SUCKER cells.
> > I have spent a couple of hours trying to find a similar problem in these
> > messages but I can't.
> >
>

Tidak ada komentar:

Posting Komentar