Cost of shares calculator or formula?

[stargazer]

Hi all

I am looking to find or workout if there is a calculator online or a formula for excel to work out a cost for shares one might buy.

Eg.

Buy 5000 xyz at 10c
buy 10000 xyz at 8c
buy 50000 xyz at 3c

Beacause we have a lot greater amount of shares at 3c it is incorrect to average out as one normally would.

Can anyone help.

Cheers
SG

 

[subaru69]

Re: Calculator or Formula

add together the total costs and divide by the no. of shares

 

[subaru69]

Re: Calculator or Formula

5000*0.1 + 10000*0.08 + 50000*0.03 = 500 + 800 + 1500 = 0.0431/share

 

[white_goodman]

Hi all

I am looking to find or workout if there is a calculator online or a formula for excel to work out a cost for shares one might buy.

Eg.

Buy 5000 xyz at 10c
buy 10000 xyz at 8c
buy 50000 xyz at 3c

Beacause we have a lot greater amount of shares at 3c it is incorrect to average out as one normally would.

Can anyone help.

Cheers
SG

thats basic maths....

ive jsut got a basic excel document for my trades, to see what percentage i want for the profits i want, with loans and repayments etc included

 

[stargazer]

Hi all

Thanks for that gee i must have had a seniors moment.. lol quite straight forward.

Cheers
SG

 

[CamKawa]

This may help

http://www.stator-afm.com/free-money-management-software.html