So I ran some simple moving averages on Excel. Just simple moving averages. Like on SPY. But I tested everything from like 2 day moving averages (lulz) through 300 day moving averages.
All the numbers sucked versus just buy and hold. Way worse upside, and the max drawdown was barely reduced. It didn't matter the period.
HOWEVER, then I found a flaw in my equations. I had a < when it should have been a >. So... AHA! I had been testing like the REVERSE of moving averages, by when spot dropped below it, sell when it went above it. THAT'S why the numbers sucked! I was going to fix it and the numbers would truly be great!
Only, I fixed it, and the numbers still sucked. Which perplexes me much. If markets trend, how can moving averages (and their reverse) suck so bad?
Here is the best I can come up with: Stock prices, on average, move up over time. Thus, despite whatever the trend is, the stock is likely to go up the next day. For every day you are out of the market that is, on average, upside you are losing out on.
Is that the answer? Or why are they so bad?
Thanks!!!
I haven't tested moving averages alone, but I have used moving average crossovers, and indeed they form a core part of my trading system. But the comments I'm about to make apply equally to almost any trading rule or indicator.
Based on my research, simple indicators like moving average crossovers have something like an average Sharpe Ratio of 0.25 for sensible ranges.
What does that actually mean? It means if you backtest a randomly chosen indicator, over a randomly chosen market, over a randomly chosen time period; then
in expectation on average you will get a Sharpe Ratio of 0.25
That means some of the time you'll do a lot better. And some of the time you'll do worse. In fact, I get a negative Sharpe Ratio in something like a third of all instruments I trade on a randomly chosen moving average. That doesn't mean that a third of all the instruments I trade don't play well with moving averages, that's just what you'd expect to get by luck alone. None of the instruments has a performance that's significantly worse than zero (and I'm using the word 'significance' here in a statistical sense). Nor indeed, do any of them a performance that's significantly better than zero.
The point is you can't conclude from just one test anything meaningful about moving averages. If you get an exceptionally good result, well it's most likely you may just have lucked upon a flukey combination. If you get an exceptionally bad result, well it is most likely that you have just had bad luck.
(This means you should treat small sample tests done by other people dressed up as 'guru advice' with a strong dose of skepticism, since they've almost certainly cherry picked the instrument, moving average, and/or time period to get the result they want).
I trade moving averages, because when I pool data across multiple instruments (about 40 futures markets in my case, covering every sector) over long time periods (up to 40 years in some cases) I find that they work pretty well on average for a wide set of possible moving averages, and in aggregate across this entire dataset the performance is indeed statistically significant.
So it might be the case that SPY is uniformly awful when it comes to using a single moving average of any reasonable length; but it may be that the result is just bad luck and you would need to do a lot more testing to be sure.
GAT