There are minor discrepancies in the share prices on the sheet, compared with the share prices in the TSP statement.
I didn't check them all, but I did find a minor discrepancy with your allocation on the sheet, for one transaction. It totaled 100.05 %. There could be more such issues.
But the major discrepancy is that Contributions aren't listed on the sheet until an IFT is made. So, from May until the end of August, if memory serves correctly, you had relatively large contributions entering funds, without being accounted for by the sheet. (You did not provide any statements prior to July, so I am assuming you were making similar (to your others) contributions between May and August.
May was the top of the market. The end of August was the bottom. Most "unexplained" losses probably occurred in this time frame.
There's yur problem.
I recommend reconciling the sheet share prices with the TSP statements as the statements become available.
I also recommend performing an "IFT" on the sheet to account for each Contribution. The Contribution will throw the percentages off on the allocations. This pseudo IFT will correct that; and should make your sheet more accurate going forward.
Hope I'm right. And hope this helps.
[COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]
S&P500 (C Fund) (delayed) (Stockcharts.com Real-time) |
DWCPF (S Fund) (delayed) (Stockcharts.com Real-time) |
EFA (I Fund) (delayed) (Stockcharts.com Real-time) |
BND (F Fund) (delayed) (Stockcharts.com Real-time) |
||
Yahoo Finance Realtime TSP Fund Tracking Index Quotes |
Bookmarks