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!!!
See my post above!!!
Mike, the SMF extension was last worked on by Dave Capro who released version 7.0 about 5 or 6 years ago. Dave was not the creator or the originator. There were several people involved. I had the same problem as the OP and was hoping for some help from other users more knowledgeable and skillful than myself.
Sometime ago, I forked SMF-Extension and added new functions to retrieve historical stock data from Yahoo (see SMF-Extension-Fork). Unfortunately, Yahoo terminated the historical stock data service somewhere around 5/15/2017 and I had to fall back to a lesser Google service that only reliably provides historical closing prices.
Today, I changed the Yahoo URL from finance.yahoo.com to download.finance.yahoo.com. This should fix the problems discussed in this thread. If you are interested in giving the updated extension a try, you can find it here.
I am unable to install SMF 8.6 on LO 5.2.7. New at this and I could use some help.
john