Bug 501961 - Quotes fail
Summary: Quotes fail
Status: RESOLVED NOT A BUG
Alias: None
Product: kmymoney
Classification: Applications
Component: general (other bugs)
Version First Reported In: 5.1.3
Platform: Other Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-03-24 23:24 UTC by Pete
Modified: 2025-04-02 13:37 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 Pete 2025-03-24 23:24:34 UTC
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/BUG...
Timeout on server query1.finance.yahoo.com: Socket operation timed out
Unable to update price for BUG (empty quote data)
Fetching URL https://fx-rate.net/CAD/USD...
Timeout on server fx-rate.net: Socket operation timed out
Unable to update price for CAD > USD (empty quote data)

On 2025-03-21, this worked fine.
Comment 1 Jack 2025-03-25 17:12:11 UTC
That sounds like a (probably transient) problem with your network, not with KMyMoney.  What happens if you try to open the link you provided in a browser?
Comment 2 Pete 2025-03-25 22:22:05 UTC
(In reply to Jack from comment #1)
> That sounds like a (probably transient) problem with your network, not with
> KMyMoney.  What happens if you try to open the link you provided in a
> browser?

The problem is reproducible and constant.  This is not a network issue, the link loads properly in a browser.
Comment 3 Jack 2025-03-25 22:33:08 UTC
I can't replicate this, and it is going to be near impossible to solve unless someone can replicate the problem.
If you run KMM from command line, is there any useful console output when the problem happens?
Can you think of anything that has changed on your system since it last worked?  Any updates to network or Qt or KDE packages?  Any change to your network configuration?  Where exactly did those error messages show up?  (I'm looking for places I might start looking into the code to see what might trigger this error.)
Comment 4 Pete 2025-03-25 23:26:09 UTC
(In reply to Jack from comment #3)
> I can't replicate this, and it is going to be near impossible to solve
> unless someone can replicate the problem.
> If you run KMM from command line, is there any useful console output when
> the problem happens?
> Can you think of anything that has changed on your system since it last
> worked?  Any updates to network or Qt or KDE packages?  Any change to your
> network configuration?  Where exactly did those error messages show up? 
> (I'm looking for places I might start looking into the code to see what
> might trigger this error.)

I update Ubuntu 22.04 LTS every day. There is no way for me to know what happens under the hood.
Network config not changed by me.
The error messages show up in red in the window that is launched by the Tools menu item: Update Stock and Currency Prices.

When I select the first ticker (BUG) and update selected, it works fine.

The next entry is a currency update which fails with the following command line info:
created tmpfile
kf.kio.workers.file: readData() returned -1
kmymoney_webpricequote: quotedata ""
Comment 5 Pete 2025-03-26 00:34:45 UTC
Can you create a special test version of KMM 5.1.3-eef04f1 in an AppImage that does a trace of everything that happens once I click on Update All in the quotes window?
Comment 6 Thomas Baumgart 2025-03-26 14:46:34 UTC
Please try to use the current development (aka master) appimage to verify if that behaves the same way. Many things around online updates have been changed since the 5.1 branch and we don't really want to go back.
Comment 7 Pete 2025-03-26 15:12:10 UTC
(In reply to Thomas Baumgart from comment #6)
> Please try to use the current development (aka master) appimage to verify if
> that behaves the same way. Many things around online updates have been
> changed since the 5.1 branch and we don't really want to go back.

It also fails, but in a completely different way: (regex, currency)

(Debug) symbol=BUG id=E000366...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/BUG...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/BUG...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
Source User does not exist.   <=== this is a currency ****
(Debug) symbol=CMR.TO id=E000322...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/CMR.TO...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/CMR.TO...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
(Debug) symbol=CMR.TO id=E000324...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/CMR.TO...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/CMR.TO...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
(Debug) symbol=CVX id=E000389...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/CVX...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/CVX...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
(Debug) symbol=EUAD id=E000420...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/EUAD...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/EUAD...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
(Debug) symbol=MRK id=E000308...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/MRK...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/MRK...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
(Debug) symbol=NA.TO id=E000280...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/NA.TO...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/NA.TO...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
(Debug) symbol=PDBC id=E000290...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/PDBC...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/PDBC...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
(Debug) symbol=RIO id=E000388...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/RIO...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/RIO...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
(Debug) symbol=SMMT id=E000401...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/SMMT...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/SMMT...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
Source User does not exist.   <=== this is a currency ****
(Debug) symbol=VKTX id=E000381...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/VKTX...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/VKTX...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
Comment 8 Pete 2025-03-28 01:25:59 UTC
I tried AppImage 5.1.3218 on a fully patched Fedora 41 and failed as follows:

Fetching URL https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&symbols=BUG...
Unable to update price for BUG (no price or no date)
Fetching URL https://fx-rate.net/CAD/USD...
Identifier found: 'CAD/USD'
Unable to update price for CAD > USD (no price or no date)
Fetching URL https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&symbols=CMR.TO...
Unable to update price for CMR.TO (no price or no date)
Fetching URL https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&symbols=CMR.TO...
Unable to update price for CMR.TO (no price or no date)
Fetching URL https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&symbols=CVX...
Unable to update price for CVX (no price or no date)
Fetching URL https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&symbols=CVX...
Unable to update price for CVX (no price or no date)
Fetching URL https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&symbols=EUAD...
Unable to update price for EUAD (no price or no date)
Fetching URL https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&symbols=MRK...
Unable to update price for MRK (no price or no date)
Fetching URL https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&symbols=NA.TO...
Unable to update price for NA.TO (no price or no date)
Fetching URL https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&symbols=PDBC...
Unable to update price for PDBC (no price or no date)
Fetching URL https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&symbols=RIO...
Unable to update price for RIO (no price or no date)
Fetching URL https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&symbols=SMMT...
Unable to update price for SMMT (no price or no date)
Fetching URL https://fx-rate.net/USD/CAD...
Identifier found: 'USD/CAD'
Unable to update price for USD > CAD (no price or no date)
Fetching URL https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&symbols=VKTX...
Unable to update price for VKTX (no price or no date)
Comment 9 Pete 2025-03-28 01:29:02 UTC
I tried AppImage master 4196 on a fully patched Fedora 41 and failed as follows:

Note that I had to change v7 to v8 for the Yahoo URL.

(Debug) symbol=BUG id=E000366...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/BUG...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/BUG...
Unable to parse symbol for BUG
Price found: '33.5' (33.5)
Date found: '1743105601'
Date format found: '1743105601' -> ''
Received an invalid price for BUG, unable to update.
Source User does not exist.
(Debug) symbol=CMR.TO id=E000322...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/CMR.TO...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/CMR.TO...
Unable to parse symbol for CMR.TO
Price found: '50.01' (50.01)
Date found: '1743105540'
Date format found: '1743105540' -> ''
Received an invalid price for CMR.TO, unable to update.
(Debug) symbol=CMR.TO id=E000324...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/CMR.TO...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/CMR.TO...
Unable to parse symbol for CMR.TO
Price found: '50.01' (50.01)
Date found: '1743105540'
Date format found: '1743105540' -> ''
Received an invalid price for CMR.TO, unable to update.
(Debug) symbol=CVX id=E000389...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/CVX...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/CVX...
Unable to parse symbol for CVX
Price found: '166.65' (166.65)
Date found: '1743105631'
Date format found: '1743105631' -> ''
Received an invalid price for CVX, unable to update.
(Debug) symbol=CVX id=E000421...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/CVX...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/CVX...
Unable to parse symbol for CVX
Price found: '166.65' (166.65)
Date found: '1743105631'
Date format found: '1743105631' -> ''
Received an invalid price for CVX, unable to update.
(Debug) symbol=EUAD id=E000420...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/EUAD...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/EUAD...
Unable to parse symbol for EUAD
Price found: '34.34' (34.34)
Date found: '1743105600'
Date format found: '1743105600' -> ''
Received an invalid price for EUAD, unable to update.
(Debug) symbol=MRK id=E000308...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/MRK...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/MRK...
Unable to parse symbol for MRK
Price found: '87.6' (87.6)
Date found: '1743105624'
Date format found: '1743105624' -> ''
Received an invalid price for MRK, unable to update.
(Debug) symbol=NA.TO id=E000280...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/NA.TO...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/NA.TO...
Unable to parse symbol for NA.TO
Price found: '120.35' (120.35)
Date found: '1743105600'
Date format found: '1743105600' -> ''
Received an invalid price for NA.TO, unable to update.
(Debug) symbol=PDBC id=E000290...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/PDBC...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/PDBC...
Unable to parse symbol for PDBC
Price found: '13.51' (13.51)
Date found: '1743105600'
Date format found: '1743105600' -> ''
Received an invalid price for PDBC, unable to update.
(Debug) symbol=RIO id=E000388...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/RIO...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/RIO...
Unable to parse symbol for RIO
Price found: '62.34' (62.34)
Date found: '1743105602'
Date format found: '1743105602' -> ''
Received an invalid price for RIO, unable to update.
(Debug) symbol=SMMT id=E000401...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/SMMT...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/SMMT...
Unable to parse symbol for SMMT
Price found: '20.6' (20.6)
Date found: '1743105600'
Date format found: '1743105600' -> ''
Received an invalid price for SMMT, unable to update.
Source User does not exist.
(Debug) symbol=VKTX id=E000381...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/VKTX...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/VKTX...
Unable to parse symbol for VKTX
Price found: '26.13' (26.13)
Date found: '1743105600'
Date format found: '1743105600' -> ''
Received an invalid price for VKTX, unable to update.
Comment 10 Pete 2025-03-28 02:26:16 UTC
On an always fully patched Ubuntu 24.04 LTS, the AppImage 5.1.3218 worked fine.

However, the AppImage master 4196 failed the exact same way as on Fedora 41 above.
Comment 11 Thomas Baumgart 2025-03-28 07:46:57 UTC
What happens if you follow the instructions on https://discuss.kde.org/t/yahoo-finance-online-quote-date-format-problem/32140 ?
Comment 12 Pete 2025-03-28 11:28:26 UTC
Ubuntu 22.04
master 4196
date format to %u
FAILS:

(Debug) symbol=BUG id=E000366...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/BUG...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/BUG...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
Source User does not exist.
(Debug) symbol=CMR.TO id=E000322...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/CMR.TO...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/CMR.TO...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
Comment 13 Pete 2025-03-28 11:29:03 UTC
Ubuntu 24.04
master 4196
date format to %u
FAILS:

(Debug) symbol=BUG id=E000366...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/BUG...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/BUG...
Unable to parse symbol for BUG
Price found: '33.5' (33.5)
Date found: '1743105601'
Date format found: '1743105601' -> 'Thu Mar 27 2025'
Price for BUG updated to $33.50 for 3/27/2025 (id E000366)
Source User does not exist.
Comment 14 Thomas Baumgart 2025-03-28 21:19:14 UTC
> Price for BUG updated to $33.50 for 3/27/2025 (id E000366)
That clearly states that the price was updated, so it worked.

> Source User does not exist.
is most likely caused by a different price entry. Check your price entries and update the source.

> Unable to find date column '"regularMarketTime":([\d]+)' in quote data
Possibly, they changed their site content again. Welcome to the dynamic world of web scraping.  The regex for date needs to be adjusted.
Comment 15 Pete 2025-03-28 21:36:18 UTC
>> Source User does not exist.

>is most likely caused by a different price entry. Check your price entries and update the source.

This source is (or should be) your currency URL https://fx-rate.net/%1/%2

What do you mean by "Check your price entries and update the source" ?
Comment 16 Thomas Baumgart 2025-03-30 08:23:59 UTC
Take a look at https://docs.kde.org/stable5/en/kmymoney/kmymoney/investment-onlineupdate.png. It shows the Source column. One (or more) row(s) contains the value 'User'. In versions 5.1.90+ this may look slightly different, but you can double click that text in the Source column to change it to another 'source' e.g. 'KMyMoney currency'.
Comment 17 Pete 2025-03-30 14:08:00 UTC
On Ubuntu 22.04, I changed the 2 User sources to "KMyMoney Currency" and the quote update still fails as follows:

Start date moved to before the weekend
(Debug) symbol=BUG id=E000366...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/BUG...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/BUG...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
(Debug) symbol=CAD > USD id=CAD USD...
Fetching URL https://fx-rate.net/CAD/USD...
URL found: https://fx-rate.net/CAD/USD...
Symbol found: ''
Price found: '0.69534' (0.69534)
Date found: '30 Mar 2025'
Date format found: '30 Mar 2025' -> ''
Received an invalid price for CAD > USD, unable to update.
(Debug) symbol=CMR.TO id=E000322...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/CMR.TO...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/CMR.TO...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
(Debug) symbol=CMR.TO id=E000324...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/CMR.TO...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/CMR.TO...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
(Debug) symbol=CVX id=E000389...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/CVX...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/CVX...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
(Debug) symbol=CVX id=E000421...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/CVX...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/CVX...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
(Debug) symbol=EUAD id=E000420...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/EUAD...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/EUAD...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
(Debug) symbol=NA.TO id=E000280...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/NA.TO...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/NA.TO...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
(Debug) symbol=PDBC id=E000290...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/PDBC...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/PDBC...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
(Debug) symbol=RIO id=E000388...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/RIO...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/RIO...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
(Debug) symbol=SMMT id=E000401...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/SMMT...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/SMMT...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
(Debug) symbol=USD > CAD id=USD CAD...
Fetching URL https://fx-rate.net/USD/CAD...
URL found: https://fx-rate.net/USD/CAD...
Symbol found: ''
Price found: '1.4382' (1.4382)
Date found: '30 Mar 2025'
Date format found: '30 Mar 2025' -> ''
Received an invalid price for USD > CAD, unable to update.
(Debug) symbol=VKTX id=E000381...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/VKTX...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/VKTX...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data
Comment 18 Thomas Baumgart 2025-03-30 14:49:46 UTC
You have two problems: a) Yahoo and b) fx-rate.net.

a) shows as

(Debug) symbol=BUG id=E000366...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/BUG...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/BUG...
Unable to find date column '"regularMarketTime":([\d]+)' in quote data

and b) shows as

