Bug 491353 - Online price updates stopped working
Summary: Online price updates stopped working
Status: RESOLVED WORKSFORME
Alias: None
Product: kmymoney
Classification: Applications
Component: file (show other bugs)
Version: 5.1.2
Platform: Ubuntu Other
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-08-06 14:36 UTC by LibertyCircle
Modified: 2024-08-10 13:31 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description LibertyCircle 2024-08-06 14:36:11 UTC
KMyMoney does no Crypto Currency Price Update any more

SUMMARY:
I use KMyMoney version 5.1.2. on KUbuntu. "Update stock and currency prices" do not work any more with all crypto currencies. As an "Online source" I use Financial Times for all stocks, due to Yahoo Finance is not working any more.

I tried CoinGecko API and added it with direct link https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=usd and as a bash script. JQ and Curl are installed. 

STEPS TO REPRODUCE
1. Use CoinGecko or any other Online Quotes to get the recent Bitcoin rate in USD.
2. Adding a CoinGecko Script or Direct Link in KMyMoney - Configure - Online Quotes
3. Set the Online Source for Bitcoin/BTC to the CoinGecko Script or Direct Link.

OBSERVED RESULT
Error Message with Direct Link to CoinGecko:
Fetching URL https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=usd...
Identifier found: ''
Unable to update price for ₿itcoin ₿ [BTC] (no price or no date)

Error Message with Script to CoinGecko:
Executing /home/user/cryptocurrency-fetch-price.sh
Identifier found: ''
Price found: '' (0)
Received an invalid price for BTC, unable to update.

EXPECTED RESULT
Get the Online Price Update for Bitcoin.

SOFTWARE/OS VERSIONS
Linux/KDE Plasma: KUbuntu 22.04
KDE Plasma Version: 5.24.7
KDE Frameworks Version: 5.92.0
Qt Version: 5.15.3

ADDITIONAL INFORMATION
I also tried different settings, e.g. leaving date and price field blank and changed other settings to no avail.
Comment 1 Thomas Baumgart 2024-08-10 13:31:54 UTC
I was able to extract data from coingecko.com using the latest master versions of Alkimia and KMyMoney. Older versions may not be able to extract the date because they don't support %u as date format but the price should be doable.

Online quote settings generated with Alkimia 8.1.72-45fc9b7-webengine-qtnetwork

URL: https://api.coingecko.com/api/v3/simple/price?ids=%1&vs_currencies=%2&include_last_updated_at=true
Download mode: Default
Data format: HTML
Identifier: 
Select by: Symbol
Price: :{"[^"]+":([^,]+),
Price decimal separator: Period (.)
Date: "last_updated_at":(\d+)
Date format: %u
Default identifier: 
Remote source: not checked


Result:

Fetching URL https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=usd&include_last_updated_at=true...
URL found: https://api.coingecko.com/api/v3/simple/price?ids=bitcoin&vs_currencies=usd&include_last_updated_at=true...
Symbol found: ''
Price found: '60665' (60.665)
Date found: '1723296361'
Date format found: '1723296361' -> 'Sa. Aug. 10 2024'
bitcoin usd bitcoin usd Sa. Aug. 10 2024 60665