I believe this is the case.If this is the case, can’t I determine by this formula (TOTAL COST/TOTAL # SHARES) what the target share price must get achieve to have zero gain and zero loss?
It seems you would have to keep track of the Price of the shares at buy time. So you would need to have a section of the spreadsheet that tracks all your purchases, and at what price you purchased them at. Or you could just update an average everytime you purchase a fund. This average could then be used to determine how much you gained and lost.I also know there is a different type of gain/loss. If I sell (through an IFT) at higher price than originally purchased I have a positive gain, and at a lower price than I purchased, a lower gain.
So I would make a section for each fund with an average share price (Total Price of Shares/Total Shares Purchased). When you sell use that number for you gains or losses.
Bookmarks