Correcting Allocation Dates

What's new at TSP Center as well as discussion of features that are due to launch shortly.

Moderator: Aitrus

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

Correcting Allocation Dates

Post by mjedlin66 »

There are 347 IFTs in the database that take effect on weekends or holidays. This is obviously incorrect and causes other bugs, such as a broken fantasyTSP account or missing allocation change markers on your FantasyTSP graph.

First I fixed the code that was allowing IFTs to be effective on weekends or holidays. The code will automatically roll the effective date forward to the next trading day *from now on*.

This bug affected IFTs as early as 2010-01-01 and as recently as 2020-06-12.

Now, I am fixing the database. The script only takes like 5 minutes. But it changed a LOT of values and it might break something. But I tested it thoroughly and I'm backing up the allocation tables first. Pretty sure this is gonna work (at least up to par with government software quality standards).

Matt
Owner/creator of TSPcalc.com - "Know your numbers"

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

Re: Correcting Allocation Dates

Post by Aitrus »

mjedlin66 wrote: (at least up to par with government software quality standards).
Oh, hell. Thanks for the heads up. Now I know to be ready to handle the flood of complaints that are no doubt about to come in. :wink:
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

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

Re: Correcting Allocation Dates

Post by mjedlin66 »

It's done. Here's a before and after, using cryptonite's fantasyTSP as an example.

Cryptonite had an IFT on 6/7/2020, which was a Sunday. This caused an error in his balance which i manually fixed before, but notice there was also no red marker on his graph on 6/8 showing an IFT. Now, his IFT date has been corrected to 6/8/2020.
Cryptonite Before.png
Cryptonite After.png
You do not have the required permissions to view the files attached to this post.
Owner/creator of TSPcalc.com - "Know your numbers"

User avatar
Amerks
Posts: 34
Joined: Sun Jan 12, 2014 10:21 am

Re: Correcting Allocation Dates

Post by Amerks »

Hi Matt...not sure if this is related but my return percentage for 6/18/2020 looks off. I am invested as 15% L2030 , 15 % F, 70 % G. For the day L2030 was -0.07%, F +0.14%, G 0.00. The combined return shows -0.01%. Just eye balling this I would have expected to have seen a slight positive return?

The actual dollar calculation in my TSP Balance Sheet By Chart Range account looks correct and shows an increase from close 6/17 to close 6/18 and matches the TSP.Gov values. However the FantasyTSP Balance Sheet By Chart Range incorrectly shows a decrease which is likely why there is a negative value for the daily return.

When I calculate the percentage from the dollars my account, the account increased was +0.012 for the day, so I think I should have seen a +0.01% increase to my return.

User avatar
Navig8tor
Posts: 560
Joined: Mon Jul 19, 2010 10:48 am

Re: Correcting Allocation Dates

Post by Navig8tor »

OH SNAP!! Does this mean my December 2018 IFT that was submitted and never executed, and subsequently caused me to drop double-digits through the end-of-the year flash crash, will be fixed and my phantom loss will be erased???

Won't help with this monstrous 2020 screw-up that I'm still clawing back from :lol: :lol: :lol:
Navig8tor
CWO4 (BOSN)
USCG, RET

VAmanBulls
Posts: 238
Joined: Wed Jul 24, 2019 8:37 am

Re: Correcting Allocation Dates

Post by VAmanBulls »

Wow man, thanks for all your work on this. Y'all have a great weekend.

Midway
Posts: 226
Joined: Tue Feb 28, 2012 6:09 pm

Re: Correcting Allocation Dates

Post by Midway »

Can you correct some of my mistakes on the real TSP site too?

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

Re: Correcting Allocation Dates

Post by mjedlin66 »

Navig8tor wrote:OH SNAP!! Does this mean my December 2018 IFT that was submitted and never executed, and subsequently caused me to drop double-digits through the end-of-the year flash crash, will be fixed and my phantom loss will be erased???

Won't help with this monstrous 2020 screw-up that I'm still clawing back from :lol: :lol: :lol:
It doesn't look like it. I don't see a december 2018 IFT for you. It's possible it got deleted a long time ago :/
Owner/creator of TSPcalc.com - "Know your numbers"

User avatar
Navig8tor
Posts: 560
Joined: Mon Jul 19, 2010 10:48 am

Re: Correcting Allocation Dates

Post by Navig8tor »

You know what, I think I have my facts wrong - I was up 13-some percent, got caught up in an ill-timed IFT sometime in mid-September 2018, rode it WAY down and back up until I was in the +5-6% range. I remember IFT'ing to the G-fund thinking, "Well, ruined my return for the year but 5% is better than being in the hole." But, in the hole is where I went because the IFT didn't cycle. Looking back at my stats, I may have actually IFT'd sometime right before or right after Thanksgiving 2018 rather than December as I originally thought.

I promise it happened - I'm sure there is a post on here somewhere in which I was griping about it. I remember it because it was the second time it happened (since I joined in 2010) and it hosed me out of a positive return FOR THE YEAR. The first time - not a big deal - KING fixed it. That one there never did get corrected.

Not a big deal - don't waste any more time looking for it. It's just a game. But - THANKS FOR CHECKING to begin with!!

Oh yeah, there was also the time I had like a 54% return in the L-Income IN ONE DAY after I went into it for a "safety move" to beat the "G." :lol: :lol: :lol: <<< I picked up about 200 "followers" over the next couple days - they have all since departed :lol: :lol: :lol:
Navig8tor
CWO4 (BOSN)
USCG, RET

NotSoGood
Posts: 84
Joined: Fri Mar 07, 2008 3:33 pm

Re: Correcting Allocation Dates

Post by NotSoGood »

Do any of the recent changes explain why the 5, 15, 30, et cetera, day leader boards are all at 0.00%?

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

Re: Correcting Allocation Dates

Post by mjedlin66 »

NotSoGood wrote:Do any of the recent changes explain why the 5, 15, 30, et cetera, day leader boards are all at 0.00%?
Probably. Give it time.
Owner/creator of TSPcalc.com - "Know your numbers"

Post Reply

Fund Prices2022-08-12

FundPriceDayYTD
G $16.99 0.01% 1.51%
F $19.10 0.37% -8.58%
C $65.23 1.74% -9.34%
S $70.95 1.86% -14.97%
I $34.16 0.59% -13.39%
L2065 $13.19 1.35% -11.37%
L2060 $13.19 1.35% -11.37%
L2055 $13.19 1.35% -11.36%
L2050 $27.11 1.14% -9.72%
L2045 $12.43 1.07% -9.06%
L2040 $45.65 1.00% -8.33%
L2035 $12.13 0.92% -7.53%
L2030 $40.66 0.84% -6.69%
L2025 $11.70 0.58% -4.50%
Linc $23.03 0.35% -1.93%

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