Page 2 of 2 FirstFirst 12
Results 13 to 15 of 15

Thread: Excel Worksheet vs TSP return ???

  1. #13

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: Excel Worksheet vs TSP return ???

    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]

  2.  
  3. Default Re: Excel Worksheet vs TSP return ???

    Thank you, that makes total sense and I'll do that. I feel pretty dumb at the moment.

    Quote Originally Posted by userque View Post
    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.

  4.  
  5. #15

    Join Date
    Jan 2014
    Posts
    7,885
    Blog Entries
    10

    Default Re: Excel Worksheet vs TSP return ???

    Quote Originally Posted by BigLair View Post
    Thank you, that makes total sense and I'll do that. I feel pretty dumb at the moment.
    You're welcome. Don't feel dumb, took me awhile to see it too.
    [COLOR=#0000ff][FONT=comic sans ms][I]"In the land of idiots, the moron is King."--Unknown[/I][/FONT][/COLOR]

  6.  
Page 2 of 2 FirstFirst 12

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
S&P500 (C Fund) (delayed)
Excel Worksheet vs TSP return ???
(Stockcharts.com Real-time)
DWCPF (S Fund) (delayed)
Excel Worksheet vs TSP return ???
(Stockcharts.com Real-time)
EFA (I Fund) (delayed)
Excel Worksheet vs TSP return ???
(Stockcharts.com Real-time)
BND (F Fund) (delayed)
Excel Worksheet vs TSP return ???
(Stockcharts.com Real-time)

Yahoo Finance Realtime TSP Fund Tracking Index Quotes