jpcavin's Account Talk

JPCavin,

PortfolioVisualizer is an awesome site...

If you want to backtest a portfolio (for example, your TSP allocation) use this page... JPCavin and I have sent some messages back and forth to figure out the best funds/etfs to use for the G/F/C/S/I. Here is what we came up with:
G - CASHX (money market)
F - AGG
C - IVV
S - VXF
I - EFA

There are issues with using these funds. CASHX is closer to the 'G Fund' than two other funds (IEF or TLH) recommended by other sites. I looked at those funds and their variance was huge. I had to ask myself why? The answer has proven illustrative (J. wanted me to talk the 'Kings English'). How could a 5 - 7 year T-Bill ETF have a standard deviation of over 6%. How could it make almost 18% in one year while losing over 6% another. Our 'G Fund' does not work like that. Well, that got me thinking. The IEF ETF began to trade like a stock fund in 2007. Same with TLH. And, regretfully, the same with AGG. What that means, in reality, is that our 'F Fund' (AGG) is no longer a stable value bond fund. The affect of capital gains growth since 2007 has dwarfed its inherent yield. Thus, when interest rates rise the AGG will plummet - probably worse than most financial advisers predict. Yowser. Regardless, our 'G Fund' will always outproduce the CASHX so using it is very conservative. Our 'G Fund' behaves more like a bond fund than our bond fund. What a mess low interest rates and QE have created.

VXF is the closest J. and I could come up with for a market completion index. The 'S Fund' consists of all the U.S. equities after the 500 companies included in the S&P500. There is no correlated index for this - maintaining it might just be too complicated and too expensive. Both the Russell 2000 and the Russell 3000 are subsets of the 'S Fund'. And, we know what the Dow Completion W4500 is - you can't see anything more than a week old.

This is a bit of work and a work in progress. It is also dependent on the lifespan of the funds in question. Watch what happens to your date rages as you use different funds/ETFs. The start date will change to the fund/ETF that started most recently. Thus, you could think you are using 20 years, but you will actually be using 10 years if you are not careful.

But, I poked around a bit and found another page that more or less addresses this issue. It is called the 'Backtest Portfolio Asset Class Allocation'. The Asset Classes you should use are as follows:
G - T-Bills / Money Market (again, it will under-perform the 'G Fund')
F - Total Bond
C - Large Cap Blend
S - Small Cap Blend (Closer than the Mid Cap Blend which is odd to me)
I - Intl Developed Markets

I tested against MoneyChimps CAGR computation (which has changed for the better) and found the results for 'Large Cap Blend' ('C Fund'/S&P500) to be largely congruent. So using this, your 'G Fund' holdings will give you Alpha over a money market/T-Bill - but again, it is as close as I can get. The 'Small Cap Blend' and 'S Fund' are the most variant. Upwards of 2% per year. I think that is the affect of growth differences in Mid Cap and Small Cap in any single year. However, I do not know the ratios of Mid Cap Blend and Small Cap Blend necessary to equalize this. I have found the 'Small Cap Blend' to be the closer of the two in performance.

You can also watch the effect of DCA on an account. Using two of their sample allocations dated 2004 on (with my balance as of 2003/12/31):
  1. A '40% F'/'60% C' Allocation and a Custom without DCA
  2. A '40% F'/'60% C' Allocation and a Custom with a $8K annual DCA

In the 40/60 allocation - which is the rule of thumb allocation used for decades - a DCA of $8K per year added $150K to your account. Your DCA would have cost you $80K of which $40K was most likely a match.

And, to rub it into all us market pickers;), how many of us have beat the 40% F / 60% C allocation over that ten year period?

Sorry for the late reply....
Thank you for your thorough review Boghie. I am always impressed with your analysis. :) Much appreciate you smoothing the information and going over the asset classes. I had no idea which asset class best represented our TSP.
 
Sorry for the late reply....
Thank you for your thorough review Boghie. I am always impressed with your analysis. :) Much appreciate you smoothing the information and going over the asset classes. I had no idea which asset class best represented our TSP.

Happy belated birthday!
 

Attachments

  • image.jpg
    image.jpg
    12.8 KB · Views: 119
JPCavin,

PortfolioVisualizer is an awesome site...

If you want to backtest a portfolio (for example, your TSP allocation) use this page... JPCavin and I have sent some messages back and forth to figure out the best funds/etfs to use for the G/F/C/S/I. Here is what we came up with:
G - CASHX (money market)
F - AGG
C - IVV
S - VXF
I - EFA

...

JP and Boghie,

Thanks for the timely discussion and analysis of the various surrogate funds ! Since my TSP account balance will dwindle to zero sometime this year (based on my monthly fixed amount withdrawals), I've been toying with the idea of taking a portion of my rollover brokerage IRA, and still playing along with all you TSPers, and the great advice available all over this Forum !

I know there have been many posts around on what's the best ETF/Fund to use, but this is the most comprehensive look at the options I've seen...THANKS ! :)

....and JP ? Happy belated birthday ! Hope you went out to someplace nice in P'cola for your birthday ! :D


Stoplight...
 
Thought the following may be of use to some of you. The below site shows you how to create algorithms without actually coding. Can be used to backtest historical data and can receive real-time results. It's all free unless you choose to link with brokerage account. Watch the video for an example of what you can do with this application.

https://app.rizm.io/home#signup



Just an article that gives information about the above website. I plugged in equivalent ETFs and my preferred indicators and I am getting buy and sell signals via email. The $99 is only if you use them to execute trades. Use of the algorithm to simulate paper trades is free, as is using the information to make trades via your own broker. ;)

Quants-R-Us? Algorithmic Trading Trickles Down To Individual Investors. - Forbes
 
The more I educate myself on Technical Analysis, the less I understand market behavior! :sick: I'll be having a couple of cold ones after work. I understand that!:cool:
 
The more I educate myself on Technical Analysis, the less I understand market behavior! :sick: I'll be having a couple of cold ones after work. I understand that!:cool:

You know, during times of turmoil, there are many reason the markets are hard to forecast. Too many variables in play. For instance, FOMC Yellen did provide good passive information and could be patient on the interest rate hike . That gave the market a bounce...but then the market decided to say...we figure that already...so lets us get back to ugly oil collapse/strong dollar issue...then we head right back down. So, don't feel bad. I don't get it either. Very difficult during market turmoil.

I just want to get out of January not too far behind the leaders. As for my real TSP...I'm following the same numbers and it is scary. Bailing would be easy for me to do...but I have to try my best to know when bailing is the correct thing to do and when I could get more of a return before I bail. Bailing on down days isn't my cup of tea, and bailing in the morning isn't my cup of tea either because the market can change directions.

I sure would like to know from anybody whether we are still in that mode of the first day of each month is positive or have we changed? The market is so uptight right now...hope we settle down and shows positive momentum.

I need a crystall ball to see past Friday. ;)
 
I was planing to bail out of the I Fund today but was stuck in a meeting. Tomorrow I'll know if that would have been a wise or foolish move.
 
I sure would like to know from anybody whether we are still in that mode of the first day of each month is positive or have we changed? The market is so uptight right now...hope we settle down and shows positive momentum.

I need a crystall ball to see past Friday. ;)
We haven't had a positive 1st day of the month since July. :( The S Fund was positive back on Sep 2 but the C & I Funds were down.
 
Congratulations on reaching the big four triple O, jp!!! Better stop posting for a spell so Tom can see it and give you credit. :D
 
Back
Top