15 Messages
Digest #3195
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?
>
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@
>
> 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.
>
# 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@
>
> 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
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?
>
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@..
> 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!
Most of SMFGetOptionQuotes(
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"
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!
>
=smfGetOptionQuotes
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 smfForceRecalculati
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@
> First of all, thanks for all the great work Randy on this awesome
> plug-in. Its been very helpful to me.
>
> Most of SMFGetOptionQuotes(
> 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"
> 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?
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
I also tried your example of =smfGetOptionQuotes
However, when I change the datasource parameter to "G" as so:
=smfGetOptionQuotes
It returns the correct quote, which is "29.75"
This also works for me:
=smfGetOptionQuotes
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 smfForceRecalculati
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?
>
=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'
On Tue, Sep 30, 2014 at 2:47 PM, katsuomorinaga@
>
> 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
>
> I also tried your example of =smfGetOptionQuotes
> Call","
>
> However, when I change the datasource parameter to "G" as so:
>
> =smfGetOptionQuotes
>
> It returns the correct quote, which is "29.75"
>
> This also works for me:
>
> =smfGetOptionQuotes
>
> 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
> smfForceRecalculati
>
> 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!
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
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
>
RCH_Stock_Market_
problems.
On Tue, Sep 30, 2014 at 1:17 PM, quickback27@
> 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."
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&outp
&startdate=Jan+
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."
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&outp
&startdate=Jan+
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
Tidak ada komentar:
Posting Komentar