How do you average your holdings? - Aussie Stock Forums

1. ## How do you average your holdings?

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

2. ## Re: How do you average your holdings?

Add total purchase price then divide by the total units.

3. ## Re: How do you average your holdings?

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

4. ## Re: How do you average your holdings?

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

thanks mate.

6. ## Re: How do you average your holdings?

Originally Posted by Timmy
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
If you wanted to know how long you have held the shares, however, you will need substantially more computing power.

(Inside joke)

7. ## Re: How do you average your holdings?

You should simply be able to choose "Average Price" setting onyour portfolio page of your online broker. It's all done for you.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
Aussie Stock Forums