Re: [GNC] problem setting the price of a share

2018-09-19 Thread John Ralls
The exponent is always there even if it’s not displayed, and floating point fails even with 0.1. It’s not possible to exactly represent that in floating point. That’s OK for math where you’re dealing with “significant digits”. As long as the floating point representation has few more digits than

Re: [GNC] problem setting the price of a share

2018-09-19 Thread David Carlson
correction: floating point fails with irrational numbers too. David C On Wed, Sep 19, 2018 at 10:13 AM David Carlson wrote: > I did not know "decimal format" was synonymous with floating point. I need > to see the exponent to think floating point. I think of decimal as simply a > way to print o

Re: [GNC] problem setting the price of a share

2018-09-19 Thread David Carlson
I did not know "decimal format" was synonymous with floating point. I need to see the exponent to think floating point. I think of decimal as simply a way to print out numbers on paper or computer screens, not a computation method. I definitely agree that floating point computations always have ac

Re: [GNC] problem setting the price of a share

2018-09-19 Thread John Ralls
David, David, Yes: "GnuCash was changed in release 2.6.8, dated late 2015 to usually store prices in decimal format when they were entered in decimal format” In computation, “decimal” and “floating point” are generally equivalent. The rare exception is binary-coded-decimal or BCD, but few langu

Re: [GNC] problem setting the price of a share

2018-09-18 Thread David Carlson
John, Did you find a reference to floating point in my last message? If so it was obsolete or inadvertent, as I know enough of the history of GnuCash to know that GnuCash never has and never will go there and why. There may have been something in one of the bug reports that I cited, but I also k

Re: [GNC] problem setting the price of a share

2018-09-18 Thread Christian Pinedo Zamalloa
If instead of a mailing list it was a social network, I just would like your reply! Thanks again for your input and references, -- Christian Pinedo Zamalloa (zako) Sent from my mobile device, please excuse brevity or typos El mié., 19 sept. 2018 1:22, David Carlson escribió: > There have been s

Re: [GNC] problem setting the price of a share

2018-09-18 Thread John Ralls
No, GnuCash has never, ever, stored any number in floating point. Stored numbers in GnuCash have been rationals from the very beginning. It was changed in 2.6.8 to always round prices for display so that they’d always appear in decimal form to the user, but the code that did it was overwhelmed b

Re: [GNC] problem setting the price of a share

2018-09-18 Thread David Carlson
There have been several discussions over the years around various aspects of the topics of numeric accuracy, displaying accurate values vs easily readable values, whether GnuCash records do or do not match brokers' reports or newspaper stock price listings, and even whether the GnuCash price databa

Re: [GNC] problem setting the price of a share

2018-09-18 Thread John Ralls
> On Sep 18, 2018, at 2:22 PM, Christian Pinedo Zamalloa > wrote: > > Hi David, > > At the end I was able to get properly the price by skipping it and letting > to GnuCash to calculate it as you suggested. However, I think that this > might be a kind of bug, because if I insert the price in

Re: [GNC] problem setting the price of a share

2018-09-18 Thread Christian Pinedo Zamalloa
Hi David, At the end I was able to get properly the price by skipping it and letting to GnuCash to calculate it as you suggested. However, I think that this might be a kind of bug, because if I insert the price in decimal format, it shouldn't be modified and the total amount should be calculated a

Re: [GNC] problem setting the price of a share

2018-09-15 Thread John Ralls
The reason David’s advice is correct is that decimal numbers on computers are represented as binaries and are fundamentally inaccurate: it is not possible to exactly represent 0.1 in binary, just as it’s impossible to exactly represent 1/3 as a decimal fraction.You avoid the representation probl

Re: [GNC] problem setting the price of a share

2018-09-15 Thread David Carlson
As I stated in my reply, enter the number of shares and total amount, Skip the price, let GnuCash take care of that. David C On Sat, Sep 15, 2018 at 9:21 AM Christian Pinedo Zamalloa < chr.pin...@gmail.com> wrote: > Hi David, > > I also agree with you that the fractional format is more difficul

Re: [GNC] problem setting the price of a share

2018-09-15 Thread Christian Pinedo Zamalloa
Hi David, I also agree with you that the fractional format is more difficult to read than decimal and I also hope to return to decimal format or at least to be able to choose between decimal or fractional format. Regarding my problem with price, I insert the number of shares, the prices (in decim

Re: [GNC] problem setting the price of a share

2018-09-15 Thread David Carlson
Christian Pinedo Zamalloa You have discovered that it is impossible to have all three values shares, price and total exactly as reported by your broker because he usually has to round off one of the numbers. The solution is to let GnuCash set the price after you enter the number of shares and th

[GNC] problem setting the price of a share

2018-09-15 Thread Christian Pinedo Zamalloa
Hello, I have problems to set the correct price of a share that I am selling. I try to put the value "128,181208053691" which is automatically converted by GnuCash when i push enter key to "128 + 64/377" whose real value is "128,169761". Furthermore, I checked if I insert value "1", it is automat