Page 1 of 1

Is there a way to download TSP share prices in a CSV file format

Posted: Sat Jun 04, 2022 8:48 am
by MrSnrub
Before the Great TSP Redesign From Hell, I would use the following URL to download the share prices in a CSV (comma-separated value) file format:

https://secure.tsp.gov/components/CORS/ ... download=1

Does anybody know of a way to replicate this? Or if the official TSP site plans on re-inserting this functionality in the future?

Re: Is there a way to download TSP share prices in a CSV file format

Posted: Sat Jun 04, 2022 3:52 pm
by nilber
I've been trying to sort it out but haven't been entirely successful. I've extracted the following from the source code that does technically return CSV formatted data.

https://secure.tsp.gov/data/getSharePri ... oad_1.html

What I haven't been able to accomplish is passing the specific dates and funds I want to "download". I use a script in an Access database to pull updated share prices since the last time I ran the script.

The portion "getSharePrices_startdate_20220424_enddate_20220524_Lfunds_1_InvFunds_1_download_1" is not a parameter string being passed back to the server. Instead it is hard coded into the JavaScript and appears to me that it is all still a work in progress, although several TSP sites have either cracked the code or have someone manually transcribing the share prices.

Re: Is there a way to download TSP share prices in a CSV file format

Posted: Sun Jun 05, 2022 7:36 am
by MrSnrub
That actually should work great for now! I just need to adjust my script a little, but that shouldn't be a problem. Thank you!

Re: Is there a way to download TSP share prices in a CSV file format

Posted: Mon Jun 06, 2022 4:38 am
by mjedlin66
I applaud you guys for sharing the info with each other that I had to figure out the hard way.

Re: Is there a way to download TSP share prices in a CSV file format

Posted: Mon Jun 06, 2022 8:14 am
by Aitrus
mjedlin66 wrote: Mon Jun 06, 2022 4:38 am I applaud you guys for sharing the info with each other that I had to figure out the hard way.
That's always been one of my favorite things about this place: how the community members help each other understand the system better.

Re: Is there a way to download TSP share prices in a CSV file format

Posted: Tue Jun 28, 2022 6:35 am
by MrSnrub
Arrgh! Broken again! Or at least not updated with 6/27/2022 data like the main Share Prices page is.

https://www.tsp.gov/data/getSharePrices ... oad_1.html

Re: Is there a way to download TSP share prices in a CSV file format

Posted: Wed Jun 29, 2022 3:52 am
by mjedlin66
MrSnrub wrote: Tue Jun 28, 2022 6:35 am Arrgh! Broken again! Or at least not updated with 6/27/2022 data like the main Share Prices page is.

https://www.tsp.gov/data/getSharePrices ... oad_1.html
Change ".html" to ".csv" and you'll be off to the races again.

Re: Is there a way to download TSP share prices in a CSV file format

Posted: Fri Jul 01, 2022 11:41 am
by MrSnrub
Works great (for now), thanks a bunch!

And as a warning, the HTML file linked above now gives incorrect data. It just puts in yesterday's data for June 24th. DO NOT USE IT.

Re: Is there a way to download TSP share prices in a CSV file format

Posted: Thu Jul 14, 2022 5:18 pm
by 12squared
The new site now has a Download share prices button. It appears to function the same as the old site.

Re: Is there a way to download TSP share prices in a CSV file format

Posted: Sun Jul 17, 2022 6:52 am
by MrSnrub
Arrgh! It's down again. So I don't know what Friday's closing prices were.

Well, I know that the S Fund's price is $61.4532, because if I login to my account and go to the "Investments" section, that's what it says the S Fund's closing price is. Can y'all that are in other funds please log in to your accounts and go to the "Investments" section and tell me what the closing price is for other TSP funds?