Google
 

TSP Talk

Market Comments TSP Tracker Premiums Site Map TSP Funds Message Board Returns


TSP Talk -
 Thrift Savings Plan

for Federal Government Employees & Military Personnel

Thrift Savings Plan Talk

 
 
Market & TSP News

Yahoo Finance

Fund Index Quotes

Globex Futures

Economic Calendar
 

TSP & Market Links
TSP Talk Pages
TSP Talk

About TSP Talk

Market Comments

Message Board

Fund Allocation

Rates of Return

The TSP Funds

Market Quotes

TSP Calculator
 

TSP.gov Links

TSP.gov Home Page

Financial Talk
Benefits Plan
Personal Finance 101
Insurance, How to Save
Debt Elimination Plan
Proper Credit Card Use
Help

How to Make an Interfund Transfer
TSP Tips
Financial Utilities
Financial Glossary
FAQ
Help
Contact Us

Ads & Links
Links

Place an ad on
  TSP Talk
1212Computer's TSP Share Prices & Financial Software Data Files

1212Computer's Center - Share Prices - Charts - Alerts

Why Financial Software Data Files? 
When it comes to investing I like to have many resources at my finger tips to process my thoughts especially when it comes to "BUY"ing and "SELL"ing securities.  Since there are few dynamic resources out there for TSP Funds I decided to utilized my financial software, Quicken®, to track my TSP portfolio.  But in order to utilize the software I had to develop a piece of software to retrieve the daily share prices from TSP.gov and format them so they could be imported into Quicken
® (I am working a Data File for Microsoft Money®, it should be released soon).  Thus, the software below:

TSP Share Prices for Quicken®

Downloads:
> Daily TSP Share Prices (updated daily Monday-Friday 2030 EST with current day only)
> Running History TSP Share Prices (from June 2003 to present)

Procedures:
The following steps were performed using Quicken® Home & Business 2005 & 2007 Retirement Account.  Each of the TSP funds are entered into the registry as Mutual Funds using transactions BUY and SELL.

** 1212Computer nor TSPTalk.com accepts NO responsibility for data lost or problems while importing the data files.

First Time Use:

1. ** BACKUP the Quicken® data files before proceeding

2. Open Quicken® and view Portfolio

3. Change/Add each of the TSP funds' Ticker Symbols to the following:

  • L 2040 Fund => TSPL40F

  • L 2030 Fund => TSPL30F

  • L 2020 Fund => TSPL20F

  • L 2010 Fund => TSPL10F

  • L INCOME Fund => TSPLIF

  • G FUND => TSPGF

  • F FUND => TSPFF

  • C FUND => TSPCF

  • S FUND => TSPSF

  • I FUND => TSPIF

4. Download and save the "Running History TSP Share Prices" data file from above

5. File->Import->Import Prices

6. Enter the file location and name (used in step 4)

7. Click OK, That is it, all historical prices are up to date!

Update/Import the Daily Data File:

1. Download and save the "Daily TSP Share Prices" data file from above

2. Open Quicken® and view the Portfolio

3. File->Import->Import Prices

4. Enter the file location and name (used in step 1)

5. Click OK, That is it, prices are updated!

 

S&P 500 (C fund))
[Chart]
1d  5d  3m  6m  1y  2y
Wilshire 4500 (S fund)
[Chart]
1d  5d  3m  6m  1y  2y
EFA (I fund)
[Chart]
1d  5d  3m  6m  1y  2y
Bonds (F fund)
[Chart]
1d  5d  3m  6m  1y  2y
20min. delay http://finance.yahoo.com

TSP Talk is in no way affiliated with the U.S. government, or military Thrift Savings Plan, tsp.gov, or any other government agency.  TSP Talk does not guarantee the accuracy or completeness of this report, nor does TSPtalk.com 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 in this report may not be published, broadcast, rewritten or otherwise distributed without prior written consent from TSPtalk.com.

Copyright © 2003 - 2008
Buy Low Sell High, Inc.
TSPtalk.com® 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 About TSP Talk Premiums Site Map TSP Funds Message Board Returns