Current Version as of 01/06/09: http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls
Thanks for sharing the spreadsheet.
Last edited by p3a; 12-23-2008 at 07:08 PM. Reason: Mistake
Current Version as of 01/06/09: http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls
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.
Thank you Scout! This is a great utility for those who want a more precise personal return than the autotracker can give.
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.
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 2009 version. I did add 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 paydate and the calculator gives you return on investment %s including the matching contributions.
1-5-2010 Version: http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls
Enjoy the spreadsheet!
A new version of Scout333's Spreadsheet has been posted on the Utilities Page for 2011:
http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls
Thanks 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.
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 2010 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 paydate 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!
Scout333, YOU JUST ROCK!
THIS IS WHERE I WOULD PUT SOMETHING TO REPRESENT MY THINKING, BUT THEN THEY SHOW UP!
Tracker = Check my position
Scout, I gave you rep before because of your spreadsheet. But just had to push those rep scales again because of the upgrades. Thanks!
Maggie
"When asked if my cup is half full or half empty, my only response is that I am thankful I have a cup." -Sam Lefkowitz
Scout,
I am new to this forum but have been studying Lichello's formula for quite some time. Are you familiar with his work? How is your friend that requested the SAFE column faring with following his methods?
As an aside, since the L funds rebalance every day to maintain their percentages, it is the equivalent of Lichello's system without the SAFE component. I have been testing that by tracking my L2050 performance daily. Please note:
Share Price Shares Value
02/09/11
10.28 963.6 9901.45
02/11/11
10.23 963.6 9862.13
02/14/11
10.28 963.6 9905.30
As you can see, the share price on the 9th and 14th are the same. The number of shares are the same, but because they rebalanced on the way down, when it came back up, the value increased by $4.
Interesting, huh?
It is interesting and I agree with his overall theory. Sort of skimming profits off the top on the way up and putting them back in on the way down. My buddy only followed the SAFE concept for a short while. He is stock picking individual stocks and doing well I understand in this bull market. Good luck with your investments!
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...
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
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