Page 1 of 2 12 LastLast
Results 1 to 12 of 17

Thread: Downloadable Historical TSP Share Prices?

  1. Default Downloadable Historical TSP Share Prices?

    Anyone know where to get historical TSP share prices that can be downloaded into an Excell file? I would like the actual TSP share prices, NOT the prices of indexes they follow. Thanks!


  2.  
  3. #2

    Join Date
    Nov 2012
    Location
    Near Washington, DC
    Posts
    194

    Default Re: Downloadable Historical TSP Share Prices?

    You can get them from the TSP.GOV site. I did a week or two ago. I don't seemed to have save the file on this PC though. Maybe it is at home.

    Here's the link: https://www.tsp.gov/investmentfunds/...eHistory.shtml
    Last edited by NiteFlyer; 01-03-2013 at 03:08 PM. Reason: Added TSP.GOV historical share prices link.

  4.  
  5. Default Re: Downloadable Historical TSP Share Prices?

    Thanks, I know how to look up prices on the TSP.GOV site, but couldn't find anywhere to download data to an Excell file. I'm looking do download years worth of data. Can you provide a link?

    Got your link from your edited post ... I'll try it out .. thanks!
    Last edited by elufints; 01-03-2013 at 03:12 PM. Reason: Received link after posting

  6.  
  7. #4

    Join Date
    Nov 2012
    Location
    Near Washington, DC
    Posts
    194

    Default Re: Downloadable Historical TSP Share Prices?

    There's the long way... since that's in a table format, 30 days at a time, you can cut and paste each page into Excel. Maybe someone has already done that somewhere or, there's a way to pull up the source of that table from TSP.GOV?

  8.  
  9. Default Re: Downloadable Historical TSP Share Prices?

    Yes, I knew I could cut and paste a page at a time, but like you said, that's the long way to do multiple years. Was hopoing to find it already in Excell format somewhere. Thanks anyway!

  10.  
  11. #6

    Join Date
    Nov 2012
    Location
    Near Washington, DC
    Posts
    194

    Default Re: Downloadable Historical TSP Share Prices?

    If you find a complete file, please post where we can get it. I'll do the same if I find or make one from the TSP site. I've been considering putting together a "best possible return" chart using our EFT limitations. I thought it would be insteresing to compare "perfect transfer points" to what was actually done and show what the maximum possible return could have been if someone had hit all those perfect timings.

  12.  
  13. Default Re: Downloadable Historical TSP Share Prices?

    I think you and I are on the same thought process on this one.

  14.  
  15. #8

    Default Re: Downloadable Historical TSP Share Prices?

    If you PM me your email address, I'll send you my file that has all of the TSP share prices. The file is about 2.5MB since there are a lot of calculations and charts that are automatically generated whenever new daily TSP share prices are added.

  16.  
  17. #9

    Default Re: Downloadable Historical TSP Share Prices?

    I put this together for myself a while back and have been updating it as I go. Updated through mid December, enjoy.
    Attached Files Attached Files


  18.  
  19. #10

    Default Re: Downloadable Historical TSP Share Prices?

    If you PM me your email address, I'll send a copy of the my Excel file as well. In the file, perfect transfer points are automatically calculated on a daily basis. Those perfect transfer points are then mapped to another worksheet where best daily funds are shown from year to year (i.e., rows indicate the yearly trade day and columns indicate the specific year). With that worksheet, you can then see for example what the best fund on the 59th trading day was for each year along with percentage returns from July 2003 to date.

  20.  
  21. Default Re: Downloadable Historical TSP Share Prices?

    Great data ... thanks!

  22.  
  23. Default Re: Downloadable Historical TSP Share Prices?

    I've sent my email through PM. Very interested to see your file, sounds very similar to what I wanted to do. Thanks so much!

  24.  
Page 1 of 2 12 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
SPY (C Fund) (delayed)
Downloadable Historical TSP Share Prices?
(Stockcharts.com Real-time)
DWCPF (S Fund) (delayed)
Downloadable Historical TSP Share Prices?
(Stockcharts.com Real-time)
EFA (I Fund) (delayed)
Downloadable Historical TSP Share Prices?
(Stockcharts.com Real-time)
AGG (F Fund) (delayed)
Downloadable Historical TSP Share Prices?
(Stockcharts.com Real-time)

Yahoo Finance Realtime TSP Fund Tracking Index Quotes