Join Early Retirement Today
Thread Tools Search this Thread Display Modes
Howto: Quicken and TSP
Old 04-28-2007, 11:39 AM   #1
Confused about dryer sheets
Join Date: Mar 2007
Posts: 1
Howto: Quicken and TSP

I have posted the updated file that allows you to easily import TSP fund-prices into Quicken. The file contains prices for all TSP funds from 2003-present. The complete howto/instructions and the file are located here: The down-and-dirty instructions are below.

Importing historical TSP prices into Quicken isn't too hard. You can do it one of two ways. Enter prices manually (which would take forever). If you want to use the automated method, use instructions below (make sure you change the fund ticker/symbols or the file will not work). Note: If you use my TSP files to import data into Quicken, disregard steps 6-9. If you want to do the whole procedure yourself, follow all steps below. Also, you only need to change the ticker's once in Quicken- once the ticker's are done you can just download the file and import.

1. Go into Quicken and create a new investment.

2. Click on "Investment Center" on left tool bar. This will show all your investment and accounts.

3. Click on "Portfolio" on top tool-bar, if you aren't already there.

4. Find your account, and right click on it. Select "Edit Security."

5. Change the Symbol to something easy to remember, but it can't conflict with an existing security name (i.e. any official ticker name). If you want to use my files below, use these fund names:
  • C Fund = C-FUND
  • F Fund = F-FUND
  • G Fund = G-FUND
  • I Fund = I-FUND
  • S Fund = S-FUND
  • L 2040 = L-2040
  • L 2030 = L-2030
  • L 2020 = L-2020
  • L 2010 = L-2010
6. Go to the TSP website. Go to "Share Prices."

7. Cut and paste the quarter's worth of data into Excel.

8. Open a new spreadsheet and put the fund-symbol you used in Step 5 in column A. In column B list the date. In column C, list the TSP price. If you open one of the files below, it will make more sense or at least give you an example. Make sure that the date (column B) is in the M/DD/YYYY format (right-click on column and choose correct format under "Format Cells.").

9. Save the file as a CVS (comma delimited).

10. Import the file into Quicken under File-> Import -> Import Prices. Type the name of the file in and hit Ok. Note: "Import Prices" will only show up if you have clicked on "Investing Center" on the tool-bar on the left side of the screen.

11. Done!

I have consolidated all the historical fund prices into one file- you only need to import one file and you should have all the historical prices for C,F,G,I,S all the way back to 2003. The L-funds started in Aug of 2005 so those are included starting then.

There is also a section on how to modify my file for Quicken for the Mac. It is slightly different, although not too complicated to do.

Allenw is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

» Quick Links

All times are GMT -6. The time now is 08:56 AM.
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2021, vBulletin Solutions, Inc.