TSP Talk Market Comments TSP AutoTracker Premiums Site Map TSP Funds Forum Returns

TSP | Thrift Savings Plan - Talk

Quotes, Charts, Info

TSP Share Prices & Returns
Fund Index Quotes

Popular Charts
Market Futures Quotes
Earnings Reports
Economic Calendar





Help and Resources

Site Map
FAQ - Premium Services
FAQ for Alerts
Reader Testimonials
How to Make a Transfer
How to Make an IFT (Video)
Report Problems / Errors
Contact Us

TSP - What is it?
Who Is TSP Talk?
What Can We Do For You?
Want More Help?

TSP Talk Toolbar

Mug Shots
Classified Ads -
TSP Talk User Map
Tell a friend or co-worker
Recent Forum Activity
Video & Image Library

Market Analysis Videos Home Page
My Federal Retirement
Ocean's ETF Blog

Mobile Options

- Android Forum App
- iPhone Forum App
- TSP Talk Mobile Version


Returns Calculator Instructions
Returns Calculator Instructions:
This utility uses Microsoft Excel. 

- Open up the Returns Calculator by clicking here.
- When the spreadsheet opens,  go to "File", then "Save as" to save it to your PC.

Under “Fund Price”, the first price entry for each fund should be the final share prices of
each fund just before you start tracking.  In the example below (marked "A") I am starting
at the beginning of 2006, so the final share prices for 2005 (Dec. 30) will go in that first row. 
These prices can be found on  More on that below.  This 2005 fund price row
constant all year as we use these numbers to get our return for the year. 

Once you have the prices in place you want to add the starting date. In the example below we're using Jan 3 ("B").
Then enter your starting allocation in the yellow cells (marked "C"). 
Now you will manually enter your current
account allocation in the yellow highlighted section.  Let's assume our first allocation is 25% F, 25% C, and 50% S.
Enter "25" in the F column, "25" in the C column, and "50" in the S column. The "%" will fill in automatically.

Now we need to get the first updated share prices.  To get the current fund prices, you need
to go to  On the main page, click on "Share Prices".

Once in the Share Prices page, highlight and copy the G fund through I fund share prices...

... a
nd paste them under the "Fund Prices" column in the current row.  You will also input the current date in the
"End Date" column. 

You will notice a couple of things.  All of the share prices below the one you entered were automatically
updated to the current share price as well.  Also notice in the orange area above that the fund returns also
filled in automatically, as well as your return on the far right for the current allocation and for the year (not shown).

As long as you have not made any new interfund transfers, any time you want to check your current return, get the
current share from, input the current date and share prices in that row and you will be all set.

To see how your allocation compares to the individual funds, scroll down toward the bottom of the spreadsheet.

- To include the L-funds into your
comparison, simply copy and paste
the current L-fund prices from into the corresponding
cells (Marked "B").

- The 2005 prices ("A") will be the final
L-fund share prices from 2005 also
found at

- The figures in the blue box will be
updated automatically.

- A positive number indicates your
return > other allocation.

- A negative number indicates your
return < other allocation.

Now let's make an interfund transfer...

Let's say that on February 9th we make an interfund transfer before the 12:00 noon ET deadline.
At the end of the day you'll want to insert the 9-FEB-06 date in the "End Date" column along with
the closing share prices of that date. 

Start another row with transaction #2, enter the starting date (10-FEB-06 in this case), and enter
your new allocation in the "Fund Allocation" columns.  In this example it is 50% G, 50% C fund.

You will continue to update the End Date and share prices in Trans #2 row until
you make another interfund transfer where you will start on Trans #3. 

I hope this helps.  If you still have any questions, please email me


Free e-mail alerts

Enter e-mail Address:
For Email Marketing you can trust

[more info]
Join the 17,108 on the list

TSP Talk Toolbar!
Download the Toolbar

Premium Services


Sponsor's Links

S&P 500 (C fund)
1d  5d  3m  6m  1y  2y
Dow Completion (S fund)
1d  5d  3m  6m 
EFA (I fund)
1d  5d  3m  6m  1y  2y
Bonds (F fund)
1d  5d  3m  6m  1y  2y
20min. delay

TSP Talk does not guarantee the accuracy or completeness of this report, nor does assume any liability for any loss that may result from reliance by any person upon any such information or opinions. Such information and opinions are subject to change without notice and are for general information only. 

The information contained on this website is for educational purposes only and not intended to be recommendations, and may not be published, broadcast, rewritten or otherwise distributed without prior written consent from Full Disclaimer

Copyright © 2003 - 2014
Buy Low Sell High, Inc.® is a trademark of Buy Low Sell High, Inc.
All Rights Reserved

Buy Low Sell High, Inc., P.O. Box 13213, Ogden UT 84412


TSP Talk Market Comments TSP AutoTracker Premiums Site Map TSP Funds Forum Returns