Selasa, 27 September 2011

[smf_addin] Digest Number 1967

Messages In This Digest (13 Messages)

Messages

1a.

smfGetOptionQuotes

Posted by: "dstange1978" danielcs@floripa.com.br   dstange1978

Mon Sep 26, 2011 8:54 am (PDT)



The function "smfGetOptionQuotes" seems not returning the correct values. For example:
=smfGetOptionQuotes("KO Out 2011 ITM3 Call";"l") is returning now the value 5.5, but the option was not even listed at this value today.
=smfGetOptionQuotes("KO Out 2011 $62.5 Call";"l") is returning nothing.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
1b.

Re: smfGetOptionQuotes

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Sep 26, 2011 9:10 am (PDT)



First of all, I'm shocked that "Out" would work for the month.

However, both worked for me when I tried them. I suspect you have IE caching
web pages -- make sure your Internet Options are set up to always get a new
web page. See the "Links" area of the group for more info.

On Mon, Sep 26, 2011 at 8:54 AM, dstange1978 <danielcs@floripa.com.br>wrote:

> The function "smfGetOptionQuotes" seems not returning the correct values.
> For example:
> =smfGetOptionQuotes("KO Out 2011 ITM3 Call";"l") is returning now the value
> 5.5, but the option was not even listed at this value today.
> =smfGetOptionQuotes("KO Out 2011 $62.5 Call";"l") is returning nothing.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
1c.

Re: smfGetOptionQuotes

Posted by: "dstange1978" danielcs@floripa.com.br   dstange1978

Mon Sep 26, 2011 11:02 am (PDT)



I emptied my IE history, but didn't work.

The smfGetYahooOptionQuote function has the same problem. As example:

=smfGetYahooOptionQuote("SPY";"C";"10/22/2011";111;"t") returns now "10:41AM EDT"

The RCHGetYahooQuotes function work fine.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> First of all, I'm shocked that "Out" would work for the month.
>
> However, both worked for me when I tried them. I suspect you have IE caching
> web pages -- make sure your Internet Options are set up to always get a new
> web page. See the "Links" area of the group for more info.
>
> On Mon, Sep 26, 2011 at 8:54 AM, dstange1978 <danielcs@...>wrote:
>
> > The function "smfGetOptionQuotes" seems not returning the correct values.
> > For example:
> > =smfGetOptionQuotes("KO Out 2011 ITM3 Call";"l") is returning now the value
> > 5.5, but the option was not even listed at this value today.
> > =smfGetOptionQuotes("KO Out 2011 $62.5 Call";"l") is returning nothing.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
1d.

Re: smfGetOptionQuotes

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Sep 26, 2011 11:35 am (PDT)



Oops. You also need to run the smfForceRecalculation macro to update the
smfGetOptionQuotes() function, or the smfGetYahooOptionQuote() function.
Again, see "Links" area of the group for more info.

On Mon, Sep 26, 2011 at 11:02 AM, dstange1978 <danielcs@floripa.com.br>wrote:

> I emptied my IE history, but didn't work.
>
> The smfGetYahooOptionQuote function has the same problem. As example:
>
> =smfGetYahooOptionQuote("SPY";"C";"10/22/2011";111;"t") returns now
> "10:41AM EDT"
>
> The RCHGetYahooQuotes function work fine.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
1e.

Re: smfGetOptionQuotes

Posted by: "dstange1978" danielcs@floripa.com.br   dstange1978

Mon Sep 26, 2011 12:17 pm (PDT)



WORKS!!!

THANKS A LOT!!!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Oops. You also need to run the smfForceRecalculation macro to update the
> smfGetOptionQuotes() function, or the smfGetYahooOptionQuote() function.
> Again, see "Links" area of the group for more info.
>
> On Mon, Sep 26, 2011 at 11:02 AM, dstange1978 <danielcs@...>wrote:
>
> > I emptied my IE history, but didn't work.
> >
> > The smfGetYahooOptionQuote function has the same problem. As example:
> >
> > =smfGetYahooOptionQuote("SPY";"C";"10/22/2011";111;"t") returns now
> > "10:41AM EDT"
> >
> > The RCHGetYahooQuotes function work fine.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (11)
2a.

Zacks data

Posted by: "Jacob Jose" pepecan47@yahoo.ca   pepecan47

Mon Sep 26, 2011 9:35 am (PDT)



I am getting n/a with
 
=RCHGetElementNumber(Ticker, 13885) (Current Average Broker Recommendation)
If I go to www.zacks.com, MCD, 1.61
 
