Use cell C2 to swap between Random Long/Short to Long if Open>MA(50 week) or short if Open <MA(50 week). Again press F9 to cycle the randoms.

Compared to the Buy & Hold over the 6 year period, the random entry is rubbish, the MA method is OK but BHP kills that due to it's massive B&H result (if RIO was in there it would probably be the same).

Of course this is all 1000 trades no reinvestment which might help against B&H.

Also these are all Top20 shares so the weekly upside is usually small. The weekly comp is operating in a totally different class of share where 10 moves are far more common (and you generally can't short)