Price Source for Mutual Fund and Stock

Fred Bone Fred.Bone at dial.pipex.com
Fri Mar 21 12:29:10 EDT 2008


On 21 March 2008 at 10:05, Derek Atkins said:

> Fred,
> 
> "Fred Bone" <Fred.Bone at dial.pipex.com> writes:
> 
> > On 19 March 2008 at 9:26, Yogesh Agrawal said:
> >
> >> Hi,
> >> 
> >> I have a question regarding the price for mutual fund and stock,
> that
> >> show
> >> up on different reports like balance sheet.
> > [...]
> >> I have two entries in the mutual fund
> >> 
> >> 1) 117.428 unit @ 53.98       = 6338.76
> >> 2) 135.725 unit @ 191.628   = 26008.77
> >> 
> >> When I select Weighted average I see total of
> >> 
> >> 253.153 unit and total amount as 29286.59
> > [...]
> >> The question I have is how is the weighted average calculated
> >> and how can I get the total amount as  32347.53 (6338.76 +
> 26008.77)
> >
> > When I enter the figures you give, and run a Balance Sheet report, it
> > shows 32347.53 as the value.
> >
> > This happens whether or not there are entries in the Pricedb.
> >
> > I am using gnucash 2.2.4 for Windows on WinXPPro-SP2.
> 
> Using what "Price Source" configuration in the report?

Weighted Average, since that's (a) the default and (b) the one in the 
question I quoted.

(I've since seen confirmation that, as I suspected, Weighted Average uses 
only transaction info, so my comment about Pricedb is irrelevant).



More information about the gnucash-user mailing list