This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Currency importer uses incorrect factor for ZAR->GBP pair

Tags: None
(comma "," separated)
gmitinct
Registered Member
Posts
2
Karma
0
Hello

I have three currency pairs: GBP (base currency), USD, and ZAR. If I update a currency for today using the currency & price updater it all looks reasonable and uses a value from KMymoney importer (fxnet or similar in the config menu). However, if I set a date range in the importer and import the ZAR units in GBP pair the program uses the stooq importer configured in the config menu which imports the currency in ZA cents and not ZAR (out by a factor of 100).

So how do I divide the incoming historical currency values by 100? I know one can use the factor field in securities for this, but it doesn't seem possible for currencies. Imapct is that any report with values from before today will be out by a factor of 100 for any ZAR denominated accounts / categories.

Also, is there a way to force KMyMoney to use another currency provider in the config menu rather than stooq? For example, how would I simply change the config to make KMyMoney first download from yahoo or elsewhere?

I'm using KMyMoney Version 5.0.8 on Linux Mint

Many thanks
User avatar
ostroffjh
Registered Member
Posts
253
Karma
0
OS
I can't answer your main question, but I have one suggestion and one possible workaround.
First, 5.0.8 is over two years old. If you can't find an updated package specifically for Mint, you can use an appimage version. See https://kmymoney.org/appimage.html. These are created daily, and although the past few have failed to build, using the most recent successful version should be good. I suggest this in case (I am not sure) there have been any related changes made in the past two years.

I'm not sure how much effort it would take, but if you go to the Price Editor (from the Tools/Prices menu) type in ZAR and then tick the "Show all stored prices" box, you can then manually adjust all the stored conversion rates.

Unfortunately, I don't believe there is any way to alter the source for downloading currency conversion rates. I am not certain about this, but think I remember it being discussed in the past.
gmitinct
Registered Member
Posts
2
Karma
0
Thanks for your reply, really appreciate it. I now have the latest AppImage installed and it does look much better. The issue does persist though with stooq currency downloads for the ZAR->GBP pair. Thanks for the pointer on manually editing the rates - I can do that although tedious, but at least will put in entries for the end of each period for the time being. I may also look at importing the pair causing the issue manually via CSV .. GBP->ZAR comes in fine from stooq, but the other way round not which is likely an oversight on their end.

..just checked on their site at https://stooq.com/q/?s=zargbp and yes they report this pair as "South African Rand / British Pounds 10^2:1 (ZARGBP)" so the factor of 100 is intentional on their side. Seems the importer would need to find a way to accommodate this, unless another source were used.

Cheers


Bookmarks



Who is online

Registered users: bancha, Bing [Bot], Evergrowing, Google [Bot], mesutakcan, Sogou [Bot]