Selasa, 30 September 2014

[smf_addin] Digest Number 3195[1 Attachment]

15 Messages

Digest #3195
1a
MSN data by danzig_36526
1b
Re: MSN data by "Randy Harmelink" rharmelink
1c
Re: MSN data by danzig_36526
1d
Re: MSN data by "Randy Harmelink" rharmelink
2a
2b
Re: Changes and notifications in SMF files by "Randy Harmelink" rharmelink
3b
Re: SMFGetOptionQuotes returning "Error" by "Randy Harmelink" rharmelink
3d
Re: SMFGetOptionQuotes returning "Error" by "Randy Harmelink" rharmelink
4b
Re: "Invalid" message for zip file by "Randy Harmelink" rharmelink
5a
Re: Adj Close by "Mark E. Miller" me_miller
5b
Re: Adj Close by "Mark E. Miller" me_miller

Messages

Tue Sep 30, 2014 12:21 pm (PDT) . Posted by:

danzig_36526

Anyone else having trouble pulling in MSN elements?


Tue Sep 30, 2014 12:44 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sigh. MSN has once again done a major overhaul of their stock web pages.
The "print page" everything used to come from no longer exists. They've
changed things for aesthetic display, instead of a data display. It looks
like most of the data items that used to exist will be gone.

It does say "Preview" on the URL, so it may not be the final version.

This did require me to log in again, and data is no longer directly
accessible by ticker symbol. So it may be all MSN data items will be
obsoleted...

On Tue, Sep 30, 2014 at 12:21 PM, danzig_36526@... wrote:

>
> Anyone else having trouble pulling in MSN elements?
>

Tue Sep 30, 2014 12:54 pm (PDT) . Posted by:

danzig_36526

Gotcha...thanks. Do you know of any other elements that provide 52 week high and low stock prices? I couldn't find any after a quick scan.

Tue Sep 30, 2014 2:38 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yahoo has them on their key statistics web page:

# Usage Source Element 938 S YahooKS Date of 52-Week High 939 S YahooKS Date
of 52-Week Low 973 S YahooKS 52-Week Change 975 S YahooKS 52-Week High
976 S YahooKS 52-Week Low

On Tue, Sep 30, 2014 at 12:54 PM, danzig_36526@...wrote:

>
> Do you know of any other elements that provide 52 week high and low stock
> prices? I couldn't find any after a quick scan.
>

Tue Sep 30, 2014 1:10 pm (PDT) . Posted by:

"Jose Jacob" pepecan47

When the files used to be in the Yahoo user's group area, I used to receive a notification for any change or addition. Is this still the case now that the files are in Randy's website?

Regards,
Jose L. Jacob

Tue Sep 30, 2014 2:39 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

There isn't anything automated at this point. But I haven't done much
updating lately either. Just a few files on the "Works in Progress" page.

On Tue, Sep 30, 2014 at 1:10 PM, Jose Jacob pepecan47@... wrote:

> When the files used to be in the Yahoo user's group area, I used to
> receive a notification for any change or addition. Is this still the case
> now that the files are in Randy's website?
>

Tue Sep 30, 2014 2:26 pm (PDT) . Posted by:

katsuomorinaga

First of all, thanks for all the great work Randy on this awesome plug-in. Its been very helpful to me.



Most of SMFGetOptionQuotes() function calls have been coming back errors starting today. Was there some major change at the Yahoo website?



Calls to Google and Options Express are still functional so I can run through all my cells and add in "G" or "OX" parameters to all the function calls as a back-up plan. But I left most of the function calls as default ("Yahoo") so P in the A, obviously. Any help would be appreciated. Thanks!

Tue Sep 30, 2014 2:33 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just tried this and it worked fine for me:

=smfGetOptionQuotes("IWM 10/31 2014 $110 Call","b")

You didn't give any examples for me to look at -- sometimes Yahoo is
missing chains for particular equities. Even something like SPY has
occasionally had them missing for several days.

Did you try running the smfForceRecalculation macro, to get a refresh of
the web pages the data comes from? It might also have been a temporary
issue at Yahoo.

On Tue, Sep 30, 2014 at 2:25 PM, katsuomorinaga@... wrote:

> First of all, thanks for all the great work Randy on this awesome
> plug-in. Its been very helpful to me.
>
> Most of SMFGetOptionQuotes() function calls have been coming back errors
> starting today. Was there some major change at the Yahoo website?
>
> Calls to Google and Options Express are still functional so I can run
> through all my cells and add in "G" or "OX" parameters to all the function
> calls as a back-up plan. But I left most of the function calls as default
> ("Yahoo") so P in the A, obviously. Any help would be appreciated.
> Thanks!
>

Tue Sep 30, 2014 2:47 pm (PDT) . Posted by:

katsuomorinaga

Randy:

Thanks for the quick reply.

Here is an example of a call that until today had been working but returns an error for me:

=smfGetOptionQuotes("TWTR 1/15 2016 $23 Call","l",0)

I also tried your example of =smfGetOptionQuotes("IWM 10/31 2014 $110 Call","b") and that also returned an error for me.

However, when I change the datasource parameter to "G" as so:

=smfGetOptionQuotes("TWTR 1/15 2016 $23 Call","l",0, "G")

It returns the correct quote, which is "29.75".

This also works for me:

=smfGetOptionQuotes("IWM 10/31 2014 $110 Call","b",0,"OX")

it returns "2.18"

So it seems like the Google datasource and the "OX" Options Express datasource still work. Which leads me to believe the problem might be with Yahoo.