Same thing with  =RCHGetElementNumber(Ticker, 13870) (PEG Ratio), for MCD from the site PEG=1.75

Regards,
Jose L. Jacob
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.

Re: Zacks data

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Sep 26, 2011 11:43 am (PDT)



I'm getting the 1.61 and 1.75 values with those two formulas. This is the
web page the data is retrieved from:

http://www.zacks.com/research/print.php?t=MCD

You may need to change you Internet Options or run the smfForceRecalculation
macro to get fresh web pages. See the "Links" area of the group for more
info.

On Mon, Sep 26, 2011 at 9:35 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:

>
> I am getting n/a with
>
> =RCHGetElementNumber(Ticker, 13885) (Current Average Broker Recommendation)
> If I go to www.zacks.com, MCD, 1.61
>
> Same thing with =RCHGetElementNumber(Ticker, 13870) (PEG Ratio), for MCD from
> the site PEG=1.75
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3a.

RCHGetYahooQuotes not working on certain tickers

Posted by: "zaigrith" adam.schoenwald@gmail.com   zaigrith

Mon Sep 26, 2011 11:33 am (PDT)



I noticed that =RCHGetYahooQuotes("nwn","l1",,NOW()) is returning 0, while the prices on yahoo are working. Any thoughts on why this is happening. Everything was working fine a few days ago and i have not changed the file. Problem occurs with older files that used to work and on different computers.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
3b.

Re: RCHGetYahooQuotes not working on certain tickers

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Sep 26, 2011 11:39 am (PDT)



Prices on Yahoo are NOT working -- at least on the CSV file interface, which
is where RCHGetYahooQuotes() gets the data. When I click on the "Download
Data" link on their web page for NWN, I get this in EXCEL:

NWN 0 N/A N/A N/A N/A N/A N/A N/A
So it's a Yahoo problem.

On Mon, Sep 26, 2011 at 9:42 AM, zaigrith <adam.schoenwald@gmail.com> wrote:

> I noticed that =RCHGetYahooQuotes("nwn","l1",,NOW()) is returning 0, while
> the prices on yahoo are working. Any thoughts on why this is happening.
> Everything was working fine a few days ago and i have not changed the file.
> Problem occurs with older files that used to work and on different
> computers.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
3c.

Re: RCHGetYahooQuotes not working on certain tickers

Posted by: "Glen" gfullmer@cox.net   gfullmer

Mon Sep 26, 2011 1:00 pm (PDT)





Noticed also the anomaly for BP. It stopped working a couple of days ago. However, going to http://finance.yahoo.com/q?s=BP&ql=0 works fine. Work around?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
3d.

Re: RCHGetYahooQuotes not working on certain tickers

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Sep 26, 2011 1:57 pm (PDT)



You can write individual RCHGetTableCell() functions, but it will be much
slower.

Have you complained to Yahoo about their "Download Data" link not working?

On Mon, Sep 26, 2011 at 1:00 PM, Glen <gfullmer@cox.net> wrote:

>
> Noticed also the anomaly for BP. It stopped working a couple of days ago.
> However, going to http://finance.yahoo.com/q?s=BP&ql=0 works fine. Work
> around?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
3e.

Re: RCHGetYahooQuotes not working on certain tickers

Posted by: "Glen Fullmer" gfullmer@cox.net   gfullmer

Mon Sep 26, 2011 3:18 pm (PDT)



Yes, Randy, I have complained and others can do so at:

http://help.yahoo.com/l/us/yahoo/finance/dataissues.html

We will see how soon it gets fixed! ;-)

Thanks for all you do,
Glen

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
3f.

Re: RCHGetYahooQuotes not working on certain tickers

Posted by: "n808" karl.lillevold@gmail.com   n808

Mon Sep 26, 2011 8:49 pm (PDT)



"Glad" to see I am not the only one with this problem. My AFSI and RVBD stopped working today :( I am not sure where to complain at yahoo, just hoping it starts working again..

--- In smf_addin@yahoogroups.com, Glen Fullmer <gfullmer@...> wrote:
>
> Yes, Randy, I have complained and others can do so at:
>
> http://help.yahoo.com/l/us/yahoo/finance/dataissues.html
>
> We will see how soon it gets fixed! ;-)
>
> Thanks for all you do,
> Glen
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
Recent Activity
Visit Your Group
Yahoo! News

Get it all here

Breaking news to

entertainment news

New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Diposting oleh EXCEL FEED LEARNING di 03.04

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)