(Debug) symbol=CAD > USD id=CAD USD...
Fetching URL https://fx-rate.net/CAD/USD...
URL found: https://fx-rate.net/CAD/USD...
Symbol found: ''
Price found: '0.69534' (0.69534)
Date found: '30 Mar 2025'
Date format found: '30 Mar 2025' -> ''
Received an invalid price for CAD > USD, unable to update.

In both scenarios, the online settings you use are missing something. Here is how that looks for me:

(Debug) symbol=CAD > USD id=CAD USD...
Fetching URL https://fx-rate.net/CAD/USD...
URL found: https://fx-rate.net/CAD/USD...
Symbol found: ''
Price found: '0.69534' (0,69534)
Date found: '30/03/2025'
Date format found: '30/03/2025' -> 'So. März 30 2025'
Price for CAD > USD updated to 0,6953 $ for 30.03.2025 (id CAD USD)

Looks like you need to adjust something around the date format for that. And since I see that 'Date format found' differs from your and my output, it seems that fx-rate.net behaves differently depending from where you access it.

(Debug) symbol=BUG id=BUG...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/BUG...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/BUG...
Symbol found: ''
Price found: '32.84' (32,84)
Date found: '1743192000'
Date format found: '1743192000' -> 'Fr. März 28 2025'
BUG BUG Fr. März 28 2025 32.84

