Mutual fund prices precision

Derek Atkins warlord at MIT.EDU
Mon Aug 3 15:17:44 EDT 2015


AC <gnucash at acarver.net> writes:

> I know the share count matters, but the share count is wrong and I can't
> get it working properly to match the statements.  Doesn't matter if I
> let GC compute the price or compute the buy/sell total, it still seems
> to be off slightly in the share totals.

The only numbers that GnuCash cares about are:

1) Number of Shares, and
2) Total Value of those shares

The price is always computed.  If you enter in a price then it will
compute one of the other values, round it, and then *recompute* the
price.

> For one account the shares as listed on the statement are 950.971 but GC
> is computing 949.632 even though I started the account from scratch and
> entered every transaction manually.  Most of the other funds differ in
> shares by 0.01 but this one is a larger difference of a whole point.
> This is also the only account where most of the prices have
> autocorrected themselves so that's why I'm suspicious of the things
> going on in the background.

This means you did not enter in the number of shares correctly...
Either that or your rounding and the institution's rounding are
different.

-derek

> On 2015-08-01 16:58, Edward Doolittle wrote:
>> AC,
>> 
>> The share count is what matters when you reconcile the account, not the
>> price. You should enter the amount you paid and the number of shares you
>> received, and let GnuCash calculate the price for you.
>> 
>> Edward
>> 
>> On 1 August 2015 at 17:37, farleykj <farleykj at gmail.com> wrote:
>> 
>>> I tried this out, via the following, pretty much as you described:
>>> (1) enter 47.889 shares in that column.
>>> (2) enter 4.76 in the price column
>>> Make no other entries, <tab> through to the next line of the split.
>>> The result is the total is calculated as 227.95. This results in the price
>>> per share being adjusted to the 4.75997 value. The number of shares is
>>> unchanged. Thus I don't understand what you mean by the final share count
>>> being off.
>>> I suspect what's happening is because the registers are only allowing the
>>> balance column to represent numbers with two decimal places, since we're
>>> dealing with dollars and cents. It calculates the total to be 47.889 * 4.76
>>> = 227.95164, rounds that to 227.95, then recalculates the price to be
>>> 4.75997.
>>>
>>>
>>>
>>> -----
>>> Ken Farley
>>> --
>>> View this message in context:
>>> http://gnucash.1415818.n4.nabble.com/Mutual-fund-prices-precision-tp4679709p4679711.html
>>> Sent from the GnuCash - User mailing list archive at Nabble.com.
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>> 
>> 
>> 
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available


More information about the gnucash-user mailing list