0

I am finding hard to arrive at the average price when there is a sell happened at much profitable price partially

Could you please advice me to arrive at the average price and the % gain for the below scenario ?

enter image description here

iappmaker
  • 117
  • 4

1 Answers1

1

Adding holding and value to your table

#   Price   Flow    Held  Value
3   4000    12000   3     12000
20  4000    80000   23    92000
10  7000   -70000   13    91000
10  7000   -70000   3     21000
1   7000    -7000   2     14000

the time-weighted return can be calculated

(92-80)/12*(91+70)/92*(21+70)/91*(14+7)/21-1 = 75%
Chris Degnen
  • 10,107
  • 1
  • 21
  • 36