Yahoo also works for me.  So this is not a bug in KMyMoney (master version) but more likely a problem of your local configuration and regex matching. Since this is more of a user question, please consult the forum for further assistance. BTW, this topic has been discussed in detail on the forum already. I will therefore close this here as "not a bug".
Comment 19 Pete 2025-03-30 15:15:55 UTC
On Ubuntu 24.04, I changed the 2 User sources to "KMyMoney Currency" and the quote update script still "fails" (false red error messages) but the price and date updates work well as follows:

N.B. Yahoo Finance date format set to %u (Friday closing date presented for stocks instead of Sunday testing date)

Start date moved to before the weekend
(Debug) symbol=BUG id=E000366...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/BUG...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/BUG...
Unable to parse symbol for BUG <== red error message is false ***
Price found: '32.84' (32.84)
Date found: '1743192000'
Date format found: '1743192000' -> 'Fri Mar 28 2025'
Price for BUG updated to $32.84 for 3/28/2025 (id E000366)
(Debug) symbol=CAD > USD id=CAD USD...
Fetching URL https://fx-rate.net/CAD/USD...
URL found: https://fx-rate.net/CAD/USD...
Symbol found: ''
Price found: '0.69534' (0.69534)
Date found: '30 Mar 2025'
Date format found: '30 Mar 2025' -> ''
Received an invalid price for CAD > USD, unable to update. <== red error message APPEARS false ***
(Debug) symbol=CMR.TO id=E000322...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/CMR.TO...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/CMR.TO...
Unable to parse symbol for CMR.TO
Price found: '50.025' (50.025)
Date found: '1743191955'
Date format found: '1743191955' -> 'Fri Mar 28 2025'
Price for CMR.TO updated to $50.02 for 3/28/2025 (id E000322)
(Debug) symbol=CMR.TO id=E000324...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/CMR.TO...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/CMR.TO...
Unable to parse symbol for CMR.TO
Price found: '50.025' (50.025)
Date found: '1743191955'
Date format found: '1743191955' -> 'Fri Mar 28 2025'
Price for CMR.TO updated to $50.02 for 3/28/2025 (id E000324)
(Debug) symbol=CVX id=E000389...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/CVX...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/CVX...
Unable to parse symbol for CVX
Price found: '166.09' (166.09)
Date found: '1743192072'
Date format found: '1743192072' -> 'Fri Mar 28 2025'
Price for CVX updated to $166.09 for 3/28/2025 (id E000389)
(Debug) symbol=CVX id=E000421...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/CVX...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/CVX...
Unable to parse symbol for CVX
Price found: '166.09' (166.09)
Date found: '1743192072'
Date format found: '1743192072' -> 'Fri Mar 28 2025'
Price for CVX updated to $166.09 for 3/28/2025 (id E000421)
(Debug) symbol=EUAD id=E000420...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/EUAD...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/EUAD...
Unable to parse symbol for EUAD
Price found: '33.69' (33.69)
Date found: '1743192000'
Date format found: '1743192000' -> 'Fri Mar 28 2025'
Price for EUAD updated to $33.69 for 3/28/2025 (id E000420)
(Debug) symbol=NA.TO id=E000280...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/NA.TO...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/NA.TO...
Unable to parse symbol for NA.TO
Price found: '119.22' (119.22)
Date found: '1743192000'
Date format found: '1743192000' -> 'Fri Mar 28 2025'
Price for NA.TO updated to $119.22 for 3/28/2025 (id E000280)
(Debug) symbol=PDBC id=E000290...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/PDBC...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/PDBC...
Unable to parse symbol for PDBC
Price found: '13.46' (13.46)
Date found: '1743192001'
Date format found: '1743192001' -> 'Fri Mar 28 2025'
Price for PDBC updated to $13.460 for 3/28/2025 (id E000290)
(Debug) symbol=RIO id=E000388...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/RIO...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/RIO...
Unable to parse symbol for RIO
Price found: '61.03' (61.03)
Date found: '1743192002'
Date format found: '1743192002' -> 'Fri Mar 28 2025'
Price for RIO updated to $61.030 for 3/28/2025 (id E000388)
(Debug) symbol=SMMT id=E000401...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/SMMT...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/SMMT...
Unable to parse symbol for SMMT
Price found: '20.32' (20.32)
Date found: '1743192000'
Date format found: '1743192000' -> 'Fri Mar 28 2025'
Price for SMMT updated to $20.32 for 3/28/2025 (id E000401)
(Debug) symbol=USD > CAD id=USD CAD...
Fetching URL https://fx-rate.net/USD/CAD...
URL found: https://fx-rate.net/USD/CAD...
Symbol found: ''
Price found: '1.4382' (1.4382)
Date found: '30 Mar 2025'
Date format found: '30 Mar 2025' -> ''
Received an invalid price for USD > CAD, unable to update.
(Debug) symbol=VKTX id=E000381...
Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/VKTX...
URL found: https://query1.finance.yahoo.com/v8/finance/chart/VKTX...
Unable to parse symbol for VKTX
Price found: '25.65' (25.65)
Date found: '1743192001'
Date format found: '1743192001' -> 'Fri Mar 28 2025'
Price for VKTX updated to $25.65 for 3/28/2025 (id E000381)
Comment 20 Pete 2025-03-30 15:21:02 UTC
On Ubuntu 22.04, the stable 3218 version now works as before this issue arose!!!

