Replies to post #21733 on ETF SWING & DAY TRADING

[jimapplesmith]

suppose collumn C contains the returns for each year.
put =log10(1+C5) in collumn, say, N.
=10^(average(N5:N14)-1 computes the average compound return of those 10 years.

e.g., ndx96-05 correct return is 10.91% per year, not 19.69% as shown in the spreadsheet.