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
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!
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.
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
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?
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!
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.
I think you and I are on the same thought process on this one.
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.
I put this together for myself a while back and have been updating it as I go. Updated through mid December, enjoy.
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.
Great data ... thanks!
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!
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