[GNC] problem setting the price of a share

[John Ralls]

> On Sep 18, 2018, at 2:22 PM, Christian Pinedo Zamalloa <chr.pinedo at 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!!

Christian,

The presentation to the user is https://bugs.gnucash.org/show_bug.cgi?id=794755, fixed for 3.3.

As for recalculating invalid prices, it's an unavoidable consequence of real money having a limited number of usable fractional values. GnuCash doesn't actually store prices, it calculates them as the ratio between the amount (shares) and value (money). In general you can't have a fraction of a share for regular stock and you can't have a fraction of currency that's not an integer/100. If you enter a price that produces a fractional number of shares or "pennies" then GnuCash will round the amount or the value to be a legal value and the price will get recalculated accordingly. The alternative would be to refuse to accept the split and require that you figure out the correct price yourself, which seems a bit cumbersome.

Regards,
John Ralls