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

General TSP Discussion.

Moderator: Aitrus

Post Reply
MrSnrub
Posts: 99
Joined: Sun Jun 26, 2016 8:21 am

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

Post 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?
Nobody knows what the market is going to do in the future. Stop asking. Just shut up and follow strategy #72033 to glory.

nilber
Posts: 1
Joined: Sat Jun 04, 2022 3:20 pm

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

Post 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.

MrSnrub
Posts: 99
Joined: Sun Jun 26, 2016 8:21 am

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

Post 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!
Nobody knows what the market is going to do in the future. Stop asking. Just shut up and follow strategy #72033 to glory.

User avatar
mjedlin66
Site Admin
Posts: 1498
Joined: Wed Oct 02, 2013 7:51 pm

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

Post by mjedlin66 »

I applaud you guys for sharing the info with each other that I had to figure out the hard way.
Owner/creator of TSPcalc.com - "Know your numbers"

User avatar
Aitrus
Moderator
Posts: 2301
Joined: Mon Aug 06, 2012 5:03 pm

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

Post 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.
Seasonal Musings 2022: viewtopic.php?f=14&t=19005
Recommended Reading: http://tspcenter.com/forums/viewtopic.php?f=14&t=13474
"It's not what happens to you, but how you react to it that matters" Epictetus

MrSnrub
Posts: 99
Joined: Sun Jun 26, 2016 8:21 am

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

Post 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
Nobody knows what the market is going to do in the future. Stop asking. Just shut up and follow strategy #72033 to glory.

User avatar
mjedlin66
Site Admin
Posts: 1498
Joined: Wed Oct 02, 2013 7:51 pm

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

Post 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.
Owner/creator of TSPcalc.com - "Know your numbers"

Post Reply

Fund Prices2022-06-28

FundPriceDayYTD
G $16.93 0.01% 1.13%
F $18.60 0.02% -10.96%
C $58.12 -2.01% -19.21%
S $61.51 -2.03% -26.28%
I $32.40 -0.43% -17.85%
L2065 $11.97 -1.45% -19.56%
L2060 $11.97 -1.45% -19.55%
L2055 $11.97 -1.45% -19.55%
L2050 $24.96 -1.19% -16.87%
L2045 $11.50 -1.12% -15.88%
L2040 $42.43 -1.04% -14.79%
L2035 $11.34 -0.96% -13.58%
L2030 $38.22 -0.87% -12.29%
L2025 $11.20 -0.61% -8.57%
Linc $22.40 -0.34% -4.62%

Live Charts

Pending Allocations

Under development. For now, you may view Pending Allocations by going to "fantasy TSP" and selecting "Leaderboard sort" of "Pending Allocations".