Price Source for Mutual Fund and Stock

[Yogesh Agrawal]

Hi Derek,

If I go with price db, you have nearest in time and most recent options,
how any of these two option will solve the problem.

Thanks,
Yogesh

On Wed, Mar 26, 2008 at 4:23 PM, Derek Atkins <warlord at mit.edu> wrote:

> Quoting Yogesh Agrawal <agrawaly at gmail.com>:
>
> >> Your five exchanges are:
> >> 36.075 shares @ 27.72
> >> 16.171 shares @ 30.9195
> >> 16.319 shares @ 30.6391
> >> 16.077 shares @ 31.1003
> >> 52.246 shares @ 46
> >>
> >> Weighted average price = (qty1 * price1 + qty2 * price2 + qty3 * price3
> +
> >> qty4 * price4 + qty5 * price5) / (qty1 + qty2 + qty3 + qty4 + qty5)
> >>
> >> The weighted average price is 35.8199, so your remaining 32.396 shares
> >> would be worth 1160.42 according to this method.
> >>
> >
> >
> > I understand this charles,  but  my question is how can I get 1000
> instead
> > of weighted average 1160.42, because, when you move from one financial
> year
> > to another
> > you balance sheet should show the amount of the investment that you are
> > carrying over, not the weighted average.
> >
> > It is same as you calculate the capital gain, you don't calculate it on
> the
> > basis of weighted average, but you calculated in on the actual price at
> > which you
> > bought the shares and the price at which you have sold it.
>
> Enter PriceDB entries for all your transactions and then select
> a PriceDB-based calculation method in the report.
>
> >> > > > 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
>
>