FYI, I found a flaw in the way I was calculating the 20% in each fund allocation on 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.
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.
This should help it compare much more closely to what the autotracker is doing.
