Description of problem: The perl-Finance-Quote package from 2022-Dec-26 is far too old to be useful. Please update this to version 1.59. Without updating to the newest version, fetching quotes from many sources results in error. The broken modules have been fixed in all F::Q versions up to 1.59. This old version is using Yahoo finance URLs for their v7 API that has been shut down (e.g. https://query1.finance.yahoo.com/v7/finance/quote?symbols=APPL). The new version uses the new URLs (e.g. https://query1.finance.yahoo.com/v8/finance/chart/APPL). This old F::Q version also has the Alphavantage quote bug whereby having more than 5 currencies results in only the 5 being fetched and the rest resulting in errors. With the free version of Alphavantage, you can only have 5 API requests a minute. So you have to wait, as F::Q version 1.59 does. Version-Release number of selected component (if applicable): 1.54 How reproducible: 100% Steps to Reproduce: 1. Simply run the following Gnucash command line script: $ gnc-fq-dump -v yahoo_json AAPL 2. Observe the error due to the no-longer functional Yahoo finance v7 API URL, that was fixed in F::Q version 1.59.
Assignee: bugsquad => pkg-bugs
Assigning to QA, Packages in 9/Core/Updates_testing: ====================== perl-Finance-Quote-1.590.0-1.mga9.noarch.rpm From SRPMS: perl-Finance-Quote-1.590.0-1.mga9.src.rpm
CC: (none) => geiger.david68210Assignee: pkg-bugs => qa-bugs
I've tested version 1.59 from "Core/Updates testing" and the Yahoo quote fetching is working again. There is still a problem with Alphavantage quote fetching trying more than 5 a minute, causing a lot of failures, however I can report this upstream. Thank you!
For the record, the AlphaVantage problem (https://github.com/finance-quote/finance-quote/issues/361) can be avoided completely by setting the environmental variable "FQ_CURRENCY" to "YahooJSON". This switches from the default of AlphaVantage, who are becoming more and more restrictive with their free quote fetching accounts, to the unlimited YahooJSON interface.
I have gnucash installed but gnc-like commnands not found.
CC: (none) => herman.viaene
I think we need some extra steps to reproduce the issue, I try to adapt what I see https://wiki.gnucash.org/wiki/Online_Quotes to the report but need more work
The current package update without issues to testing version VM mageia 9 x86_64
CC: (none) => tarazed25
Len, can you handle advisory for this report?
Sorry, gnc-fq-dump was the old Gnucash command. The current version uses: $ gnucash-cli -V --quotes dump yahoo_json AAPL
(In reply to Edward d'Auvergne from comment #8) > Sorry, gnc-fq-dump was the old Gnucash command. The current version uses: > > $ gnucash-cli -V --quotes dump yahoo_json AAPL For the record, the result on mga9 with F::Q v1.540 is: $ gnucash-cli -V --quotes dump yahoo_json AAPL Finance::Quote reported a failure for symbol AAPL: Error retrieving quote for AAPL. Attempt to fetch the URL https://query1.finance.yahoo.com/v7/finance/quote?symbols=AAPL resulted in HTTP response 401 (Unauthorized) $ And with the newer v1.590: $ gnucash-cli -V --quotes dump yahoo_json AAPL AAPL: eps => 6.43 open => 173.15 low => 171.02 pe => 26.940903 date => 03/12/2024 year_range => 149.92 - 199.62 last => 173.23 currency => USD method => yahoo_json exchange => NasdaqGS div_yield => 0.54992763 symbol => AAPL high => 174.03 volume => 58529744 name => AAPL (Apple Inc.) type => EQUITY isodate => 2024-03-12 success => 1 close => 172.75 $
(In reply to Edward d'Auvergne from comment #9) I'll trust you because I think a configuration step is needed LC_ALL=C gnucash-cli -V --quotes dump yahoo_json AAPL Price retrieval failed: Failed to initialize Finance::Quote: missing_modules JSON::Parse
CC: (none) => andrewsfarm
Whiteboard: (none) => MGA9-64-OK
Keywords: (none) => advisory
Validating.
Keywords: (none) => validated_updateCC: (none) => sysadmin-bugs
An update for this issue has been pushed to the Mageia Updates repository. https://advisories.mageia.org/MGAA-2024-0108.html
Status: NEW => RESOLVEDResolution: (none) => FIXED
(In reply to katnatek in comment #7) Sorry katnatek, I have been out of touch today - have only just now checked my email.
(In reply to Len Lawrence from comment #13) > (In reply to katnatek in comment #7) > > Sorry katnatek, I have been out of touch today - have only just now checked > my email. Don't sorry, we all have lives beyond mageia Next time