Price Source for Mutual Fund and Stock

[Derek Atkins]

Hi,

"Yogesh Agrawal" <agrawaly at gmail.com> writes:

> Hi,
>
> I have a question regarding the price for mutual fund and stock, that show
> up on different reports like balance sheet.
>
> There are three options
> 1) Weighted Average
> 2) Nearest in time
> 3) Most recent
>
> 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
>
> But when I select "nearest in time" or "most recent" I see
> total amount as 48511.20
>
> Yes I have two entry in the price editor one for 53.98 (dated 04/19/2004)
> and another for 191.628 (dated 01/11/2008)

That's correct, nearest in time and most recent use pricedb entries.
The most recent entry and the nearest in time entry are all 191.628,
so 191.628 * 253.153 == 48511.20.  So THAT is correct.

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

Honestly, I'm not sure how weighted average is computed.  It seems
to be computing the average price as 115.687 instead of what
you expect it to be: 127.778 but I'm afraid I don't know why.

> Sorry, if it has been answered already, as I couldn't find it in the mailing
> list.

Maybe one of the report guys will pipe up?

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

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