Price Source for Mutual Fund and Stock

[Yogesh Agrawal]

On Thu, Mar 20, 2008 at 11:47 AM, Fred Bone <Fred.Bone at dial.pipex.com>
wrote:

> 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.


I am using gnucash 2.2.4 for Windows on WinXPPro-SP2 too.
I understand whether there is pricedb entries or not, you get the same
result when you select the price source of  weighted average.

I have some other fund as well and for them I get the total amount correct

But I am having a problem in this particular fund, as both of these
transaction are split transactions.

So the split transaction is like, selling one mutual fund and buying another
one.

So in first case 117.428 unit @ 53.98       = 6338.76

I sold something for 6338.76, in which I have capital gain of 338.75
and then I bought 117.428 unit @ 53.98

in the second case 135.725 unit @ 191.628   = 26008.77

I sold something for 26,008.77, in which I have a capital gain of 11,305.23
and then I bought 135.725 unit @ 191.628.

So which basically means instead of funding from bank, I am funding from
the amount that I got while selling some other fund.

Is it I am splitting it wrong, or there is some bug in weighted average
calculation in the split transaction.


Thanks,
Yogesh








>
> _______________________________________________
> 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.
>



-- 
"Being rich is having money; being wealthy is having time"- Margaret Bonnano

Text : 15103257640 at mobile.mycingular.com

Blogs
---------------------------------------------------------
Tech: http://yagrawal.blogspot.com
Financial: http://agrawaly.blogspot.com