How to enter a constant sum formula using values from 2 different
 

I am trying to program a spread sheet to track the average cost per share of
stock based on periodic investments and sales of the stock. Want to have a
column which will show the average cost per share of every purchase as well
as another which will show average cost of all shares being held.

Thanks for your assistance.