Cost of shares calculator or formula?

• 17 July 2008

• #1

S

stargazer

Joined

17 July 2005

Posts

259

Reactions

0

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

 

• 17 July 2008

• #2

subaru69

Just keep swimming...

Joined

22 June 2008

Posts

126

Reactions

0

Re: Calculator or Formula

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

 

• 17 July 2008

• #3

subaru69

Just keep swimming...

Joined

22 June 2008

Posts

126

Reactions

0

Re: Calculator or Formula

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

 

• 17 July 2008

• #4

white_goodman

BOC

Joined

13 December 2007

Posts

1,635

Reactions

0

stargazer said:

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

Click to expand...

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

 

• 17 July 2008

• #5

S

stargazer

Joined

17 July 2005

Posts

259

Reactions

0

Hi all

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

Cheers
SG

 

• 18 July 2008

• #6

CamKawa

Joined

5 January 2008

Posts

556

Reactions

0

This may help

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