Did you make the change to kmymoneyrc without KMyMoney running? If yes, I am out of ideas why you see this error. The only place where Malformed URL shows in the KMyMoney source tree is when saving the KMyMoney data file has a problem. But that certainly is not the case here.

ipwizard wrote:Did you make the change to kmymoneyrc without KMyMoney running? If yes, I am out of ideas why you see this error. The only place where Malformed URL shows in the KMyMoney source tree is when saving the KMyMoney data file has a problem. But that certainly is not the case here.

Yes, I edited kmymoneyrc with KMyMoney closed thank you anyway for trying to find out what's going on!

alainpetit wrote:@All:

Eureka, I've made a awesome discovery, and I have to share it with all here that were interested in this issue. Moving to Google Finance was good 99% of the time, but based on my own problems with ETH currency, I couldn't find a one solution to suit all. Until now ... I've found a little unknown currency tracker that works with ALL currency and crypto :

Code: Select all

Kmymoney Settings
URL : https://fx-rate.net/%1/%2
Symbol : href="https:\/\/fx-rate.net\/([^\/]+\/[^\/]+)
Price : 1\s[^=]+\s=<\/span><br\s\/>\s([^\s]+)
Date : updated\s\d+:\d+:\d+\(\w+\)\s(\d{1,2}\/\d{2}\/\d{4})
Date Format : %d/%m/%y
Skip Stripped HTML : CHECKED


@All :
Alrigth new minor problem, now that BTC is coming increasingly high .. fx-rate started displaying CAD to BTC price as 7.2482e-5 Bitcoin (scientific notation), which kinda screw the REGEX reading for that particular pair ... however everything else in KMyMoney seems to be based on BTC to CAD. Nonetheless, are there anyone REGEX wizard here that alter the Price : part of REGEX to support scientific notation ?

EDIT : Also Question 2 - how can I change the currency to 4 decimal digits precision ?

Answer 1: Having a price in a scientific notation is (currently) not supported. I doubt that we can change the value from the scientific to normal representation using a regex.

Answer 2: Do you mean the precision of the currency or the price?

ipwizard wrote:Answer 1: Having a price in a scientific notation is (currently) not supported. I doubt that we can change the value from the scientific to normal representation using a regex.

Answer 2: Do you mean the precision of the currency or the price?

hum, Question 2 : I meant the price but after further look .. it is 4 digit, and configurable in the general options. My bad.

But now that you mention about the precision of the currency, a minor annoyance I'm encountering is that my bitcoin accounts are displaying only 2 digit. is this customizable somewhere ?

Not via the UI. You can try to modify that directly in your data file. Make sure to have a backup of it before you fiddle around. Search for the following line:

Code: Select all

<CURRENCY symbol="BTC" saf="100" type="3" id="BTC" rounding-method="0" name="Bitcoin" scf="100" pp="4"/>


Change saf (Smallest Account Fraction) and scf (Smallest Cash Fraction) to e.g. 10000 to get 4 digits of precision. Don't change anything else. Do that while KMyMoney is not running.

Here's a bit of documentation regarding the file formats provided/used by KMyMoney.

What would be a good default for saf and scf for Bitcoins? We can certainly adjust the source for future users.

Very interesting discussion! I just registered to be a part of it!

I have some cryptocurrencies that are not very popular (like MONA or OK). I'd like to add them to my KMyMoney as an investment. It works perfect for BTC with the Google Finance settings that you provided. But the only website I found listing all of the crypto prices is Coingecko.
Unfortunately I cannot find the right regex to extract price and date.
Can anybody help me?

URL is https://www.coingecko.com/de/munze/%1 (or /en/coins/%1 for english users).

Thank you very much in advance!!!

Why not use https://finance.yahoo.com/quote/ again?

Code: Select all

URL = https://finance.yahoo.com/quote/%1
Symbol = <!-- react-text: 36 -->[^0-9]*([0-9,\s\.]+).*
Quotation =
Date =
Date Format = %m %d %y