Of course, the OS is freshly patched every day.
Comment 21 Pete 2025-03-31 21:02:52 UTC
(In reply to Thomas Baumgart from comment #18)
> You have two problems: a) Yahoo and b) fx-rate.net.
> 
> a) shows as
> 
> (Debug) symbol=BUG id=E000366...
> Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/BUG...
> URL found: https://query1.finance.yahoo.com/v8/finance/chart/BUG...
> Unable to find date column '"regularMarketTime":([\d]+)' in quote data
> 
> and b) shows as
> 
> (Debug) symbol=CAD > USD id=CAD USD...
> Fetching URL https://fx-rate.net/CAD/USD...
> URL found: https://fx-rate.net/CAD/USD...
> Symbol found: ''
> Price found: '0.69534' (0.69534)
> Date found: '30 Mar 2025'
> Date format found: '30 Mar 2025' -> ''
> Received an invalid price for CAD > USD, unable to update.
> 
> In both scenarios, the online settings you use are missing something. Here
> is how that looks for me:
> 
> (Debug) symbol=CAD > USD id=CAD USD...
> Fetching URL https://fx-rate.net/CAD/USD...
> URL found: https://fx-rate.net/CAD/USD...
> Symbol found: ''
> Price found: '0.69534' (0,69534)
> Date found: '30/03/2025'
> Date format found: '30/03/2025' -> 'So. März 30 2025'
> Price for CAD > USD updated to 0,6953 $ for 30.03.2025 (id CAD USD)
> 
> Looks like you need to adjust something around the date format for that. And
> since I see that 'Date format found' differs from your and my output, it
> seems that fx-rate.net behaves differently depending from where you access
> it.
> 
> (Debug) symbol=BUG id=BUG...
> Fetching URL https://query1.finance.yahoo.com/v8/finance/chart/BUG...
> URL found: https://query1.finance.yahoo.com/v8/finance/chart/BUG...
> Symbol found: ''
> Price found: '32.84' (32,84)
> Date found: '1743192000'
> Date format found: '1743192000' -> 'Fr. März 28 2025'
> BUG BUG Fr. März 28 2025 32.84
> 
> Yahoo also works for me.  So this is not a bug in KMyMoney (master version)
> but more likely a problem of your local configuration and regex matching.
> Since this is more of a user question, please consult the forum for further
> assistance. BTW, this topic has been discussed in detail on the forum
> already. I will therefore close this here as "not a bug".

+++>it seems that fx-rate.net behaves differently depending from where you access it

Would you like me to email you a screenshot of fx-rate.net ?
Comment 22 Thomas Baumgart 2025-04-02 06:54:26 UTC
A screenshot is of no help here. The question here is why does fx-rate.net provide the date in the form "30 Mar 2025" for you whereas for me it is "30/03/2025" for the same date. That is something only you can find out looking at the source of the website.
Comment 23 Pete 2025-04-02 13:37:14 UTC
There are three (3) dates on this page:

https://fx-rate.net/USD/CAD

The first one appears at the upper left as follows:

14:25:30(BST) 2/04/2025

comment: BST is British summer time, we here in Montreal are on Eastern Summer Time (same as New York)

The two (2) other dates appear at the bottom of the rate tables:

C$1.4319 per Dollar
Wed, 2 April, 2025

$0.6984 per CA Dollar
Wed, 2 April, 2025

This would appear to indicate that the regex needs fine tuning.  Do you agree?