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

[Formula challenged]

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.