How to calculate buy and sell average

#1

i was back testing a strategy, i don’t know how to calculate average buy and sell price, please write me correct method of calculating average buy and sell price from below screen shot. thanks

image

1 Like
#2

@Anshu_Tiwari : Purchase price average is 1773.66 and sell price average is 1814.33. ADD all 3 of your purchase divide by 3 . same way do it for your sale.

#3

@sabkaview thanks for reply, one more query -
as you wrote to divide by “3” , what is 3 here? total no. of quantity or total no. of transaction?

#4

total number of quantity should be divided by total value of purchase or sell as the case may be to arrive at average price.

1 Like
#5

Weighted average based on quantity

Summation (P,Q) / Summation (Q)

#6

@Newbie420 can you please elaborate with given trade-book screenshot.

#7

Thank you for sharing this with all the members!