Price Source for Mutual Fund and Stock

[Yogesh Agrawal]

On Thu, Mar 20, 2008 at 6:59 AM, Derek Atkins <warlord at mit.edu> wrote:

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


I understand recent entry, but not the nearest in time, if nearest in time
is  nearest to
the current date, then in that case most recent and nearest in time will
always come same,
If nearest in time is something else, then I don't know what it is?

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



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