Sabtu, 08 September 2012

[smf_addin] Digest Number 2339

7 New Messages

Digest #2339
1b
Re: =RCHGetYahooQuotes, zeros and N/A by "Randy Harmelink" rharmelink
1c
Re: =RCHGetYahooQuotes,  zeros and N/A by "analyst101010" analyst101010
2a
Different option price values by "hcl0903@sbcglobal.net" hcl0903@sbcglobal.net
2b
Re: Different option price values by "Randy Harmelink" rharmelink

Messages

Fri Sep 7, 2012 7:09 am (PDT) . Posted by:

"rr76012" rr76012

Hi Randy,

Anyone else getting the following results using =rchgetyahooquotes? zero's and N/A's?

EPS Est. Current Year 0
EPS Est. Next Year 0
Price/EPS Est. Current Yr N/A
Price/EPS Est. Next Yr N/A
1yr Target Price N/A

Fri Sep 7, 2012 9:12 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yup. Looks like that's what Yahoo is returning...

On Fri, Sep 7, 2012 at 7:09 AM, rr76012 <rr76012@yahoo.com> wrote:

>
> Anyone else getting the following results using =rchgetyahooquotes? zero's
> and N/A's?
>
> EPS Est. Current Year 0
> EPS Est. Next Year 0
> Price/EPS Est. Current Yr N/A
> Price/EPS Est. Next Yr N/A
> 1yr Target Price N/A
>

Fri Sep 7, 2012 1:43 pm (PDT) . Posted by:

"analyst101010" analyst101010

Yep, me too.

I assume Yahoo's tweaking their system or something?

Its still pulling price, 52wk range data, moving averages, etc.

PEG, EPS est. Consensus price target, etc, all coming up 0 or N/A

John

--- In smf_addin@yahoogroups.com, "rr76012" <rr76012@...> wrote:
>
> Hi Randy,
>
> Anyone else getting the following results using =rchgetyahooquotes? zero's and N/A's?
>
> EPS Est. Current Year 0
> EPS Est. Next Year 0
> Price/EPS Est. Current Yr N/A
> Price/EPS Est. Next Yr N/A
> 1yr Target Price N/A
>

Fri Sep 7, 2012 7:49 pm (PDT) . Posted by:

"hcl0903@sbcglobal.net" hcl0903@sbcglobal.net

Hi,

When I use smfGetOptionQuote("SBUX", "C", "9/22/2012", 48, "L") to get the last option price, I get 3.1 (from default Zacks source), which different from the Yahoo / Google finance web page, which show 3.31 as the last price (as of 9/7/12 close)

Also, in the version I have looks like Zacks is the only source for Option prices.

What am I doing wrong or am I missing something here?

Thanks.

H

Fri Sep 7, 2012 7:53 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The smfGetOptionQuote() function is not an officially released function. It
was something I was playing around with. So far, only Zacks is in it, and
it's the only one that accesses Zacks.

See the two smfForceRecalculation items in the LINKS area of the group for
why quotes may appear to be not current.

On Fri, Sep 7, 2012 at 7:46 PM, hcl0903@sbcglobal.net <
rajk2302@sbcglobal.net> wrote:

>
> When I use smfGetOptionQuote("SBUX", "C", "9/22/2012", 48, "L") to get the
> last option price, I get 3.1 (from default Zacks source), which different
> from the Yahoo / Google finance web page, which show 3.31 as the last price
> (as of 9/7/12 close)
>
> Also, in the version I have looks like Zacks is the only source for Option
> prices.
>
> What am I doing wrong or am I missing something here?
>

Fri Sep 7, 2012 11:53 pm (PDT) . Posted by:

"ajtalukdar" ajtalukdar

I am making the following calls for getting float info

RCHGetElementNumber(AMGN, 981)
RCHGetElementNumber(AMGN, 982)

and getting the folllowing data respectively

770770
776490

A cross check with the Yahoo KS page (http://finance.yahoo.com/q/ks?s=AMGN+Key+Statistics) shows that the first data fetched is correct while the second one is incorrect. It should have fetched

769640

Can someone help me with this discrepancy please?

Abhijit

Sat Sep 8, 2012 12:05 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I'm getting 770770 and 769640 right now. Is it possible you are extracting
data from a web page that was saved when the data was different? The
extracted data will reflect what is on the saved copy of the web page, not
the current page on the web site.

See the writeup on the smfForceRecalculation macro in the LINKS area of the
group for more info.

On Fri, Sep 7, 2012 at 11:52 PM, ajtalukdar <ajtalukdar@yahoo.com> wrote:

> I am making the following calls for getting float info
>
> RCHGetElementNumber(AMGN, 981)
> RCHGetElementNumber(AMGN, 982)
>
> and getting the folllowing data respectively
>
> 770770
> 776490
>
> A cross check with the Yahoo KS page (
> http://finance.yahoo.com/q/ks?s=AMGN+Key+Statistics) shows that the first
> data fetched is correct while the second one is incorrect. It should have
> fetched
>
> 769640
>
> Can someone help me with this discrepancy please?
>

Tidak ada komentar:

Posting Komentar