Jumat, 10 Mei 2013

[smf_addin] Digest Number 2611

4 New Messages

Digest #2611
1a
Re: data from Google by "Randy Harmelink" rharmelink
2a
Re: MSN data by "Danny" danzig_36526
2b
Re: MSN data by "Randy Harmelink" rharmelink
2c
Re: MSN data by "Danny" danzig_36526

Messages

Thu May 9, 2013 6:41 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. That function works fine here. Could have been a temporary page
retrieval issue from Google. What happens if you run the
smfForceRecalculation macro (see LINKS area of Yahoo group for more info on
it)?

Otherwise, what do you get with:

=RCHGetElementNumber("Version")
=smfGetAParms(2742)
=RCHGetWebData("http://www.google.com/finance?fstype=ii&q=AA",1,20)
=RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=AA",1,"per
share items")
=RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=aa",1,"per
share items")
=RCHGetElementNumber("MMM";, 2742)

On Thu, May 9, 2013 at 6:33 PM, Lawrence <lawrence.leesh@gmail.com> 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".
>

Thu May 9, 2013 6:46 pm (PDT) . Posted by:

"Danny" danzig_36526

It's mostly Industry data. Element numbers 151, 70, 61, 58, 121, 85, 91, 52, 139, 127, 133, etc. It happens on most tickers I enter, such as QCOR, CRUS, EZPW, INTC, CF to name a few.


--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I just tried several dozen and they're working fine here. They did revamp
> their website structure last year, which required elements to be redefined.
> But nothing recently I'm aware of, unless you can give more details, like
> example ticker symbols and element numbers.
>
> On Thu, May 9, 2013 at 7:15 AM, Danny <danzig_36526@...> wrote:
>
> > Anyone else noticing lack of elements from MSN recently?
> >
>

Thu May 9, 2013 7:58 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I get "NA" returned, which is what MSN is posting for those data items.

On Thu, May 9, 2013 at 6:46 PM, Danny <danzig_36526@yahoo.com> wrote:

> It's mostly Industry data. Element numbers 151, 70, 61, 58, 121, 85, 91,
> 52, 139, 127, 133, etc. It happens on most tickers I enter, such as QCOR,
> CRUS, EZPW, INTC, CF to name a few.
>

Thu May 9, 2013 8:08 pm (PDT) . Posted by:

"Danny" danzig_36526

Yeah just started doing that the other day...unusual. Must be a bad feed from their data provider. Thanks for checking it out.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I get "NA" returned, which is what MSN is posting for those data items.
>
> On Thu, May 9, 2013 at 6:46 PM, Danny <danzig_36526@...> wrote:
>
> > It's mostly Industry data. Element numbers 151, 70, 61, 58, 121, 85, 91,
> > 52, 139, 127, 133, etc. It happens on most tickers I enter, such as QCOR,
> > CRUS, EZPW, INTC, CF to name a few.
> >
>

Tidak ada komentar:

Posting Komentar