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.
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.