5 New Messages
Digest #2587
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-
from this url: http://www.theglobe
When I try:
=RCHGetTableCell(
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?
>
=0+smfGetTagContent
http://www.theglobe
",
"span"
On Tue, Apr 16, 2013 at 9:14 PM, bobmikejohn1 <en905a@gmail.
>
> I can't seem to figure out how to pull the Liabilities-
> from this url:
> http://www.theglobe
>
> When I try:
> =RCHGetTableCell(
> http://www.theglobe
> 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.
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")
=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.
>
=RCHGetElementNumbe
=RCHGetElementNumbe
=RCHGetTableCell(
=RCHGetWebData(
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.
> 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")
> =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.
> >
>
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@yahoogrou
>
> What do you get with:
>
> =RCHGetElementNumbe
> =RCHGetElementNumbe
> =RCHGetTableCell(
> =RCHGetWebData(
>
> 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@
>
> > 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