Page 3 of 6 FirstFirst 12345 ... LastLast
Results 25 to 36 of 61

Thread: Scout333's TSP Contribution Spreadsheet

  1. #25

    Default Re: Scout333's TSP Contribution Spreadsheet

    Quote Originally Posted by RealMoneyIssues View Post
    So, why doesn't the spreadsheet use shares? It would seem to me that that would be more accurate... but, then again, I am a newbie...
    Real, which spreadsheet do you mean?

  2.  
  3. #26

    Join Date
    Feb 2011
    Location
    Washington
    Posts
    9,583

    Default Re: Scout333's TSP Contribution Spreadsheet

    Quote Originally Posted by Scout333 View Post
    Real, which spreadsheet do you mean?
    http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls
    Rules:
    - Trade what you see, not what you believe
    - Don't put stuff in your signature that a Mod doesn't like

    "Government exists to protect all people’s rights, not some people’s feelings." - A. Barton Hinkle

    Great Tools:
    http://www.CreditKarma.com
    http://www.Mint.com
    http://www.SaveUp.com/r/nmJ

  4.  
  5. #27

    Default Re: Scout333's TSP Contribution Spreadsheet

    Hello Real, My spreadsheet is used mainly to track dollars in the TSP and related return on investments by using the daily share prices for each fund since that is what most members are interested in. Why would you want to track the number of shares? Don't really think one method is more accurate than the other.


  6.  
  7. #28

    Join Date
    Feb 2011
    Location
    Washington
    Posts
    9,583

    Wink Re: Scout333's TSP Contribution Spreadsheet

    Quote Originally Posted by Scout333 View Post
    Hello Real, My spreadsheet is used mainly to track dollars in the TSP and related return on investments by using the daily share prices for each fund since that is what most members are interested in. Why would you want to track the number of shares? Don't really think one method is more accurate than the other.
    Mainly because when I put the $$, %%, and share prices in the spreadsheet, none of the dollar amounts added up. I will continue to take a look at it to see what I am missing. I started this whole thing late, so my returns on the website will be off a little.

    I did 15%+ last year, so I am just trying to maximize it and still try to stay a little diversified and wanted a way to track it.

    Thanks !!
    Rules:
    - Trade what you see, not what you believe
    - Don't put stuff in your signature that a Mod doesn't like

    "Government exists to protect all people’s rights, not some people’s feelings." - A. Barton Hinkle

    Great Tools:
    http://www.CreditKarma.com
    http://www.Mint.com
    http://www.SaveUp.com/r/nmJ

  8.  
  9. #29

    Default Re: Scout333's TSP Contribution Spreadsheet

    Quote Originally Posted by RealMoneyIssues View Post
    Mainly because when I put the $$, %%, and share prices in the spreadsheet, none of the dollar amounts added up. I will continue to take a look at it to see what I am missing. I started this whole thing late, so my returns on the website will be off a little.

    I did 15%+ last year, so I am just trying to maximize it and still try to stay a little diversified and wanted a way to track it.

    Thanks !!
    Real, Take a look at the Tips tab. If you haven't made a lot of IFTs and/or changes in your % allocations this year it may be worth it to go back to the beginning of the year and start with 12-31-2010 fund balances. PM me if you have specific questions about how to enter $, share prices, etc. and I'll see if I can help.

  10.  
  11. #30

    Default Re: Scout333's TSP Contribution Spreadsheet

    A new version of Scout333's Spreadsheet has been posted on the Utilities Page for 2012:

    http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls

    Thanks again Scout333!!
    Tom
    Market Commentary | My Blog | TSP Talk Plus | |

    I am not a Registered Investment Advisor and this is not investment advice. Please do your own due diligence.

  12.  
  13. #31

    Join Date
    Oct 2008
    Location
    Stinking desert valley of bad air quality, AZ
    Posts
    2,993

    Default Re: Scout333's TSP Contribution Spreadsheet

    Scout333, I wanted to say thank you for your spread sheet. I down loaded it last year but never got a "round toit".

    One suggestion about the tips that is a little confusing.

    "(1) Bi-weekly contributions- When you put in the bi-weekly contribution amounts put in the daily share prices first (for the day the contribution is posted) then drop down one line, use the same date and share prices, and enter the contribution in Column E for that line. The reason you have to do this is because the contributions are made after the share prices for that day are implemented. Enter the percentage going to each fund in Columns Z to AD. i.e. 20% to G would be entered .2 in Column Z. Contribution amounts will be allocated prorata among the TSP funds based on your allocation percentages."

    You do say to drop down one line when entering the contribution but the statement about using the same date and share prices confuses at first. You are actually entering the contribution on the line for the next day. You explain it well in the next line.

    Thanks again for the sheet. It does much more than mine which simply multiplies the number of shares times the price and then adds those totals up.

    Is the 2012 Stk Funds (2) for playing "what if"?

    You don't appear to have an "account talk" thread or I would have posted this there.

  14.  
  15. #32

    Default Re: Scout333's TSP Contribution Spreadsheet

    Quote Originally Posted by PessOptimist View Post
    Is the 2012 Stk Funds (2) for playing "what if"?
    Pess you're very welcome. The 2012 Stk Funds (2) is a backup in case something gets messed up in your main spreadsheet. Could be used for "what if" scenarios also or just copy it as another worksheet. If you have a better explanation for the "Bi-weekly contributions" part of the tips feel free to PM it to me and I will add it to tips for next year.

  16.  
  17. #33

    Default Re: Scout333's TSP Contribution Spreadsheet

    Hello Fellow TSP'rs, The new version of the Scout TSP Contribution spreadsheet is out. Tom was kind enough to post it in the Utilities section. It is very similar to the 2012 version. There are a couple of very simple return on investment calculators. See the TSP Return and Tips tabs for info. FERS employees receiving matching contributions can input the employee contribution amounts each pay date and the calculator gives you return on investment %s including the matching contributions. I added some additional input lines. Its so easy to mess up a spreadsheet when adding lines in the middle of the year.

    Enjoy the spreadsheet!

    http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls

  18.  
  19. #34

    Default Re: Scout333's TSP Contribution Spreadsheet

    Hello Fellow TSP'rs, The new version of the Scout TSP Contribution spreadsheet is out. Tom was kind enough to post it in the Utilities section. It is very similar to the 2013 version. There are a couple of very simple return on investment calculators. See the TSP Return and Tips tabs for info. FERS employees receiving matching contributions can input the employee contribution amounts each pay date and the calculator gives you return on investment %s including the matching contributions. I added some additional input lines. Its so easy to mess up a spreadsheet when adding lines in the middle of the year.

    Enjoy the spreadsheet!

    http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls

  20.  
  21. #35

    Default Re: Scout333's TSP Contribution Spreadsheet

    Quote Originally Posted by Scout333 View Post
    Hello Fellow TSP'rs, The new version of the Scout TSP Contribution spreadsheet is out. Tom was kind enough to post it in the Utilities section. It is very similar to the 2013 version. There are a couple of very simple return on investment calculators. See the TSP Return and Tips tabs for info. FERS employees receiving matching contributions can input the employee contribution amounts each pay date and the calculator gives you return on investment %s including the matching contributions. I added some additional input lines. Its so easy to mess up a spreadsheet when adding lines in the middle of the year.

    Enjoy the spreadsheet!

    http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls
    If you haven't used the spreadsheet before suggest that you start with the tips tab! Enjoy!

  22.  
  23. #36

    Default Re: Scout333's TSP Contribution Spreadsheet

    Quote Originally Posted by Scout333 View Post
    Hello Fellow TSP'rs, The new version of the Scout TSP Contribution spreadsheet is out. Tom was kind enough to post it in the Utilities section. It is very similar to the 2012 version. There are a couple of very simple return on investment calculators. See the TSP Return and Tips tabs for info. FERS employees receiving matching contributions can input the employee contribution amounts each pay date and the calculator gives you return on investment %s including the matching contributions. I added some additional input lines. Its so easy to mess up a spreadsheet when adding lines in the middle of the year.

    Enjoy the spreadsheet!

    http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls
    Hi Scout333, Thank you so much for the spreadsheet!!
    Don't take my comments as trading advice /IFT: 2-13-24=100G/https://www.theepochtimes.com/ & http://www.ewg.org/PermaCharts@p430#5159/strategy#4918p.410


  24.  
Page 3 of 6 FirstFirst 12345 ... LastLast

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)
Scout333's TSP Contribution Spreadsheet
(Stockcharts.com Real-time)
DWCPF (S Fund) (delayed)
Scout333's TSP Contribution Spreadsheet
(Stockcharts.com Real-time)
EFA (I Fund) (delayed)
Scout333's TSP Contribution Spreadsheet
(Stockcharts.com Real-time)
BND (F Fund) (delayed)
Scout333's TSP Contribution Spreadsheet
(Stockcharts.com Real-time)

Yahoo Finance Realtime TSP Fund Tracking Index Quotes