-
The Forum works well on MOBILE devices without an app: Just go to: https://forum.tsptalk.com
-
Please read our AutoTracker policy on the IFT deadline and remaining active. Thanks!
div>
$ - Premium Service Content (Info) | AutoTracker Monthly Winners | Is Gmail et al, Blocking Our emails?
Find us on: Facebook & X | Posting Copyrighted Material
Join the TSP Talk AutoTracker: How to Get Started | Login | Main AutoTracker Page
The Forum works well on MOBILE devices without an app: Just go to: https://forum.tsptalk.com ...
Or you can now use TapaTalk again!New Tracker Wanted!
- Thread starter tsptalk
- Start date
EW_ret
Retired Tracker
- Reaction score
- 21
How is the ten minute grace period accounted for? Should the 12:00 pm ET times be 12:10 pm ET?
I will send you the MYSQL (ver 5.0.18-Debian_9) database tables on member names, transactions, and fund prices that I have for this year. If we transition to the automated tracker this year we will have the data for this year. The format and layout will likely be different from yours. The fund price table contains all Lifecycle funds prices and well as G/F/C/S/I. How do you want me to send these MySQL database tables? Send me your email by PM.EWGuy,
The 10 minute grace period will be enforced. The tracker will track the member's IFT allocation with time stamp. If IFT report is recorded before or at 12:10 PM, the transfer will take place on the same COB day. Everything else at or after 12:11 PM will be deferred for the next COB day and holidays and weekend rules will apply.
As for your database, it is a challenge to incorporate into the tracker but I will try my best to make good use of the data that you have. I will PM you for exporting the data.
As for stat reports, it will open for all members, I will try to have YTD returns, Qtr-T-D, Month-T-D, Week-T-D, daily movers, top 10 list or 20 or 30 that similar to what Rokid, Fundsufer, ATCJeff are doing now. Hopefully these automated stat reports will save everybody's time in the future.
OceanHi,
It took me a week (spare time) to get the logic nailed down for synchronizing members daily allocation, share prices and balances. It was the most difficult part so far in this project. I am glad that I got it working now.
Next question to the board members is: Do you want to have the L funds to be tracked also? I can add this feature if it is desired.
Ocean
weatherweenie
TSP Legend
- Reaction score
- 133
Personally, I don't use the L funds, so I don't need them tracked.
Part of the reason that they weren't tracked before was the difficulty of determining returns using the standard returns spreadsheet. (You had to work with the returns spreadsheet that had the L fund on them.)
I dont use the L funds. But would recommend that if there is very little cost for implementing the capability, include it since you could always remove it later if it is unused or unwanted.
FundSurfer
TSP Pro
- Reaction score
- 39
IMHO, if you are using a L-fund, then you should be in that fund as a long and not moving around. Being 50% L-Income and 50% L-2040 just would not make sense. Returns on 100% Allocation on any of the L-funds is easy to find.
I'd bet it wouldn't take a whole lot of programming to add but at the same time I don't think it should be there. I'm sure there will be many others who will want it added. There will be others who want other things added to whatever software program you develop -- version creep. People will never be completely satisfied. I always suggest clean, straight forward, get the job done software.
FundSurfer
TSP Pro
- Reaction score
- 39
Actually, the reason for not putting that capability into the tracker was that it exploded the size of the tracker spreadsheet. The data is readily available fron the tsp.gov share price page.
EW_ret
Retired Tracker
- Reaction score
- 21
There are actually two parts to this question/issue. Should we track/record the Lifecycle fund prices? Should we track member returns that choose to invest in the L funds?
We currently track all Lifecycle (L) fund prices in the WebTracker database. Rokid lists the YTD performance of each L fund in the Weekly Tally. It makes sense that we continue to track L fund prices so we can calculate returns for report purposes. The alternatives would be 1) not include L fund returns in any future reports, or 2) develop a method to get L fund return data from other internet sites that report weekly, or monthly YTD return performance.
The second part to this question, that others have voiced opinion, is should we track member returns who use the L funds? We have handled this in the past by having the member give the percentage allocated to each underlying TSP fund (G/F/C/S/I). As FundSufer stated, we did this to minimize the size of the TSPTalk calculator spreadsheet. This Excel spreadsheet got so large last year that its size (11 MB) exceeded many email server attachment limits. Adding five columns, for L funds, in each member spreadsheet would increase the size of this file way beyond limits. Tom and others believed that TSPTalk members should use the basic TSP funds. The L funds are for those who do not have the time, or expertise, to manage their TSP account.
Should we now reconsider tracker members invested in the L funds? The file size issue should not be a problem since the new Auto Tracker database will reside on a TSPTalk server. The second reason is still valid; the L funds are for those who do not have the time, or expertise, to manage their TSP account.
Will we continue to generate the same Excel calculator spreadsheet? I don't see that we need to generate the entire TSPTalk calculator spreadsheet. We can directly generate other reports, such as the Weekly Tally, from the database. These reports need to be defined. The calculator software (php) that I developed to generate Excel shreadsheets from the WebTracker database can generate any member’s worksheet, or All worksheets. I email the All worksheets version to Tom, Rokid and Fundsurfer. Perhaps we will have a demand/need to generate a members worksheet. (?)
Good day. (Indeed it was, who could deny a 284 point jump in the Dow in one day - just by watching it).
Thanks for all your feedbacks and thanks for EWGuy's clarification, and you exactly hit the right points that I had considered.
But judging by the responses, the L funds tracking seems not needed. So I will not implement it even though all it needs is 5 more fields in a few database tables.
On the other, because of the data is generated automatically from the database, so there will a lot of reports that can be generated with a few clicks of the mouse. I may come up with option that a few favor members that other members may be able to bookmark it. Members like 12%, EBB (until he charges it), Thunder, T2040, ACTJeff, Griffin, Fundsurfer etc etc etc. Hope I can come through with this.
Ocean
Exactly why I recommended putting it in there... shrug
I guess I see it somewhat differently though. This website isnt about informed day trading, its about informed investing through TSP. And BAH is a popular investing option. Its no different that tracking members who choose to stay in C for years, right?
Not to mention that the L funds will get a lot more attention should congress ever approve the boards recommendation to make the L funds the default funds much like G is now.
Its your barbecue Tom, but Im going to give you my opinion.
- Reaction score
- 1,832
Playing devil's advocate, buy and hold is not something others will sit by and follow. The tracker is designed so others can watch those that are managing their accounts well. And I agree, someone who sits in the C fund for years isn't imparting any knowledge to those looking in, even if it does well. We can all see what the C fund and the L funds are doing.
I worry about those who trade the L-funds - and split them up (ie 20% L20, 30% L10, 50% C). I'm also worried about the TSP folks getting P.O.'d enough that they take away the daily transfers. I don't want anyone pointing to this site saying we are encouraging trading the L-funds. The men in black already want to shut us down.
Can we make it so that anyone who uses the L-funds can only be 100% in that one fund?Similar threads
