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
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
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.
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.
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.
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.
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
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
Don't take my comments as trading advice /IFT: 4-1-24=100G/https://www.theepochtimes.com/ & http://www.ewg.org/PermaCharts@p430#5159/strategy#4918p.410
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