SONJOE JOSEPH
Member
Good Noon to all Excel Experts. I was just facing a problem to do a calculation to find out the Average Selling Price of a stock. I have attached a working file were there are two sheets named "His" and "Positions". Just click on the "Positions" sheet and the first stock u will find is "Heidelberg" . I need to find out the Average Selling Price using the Contact Value which is given in the "His" Sheet were it should only take all the SELL done of a particular stock and divide the Contract Value by the Quantity.
In the case of Heidelberg SELL transaction happening on
Date Contract Value Qty
28 Aug 20 1957.89 -10
22 Sep 20 1791.91 -10
So the calculation of Avg Selling Price is total of (1957.89+1791.91) / 20 = 187.54. This answer should come in the "Positions" sheet at B3 straight to Heidelberg. Like this i want the results of others too.
Hope some of u will help me in solving it and attaching the working file.
Thanks & Regards,
In the case of Heidelberg SELL transaction happening on
Date Contract Value Qty
28 Aug 20 1957.89 -10
22 Sep 20 1791.91 -10
So the calculation of Avg Selling Price is total of (1957.89+1791.91) / 20 = 187.54. This answer should come in the "Positions" sheet at B3 straight to Heidelberg. Like this i want the results of others too.
Hope some of u will help me in solving it and attaching the working file.
Thanks & Regards,