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

Windows CSV price quotes

Tags: None
(comma "," separated)
DrCaves
Registered Member
Posts
5
Karma
0

Windows CSV price quotes

Mon Mar 08, 2021 9:46 am
Hi,

I have two question:
1) My currency is CZK and as BTC exceeded the 1,000,000 CZK the default online quote source (fx-rate.net) is downloading only 1.1043 instead of 1.1043e+6.
So I've tried to make my own source in CSV, but I'm unable to make it work. Does anybody has any idea how to correctly set the source (in Windows 10)?

the CSV for BTCCZK pair looks like: 2021-03-08,BTCCZK,1104300.000000000 and there are many more lines for other currencies.

2) It is unable to import the CSV file with historical prices with more than just 1 one-way pair of currencies (and securities as well). So I need to do separate CSV file for every single pair and security. Is it possible to edit the CSV importer to import not only columns "Date" and "Price" but also the columns "From" and "To" in case of currencies or the column "Ticker" in case of security?

If the problem number 2 would be solved, there will be no more need to deal with the problem number 1.

Thanks a lot
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS

Re: Windows CSV price quotes

Mon Mar 08, 2021 4:41 pm
Which version of KMyMoney are you using? The download of exponential prices was fixed in 5.0.3.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
DrCaves
Registered Member
Posts
5
Karma
0

Re: Windows CSV price quotes

Mon Mar 08, 2021 5:14 pm
ipwizard wrote:Which version of KMyMoney are you using? The download of exponential prices was fixed in 5.0.3.


The version should be 5.1.1-c021dfbf4
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS

Re: Windows CSV price quotes

Mon Mar 08, 2021 5:31 pm
Hm, strange. I see it as
Fetching URL https://fx-rate.net/BTC/CZK...
Identifier found: 'BTC/CZK'
Price found: '1.1304e+6' (1,1304e+06)
Date found: 'Mo. März 8 2021'
Price for BTC > CZK updated (id BTC CZK)

and the price entered is 1130400,0000. The only difference: I am using Version 5.1.1-48768dc01 on Linux, but that should not make a difference (three commits which have nothing to do with your problem).


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
DrCaves
Registered Member
Posts
5
Karma
0

Re: Windows CSV price quotes

Mon Mar 08, 2021 9:55 pm
I've tried to completely uninstall the KMyMoney, delete all the remaining files and install it again... The result is still the same.

Image
Image
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS

Re: Windows CSV price quotes

Tue Mar 09, 2021 7:39 am
My settings for KMyMoney currency are:
URL: https://fx-rate.net/%1/%2
Identifier: https://fx-rate.net/([^/]+/[^/]+)
Identified by: Symbol
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 HTML stripping: checked

It seems, that your price regex does not catch the exponent where mine does.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5
DrCaves
Registered Member
Posts
5
Karma
0

Re: Windows CSV price quotes

Tue Mar 09, 2021 10:22 pm
Now it works. So the default settings is incorrect. Thanks a lot

To the second question. Is that possible to add to some coming updates?
User avatar
ipwizard
KDE Developer
Posts
1359
Karma
6
OS

Re: Windows CSV price quotes

Wed Mar 10, 2021 9:54 am
Yes, see/monitor KMyMoney bug tracker.


ipwizard, proud to be a member of the KMyMoney forum since its beginning. :-D
openSuSE Leap 15.4 64bit, KF5


Bookmarks



Who is online

Registered users: Bing [Bot], Google [Bot], Sogou [Bot]