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!
$ - 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!
Do you know how to upload spreadsheet?
Hi JKJ.. Do you know where I can get more closing prices for TSP going back from 2003 to early 1990's?
Not yet uploaded results because I don' t know how. Just see instructions on uploading pics n video. Do you know how to upload spreadsheet?
Yes... 2013 is really low except for those of us not playing enough. Really looks like this strategy works great in the really bad years. How odd! :blink:
I think I will use it but modify a bit for this year but keep eye on market for big market turns. Analysis is showing about 300% total return for the years going back to 2004. I was able to filter by investment period and found two periods that had better returns using a different fund for two periods...which caused returns to go up around 311% or so...gotta look at it again. I've got all that info in spreadsheet.
There were no daily share prices (or shares at all) before the new daily tracking system started in 2003.
I found out from other website for this strategy (found by mstrzerg) very interesting with the average return of 42% for the last 8 yrs, then this may help me to become millionaire sooner. YTD gain more than 15% (this beat my estimate of 12% average).
[TABLE="width: 128"]
[TR]
[TD]2004 - 26%[/TD]
[/TR]
[TR]
[TD]2005 - 13%[/TD]
[/TR]
[TR]
[TD]2006 - 27%[/TD]
[/TR]
[TR]
[TD]2007 - 30%[/TD]
[/TR]
[TR]
[TD]2008 - 55%[/TD]
[/TR]
[TR]
[TD]2009 - 85%[/TD]
[/TR]
[TR]
[TD]2010 - 49%[/TD]
[/TR]
[TR]
[TD]2011 - 45%[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]January[/TD]
[/TR]
[TR]
[TD]3 - F Fund[/TD]
[/TR]
[TR]
[TD]23 - S Fund[/TD]
[/TR]
[TR]
[TD]February[/TD]
[/TR]
[TR]
[TD]12 - F Fund[/TD]
[/TR]
[TR]
[TD]March[/TD]
[/TR]
[TR]
[TD]7 - S Fund[/TD]
[/TR]
[TR]
[TD]April[/TD]
[/TR]
[TR]
[TD]26 - G Fund[/TD]
[/TR]
[TR]
[TD]May[/TD]
[/TR]
[TR]
[TD]9 - F Fund[/TD]
[/TR]
[TR]
[TD]24 - S Fund[/TD]
[/TR]
[TR]
[TD]June[/TD]
[/TR]
[TR]
[TD]1 - G Fund[/TD]
[/TR]
[TR]
[TD]10 - I Fund[/TD]
[/TR]
[TR]
[TD]July[/TD]
[/TR]
[TR]
[TD]3 - C Fund[/TD]
[/TR]
[TR]
[TD]25 - F Fund[/TD]
[/TR]
[TR]
[TD]August[/TD]
[/TR]
[TR]
[TD]19 - S Fund[/TD]
[/TR]
[TR]
[TD]September[/TD]
[/TR]
[TR]
[TD]18 - G Fund[/TD]
[/TR]
[TR]
[TD]October[/TD]
[/TR]
[TR]
[TD]26 - I Fund[/TD]
[/TR]
[TR]
[TD]November[/TD]
[/TR]
[TR]
[TD]8 - F Fund[/TD]
[/TR]
[TR]
[TD]20 - S Fund[/TD]
[/TR]
[TR]
[TD]December[/TD]
[/TR]
[TR]
[TD]3 - C Fund[/TD]
[/TR]
[TR]
[TD]23 - I Fund[/TD]
[/TR]
[/TABLE]
There were no daily share prices (or shares at all) before the new daily tracking system started in 2003.
So how were earnings tracked? There were monthly/quarterly returns. Do you know if anyone has attempted to get audited daily earnings data via FOIA going back the beginning of TSP? Surely it exists... But just not published.
To upload a spreadsheet you need to select "go advanced" instead of posting a quick reply. Then look at the icons and select the paperclip (to the right of the).
1. Select "add files"
2. Select "select files"
3. At this point you can locate the file on your computer you wish to attach. Select "open".
4. Make sure there is an "X" in the box next to your file.
5. Select "upload file".
During bull markets, the market outperforms this strategy. During bearish and sideways markets, the strategy outperforms. The dates are used as potential windows of opportunity and one needs to apply traditional analysis to make a final decision. (Momentum, price action, etc) The trend is your guide.
Thanks Dream Boat, i have shared your work with some colleagues. It is quite interesting that members of TSP Talk have not tried this. It would have been cool to see one of the 60-70%ers on the tracker. While i am fairly new to TSP (3 years) i have averaged +- 16%, which i am very happy with but i am commiting to this strategy for the remainder of the year just to see what happens. Currently up 18% YTD, heck why not see what happens. Again thanks for your work on the spreadsheet.![]()
Hello to anyone interested:
I did notice that the spreadsheet was opening to wrong spreadsheet so I deleted that tab and extra tabs so that only the second tab now shows. Also updated the date fields to Text so that they now show as I noticed they were not showing up when opened with an ipad. So here it is again.....
Please note this is not investment/financial advise. Just testing a strategy referenced by others to something developed at another site. Thx
So are you going to track it and let us know when the signal changes?![]()
i can update spreadsheet with actuals using that methodology, so we can see what actual outcomes are based on that method. However, I would not use it as my sole source for making investment decisions without looking at other indicators and performing other technical analysis. If you look at this methodology's track record for 2013, it has not performed as well in past years because we were in such a strong bull market. However, other factors are affecting market including the Feds QEPolicy and market is hyper sensitive to it. Really need to see what is happening in market realtime. I'll try to update it tomorrow or this weekend.
I am posting some links in my account talk regarding look at market action today.