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 <david.carlson....@gmail.com> escribió: > 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 database is properly configured and whether data is correctly > extracted from it for various reports. If you want to research the topic > further there are several threads in this user maillist going back a decade > or more. > > I just searched the bug database and found several open bug reports which > directly involve these points. > *Bug 787813* <https://bugs.gnucash.org/show_bug.cgi?id=787813> > *Bug 793556* <https://bugs.gnucash.org/show_bug.cgi?id=793556> > *Bug 638175* <https://bugs.gnucash.org/show_bug.cgi?id=638175> > *Bug 410060* <https://bugs.gnucash.org/show_bug.cgi?id=410060> > > 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, but > there was a regression in the 2.7.x development series leading up to the > 3.x releases reverting to the fractional display currently seen. Bug > 793556 has already been filed regarding the fractional format as related to > CSV imports and exports, but it does not extend to use of those values in > spreadsheets. The fractional format is the raw display of the number > format used internally for certain calculations requiring high accuracy, > and a few users actually prefer to see prices displayed in that format, so > it is not likely to be completely hidden. > > John Ralls points out in his reply that release 3.3 will fix your first > concern as well as it can in this real world. > > David C > > On Tue, Sep 18, 2018 at 4:22 PM Christian Pinedo Zamalloa < > chr.pin...@gmail.com> 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 decimal >> format, it shouldn't be modified and the total amount should be calculated >> accordingly. >> >> Regarding the fractional format of prices, one more issue. Apart from >> being more difficult to read, when transactions are exported to CSV, the >> fractional format is maintained (i.e. "123 + 3/45") and if the CSV is >> opened with calc/excel we need to modify all the prices to be considered >> numbers not strings (i.e. insert "=123 + 3/45"). >> >> Thanks for your suggestions!! >> >> >> >> El sáb., 15 sept. 2018 a las 16:26, David Carlson (< >> david.carlson....@gmail.com>) escribió: >> >>> 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 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 decimal format) and press enter. The decimal formal is converted >>>> to fractional format, but fractional number is not the same that I inserted >>>> before. :-( >>>> >>>> Any idea? >>>> >>>> -- >>>> Christian Pinedo Zamalloa (zako) >>>> Sent from my mobile device, please excuse brevity or typos >>>> >>>> El sáb., 15 sept. 2018 14:49, David Carlson < >>>> david.carlson....@gmail.com> escribió: >>>> >>>>> 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 the total >>>>> amount. Actually, GnuCash is closer to being correct than your broker is. >>>>> >>>>> You have also discovered that in release 3.3 GnuCash shows the number >>>>> of shares in fractional format, which has the technical advantage of being >>>>> very accurate, if very hard to read. I believe that in the future GnuCash >>>>> may be changed back to show the number of shares in decimal format to be >>>>> easier to read, if less accurate. >>>>> >>>>> David C >>>>> >>>>> >>>>> >>>>> On Sat, Sep 15, 2018 at 4:16 AM Christian Pinedo Zamalloa < >>>>> chr.pin...@gmail.com> wrote: >>>>> >>>>>> 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 >>>>>> automatically converted by GnuCash to value "1+3/377" (1,007958). >>>>>> >>>>>> I don't know how to solve this mesh. Am I doing something wrong? >>>>>> >>>>>> -- >>>>>> zako >>>>>> _______________________________________________ >>>>>> gnucash-user mailing list >>>>>> gnucash-user@gnucash.org >>>>>> To update your subscription preferences or to unsubscribe: >>>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>>>>> If you are using Nabble or Gmane, please see >>>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>>>>> ----- >>>>>> Please remember to CC this list on all your replies. >>>>>> You can do this by using Reply-To-List or Reply-All. >>>>>> >>>>> >> >> -- >> Christian Pinedo Zamalloa (zako) >> PGP keyID: 0xdb577d4ee6ffbd55 >> PGP Fgprt: A895 7C11 84F6 30B4 4938 32A4 9306 DFD0 CDE4 B542 >> > _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
