Hi to all,
The complexities of your mathematics is catching up to all you.
The easiest solution is to us MS Money to track your investments. Since Money does it I am reasonably certain that Quicken does it also.
The next easiest solution is to set up a spreadsheet. How you declare your sales to Uncle Sam would determine how you set up the spreadsheet.
There are many ways to determine which shares are sold for tax purposes.
You could sell the first ones you purchased which is called FIFO.
You could sell the last ones you purchased which is LIFO
You could specify specific blocks of shares to be sold.
MS Money allows for all of the these methods. What the program then does is simply take the total cost of the remaining shares and divide it by the total number of shares owned. This would give you the average cost of every share which I believe is what Lou is looking for. I can't believe that anyone is going to come up with a different method to compute a simple average.
Once you have determined what method is used to report to the IRS it would be a simple spreadsheet to set up using the SUM and Average functions. Lou, if you have any trouble doing this, let me know and I will set up a spreadsheet and e-mail it to you.
Bernie
Market Data 
Markets 
AI