Put "Skip HTML string".

I can not write the code for the date.
But I receive the current price.

Hi all,

yea I coming back from the dead to this thread to try to solve another problem ...

As theravet was mentionning, I too have other cryptocurrencies that I starting to get annoy to update manually ... I'll try to work on the regex for Coingecko and/or coinmarketcap and see what i get ...

but this will still lead to 1 other issue : it will just do crypto ... not real investments (stocks, funds, etc.). The work around for this would be to another another source which will be named "Yahoo Currency (crypto)" but rename to "Yahoo Currency" when we want to gather the latest crypto quotes

ipwizard wrote:Not via the UI. You can try to modify that directly in your data file. Make sure to have a backup of it before you fiddle around. Search for the following line:

Code: Select all

<CURRENCY symbol="BTC" saf="100" type="3" id="BTC" rounding-method="0" name="Bitcoin" scf="100" pp="4"/>


Change saf (Smallest Account Fraction) and scf (Smallest Cash Fraction) to e.g. 10000 to get 4 digits of precision. Don't change anything else. Do that while KMyMoney is not running.

Here's a bit of documentation regarding the file formats provided/used by KMyMoney.

What would be a good default for saf and scf for Bitcoins? We can certainly adjust the source for future users.

Sorry for the delay, and thanks for the advice, I did notice that this is for a data file saved in .xml format ... not .kmy but no worries .. that is indeed better to use that format is I want to specifically work on stuff. Changing the thing worked perfectly, and to answer your question, I would say 4 digits of precision is good for now (allow the granularity to be equivalent to more or less 1 USD). However, if development lead the way I think they will lead, I would be surprise that raising to 6 and or more would be better in the near future.

Rationale 1 : Increase in BTC value.
Rationale 2 : development of Lightning Network, allowing a better usage of IoT money-terization and payments (i.e. millions of sub-pennies transactions) ...

In Summary, keeping the door open would be good. How about working on a flexible way of expressing currencies, similar to what is frequently used in crypto world :
1 BTC / 1000 = 1 mBTC ;
1 mBTC / 1000 = 1 uBTC ;
1 uBTC / 100 = 1 sat (divided by one hundred indeed not a typo, special unit "satoshi")

Can KMymoney be wise enough to detect fractional unit so small (Or so big as well), and adjust with the appropriate Metric prefix ?

That being said I would assume that this could be a good addition to any currency. Expression a bank account in in 8-9 digit range could be useful as 15 787 K$.

I've changed the setting of Yahoo Currency according the instructions from ipwizard and get the folloing error:

