Sql data problem

General TSP Discussion.

Moderator: Aitrus

Post Reply
jdeacon
Posts: 136
Joined: Fri Mar 05, 2010 4:38 pm

Sql data problem

Post by jdeacon »

Ever since my real balance exceeded 6 digits, I cannot adjust the balance. Further, daily increases are not reflected even though my year to date percentage increases. Is this a bug?

User avatar
TSPTrader
Posts: 119
Joined: Tue Oct 05, 2010 3:42 pm

Re: Sql data problem

Post by TSPTrader »

How do you adjust the balance? I did not know you can adjust it.

jdeacon
Posts: 136
Joined: Fri Mar 05, 2010 4:38 pm

Re: Sql data problem

Post by jdeacon »

Go to my fantasy tsp. Click on the manage link on the left side of the page. Enter your actual values from the official usg government tsp page for each fund and then hit the submit button. The next time you open the my fantasy tsp page, your updated total shall be reflected

User avatar
jlozano042
Posts: 836
Joined: Tue Apr 04, 2017 12:37 pm

Re: Sql data problem

Post by jlozano042 »

I'm blind as an atretochoana ... can't find this "manage" link. :(

User avatar
ubascuba
Posts: 86
Joined: Fri Sep 08, 2017 11:56 pm

Re: Sql data problem

Post by ubascuba »

I tried to update mine and it just reset my balance to 100K.
Ubascuba
Strategy:167054

“Courage is what it takes to stand up and speak; courage is also what it takes to sit down and listen.” ~ Winston Churchill

jdeacon
Posts: 136
Joined: Fri Mar 05, 2010 4:38 pm

Re: Sql data problem

Post by jdeacon »

On the home page of tspcenter.com, go to the upper right hand side of the page and click the myfantasytsp link. That brings you to your personal tsp page. On the left side of that page you will see the manage hyperlink.

User avatar
TSPTrader
Posts: 119
Joined: Tue Oct 05, 2010 3:42 pm

Re: Sql data problem

Post by TSPTrader »

jdeacon wrote:On the home page of tspcenter.com, go to the upper right hand side of the page and click the myfantasytsp link. That brings you to your personal tsp page. On the left side of that page you will see the manage hyperlink.
take a screen shot please. Your profile may be different.

User avatar
mhende2
Posts: 87
Joined: Wed Oct 12, 2016 12:32 pm

Re: Sql data problem

Post by mhende2 »

I'll give this a whirl since it took me a little while to figure it out.
First, select Fantasy TSP. once that opens, look for the link about middle center of page.
"View my Fantasy TSP"
My Fantasy Screen opens, go to fourth line down on left side below your User Name and find
"TSP Balance" (manage) the word manage is a blue underlined hyperlink opens when you click it.
New screen opens. On left side in options, click on link "Fantasy TSP" which then opens more choices below it. Click on "TSP Balance Tracking". click in window beside TSP Balance status selecting "Enable". below that, Enter your actual TSP balances in the various fund windows, next enter your bi-weekly contribution amount, then enter what % of the contribution goes into the various funds. Then click on the submit button.
That's it. Can be revised anytime.
Hope that helps.

User avatar
evilanne
Posts: 2067
Joined: Thu May 14, 2015 6:52 pm

Re: Sql data problem

Post by evilanne »

jdeacon,

Send Message to Aitrus & Skiehawk11. I think it is something that TSPKing would need to do with the programing to fix.

jdeacon
Posts: 136
Joined: Fri Mar 05, 2010 4:38 pm

Re: Sql data problem

Post by jdeacon »

Thank you

User avatar
TSPking
Site Admin
Posts: 1066
Joined: Thu Nov 15, 2007 7:02 am

Re: Sql data problem

Post by TSPking »

I see the problem. I'm looking into it.
TSPking

It's a gift...and a curse ~ Adrian Monk

jdeacon
Posts: 136
Joined: Fri Mar 05, 2010 4:38 pm

Re: Sql data problem

Post by jdeacon »

Thank you Tspking!

Post Reply

Fund Prices2024-04-18

FundPriceDayYTD
G $18.19 0.01% 1.27%
F $18.62 -0.30% -3.14%
C $78.45 -0.21% 5.50%
S $76.12 -0.20% -1.27%
I $40.67 0.02% 1.21%
L2065 $15.58 -0.13% 3.04%
L2060 $15.58 -0.13% 3.04%
L2055 $15.58 -0.13% 3.04%
L2050 $31.35 -0.13% 2.44%
L2045 $14.32 -0.12% 2.35%
L2040 $52.37 -0.11% 2.29%
L2035 $13.85 -0.10% 2.21%
L2030 $46.21 -0.09% 2.15%
L2025 $12.93 -0.05% 1.72%
Linc $25.28 -0.04% 1.51%

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