Hi banjanxed:
It appears you may a logic issue in the way you have set up the table. If your purchase price for all the stocks is set up correctly, your average purchase price can not go negative unless you got some stock for free ... even in that case your price can at most be zero. A sample layout of your table and the formulas will be helpful in looking at the problem.
Like this thread? Share it with others