i have one question regarding profit amount be taken in actual consideration

10 shares of zomato bought at 50 rs each

20 shares of zomato bought at 60 rs each

50 shares of zomato bought at 40 rs each

in console average price is somethings lets say 45

all this buy orders were in different months

while selling

February

sold 10 shares at 47 rs

now on console average price increases or decrease (no matter)

if we take profit loss statement from backoffice we will see FIFO

where the sold shares will be taken as loss of 3 rs per share

but what will be actual profit

i want to calculate it based on average price as i bought more quantity to average out price

now while selling price was higher than average price so I sold some quantity but p&L statement will take fifo i want to calculate it by average rate

anyone has any excel or something

i have teared this example in 2 digit actual value i traded was in 4 digits

so this matters