Rabu, 17 Mei 2017

[smf_addin] Digest Number 4009

15 Messages

Digest #4009

Messages

Tue May 16, 2017 9:24 pm (PDT) . Posted by:

tonyestep

I got the Google prices working well enough so that I'm sorta limping along, but I really need for Yahoo to fix itself. The Yahoo database is partly fixed. Earlier today if you manually grabbed 'Historical Prices' it had historical prices up through 5/12, and then today 5/16, but 5/15 was missing. At that point the SMF call worked but of course did not return a price for 5/15. Then they did something that totally hosed the SMF call and made it return nothing.
Now a manual call for 'Historical Prices' gets a correct series, including all dates you request. So someone has been doing something to fix it. However, the SMF call still is dead. I don't know what they changed, but whatever it is, I hope something good happens pretty soon.

Tue May 16, 2017 10:21 pm (PDT) . Posted by:

keoughjeffrey

I've run into the same problem with failed access to the Yahoo finance historical data starting Monday evening (5/15/2017). Friday was successful.

I'm not using RCHGetYahooHistory but it looks like the URL has changed from something like:

http://real-chart.finance.yahoo.com/table.csv?s=YHOO&a=00&b=1&c=2017&d=04&e=16&f=2017&g=d&ignore=.csv http://real-chart.finance.yahoo.com/table.csv?s=AMBFX&a=00&b=1&c=2015&d=08&e=13&f=2015&g=d&ignore=.csv

to something like:

https://query1.finance.yahoo.com/v7/finance/download/YHOO?period1=1494475200&period2=1494907200&interval=1d&events=history&crumb=ZYNrOtxHgl https://query1.finance.yahoo.com/v7/finance/download/YHOO?period1=1494475200&period2=1494907200&interval=1d&events=history&crumb=ZYNrOtxHglN

