This google doc link has trades done on NATCO Pharma stocks in my trading account, intraday and delivery.
I am currently holding 15 shares of NATCO in my demat, what should be the average buy price of this? Can someone explain how it was calculated as well?
You have cleared all your holdings on 3rd of this month which you had in your demat account perviously and again bought 15 stocks on 10/06/2015 @ 2102.
On 11/06/2015, you did intraday I guess.
Again on 19/06/2015, you bought 10 stocks @ 2121
So, Currently 15 stocks which you are holding is at the average buy price of 2102.
But After Tuesday (23/06/2015) when the settlement of stocks which are bought on 19th is done ,
As per FIFO (First In First Out ) method Holding Price 2102 15 quantity and 10 quantity at 2121 T1 holding.
Example:
NATCO LTD purchased 50 during June and sold 35, details of which are as follows:
June 1 Purchased 30
June 5 Sold 15
June 10 Sold 10
June 15 Purchased 20
June 25 Sold 10
The sales made on June 5 and 10 were clearly made from purchases on 1st June. Of the sales made on June 25, it will be assumed that 5 quantity relate to purchases on June 1 whereas the remaining 5 quantity has been issued from the purchases on 15th June and remaining 15 quantity buy price as per 15th June.
2058 is the Buy Average for 15 qty which he had bought recently after that he didn’t sell any stocks & again he bought 10 it will be T1 holding. it will be calculated FIFO method
As per day by day transactions all the holdings you cleared on : 3/6/2015 there is no holdings in your a/c after that on 10th you bought 15 shares @2102 again 11th you traded but it’s intraday so there is no shares here. again you bought 19 th 10 shares @2121 but this will come in t1 holdings . Finally you have 15 shares in your demat a/c which you bought on 10/6/2015 on that day average price : 2102 . 15 shares Buy avg price : 2102
The buy average price is 2102 for 15 Qty of NATCO. All the intraday trades are to be ignored and only the remaining buy and sell qty needs to be adjusted as per the First In First Out basis. By calculating in this manner, we get an average price of 2120 for 15 Qty. We are not considering the trade for 19-06-2015 as it is still not credited to Demat A/c.
As per the doc the when we sum up the all by price and qty you purchased for the period the buy average comes to is 233986/109 = 2146.66 for each share you have bought on that period ie., 2146.66*15 shares
price for 15 shares is 2146.66
price*qty(share) = value , total value/total shares = price for one share(average)