What is the average buy price of my holding?

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? 

1 Like

Hi,

10-06-2015 15:25:27 NSE NATCOPHARM B 15 2102

Above question fresh buy started on 10th June 15 shares at 2102 Rs presently thats in the Demat

11-06-2015 09:25:26 NSE NATCOPHARM S 2 2130
11-06-2015 09:25:26 NSE NATCOPHARM S 13 2130
11-06-2015 15:20:59 NSE NATCOPHARM B 15 2058

Next trades were Intraday. 

19-06-2015 09:24:32 NSE NATCOPHARM B 10 2121

T1 holdings 

When all the 25 shares get added to the demat:

10-06-2015 15:25:27 NSE NATCOPHARM B 15 2102
19-06-2015 09:24:32 NSE NATCOPHARM B 10 2121

Total buy value = 52740
Total shares = 25

Total buy Value/Total Number of shares = Buy Average

52740/25 = 2109.6 Rs

Hope it helped :)

1 Like

When all the 25 shares get added to the demat:

10-06-2015 15:25:27 NSE NATCOPHARM B 15 2102
19-06-2015 09:24:32 NSE NATCOPHARM B 10 2121

Total buy value = 52740
Total shares = 25

Total buy Value/Total Number of shares = Buy Average

52740/25 = 2109.6 Rs

The buy Avg for 15 qty will be 2102

Because 10 qty will be under T1 holding

Mechanism of calculation is as per FIFO basis

Its calculating as per FIFO base so the buy average price for 15 qty 2102 and last 10 qty will be under T1 holding.

The average buy price for 15 qty is 2102 and last 10 qty will be in T1 holding. this is according to the FIFO method.

In demat account 15 share is there for that buy avg is 2102

and

In T1 holding 10 share is there for that buy avg is 2121.

Hi,

As per the doc shared by You,

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 ,

Your average buy price will be = 2111.5

1 Like

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.

BUY Avg - 2160.167

SELL Avg - 2241.912

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

In Holdings 15 shares at an average of 2058 and T1 10 shares at 2121.

All his past purchases have been offset by the sales.

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

1 Like

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.

Calculation :- Average buy price :- 2146.6 (total buy value/ total number of shares)

 NATCO

Quantity

Avg Price

Buy

109

2160.87

Sell

84

2214.91

Ave. Buy Price - 2146.6 (Total Buy Value/ Total No. of Shares)

buy Avg price is 2058

Because 10 qty will be under T1 holding

The buy average price for 15 shares is 2058 and T1 10 shares at 2121.

Hi

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)