Error 501

[lixuuu]

Hi everyone,

I installed the last version of Financials-Extension.oxt in 3.0.8 but I always get the error message 501 when I try the following formula =GETREALTIME("ASTO.L",25,"yahoo")

OS : Kubuntu 18.04

kfocal@kfocal:~$ libreoffice --version
LibreOffice 6.4.7.2 40(Build:2)
kfocal@kfocal:~$ python --version
Python 2.7.18
kfocal@kfocal:~$ python3 --version
Python 3.8.10

Would you know why I get this error ? Did I miss something in the installation ?

[cmallwitz]

Not sure what is going on here. The formulae works for me and the data is consistent with https://finance.yahoo.com/quote/ASTO.L?p=ASTO.L - under your home directory, you can check if a file .financials-extension/yahoo-ASTO.L.html exists too.

Are you on the latest version 3.0.8 ?

You can get a bunch of details when putting this in a LibreCalc cell: =GETREALTIME("SUPPORT")

On Wed, 7 Dec 2022 at 21:49, lixuuu @.***> wrote:

Hi everyone,

I installed the last version of Financials-Extension.oxt in 3.0.8 but I always get the error message 501 when I try the following formula =GETREALTIME("ASTO.L",25,"yahoo")

OS : Kubuntu 18.04

@.:~$ libreoffice --version LibreOffice 6.4.7.2 40(Build:2) @.:~$ python --version Python 2.7.18 @.***:~$ python3 --version Python 3.8.10

Would you know why I get this error ? Did I miss something in the installation ?

— Reply to this email directly, view it on GitHub https://github.com/cmallwitz/Financials-Extension/issues/66, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA226T3PMXPO4IZ35YQPKQTWMEA7TANCNFSM6AAAAAASXK73LA . You are receiving this because you are subscribed to this thread.Message ID: @.***>

[cmallwitz]

or in fact, lastet 3.0.9 version.

[lixuuu]

I just installed the latest version of the extension and I'm even in version 3.1. The latest version has installed well as shown by the SUPPORT function

=GETREALTIME("SUPPORT")

ctx=pyuno object (com.sun.star.uno.XComponentContext)0x55648d057e10{, supportedInterfaces={com.sun.star.uno.XComponentContext,com.sun.star.container.XNameContainer,com.sun.star.lang.XTypeProvider,com.sun.star.uno.XWeak,com.sun.star.lang.XComponent}}
id(self)=140193303741632
version=3.1.0
file=/home/kfocal/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu53140mrbvqo.tmp_/Financials-Extension.oxt/financials.py
cwd=/home/kfocal
home=/home/kfocal
uname=Linux kfocal 5.15.0-56-generic #62~20.04.1-Ubuntu SMP Tue Nov 22 21:24:20 UTC 2022 x86_64 x86_64
pid=53735
sys.executable=/usr/bin/python3
sys.version=3.8.10 (default, Nov 14 2022, 12:59:47)  [GCC 9.4.0]
sys.path=['/home/kfocal/.config/libreoffice/4/user/uno_packages/cache/uno_packages/lu53140mrbvqo.tmp_/Financials-Extension.oxt', '/usr/lib/libreoffice/program', '/usr/lib/python38.zip', '/usr/lib/python3.8', '/usr/lib/python3.8/lib-dynload', '/home/kfocal/.local/lib/python3.8/site-packages', '/usr/local/lib/python3.8/dist-packages', '/usr/lib/python3/dist-packages', '/usr/lib/python3.8/dist-packages', '/usr/lib/libreoffice/program']
locale=('en_US', 'UTF-8')
defaultlocale=('en_US', 'UTF-8')
dateutil=2.8.1
pytz=2021.1
pyparsing=2.4.7
six=1.15.0

But strangely I still have the error 51 I can reach the url https://finance.yahoo.com/quote/ASTO.L?p=ASTO.L I forgot to mention that I don't have a firewall on my computer.

But I don't have file named yahoo-ASTO.L.html as you. Here my files :

