Originally Posted by
ChemEng
Additionally, the tspworksheet does not account for this "gain/loss" for this lag. It seems that the percent gain should be calculated on the ending price of the fund you are leaving, not the gaining price of the fund you are moving into.
Given this transaction listed above, the tspworksheet says I have a 2.83% gain since 21JUL05. (Thats when I started using the worksheet.) The first 2.23% was gained in the S fund on 24JUL06. But it is saying that I gained 0.58% because of the IFT into C fund that was effective yesterday. The problem is I sold my S fund at the price it was on 25JUL06 and have not created any C fund gains at all because I bought it at the 25JUL06 price.
That doesnt make sense to me.
Bookmarks