Replies to post #21703 on ETF SWING & DAY TRADING

[Keith K]

Hey wild_card,

Can I be so bold to nominate you as the lead dog-caretaker of this spreadsheet. That may already be the case, but we do need to have one designated person responsible for controlling whatever changes are proposed.

Anybody else agree/disagree? ...or other SIMPLE ideas to manage this process?

[zzz2maro]

Yes those are the links that have erroneous data. Not too big a deal for current calculation of NASI if you use the MEIKKA formula. However it might change the backtest numbers a little. Look for suspect &/or duplicate values on the following dates:
5/20/2002
7/4/2002
12/24/2002
12/31/2002
2/14/2003
4/17/2003
5/23/2003
8/29/2003
11/26/2003
12/24/2003
1/16/2004
4/9/2004
2/21/2005
5/30/2005
7/31/2001
5/2/1986

[jimapplesmith]

wild_card,

If you put 1 or 2 in cell M$4, then the following formula for collum L computes the 1x or 2x results:

L75
=IF(N74="long",L74*(1+M$4*(E75/E74-1)),IF(N74="short",L74*(1-M$4*(E75/E74-1)),L74))

And =((L5122/10000)^0.05-1)*100 computes the 20 year compound annual return.

(edit: in the program sheet)

Arithmatic mean of annual returns is not very meaningful. For example, if year 1 has return of 100% and year 2 has -50%, the average of two is 25%. However, the actual total gain is actually 0%, which is dramatically different from 25%.

Jim