30 September 2009 #1 P Pallen Joined 8 May 2009 Posts 40 Reactions 0 Im trying to work out my average price for one of my shares. Bought 5 packets, each at a different price, how do I get my average holding price? TIA
Im trying to work out my average price for one of my shares. Bought 5 packets, each at a different price, how do I get my average holding price? TIA
30 September 2009 #2 N nawshus Joined 23 April 2009 Posts 16 Reactions 0 Add total purchase price then divide by the total units.
30 September 2009 #3 Timmy white swans need love too Joined 30 September 2007 Posts 3,457 Reactions 3 I knocked this spreadsheet up as a bit of a joke, but it will do the job. Put the inputs into the cells with yellow background. Can be used with Excel, Open Office, or Google docs Attachments average price.xls 14.5 KB · Views: 15
I knocked this spreadsheet up as a bit of a joke, but it will do the job. Put the inputs into the cells with yellow background. Can be used with Excel, Open Office, or Google docs
30 September 2009 #4 joslad Joined 3 August 2006 Posts 68 Reactions 0 Work out the total price paid for the 5 packets, and then divide the total price paid by the number of shares. This will give you the price per share. ie if you bought: 100 shares at $1 - paid $100 75 shares at 1.20 - $90 33 shares at 1.40 - $46.20 200 shares at 1.55 - $310 25 shares at 2.00 - $50 Total paid - $596.20 divided by 433 shares avg paid per share $1.37690531
Work out the total price paid for the 5 packets, and then divide the total price paid by the number of shares. This will give you the price per share. ie if you bought: 100 shares at $1 - paid $100 75 shares at 1.20 - $90 33 shares at 1.40 - $46.20 200 shares at 1.55 - $310 25 shares at 2.00 - $50 Total paid - $596.20 divided by 433 shares avg paid per share $1.37690531
30 September 2009 #6 skc Goldmember Joined 12 August 2008 Posts 8,277 Reactions 329 Timmy said: I knocked this spreadsheet up as a bit of a joke, but it will do the job. Put the inputs into the cells with yellow background. Can be used with Excel, Open Office, or Google docs Click to expand... If you wanted to know how long you have held the shares, however, you will need substantially more computing power. (Inside joke)
Timmy said: I knocked this spreadsheet up as a bit of a joke, but it will do the job. Put the inputs into the cells with yellow background. Can be used with Excel, Open Office, or Google docs Click to expand... If you wanted to know how long you have held the shares, however, you will need substantially more computing power. (Inside joke)
30 September 2009 #7 Julia In Memoriam Joined 10 May 2005 Posts 16,986 Reactions 1,973 You should simply be able to choose "Average Price" setting onyour portfolio page of your online broker. It's all done for you.
You should simply be able to choose "Average Price" setting onyour portfolio page of your online broker. It's all done for you.