I opened and closed the spreadsheet several times and also ran smfForceRecalculation and it still seems to pop up error for me.

Perhaps I should wait around for a day to see if it functions again?

Tue Sep 30, 2014 4:30 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. Your example worked fine for me:

=smfGetOptionQuotes("TWTR 1/15 2016 $23 Call","l",0)

Can you bring up this web page in the EXCEL Web Query dialog (keyboard
shortcut alt+d+d+w):

http://finance.yahoo.com/q/op?s=TWTR&m=2016-01

Something appears to be blocking you from the Yahoo web pages? Hard to say
what the problem might be.

You do have your Internet options set up to always get a fresh copy of the
web page, right? Cached copies of web pages under Internet Explorer would
continue to give you errors no matter what you did with EXCEL and the
add-in. Because those same cached web pages would be served up by
Microsoft's Internet Explorer engine.

On Tue, Sep 30, 2014 at 2:47 PM, katsuomorinaga@...wrote:

>
> Thanks for the quick reply.
>
> Here is an example of a call that until today had been working but returns
> an error for me:
>
> =smfGetOptionQuotes("TWTR 1/15 2016 $23 Call","l",0)
>
> I also tried your example of =smfGetOptionQuotes("IWM 10/31 2014 $110
> Call","b") and that also returned an error for me.
>
> However, when I change the datasource parameter to "G" as so:
>
> =smfGetOptionQuotes("TWTR 1/15 2016 $23 Call","l",0, "G")
>
> It returns the correct quote, which is "29.75".
>
> This also works for me:
>
> =smfGetOptionQuotes("IWM 10/31 2014 $110 Call","b",0,"OX")
>
> it returns "2.18"
>
> So it seems like the Google datasource and the "OX" Options Express
> datasource still work. Which leads me to believe the problem might be with
> Yahoo.
>
> I opened and closed the spreadsheet several times and also ran
> smfForceRecalculation and it still seems to pop up error for me.
>
> Perhaps I should wait around for a day to see if it functions again?
>

Tue Sep 30, 2014 5:34 pm (PDT) . Posted by:

katsuomorinaga

OK I went through and manually deleted all my Temporary Internet Files by hand and that seems to have done the trick. The Web query went through without a hitch as well.

Thanks for your time and keep up the great work!

Tue Sep 30, 2014 2:27 pm (PDT) . Posted by:

t.palm27

Hi Randy,


I just joined your group and am having trouble opening the zip file. It downloads fine but I receive an "Invalid" message when I try to open it. Is this because you are currently working on an update, or am I doing something wrong? Thanks

Tue Sep 30, 2014 2:29 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not sure what the problem would be -- I just opened
RCH_Stock_Market_Functions-2.1.2014.01.30.zip from the web site and had no
problems.

On Tue, Sep 30, 2014 at 1:17 PM, quickback27@... wrote:

> I just joined your group and am having trouble opening the zip file. It
> downloads fine but I receive an "Invalid" message when I try to open it. Is
> this because you are currently working on an update, or am I doing
> something wrong? Thanks
>

Tue Sep 30, 2014 4:10 pm (PDT) . Posted by:

"Mark E. Miller" me_miller

rjemery7 -

You can download Google historical price information to a CSV file as
follows (substitute your own ticker instead of "PSB"):

http://finance.google.com/finance/historical?q=PSB
<http://finance.google.com/finance/historical?q=PSB&startdate=Jan+01+1990&hi
stperiod=daily&output=csv>
&startdate=Jan+01+1990&histperiod=daily&output=csv

You're right about Google not having adjusted closing prices. Google does
not have historical prices for funds, only stocks and ETFs. I also think
Google limits the CSV download to only 4000 price dates (e.g., the above
link only results in 4000 prices back to 5-Nov-1998 even though the URL asks
for a starting date of 2-Jan-1990, whereas the Yahoo! historical quotes
server has prices for PSB back to 27-May-1991).

Mark

"The only real failure is the failure to try. The measure of success is how
we cope with disappointment."

Tue Sep 30, 2014 4:12 pm (PDT) . Posted by:

"Mark E. Miller" me_miller

Correction: "even though the URL asks for a starting date of 2-Jan-1990"
should have been 1-Jan-1990 instead of 2-Jan-1990.

Mark

"The only real failure is the failure to try. The measure of success is how
we cope with disappointment."

From: Mark E. Miller [mailto:miller.mark.e@sbcglobal.net]
Sent: Tuesday, September 30, 2014 4:10 PM
To: smf_addin@yahoogroups.com
Subject: Re: Adj Close

rjemery7 -

You can download Google historical price information to a CSV file as
follows (substitute your own ticker instead of "PSB"):

http://finance.google.com/finance/historical?q=PSB
<http://finance.google.com/finance/historical?q=PSB&startdate=Jan+01+1990&hi
stperiod=daily&output=csv>
&startdate=Jan+01+1990&histperiod=daily&output=csv

You're right about Google not having adjusted closing prices. Google does
not have historical prices for funds, only stocks and ETFs. I also think
Google limits the CSV download to only 4000 price dates (e.g., the above
link only results in 4000 prices back to 5-Nov-1998 even though the URL asks
for a starting date of 2-Jan-1990, whereas the Yahoo! historical quotes
server has prices for PSB back to 27-May-1991).

Mark

"The only real failure is the failure to try. The measure of success is how
we cope with disappointment."

Attachment(s) from Mark E. Miller
1 of 1 File(s)
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
READ MORE....