Historical Tsp Data In Excel Format

**VirginiaBob** · 10-13-2006, 12:50 PM

Has anyone happened to go through all the historical day-by-day TSP G,F,C,S,I, LFUND data on the tsp website and cut and pasted it all to excel? If so, can you post the file here so I don't have to spend hours upon hours doing it myself. Much appreciated if anyone has it.

**VirginiaBob** · 10-13-2006, 01:32 PM

Ok, I ended up doing it myself. In anybody wants the file, let me know how to attach it in this message board, and it's yours.

**ayla** · 10-13-2006, 01:40 PM

Too much to post since I have it incorporated into a work sheet (or multiple worksheets) that I've added a whole lot more too. Way too much to post here. Shouldn't take you hours and hours though. Probably less than 1 hour.

Use the copy and "paste special" or at least that is what I've done. Also, if you really want to cut your time down to probably 30 minutes or less, you don't need to go back to the earliest date. Just copy one or two years.

Guess I shouldn't have posted here if I wasn't going to meet your request but I wanted to make the point that this is definitely a worthwhile project to do. In general, working with this data in Excel is fairly tedious so best to get in that mode at the beginning. Best if you get the hang of it by doing it yourself. You'll learn more that way.

I've probably gotten carried away but I've set up over 100 charts and still going. I've only been doing this a short while. Amazing how nice it is to have this data to use to plot your own graphs exactly how you'd like them. Let me know if you have any questions about "formulas". Though probably best to bring these up in the "technical charts" section.