search

cmallwitz / Financials-Extension

Extension for LibreOffice Calc to access stock market data
Other
152 stars 21 forks source link

=GETHISTORIC("IBM",90,"2020-12-01","YAHOO") has an error #11

Closed omoknen closed 3 years ago

omoknen commented 3 years ago

Using LO Windows 6.4.7.2 (x64) Get GETREALTIME command works, but GETHISTORIC command doesn't work. We received an error in the cell of:

Date format not supported: '2020-12-01'

We can not figure out why that happened. We tried alternate dates and symbols still the same error. I wish I knew something about Python. I did check the error message and I know it is about "dateutil" and I checked it is installed in LO.

We looked at the download on the page and that date format looks the same. Is there something we can change? Thank you

cmallwitz commented 3 years ago

Assuming you use a recent version, could you check file extension.log in directory .financials-extension under the current users home directory if it contains any usable error message? What is your Windows language?

You could copy/paste the output from =GETREALTIME("SUPPORT") here.

And check the the details for the =GETHISTORIC call in the trace.log file in same location as above?

omoknen commented 3 years ago

Using Windows 10 Pro English, I decided to put both a getrealtime and a gethistoric on a single sheet.

The "extension.log" had nothing, so I looked at the "trace log" and it had the same kind if messages.

2021-01-01 14:00:51.794242 getRealtime args=('IBM', 21.0, 'YAHOO') r='125.88' 2099.483 ms 2021-01-01 14:00:51.794242 getHistoric args=('IBM', 90.0, '2020-11-01', 'YAHOO') r='Date format not supported: '2020-11-01'' 0.115 ms 2021-01-01 14:00:51.794242 getRealtime args=('IBM', 21.0, 'YAHOO') r='125.88' 0.033 ms 2021-01-01 14:00:51.794242 getHistoric args=('IBM', 90.0, '2020-11-01', 'YAHOO') r='Date format not supported: '2020-11-01'' 0.097 ms 2021-01-01 14:01:03.518853 getRealtime *args=('DIS', 21.0, 'YAHOO') r='181.18' 1105.451 ms

getHistoric is above

GETREALTIME("SUPPORT") reads

ctx=pyuno object (com.sun.star.uno.XComponentContext)0x217995c16b0{, 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)=2300932923912 version=2.4.0 file=D:\Applications\Winapp\LibreOffice\share\uno_packages\cache\unopackages\lu7116kolq2.tmp\Financials-Extension.oxt\financials.py cwd=D:\Applications\Winapp\LibreOffice\program home=C:\Users############ uname=Windows Spring 10 10.0.19041 AMD64 Intel64 Family 6 Model 158 Stepping 9, GenuineIntel pid=5696 sys.executable=D:\Applications\Winapp\LibreOffice\program\soffice.bin sys.version=3.7.7 (default, Oct 7 2020, 21:30:40) [MSC v.1916 64 bit (AMD64)] locale=(None, None)

cmallwitz commented 3 years ago

I have uploaded a new release of the extension to fix this issue (I hope) - let me know if that works for you. For the record, the was the (normal) Python locale not being set on Windows.

omoknen commented 3 years ago

Thanks it worked - you worked so fast!

I saw that in the release about the locale, since all my settings are defaulted in LO it must take it from the OS. That was probably the problem.

cmallwitz commented 3 years ago

Good to know! closing...