which is using epoch times (seconds since 1/1/1970) for start/end times and some cookie-related data ('crumb") as jeff.pietsch pointed out.

I'm using wget in VBA in Excel to get the downloaded file but have had no luck with the new "query1" page. wget64 returns an authorization error which *might* be related to the "crumb". Haven't figured it out yet.

Tue May 16, 2017 10:40 pm (PDT) . Posted by:

nelsonmuntz1000

Randy, I take it that array-entered smfPricesByDates() formula is affected by this same problem with Yahoo. Sure hope they correct this.

Wed May 17, 2017 12:05 am (PDT) . Posted by:

nelsonmuntz1000

Thanks for the formula John. Just a note that prices don't appear to be adjusted for dividends as they are in Yahoo.

Wed May 17, 2017 12:16 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Correct. The first thing it does is call RCHGetYahooHistory() to get the
data from which to extract the requested dates.

On Tue, May 16, 2017 at 10:40 PM, ccoupe300@
​...wrote:

>
> Randy, I take it that array-entered smfPricesByDates() formula is affected
> by this same problem with Yahoo. Sure hope they correct this.
>
>

Wed May 17, 2017 7:36 am (PDT) . Posted by:

"Michael Thomas" thomas91112

I downloaded the Windows updates to prevent the WannaCry ransomware and when done, none of my SMF functions are working!

From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, May 16, 2017 6:23 PM
Subject: Re: [smf_addin] RCHGetYahooHistory Not Working?

  Those are the reasons I've never pursued a function for the Google historical quotes.

I've never been impressed with Google's option quotes data either.

On Tue, May 16, 2017 at 5:59 PM, earladamy@​...wrote:

Thank you for the G URL code (along with all of the other code you have contributed). Unfortunately, G's history requires cleaning as it includes a number of dates with close price only. Also, the lack of adjusted data is a deal killer for me; however I'm probably in the minority on that score. I use a paid service for my usual charting work. My Y data usage is backtesting for which I require EOD trading date and adjusted close. 

#yiv3118626188 #yiv3118626188 -- #yiv3118626188ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3118626188 #yiv3118626188ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3118626188 #yiv3118626188ygrp-mkp #yiv3118626188hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3118626188 #yiv3118626188ygrp-mkp #yiv3118626188ads {margin-bottom:10px;}#yiv3118626188 #yiv3118626188ygrp-mkp .yiv3118626188ad {padding:0 0;}#yiv3118626188 #yiv3118626188ygrp-mkp .yiv3118626188ad p {margin:0;}#yiv3118626188 #yiv3118626188ygrp-mkp .yiv3118626188ad a {color:#0000ff;text-decoration:none;}#yiv3118626188 #yiv3118626188ygrp-sponsor #yiv3118626188ygrp-lc {font-family:Arial;}#yiv3118626188 #yiv3118626188ygrp-sponsor #yiv3118626188ygrp-lc #yiv3118626188hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3118626188 #yiv3118626188ygrp-sponsor #yiv3118626188ygrp-lc .yiv3118626188ad {margin-bottom:10px;padding:0 0;}#yiv3118626188 #yiv3118626188actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3118626188 #yiv3118626188activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3118626188 #yiv3118626188activity span {font-weight:700;}#yiv3118626188 #yiv3118626188activity span:first-child {text-transform:uppercase;}#yiv3118626188 #yiv3118626188activity span a {color:#5085b6;text-decoration:none;}#yiv3118626188 #yiv3118626188activity span span {color:#ff7900;}#yiv3118626188 #yiv3118626188activity span .yiv3118626188underline {text-decoration:underline;}#yiv3118626188 .yiv3118626188attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3118626188 .yiv3118626188attach div a {text-decoration:none;}#yiv3118626188 .yiv3118626188attach img {border:none;padding-right:5px;}#yiv3118626188 .yiv3118626188attach label {display:block;margin-bottom:5px;}#yiv3118626188 .yiv3118626188attach label a {text-decoration:none;}#yiv3118626188 blockquote {margin:0 0 0 4px;}#yiv3118626188 .yiv3118626188bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3118626188 .yiv3118626188bold a {text-decoration:none;}#yiv3118626188 dd.yiv3118626188last p a {font-family:Verdana;font-weight:700;}#yiv3118626188 dd.yiv3118626188last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3118626188 dd.yiv3118626188last p span.yiv3118626188yshortcuts {margin-right:0;}#yiv3118626188 div.yiv3118626188attach-table div div a {text-decoration:none;}#yiv3118626188 div.yiv3118626188attach-table {width:400px;}#yiv3118626188 div.yiv3118626188file-title a, #yiv3118626188 div.yiv3118626188file-title a:active, #yiv3118626188 div.yiv3118626188file-title a:hover, #yiv3118626188 div.yiv3118626188file-title a:visited {text-decoration:none;}#yiv3118626188 div.yiv3118626188photo-title a, #yiv3118626188 div.yiv3118626188photo-title a:active, #yiv3118626188 div.yiv3118626188photo-title a:hover, #yiv3118626188 div.yiv3118626188photo-title a:visited {text-decoration:none;}#yiv3118626188 div#yiv3118626188ygrp-mlmsg #yiv3118626188ygrp-msg p a span.yiv3118626188yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3118626188 .yiv3118626188green {color:#628c2a;}#yiv3118626188 .yiv3118626188MsoNormal {margin:0 0 0 0;}#yiv3118626188 o {font-size:0;}#yiv3118626188 #yiv3118626188photos div {float:left;width:72px;}#yiv3118626188 #yiv3118626188photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3118626188 #yiv3118626188photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3118626188 #yiv3118626188reco-category {font-size:77%;}#yiv3118626188 #yiv3118626188reco-desc {font-size:77%;}#yiv3118626188 .yiv3118626188replbq {margin:4px;}#yiv3118626188 #yiv3118626188ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3118626188 #yiv3118626188ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3118626188 #yiv3118626188ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3118626188 #yiv3118626188ygrp-mlmsg select, #yiv3118626188 input, #yiv3118626188 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3118626188 #yiv3118626188ygrp-mlmsg pre, #yiv3118626188 code {font:115% monospace;}#yiv3118626188 #yiv3118626188ygrp-mlmsg * {line-height:1.22em;}#yiv3118626188 #yiv3118626188ygrp-mlmsg #yiv3118626188logo {padding-bottom:10px;}#yiv3118626188 #yiv3118626188ygrp-msg p a {font-family:Verdana;}#yiv3118626188 #yiv3118626188ygrp-msg p#yiv3118626188attach-count span {color:#1E66AE;font-weight:700;}#yiv3118626188 #yiv3118626188ygrp-reco #yiv3118626188reco-head {color:#ff7900;font-weight:700;}#yiv3118626188 #yiv3118626188ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3118626188 #yiv3118626188ygrp-sponsor #yiv3118626188ov li a {font-size:130%;text-decoration:none;}#yiv3118626188 #yiv3118626188ygrp-sponsor #yiv3118626188ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3118626188 #yiv3118626188ygrp-sponsor #yiv3118626188ov ul {margin:0;padding:0 0 0 8px;}#yiv3118626188 #yiv3118626188ygrp-text {font-family:Georgia;}#yiv3118626188 #yiv3118626188ygrp-text p {margin:0 0 1em 0;}#yiv3118626188 #yiv3118626188ygrp-text tt {font-size:120%;}#yiv3118626188 #yiv3118626188ygrp-vital ul li:last-child {border-right:none !important;}#yiv3118626188

Wed May 17, 2017 6:38 am (PDT) . Posted by:

lexstar

Is anyone else having problem retrieving data using the smfPriceBetween() function? I get a 0 as the return data only.

Wed May 17, 2017 6:58 am (PDT) . Posted by:

friedman_steve

Yep. I'm getting #N/A when using smfPricesByDates


was working well yesterday.


Wed May 17, 2017 6:58 am (PDT) . Posted by:

gareneau

Yes, per the thread there seems to be a problem pulling historical date from Yahoo.

Wed May 17, 2017 7:24 am (PDT) . Posted by:

"Robbie Geary" rgearyiii

Interesting post from another Yahoo! Group.

---------- Forwarded message ----------
From: leov@qmatix.com [xlqusers] <xlqusers@yahoogroups.com>
Date: Wed, May 17, 2017 at 5:21 PM
Subject: RE: [xlqusers] Yahoo Data
To: xlqusers@yahoogroups.com

Hi

For historic data Yahoo recently added a new download system on their
site, but maintained support for the prior system. However after Monday's
close the new system continued to have the new data, whereas the old did
not, indicating that new servers had been put in place, and yesterday
(Tuesday) after market close the connection to the old servers were
terminated. As a result xlq will attempt to, but can no longer connect with
Yahoo for historic data, resulting in a 12029 error and a yellow, or
intermittent yellow Q on the task bar.

Their new download system works with encryption and cookies associated with
the web page being viewed, so it is likely that future downloads from Yahoo
historic cannot be supported in xlq. I will continue looking into what is
possible, updating xlq as needed, or alternatively removing yahoo historic
as a source.

Until then to ensure smooth processing from other sources etc., you should
remove any symbols under yahoo historic in the stock manager to ensure no
requests are made to the removed servers. You should also update your
workbooks, xlqCompanion etc. to not use yahoo historic as a source, using
the other sources where possible.

For information on symbol differences between sources please consult
http://www.qmatix.com/XLQSymbolGuide.htm

Yahoo day data continues to update, but it is always possible that they
apply similar changes.

When I have more information I will let you know.

Regards

Leo

---In xlqusers@yahoogroups.com, <Michael@Maher77.com> wrote :

I'm having the same problem. I think Leo is looking into it.

*Michael*

*From:* xlqusers@yahoogroups.com [mailto:xlqusers@yahoogroups.com]
*Sent:* Wednesday, 17 May 2017 12:25 PM
*To:* xlqusers@yahoogroups.com
*Subject:* [xlqusers] Yahoo Data

Is anyone else having issues connecting to yahoo right now?

Here is my connection log.

21:24:45 No Connection
21:24:46 Connection Failed (12029)
21:24:47 M IBUY Update Failed, retry
21:24:47 No Connection
21:24:48 D IBUY Begin Processing
21:24:48 M IBUY Begin Processing
21:24:49 Processing...
21:24:49 Connection Failed (12029)
21:24:49 W IBUY Update Failed, retry
21:24:49 No Connection
21:24:50 W IBUY Begin Processing
21:24:51 Processing...
21:24:54 Connection Failed (12029)
21:24:55 D IBUY Update Failed, retry
21:24:55 M IBUY Update Failed, retry
21:24:55 No Connection

--
Robbie Geary

Wed May 17, 2017 7:34 am (PDT) . Posted by:

rr76012

We all appreciate you lookin at the downloading of yahoo historical stock prices. I myself like others so depend on rchgetyahoohistory.


thank you.

Wed May 17, 2017 9:09 am (PDT) . Posted by:

tonyestep

I'm not sure what changes Yahoo made, but here's where things seem to be now.
If you access Yahoo historical prices manually, you wind up at a page like, for example: https://finance.yahoo.com/quote/SPY/history/ https://finance.yahoo.com/quote/SPY/history/

If you specify a date range, the URL looks like this:
https://finance.yahoo.com/quote/SPY/history?period1=1431838800&period2=1494997200&interval=1d&filter=history&frequency=1d https://finance.yahoo.com/quote/SPY/history?period1=1431838800&period2=1494997200&interval=1d&filter=history&frequency=1d



Looking at the source of the page that is returned, the prices are there in the HTML, so presumably the source of our problem is just that Yahoo has re-written the code that formats the page. I sort of know how to parse this kind of page with Python, but I admit that I have no idea how to do it with VBA.

Wed May 17, 2017 9:40 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I can't even navigate to the new pages with the IE object that EXCEL uses,
and Yahoo is using cookies to require access. So it appears the data may no
longer be accessible to the add-in.

This is what I've been saying all along -- it wouldn't take that much for
the online services to prevent automated access to their data.

On Wed, May 17, 2017 at 9:09 AM, tonyestep@
​...wrote:

>
> I'm not sure what changes Yahoo made, but here's where things seem to be
> now.
> If you access Yahoo historical prices manually, you wind up at a page
> like, for example:
> https://finance.yahoo.com/quote/SPY/history/
> If you specify a date range, the URL looks like this:
> https://finance.yahoo.com/quote/SPY/history?period1=
> 1431838800&period2=1494997200&interval=1d&filter=history&frequency=1d
>
> Looking at the source of the page that is returned, the prices are there
> in the HTML, so presumably the source of our problem is just that Yahoo
> has re-written the code that formats the page. I sort of know how to parse
> this kind of page with Python, but I admit that I have no idea how to do it
> with VBA.
>
>

Wed May 17, 2017 9:47 am (PDT) . Posted by:

rr76012

Hi Randy,


I just wanted to say hang in there, we all know how smart you really are...We all are behind you.


Yahoo history download has really thrown us all a curve ball.


rr76012

Wed May 17, 2017 9:50 am (PDT) . Posted by:

rr76012

Hi Tonyestep,


I wish you the very best to help find a solution to yahoo historical stock price downloads.


Thank you for trying very hard


I, we, all know randy will do all that he can.


rr76012

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 09.50

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)