Price Source for Mutual Fund and Stock

[Derek Atkins]

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