First, thank you to all of you - your inputs guided my troubleshooting. It turns out that the “+” sign doesn’t work for me. Instead I am using the asterisk. This works for me in the price field:
Today\s*=\s*([^<]*)
Now I can update exchange rates between EUR and USD.
YES! YES! Thanks for that. That was the problem exactly! All working great now!
Hit an update error today with the default configuration in KMyMoney v5.1.3 after running for one month. Thanks to @ipwizard for the Price regex.
Not sure if it is necessary to have the Date regex. I have been running without the Date regex for many months and the updates still works without it.
For some reason I started to fail fetching currency data today (yesterday it worked) and I had not changed any settings. I have tried to debug what might be wrong but I do not see anything what can cause this. It connects the site for sure but doesnt “find the date” Price seems to be found ok.
I have had to update the regex to pick up the date. This is what I have now.
,\s*(\d+\s*[a-zA-Z]+\s*\d{4})
Date format %d %m %y
The Date format has been inconsistent whenever something changes at fx-rate.net. I decided to opt out from using the Date regex unless you needed it. Works for me so far.
Hi Dave
I’m not completely literate with using these formatting strings
Whatever I try, it still fails trying to get the date
Could you post the complete string for the ‘DATE’ field that you used ?
Hi
The string is as I posted above. If it is not working for you I wonder if maybe you are getting different exchange rates to me. I am using it for GBP to USD and BTC.
Let me know if your currencies are different and I’ll take another look.
Alternatively, try Wing’s solution above. I’ve not tried it but sounds like it may work.
Edit: The Identifier for the Currencies is showing the Header text instead of the actual URL - it shows the URL when you hover over the link. Don´t know why it does that!?!
Just in case this is of help to anybody, This is exactly what I have for Stocks & Currencies and it all works perfectly:
Currencies:
Identifier: Exchange Rates - Currency Converter - Foreign Currency Rates - Money Transfer Services Comparison
Price: Today\s*=\s*([^<]*)
Date: ,\s*(\d+\s*[a-zA-Z]+\s*\d{4})
Date Format: %d/%m/%y
Stocks:
URL: https://query1.finance.yahoo.com/v8/finance/chart/%1
Identifier: %1
Indentify by: Symbol
Price: “regularMarketPrice”:((\d+|\d{1,3}(?:[,]\d(3))).\d+)
Date: “regularMarketTime”:([\d]+)
Thanks to daveh & porpoise1954 for replying
I have applied ‘porpoise1954’ suggestions and my currency conversions are working again.
Mainly AUD to USD CAN EUR
For future readers, fx-rate.net changes their dateformat based on the user geolocation.
porpoise1954 solution works for me, with an IP address which likely geolocates to Switzerland.
I assume some of the solutions above are for US geolocations.
The HTML I get from fx-rate does not contain the string ‘ip_ondate’.
This is what I’m seeing. How do I need to change the pattern matching for the date?
downloading the HTML has this section:
<span class="datetime" style="display:inline-block; margin-top:10px; text-align:right; align:right; font-size:12px; color:#9c9c9c">11:55:01(EST) 30/12/2023</span>
Have you tried the settings provided by myself or Porpoise1984 earlier in this discussion?
Yes. Did I do it correctly? The problem remains the date.
I think this should work for the date but it doesn’t:
\d{2}/\d{2}/\d{4}
EDIT: slash added before year
There is a / missing from that. Also remember that you need () around the part of the regex containing the date so kmymoney knows where it is. So, this should work (\d{2}/\d{2}/\d{4}) but you may need to put some text around it to uniquely identify the bit of html you want to be used.
Yes, I did not copy/paste that. The slash was there in KMM. dd/mm/yyyy is unique in the html, but I did try adding strings, adding the date pattern parentheses. No matter what I try, it finds the exchange rate but not the date. No clue. Thanks.
Also the ‘Identify by’ field was changed from SYMBOL to NAME
Symbol or Name, both fail in the same manner.
Seems as though the forward slash character needs to be escaped by back slash. Depending what you read, some documentation says this is needed while others say it is not. I couldn’t understand it so tried escaping the forward slash and it works for me.
Looking at the data provided in @aduxas screen shot and the HTML download we can see, that the screen shot only has time information with an offset to GMT/UTC but the HTML section for that output contains a complete different content (and I don’t refer to the time difference). The format now says EST for the timezone (which is identical to GMT-5) and shows a date. The fun thing is, that I experienced it exactly the other way around: web browser shows the date but when downloading it with KMyMoney I see only the time information (the whole HTML part is dumped to the console for inspection).
fx-rate.net is a service that is visible through the cloudflare CDN which explains why some of us see different things. We don’t know to which server instance of fx-rate.net the actual connection is talking and which software version it runs.