2016-02-11 GnuCash IRC logs
00:00:17 *** Coderjoe has joined #gnucash
00:15:13 *** root_ has joined #gnucash
00:15:27 *** root_ is now known as AlanTop
01:29:09 *** Mechtilde has joined #gnucash
01:57:17 *** Apteryx has quit IRC
01:57:51 *** fell has quit IRC
02:06:09 *** Mechtilde has quit IRC
02:27:16 *** uXus has quit IRC
03:17:21 *** gjanssens has joined #gnucash
03:17:21 *** ChanServ sets mode: +o gjanssens
03:21:04 *** Unhammer has joined #gnucash
04:23:16 *** rubdos has joined #gnucash
04:30:05 *** fabior has joined #gnucash
05:14:54 *** Jimraehl1 has left #gnucash
06:51:57 *** Jimraehl1 has joined #gnucash
06:59:39 *** Jimraehl1 has left #gnucash
07:04:07 *** Jimraehl1 has joined #gnucash
07:06:34 *** fabior has quit IRC
07:19:21 *** fabior has joined #gnucash
09:30:18 *** mlncn has joined #gnucash
10:12:08 *** fell has joined #gnucash
10:44:56 *** jralls has quit IRC
10:51:47 *** MoeD_ has joined #gnucash
10:51:59 *** mlncn has quit IRC
10:51:59 *** AlanTop has quit IRC
10:51:59 *** Coderjoe has quit IRC
10:51:59 *** MoeD has quit IRC
10:51:59 *** meb has quit IRC
10:51:59 *** ThomasKeller has quit IRC
10:51:59 *** Cork has quit IRC
10:51:59 *** Unhammer has quit IRC
10:51:59 *** GabrieleV has quit IRC
10:51:59 *** reactormonk has quit IRC
10:51:59 *** mikee has quit IRC
10:51:59 *** linas has quit IRC
10:51:59 *** neena has quit IRC
10:52:13 *** MoeD_ is now known as MoeD
10:54:06 *** Coderjoe has joined #gnucash
10:55:30 *** AlanTop has joined #gnucash
10:57:47 *** meb has joined #gnucash
10:58:09 *** GabrieleV has joined #gnucash
11:00:35 *** mlncn has joined #gnucash
11:00:35 *** reactormonk has joined #gnucash
11:00:35 *** mikee has joined #gnucash
11:00:35 *** linas has joined #gnucash
11:00:35 *** irc.gimp.ca sets mode: +o mikee
11:00:45 *** neena has joined #gnucash
11:00:50 *** Cork has joined #gnucash
11:00:59 *** Unhammer has joined #gnucash
11:08:55 *** ThomasKeller has joined #gnucash
11:22:36 *** gncbot sets mode: +o fell
11:26:13 *** Apteryx has joined #gnucash
11:45:18 *** jralls has joined #gnucash
11:45:18 *** ChanServ sets mode: +o jralls
11:49:17 *** jralls has quit IRC
11:51:29 *** Hinnerk has joined #gnucash
11:54:06 *** Mechtilde has joined #gnucash
11:54:25 <Hinnerk> Hi
11:54:26 <Hinnerk> I have a question about an equity account. I havy many of these and so far never had this problem. When I'm entering a transaction, my entered price is being overwritten automatically by a slightly different one. I did not enter the entire buy price, but the price per unit and the amount. I'm unable to change the calue to what it should be. Even mor interesting: I have online price retrieval...
11:54:28 <Hinnerk> ...active for this fund, and I can see in the price database the value I entered with source "transaction". So why does GnuCash overwrite my entered price in the account?
11:55:17 <Hinnerk> Latest version of GnuCash of course.
11:58:29 <fell> It might depend on the smallest unit number of your commodity and currency.
11:58:45 <Hinnerk> I used 1/10000.
11:58:54 *** Apteryx has quit IRC
11:59:14 <Hinnerk> And the amount is too far off, it is certainly no rounding issue.
11:59:59 <Hinnerk> Exampe: I entered a price of 77,97 and it turns into 78,3333.
12:00:32 <Hinnerk> In the price database I find 77,97 from Transaction.
12:00:43 <Hinnerk> And no other price for the given date.
12:01:09 <fell> And the other numbers are?
12:01:38 <Hinnerk> In this case I sold 0,178 units.
12:02:07 <Hinnerk> (if you are wondering: It is a saving plan and the sell was executed automatically to cover fees)
12:02:57 <fell> No, I know that very well. ;-)
12:03:14 *** minot has quit IRC
12:03:56 <Hinnerk> All the mistakes add up to only less than a euro from one year, but it's not very transparent...
12:05:20 <Hinnerk> As I use gc only for my private finance, I guess I can live with it if I have to, but I guess someone actually having to do offical accounts may not like the differences.
12:06:43 <fell> And the total is in that txn?
12:07:09 <Hinnerk> In this case total is 13,88.
12:07:28 <Hinnerk> Ups, sorry, messed up two lines.
12:07:29 <Hinnerk> But the issue is real.
12:08:19 <Hinnerk> So I have one that reads: 78,3333 for a price where I entered 77,97. Units sold were 0,012 and the total was calculated to be 0,94.
12:08:57 <Hinnerk> The other line reads: 0,178 units sold for 77,9775/unit with a total of 13,88. I also entered 77,97.
12:09:20 <Hinnerk> There a more cases, each buy also had the issue.
12:09:49 <Hinnerk> Sometimes the total is off by 4 cetns, so it should not be rounding to the next full cent.
12:11:53 <fell> That sounds really strange. Can you file a bug report and attach an example file?
12:13:43 <Hinnerk> Is there a good way to "clean" a gnucash file? I would rather not hnad over my productive version with real numbers, accounts numbers, membership numbers etc...
12:15:04 <fell> How about creating a new file with a few txns of this commodty?
12:15:12 <Hinnerk> I know this must be annoying as dev, but it's just that the data is about as sensitive as it can get
12:17:44 <Hinnerk> Hm, that will be quite some work and I'm not fully convinced it will reproduce. I doubt the reason lies within the fund itself, but maybe rather in an option like including user transactions in price database, rounding issues or smallest unit number. Maybe something it out of line in this particular account that I will never think of to set in a new file.
12:18:59 <Hinnerk> It is the first time ever I observed this behavior. Actually, coming to think about it, I just upgraded to gc 2.6.11 - or at least it was the first time I entered an equity transaction.
12:19:21 <fell> You know or you fear it?
12:19:36 <fell> And before you used?
12:20:07 <warlord> Hinnerk: note that the 'price' is not stored in the transaction. The transaction only stores "# of shares" and "total value"; and then it computes the price from that.
12:20:25 <Hinnerk> Well, I usually stay very close to the current version, I'm hardly ever more than one version behind.
12:20:52 <warlord> I'm assuming you are entering price and #shares. So what it's doing is computing the value, rounding to the currency SKU (e.g. €0.01), and then re-computing the price based on the rounded value and #shares.
12:20:59 <Hinnerk> I don't know it, but I'm reluctant to put in all the work if I doubt it will get the job done.
12:21:40 <Hinnerk> warlord: The the total shouldn't be off by more than 1 cent ever - in my case it is sometime by 4 cents.
12:23:53 <warlord> "shouldn't" is a very hard thing to say. So when you entered 0.178 @ 77.9975, that == 13.88 So what exactly did you enter and what did it re-compute?
12:25:17 <warlord> .178 * 77.97 == 13.87866 (which gets rounded to 13.88). Then when it recomputes the price, 13.88/.178 == 77.9775
12:26:05 <warlord> If the value is off, then instead of entering #shares and price, you should enter #shares and VALUE, and let gnucash compute whatever price it wants to show you.
12:27:25 <warlord> Hinnerk: does that make sense?
12:31:14 <fell> IMHO there a 2 prices: 1. nominal: used for calculation of total (or, in your case, pieces)
12:31:53 <fell> The result is rounded to full SCU
12:32:43 <fell> And then you get your effective price by dividing Total/#shares
12:37:43 <warlord> The first is stored in the PriceDB. The second is always computed on-the-fly and displayed in the register.
12:37:51 *** minot has joined #gnucash
12:48:18 <Hinnerk> warlord: Yes, that makes sense. I actually just fixed it that way - not the prices are off, but the values are correct, which is off course more important. Guess I should have done this from the start.
12:54:49 *** jralls has joined #gnucash
12:54:49 *** ChanServ sets mode: +o jralls
13:40:43 *** fabior has quit IRC
13:53:45 *** rpg has joined #gnucash
13:59:10 *** Hinnerk_ has joined #gnucash
14:01:07 *** Hinnerk has quit IRC
14:01:08 *** Hinnerk_ is now known as Hinnerk
14:10:17 *** fabior has joined #gnucash
14:45:21 *** Mechtilde has quit IRC
14:55:01 *** mlncn has quit IRC
15:52:01 *** gjanssens has quit IRC
15:59:25 *** g5pw has quit IRC
15:59:42 *** g5pw has joined #gnucash
16:00:42 *** g5pw has joined #gnucash
16:04:29 *** rpg has quit IRC
16:18:28 *** mlncn has joined #gnucash
16:48:33 *** fell has quit IRC
16:50:36 *** fell has joined #gnucash
16:50:37 *** gncbot sets mode: +o fell
17:30:03 <fell> Warlord: there seems to be some kind of spam attack on the wiki: verey hour a new user Medic*
17:30:29 <fell> every
17:47:55 *** fabior has quit IRC
18:20:03 <jralls> fell: Not really an attack yet. Might be preparing for one though. It's been a while since we had bogus registrations like that, but there are thousands of them in the user base.
18:35:14 *** mlncn has quit IRC
19:02:51 *** rpg has joined #gnucash
19:58:46 <warlord> Maintaining a wiki is such a PITA.
22:59:40 *** mlncn has joined #gnucash
23:36:26 *** CDB-Man_ has quit IRC
23:48:55 *** CDB-Man has joined #gnucash
23:50:43 *** CDB-Man has quit IRC
23:50:54 *** CDB-Man has joined #gnucash