I’m now getting the error in the cell where I’m attempting to use GETYAHOO…unknown url type: https. I’ve killed the original extension thinking it may have gotten corrupted and reloaded it. Same result. What happened?
I had the same problem. Searched my system for “yahoo.py” and updated the URL in it to “http://download.finance.yahoo.com/d/quotes.csv?s=%s&f=%s&e=.csv”. Seems to work now.
Tom, please detail the steps involved. I am on the latest Win10 and cannot find yahoo.py on my system. LIbre office version 5.2.7 and SMF version 7.0 same error as OP unknown url type: https. I used this SMF to retrieve about 50 symbols daily and suddenly it went kaput. I have installed and reinstalled LO and Apache OO to no avail.
HI tom, please detail the steps involved. I am Win10 last version and LO v 5.2.7 and SMF v 7.0. Cannot find yahoo.py on my system.
After many hours I finally fixed the problem. Thank you Thomas for pointing out the direction. Really appreciated it. Who changed the previously working SMF is a mystery for me.
I have the same problem. IMHO Yahoo changed something andhe original URL no longer works.
One must find the file yahoo.py which going to be somewhere in the hierarchy of where the extension is installed. On a mac, it is down in ~/Library/Application Support. I don’t know where it is on a PC.
Once you find the file, you need to use a (dumb) text editor to change http://finance… to http://download.finance.
Note that getQuote in OO is also broken. I don’t know how to fix getQuote - yet.
husky1055, I’m having this problem also. I located and modified yahoo.py but still see the same behaviour. Can you outline the steps you took to correct this?
Many thanks,
since =INDIRECT(CONCATENATE("‘http://finance.yahoo.com/d/quotes.csv?s=",A4,"&f=l1’#Sheet1.a1")) works perfectly fine with a ticker in the A4 cell, this is not the problem. Something about the python script is out of wack. Its been doing it to me before i updated to 5.x. There is no yahoo.py anywhere in my win10 system other than in the zip containing the source.
On windows 10 I found yahoo.py buried deep in my user directory:
C:\Users\username\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu860428wnkp.tmp_\smf.oxt\yahoo.py
Yahoo is redirecting the old url to “https://finance.yahoo.com/d/quotes.csv”, which is where the python script fails (it doesn’t seem to be able to handle https). If that redirect had worked they would have been redirected again to “http://download.finance.yahoo.com/d/quotes.csv”, which python can handle.
Thomas outlined the exact steps needed to fix this issue. Just to be clear, yahoo.py is a folder not a file. the file you needed is smf.oxt. You will then use notepad to edit the url as mentioned above. I have several computers and laptops and want to verified if they all needed to be fixed before posting all the steps. You canot just edit the smf.oxt in your various locations. It has to be in yahoo.py folder as outlined above. Hope it helps somebody.
couple of things:
- yahoo.py is the file to change, not the directory. 2. you may have more than one tmp directory under uno_packages if you’ve removed and reinstalled the extension multiple times. in the cache directory, view the pmap file to find the correct one (install notepad++ if you get garbage with notepad) 3. do not have LO open. 4. Just add download. to the beginning of the url. the rest stays the same. 5. If you get garbage when opening the file, install notepad++
it appears that when yahoo took their EOD data offline a couple days ago they redirected that url to a https which requires a token/cookie/crumb which python is choking on. Formulas don’t have the secure session problem.There are a lot of angry people running around because they lost their historical chart data.
You are right, I went back and checked. 1. yahoo.py is the file to change 2. it’s in the folder smf.oxt under uno_packages. Note my desktops have no problem when hardwired to the network. Laptops through wifi have the problem. At least that’s the experience for me!!!
I found and modified the yahoo.py file as described above (located in the smf.oxt directory). Unfortunately, I ran into the same problem described by husky1005 - that the “download.yahoo” fix doesn’t appear to work if using a laptop on WiFi like I am.
Update - after several unsuccessful previous attempts, I was able to fix the problem! The mistake I made was to that I updated the wrong yahoo.py file (apparently I have more than one). I found and updated the URL to http://download.finance…at this location in Windows: C:\Users\User\AppData\Roaming\LibreOffice\4\user\uno_packages\cache\uno_packages\lu75042obweb.tmp_\SMF-Extension-0.7.0.zip… Make sure LO is closed before updating the file.
The problems with extensions should be reported to those extensions authors. It may be a problem in extension itself (and just happened to work because it relied on something incorrectly); or it might happen that the problem is really in LibreOffice; but only a person familiar with extension code can sort it out and fix it in the extension’s code, or work with LO community to get it fixed. Please use extension’s home page (or documentation that comes with it) to find ways to contact them.
Mike, the SMF extension has not been changed and/or updated for years. David Capro was the last person working on it. I have been using this extension for a few years and suddenly have this problem explained exactly by the OP. I have not been able to identify the cause of this problem and am hoping for some help from others users who might have some helpful solution or idea.
OK. So I see that you two have found some solution, (btw @husky1055 didn’t even shared exact steps for others to benefit) and SMF-Extension’s bug tracker wasn’t used to file a bug. Thus, whoever might want to jump in and take over/fork, wouldn’t even know about such a problem. That’s what I’m talking about, and that isn’t community-friendly.
Husky1055 could you please detail your solution.
Thanks
sorry, I’m totally new to LO and to this community. as I posted above, this cause of this problem appears to be a change made by Yahoo (or possibly some DNS issue). All that needs to happen is that SMF.oxt needs to be updated by changing the URL in yahoo.py. (from http://finance… to http://download.finance…)If one of you gurus would be kind enough to file the bug, I would really appreciate it. Yes, I should do it, but this change has already eaten up two days of my time. many thanks!!!