FYI, I found a flaw in the way I was calculating the 20% in each fund allocation my spreadsheets.
I use to just take 20% of the return of each of the 5-funds and add them together. This wasn't accurate.
Now I am doing it the way I do any allocation. That is, put it in the spreadsheet as 20% in each fund, insert share price, and bam, we get a monthly return. Then I compound the monthly return of each month and create the total return cell like this...
=(100*((1+(M8))*(1+(M9))*(1+(M10))*(1+(M11))*(1+(M12))*(1+(M13))*(1+(M14))*(1+(M15))*(1+(M16))*(1+(M17))*(1+(M18))*(1+(M19)))-100)/100
M8 in my spreadsheet is January's return, M9 is February, etc., until you get to M19, which is December's. (http://www.tsptalk.com/returns/returns.html)
This should help it compare much more closely to what the autotracker is doing.
I use to just take 20% of the return of each of the 5-funds and add them together. This wasn't accurate.
Now I am doing it the way I do any allocation. That is, put it in the spreadsheet as 20% in each fund, insert share price, and bam, we get a monthly return. Then I compound the monthly return of each month and create the total return cell like this...
=(100*((1+(M8))*(1+(M9))*(1+(M10))*(1+(M11))*(1+(M12))*(1+(M13))*(1+(M14))*(1+(M15))*(1+(M16))*(1+(M17))*(1+(M18))*(1+(M19)))-100)/100
M8 in my spreadsheet is January's return, M9 is February, etc., until you get to M19, which is December's. (http://www.tsptalk.com/returns/returns.html)
This should help it compare much more closely to what the autotracker is doing.