Preis für USD > EUR kann nicht aktualisiert werden (kein Preis oder kein Datum

I now made it finally work!!!! Yahooooooo!!!! No, not yahoo, other sources...
Following code for German users.

For my funds (symbol has to be the ISIN):

Code: Select all

URL: https://www.fondsweb.com/de/%1
Symbol: %1
Preis: <p>([0-9]+\,[0-9]+)&nbsp;[EUR|USD]
Datum: NAV vom (\d\d\.\d\d\.\d{4})
Datumsformat: %d.%m.%y


For my cryptos (symbol has to be the name as in the URL):

Code: Select all

URL: https://www.finanzen.net/devisen/%1-euro-kurs
Symbol: %1
Preis: ([0-9|0-9\.]+\,[0-9]+)<span>EUR
Datum: <td colspan="3">(\d\d\.\d\d\.\d{4}).+ Uhr
Datumsformat: %d.%m.%y


For currencies (change the Yahoo Currency source!):

Code: Select all

URL: https://fx-rate.net/%1/%2
Symbol: %1%2
Preis: 1\s[^=]+\s=</span><br */> *(\d+\.\d+)
Datum: updated\s\d+:\d+:\d+\(\w+\)\s+(\d{1,2}/\d{2}/\d{4})
Datumsformat: %d/%m/%y


Thanks to alainpetit and ipwizard for the last one!

I updated broken sites to get quotes: viewtopic.php?f=69&t=138308&start=15#p407773

ipwizard wrote:Answer 1: Having a price in a scientific notation is (currently) not supported. I doubt that we can change the value from the scientific to normal representation using a regex.

KMyMoney recently received the ability to process prices in scientific notation. See the bug entry for more details.

Hello, try this free api: https://s.fx-w.io/latest/en.json from https://fx-w.io/about
available 67 languages

Code: Select all

{
   "timestamp": "1598162407",
   "base": "USD",
   "title": "Currency Converter",
   "copyright": "Exchange Rates By: https:\/\/currencyrate.today\/",
   "rates": {
      "AED": ["UAE Dirham", 3.67294, 3.67294],
      "AFN": ["Afghan Afghani", 78.044275, 78.044275],
      "ALL": ["Albanian Lek", 104.856723, 104.856723],
      "AMD": ["Armenian Dram", 481.616228, 481.616228],
      "ANG": ["Netherlands Antillean Guilder", 1.78968, 1.78968],
      "AOA": ["Angolan Kwanza", 588.982, 588.982],
      "ARS": ["Argentine Peso", 73.587443, 73.587443],
      "AUD": ["Australian Dollar", 1.396609, 1.396609],
      "AWG": ["Aruban Florin", 1.8, 1.8],
      "AZN": ["Azerbaijani Manat", 1.7025, 1.7025],
      "BAM": ["Bosnia-Herzegovina Convertible Mark", 1.657898, 1.657898],
      "BBD": ["Barbadian Dollar", 2, 2],
      "BDT": ["Bangladeshi Taka", 84.812034, 84.812034],
      "BGN": ["Bulgarian Lev", 1.65754, 1.65754],
      "BHD": ["Bahraini Dinar", 0.377005, 0.377005],
      "BIF": ["Burundian Franc", 1923.07273, 1923.07273],
      "BMD": ["Bermudan Dollar", 1, 1],
      "BND": ["Brunei Dollar", 1.36941, 1.36941],
      "BOB": ["Bolivian Boliviano", 6.88426, 6.88426],
      "BRL": ["Brazilian Real", 5.620076, 5.620076],
      "BSD": ["Bahamian Dollar", 1, 1],
      "BTC": ["Bitcoin", 8.6310742e-5, 8.7125462e-5],
      "BTN": ["Bhutanese Ngultrum", 74.787053, 74.787053],
      "BTS": ["BitShares", 32.7327492424, 34.1626184314],
      "BWP": ["Botswana Pula", 11.607039, 11.607039],
      "BYN": ["Belarusian Ruble", 2.484327, 2.484327],
      "BZD": ["Belize Dollar", 2.009642, 2.009642],
      "CAD": ["Canadian Dollar", 1.317565, 1.317565],
      "CDF": ["Congolese Franc", 1955.184637, 1955.184637],
      "CHF": ["Swiss Franc", 0.911225, 0.911225],
      "CLF": ["Chilean Unit Of Account (UF)", 0.028602, 0.028565],
      "CLP": ["Chilean Peso", 793.100062, 793.100062],
      "CNH": ["Chinese Yuan (Offshore)", 6.912, 6.912],
      "CNY": ["Chinese Yuan", 6.9195, 6.9195],
      "COP": ["Colombian Peso", 3806.517379, 3806.517379],
      "CRC": ["Costa Rican Colón", 593.36127, 593.36127],
      "CUC": ["Cuban Convertible Peso", 1, 1],
      "CUP": ["Cuban Peso", 25.75, 25.75],
      "CVE": ["Cape Verdean Escudo", 92.65, 92.65],
      "CZK": ["Czech Republic Koruna", 22.1128, 22.1128],
      "DASH": ["Dash", 0.0113269828, 0.0114758964],
      "DJF": ["Djiboutian Franc", 177.499717, 177.499717],
      "DKK": ["Danish Krone", 6.3113, 6.3113],
      "DOGE": ["DogeCoin", 297.980889655, 300.395437931],
      "DOP": ["Dominican Peso", 58.298635, 58.298635],
      "DZD": ["Algerian Dinar", 128.370188, 128.370188],
      "EAC": ["EarthCoin", 2867.98535556, 2867.98535556],
      "EGP": ["Egyptian Pound", 15.933023, 15.933023],
      "EMC": ["Emercoin", 1.2125648612, 1.2125648612],
      "ERN": ["Eritrean Nakfa", 15.003119, 15.003082],
      "ETB": ["Ethiopian Birr", 35.86418, 35.86418],
      "ETH": ["Ethereum", 0.0025708924, 0.0025906736],
      "EUR": ["Euro", 0.847817, 0.847817],
      "FCT": ["Factom", 0.5715065711, 0.5715065711],
      "FJD": ["Fijian Dollar", 2.1327, 2.1327],
      "FKP": ["Falkland Islands Pound", 0.763971, 0.763971],
      "FTC": ["Feathercoin", 22.4451027826, 22.4451027826],
      "GBP": ["British Pound Sterling", 0.763971, 0.763971],
      "GEL": ["Georgian Lari", 3.107946, 3.107659],
      "GGP": ["Guernsey Pound", 0.763971, 0.763971],
      "GHS": ["Ghanaian Cedi", 5.782886, 5.782886],
      "GIP": ["Gibraltar Pound", 0.763971, 0.763971],
      "GMD": ["Gambian Dalasi", 51.8, 51.8],
      "GNF": ["Guinean Franc", 9659.715003, 9659.715003],
      "GTQ": ["Guatemalan Quetzal", 7.676911, 7.676911],
      "GYD": ["Guyanese Dollar", 208.286878, 208.286878],
      "HKD": ["Hong Kong Dollar", 7.75045, 7.75045],
      "HNL": ["Honduran Lempira", 24.579457, 24.579457],
      "HRK": ["Croatian Kuna", 6.389402, 6.389402],
      "HTG": ["Haitian Gourde", 111.905024, 111.905024],
      "HUF": ["Hungarian Forint", 297.58, 297.58],
      "IDR": ["Indonesian Rupiah", 14764.3, 14764.3],
      "ILS": ["Israeli New Sheqel", 3.40075, 3.40075],
      "IMP": ["Manx Pound", 0.763971, 0.763971],
      "INR": ["Indian Rupee", 74.9293, 74.9293],
      "IQD": ["Iraqi Dinar", 1194.400146, 1194.400146],
      "IRR": ["Iranian Rial", 42105, 42105],
      "ISK": ["Icelandic Króna", 137.83, 137.83],
      "JEP": ["Jersey Pound", 0.763971, 0.763971],
      "JMD": ["Jamaican Dollar", 149.601877, 149.601877],
      "JOD": ["Jordanian Dinar", 0.709, 0.709],
      "JPY": ["Japanese Yen", 105.80896532, 105.80896532],
      "KES": ["Kenyan Shilling", 108.020357, 108.020357],
      "KGS": ["Kyrgyzstani Som", 77.840977, 77.840976],
      "KHR": ["Cambodian Riel", 4090.414391, 4090.414391],
      "KMF": ["Comorian Franc", 412.949876, 412.949876],
      "KPW": ["North Korean Won", 900, 900],
      "KRW": ["South Korean Won", 1192.22, 1192.22],
      "KWD": ["Kuwaiti Dinar", 0.30596, 0.30596],
      "KYD": ["Cayman Islands Dollar", 0.830874, 0.830874],
      "KZT": ["Kazakhstani Tenge", 420.084565, 420.084565],
      "LAK": ["Laotian Kip", 9132.781409, 9132.781409],
      "LBP": ["Lebanese Pound", 1512.908863, 1512.908863],
      "LD": ["Linden Dollar", 320, 320],
      "LKR": ["Sri Lankan Rupee", 184.689902, 184.689902],
      "LRD": ["Liberian Dollar", 199.300046, 199.300046],
      "LSL": ["Lesotho Loti", 17.159518, 17.159518],
      "LTC": ["LiteCoin", 0.0170328734, 0.0169750467],
      "LYD": ["Libyan Dinar", 1.367969, 1.367969],
      "MAD": ["Moroccan Dirham", 9.196536, 9.196536],
      "MDL": ["Moldovan Leu", 16.496307, 16.496307],
      "MGA": ["Malagasy Ariary", 3831.163248, 3831.163248],
      "MKD": ["Macedonian Denar", 52.229162, 52.229162],
      "MMK": ["Myanmar (Burmese) Kyat", 1361.172489, 1361.172489],
      "MNT": ["Mongolian Tugrik", 2851.664158, 2848.822049],
      "MOP": ["Macanese Pataca", 7.986658, 7.986658],
      "MRO": ["Mauritanian Ouguiya (pre-2018)", 357, 357],
      "MRU": ["Mauritanian Ouguiya", 38.313816, 38.313816],
      "MUR": ["Mauritian Rupee", 39.700908, 39.700908],
      "MVR": ["Maldivian Rufiyaa", 15.410189, 15.409845],
      "MWK": ["Malawian Kwacha", 747.224019, 747.224019],
      "MXN": ["Mexican Peso", 21.975598, 21.975598],
      "MYR": ["Malaysian Ringgit", 4.18, 4.18],
      "MZN": ["Mozambican Metical", 71.315, 71.315],
      "NAD": ["Namibian Dollar", 17.35, 17.35],
      "NGN": ["Nigerian Naira", 386.52, 386.52],
      "NIO": ["Nicaraguan Córdoba", 34.746769, 34.746769],
      "NMC": ["Namecoin", 3.2262324937, 3.2262324937],
      "NOK": ["Norwegian Krone", 9.0105, 9.0105],
      "NPR": ["Nepalese Rupee", 119.660418, 119.660418],
      "NVC": ["NovaCoin", 0.3852517642, 0.3852517642],
      "NXT": ["Nxt", 77.8508630631, 78.481690991],
      "NZD": ["New Zealand Dollar", 1.529134, 1.529134],
      "OMR": ["Omani Rial", 0.385061, 0.385061],
      "PAB": ["Panamanian Balboa", 1, 1],
      "PEN": ["Peruvian Nuevo Sol", 3.552371, 3.552371],
      "PGK": ["Papua New Guinean Kina", 3.532832, 3.532832],
      "PHP": ["Philippine Peso", 48.648588, 48.648588],
      "PKR": ["Pakistani Rupee", 168.582085, 168.582085],
      "PLN": ["Polish Zloty", 3.7434, 3.7434],
      "PPC": ["Peercoin", 2.5433167196, 2.5433167196],
      "PYG": ["Paraguayan Guarani", 6975.946479, 6975.946479],
      "QAR": ["Qatari Rial", 3.642745, 3.642745],
      "RON": ["Romanian Leu", 4.104, 4.104],
      "RSD": ["Serbian Dinar", 99.69, 99.69],
      "RUB": ["Russian Ruble", 74.8209, 74.8209],
      "RWF": ["Rwandan Franc", 963.137847, 963.137847],
      "SAR": ["Saudi Riyal", 3.75045, 3.75045],
      "SBD": ["Solomon Islands Dollar", 8.265569, 8.265569],
      "SCR": ["Seychellois Rupee", 17.83, 17.83],
      "SDG": ["Sudanese Pound", 55.3, 55.3],
      "SEK": ["Swedish Krona", 8.80945, 8.80945],
      "SGD": ["Singapore Dollar", 1.37159, 1.37159],
      "SHP": ["Saint Helena Pound", 0.763971, 0.763971],
      "SLL": ["Sierra Leonean Leone", 9886.5745, 9886.573409],
      "SOS": ["Somali Shilling", 576.764474, 576.764474],
      "SRD": ["Surinamese Dollar", 7.458, 7.458],
      "SSP": ["South Sudanese Pound", 130.26, 130.26],
      "STD": ["São Tomé And Príncipe Dobra (Pre-2018)", 20973.366047, 20973.366047],
      "STN": ["São Tomé And Príncipe Dobra", 20.7, 20.7],
      "STR": ["Stellar", 10.0016733796, 10.0478289504],
      "SVC": ["Salvadoran Colón", 8.72388, 8.72388],
      "SYP": ["Syrian Pound", 511.810422, 511.818932],
      "SZL": ["Swazi Lilangeni", 17.159988, 17.159988],
      "THB": ["Thai Baht", 31.540484, 31.540483],
      "TJS": ["Tajikistani Somoni", 10.32258, 10.32258],
      "TMT": ["Turkmenistani Manat", 3.51, 3.51],
      "TND": ["Tunisian Dinar", 2.731001, 2.731001],
      "TOP": ["Tongan Paʻanga", 2.28815, 2.28815],
      "TRY": ["Turkish Lira", 7.333, 7.333],
      "TTD": ["Trinidad And Tobago Dollar", 6.756881, 6.756881],
      "TWD": ["New Taiwan Dollar", 29.402, 29.402],
      "TZS": ["Tanzanian Shilling", 2320, 2320],
      "UAH": ["Ukrainian Hryvnia", 27.44364, 27.44364],
      "UGX": ["Ugandan Shilling", 3663.938455, 3663.938455],
      "USD": ["US Dollar", 1, 1],
      "UYU": ["Uruguayan Peso", 42.878415, 42.878415],
      "UZS": ["Uzbekistan Som", 10262.388237, 10262.388237],
      "VEF": ["Venezuelan Bolívar Fuerte (Old)", 248487.642241, 248487.642241],
      "VEF_BLKMKT": ["Venezuelan Bolívar (Black Market)", 306993.62, 306993.62],
      "VEF_DICOM": ["Venezuelan Bolívar (DICOM)", 303538, 303538],
      "VEF_DIPRO": ["Venezuelan Bolívar (DIPRO)", 17188952.92, 17188952.92],
      "VES": ["Venezuelan Bolívar Soberano", 298809.73, 292167],
      "VND": ["Vietnamese Dong", 23191.186918, 23191.186918],
      "VTC": ["VertCoin", 6.8084886676, 6.8084886676],
      "VUV": ["Vanuatu Vatu", 113.175248, 113.524092],
      "WST": ["Samoan Tala", 2.643774, 2.628484],
      "XAF": ["CFA Franc BEAC", 556.131496, 556.131496],
      "XAG": ["Silver Ounce", 0.03734831, 0.03734831],
      "XAU": ["Gold Ounce", 0.00051541, 0.00051541],
      "XCD": ["East Caribbean Dollar", 2.70255, 2.70255],
      "XDR": ["Special Drawing Rights", 0.708364, 0.708364],
      "XMR": ["Monero", 0.0108478292, 0.0109826736],
      "XOF": ["CFA Franc BCEAO", 556.131496, 556.131496],
      "XPD": ["Palladium Ounce", 0.00045777, 0.00045777],
      "XPF": ["CFP Franc", 101.17148, 101.17148],
      "XPM": ["Primecoin", 21.0235762811, 21.0235762811],
      "XPT": ["Platinum Ounce", 0.00108446, 0.00108446],
      "XRP": ["Ripple", 3.5693704254, 3.5834914439],
      "YER": ["Yemeni Rial", 250.349961, 250.349961],
      "ZAR": ["South African Rand", 17.15659, 17.15659],
      "ZMW": ["Zambian Kwacha", 18.818868, 18.818868],
      "ZWL": ["Zimbabwean Dollar", 322, 322]
   }
}