kfocal@kfocal:~/.financials-extension$ ls -lt
total 14272
-rw-rw-r-- 1 kfocal kfocal   74066 déc.  13 22:59  trace.log
-rw-rw-r-- 1 kfocal kfocal  148803 nov.   1 09:15 'yahoo-^GDAXI.csv'
-rw-rw-r-- 1 kfocal kfocal  124907 nov.   1 09:15  yahoo-SAP.DE.csv
-rw-rw-r-- 1 kfocal kfocal  131166 nov.   1 09:15  yahoo-VOD.L.csv
-rw-rw-r-- 1 kfocal kfocal  121838 nov.   1 09:15  yahoo-INTC.csv
-rw-rw-r-- 1 kfocal kfocal  128691 nov.   1 09:15  yahoo-IBM.csv
-rw-rw-r-- 1 kfocal kfocal  867519 nov.   1 09:15  yahoo-NO_NAME.html
-rw-rw-r-- 1 kfocal kfocal   14894 nov.   1 09:15  yahoo-C060.DE.js
-rw-rw-r-- 1 kfocal kfocal  866170 nov.   1 09:15  yahoo-C060.DE.html
-rw-rw-r-- 1 kfocal kfocal   15699 nov.   1 09:15  yahoo-VERX.L.js
-rw-rw-r-- 1 kfocal kfocal  867044 nov.   1 09:15  yahoo-VERX.L.html
-rw-rw-r-- 1 kfocal kfocal   14758 nov.   1 09:15  yahoo-DELT.TA.js
-rw-rw-r-- 1 kfocal kfocal  895843 nov.   1 09:15  yahoo-DELT.TA.html
-rw-rw-r-- 1 kfocal kfocal   39053 nov.   1 09:15  yahoo-VFIAX.js
-rw-rw-r-- 1 kfocal kfocal  886898 nov.   1 09:15  yahoo-VFIAX.html
-rw-rw-r-- 1 kfocal kfocal   18763 nov.   1 09:15  yahoo-6503.T.js
-rw-rw-r-- 1 kfocal kfocal  915013 nov.   1 09:15  yahoo-6503.T.html
-rw-rw-r-- 1 kfocal kfocal    4583 nov.   1 09:15 'yahoo-^GSPC.js'
-rw-rw-r-- 1 kfocal kfocal  908715 nov.   1 09:15 'yahoo-^GSPC.html'
-rw-rw-r-- 1 kfocal kfocal   17789 nov.   1 09:15  yahoo-SAP.DE.js
-rw-rw-r-- 1 kfocal kfocal  927319 nov.   1 09:15  yahoo-SAP.DE.html
-rw-rw-r-- 1 kfocal kfocal    4518 nov.   1 09:15 'yahoo-^GDAXI.js'
-rw-rw-r-- 1 kfocal kfocal  877288 nov.   1 09:15 'yahoo-^GDAXI.html'
-rw-rw-r-- 1 kfocal kfocal   16299 nov.   1 09:15  yahoo-VOD.L.js
-rw-rw-r-- 1 kfocal kfocal  925459 nov.   1 09:15  yahoo-VOD.L.html
-rw-rw-r-- 1 kfocal kfocal    4964 nov.   1 09:15  yahoo-ZVZZT.js
-rw-rw-r-- 1 kfocal kfocal  848604 nov.   1 09:15  yahoo-ZVZZT.html
-rw-rw-r-- 1 kfocal kfocal   85451 nov.   1 09:15  yahoo-INTC.js
-rw-rw-r-- 1 kfocal kfocal 1024773 nov.   1 09:15  yahoo-INTC.html
-rw-rw-r-- 1 kfocal kfocal  867083 nov.   1 09:15  yahoo-IBM210618C00090000.html
-rw-rw-r-- 1 kfocal kfocal    4333 nov.   1 09:14 'yahoo-EURGBP=X.js'
-rw-rw-r-- 1 kfocal kfocal  844006 nov.   1 09:14 'yahoo-EURGBP=X.html'
-rw-rw-r-- 1 kfocal kfocal   47056 nov.   1 09:14  yahoo-IBM.js
-rw-rw-r-- 1 kfocal kfocal  996862 nov.   1 09:14  yahoo-IBM.html
-rw-rw-r-- 1 kfocal kfocal       0 nov.   1 09:05  extension.log
kfocal@kfocal:~/.financials-extension$ 
kfocal@kfocal:~/.financials-extension$ pwd
/home/kfocal/.financials-extension
kfocal@kfocal:~/.financials-extension$ 

[cmallwitz]

Still no idea what is going on :-(

Can close LibreOffice and delete all files in ~/.financials-extension ? Then could you open LibreCalc, create a new/empty spread sheet and copy the below in two cells ?

=GETREALTIME("ASTO.L",25,"YAHOO") =GETREALTIME("ASTO:LSE",25,"FT")

What does the file ~/.financials-extension/trace.log contain now ?

[felsan1]

Hi there.

Can you ensure this package has been installed? apt list libreoffice-script-provider-python If it does not installed, do it. I think the ticker must be write in uppercase. It works for me.

[ijko314]

The same issue. Oh, sorry, my bad. If use ";" as parameters separator - all ok. Thanks.