2 New Messages

Digest #2614

Re: data from Google by "Lawrence" lawleesh

Re: data from Google by "Randy Harmelink" rharmelink

Messages

1a

Hi Randy

Why do you think =RCHGetElementNumber("MMM";,1286) returns a value while changing the formula in the same cell to =RCHGetElementNumber("MMM";,2742)would return an error?

regards

LL

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> If you got #VALUE! and TRUE values returned, something is so wrong I can't
> help...
>
> Do you have your cells formatted incorrectly?
>
> On Fri, May 10, 2013 at 3:22 PM, Lawrence <lawrence.leesh@...> wrote:
>
> > Hi Randy
> >
> > Pls see below.
> >
> > regards
> >
> > LL
> >
> > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > >
> > > Hmmm. That function works fine here. Could have been a temporary page
> > > retrieval issue from Google.
> > It worked on a Windows 8 machine but not on another Windows 7 machine even
> > though data from Yahoo loaded properly.
> >
> > What happens if you run the
> > > smfForceRecalculation macro (see LINKS area of Yahoo group for more info
> > on
> > > it)?
> > > I did that and also set IE to load page every time I visit website and
> > also deleted all temporary files but still does not work on second machine.
> >
> > > Otherwise, what do you get with: Pls see below.
> > >
> > > =RCHGetElementNumber("Version") TRUE
> > > =smfGetAParms(2742)
> > Google;Quarterly Income Statement -- Date -- FQ1;
> > http://www.google.com/finance?fstype=ii&q=~~~~~;1;INCINTERIMDIV;(exceptfor per share items); ; ;0;</TABLE;0;0
> >
> > > =RCHGetWebData("http://www.google.com/finance?fstype=ii&q=AA",1,20)
> > #VALUE!
> > > =RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=AA",1,"per
> > > share items")
> > TRUE
> > > =RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=aa",1,"per
> > > share items")
> > TRUE
> > > =RCHGetElementNumber("MMM";, 2742)
> > Error
> > >
> > > On Thu, May 9, 2013 at 6:33 PM, Lawrence <lawrence.leesh@> wrote:
> > >
> > > >
> > > > I thought that Google might have switched to dynamic web pages which
> > > > caused info not to be downloaded.
> > > >
> > > > One of the formulas I have difficulty with is
> > > > =RCHGetElementNumber("aa",2742). It returned "Error".
> > > >
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

1b

Re: data from Google

Sat May 11, 2013 9:55 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Because element #1286 comes from a different data source. If your error is
from retrieving Google web pages, that won't have any affect on retrieving
data from other data sources.

Y'know, some just the other day got a TRUE value returned, and it turned
out they had double-pasted the formula. That is, instead of something like:

=RCHGetElementNumber("Version")

...they had:

=RCHGetElementNumber("Version")=RCHGetElementNumber("Version")

I just can't think of a reason for you to get a *value* of TRUE back on
those formulas.

On Sat, May 11, 2013 at 9:28 PM, Lawrence <lawrence.leesh@gmail.com> wrote:

>
> Why do you think =RCHGetElementNumber("MMM";,1286) returns a value while
> changing the formula in the same cell to
> =RCHGetElementNumber("MMM";,2742)would return an error?
>