I was playing with Excel over the weekend and thought I'd test a simple strategy on a selected market over a long period of time. The strategy I chose is a very simple one: one of the oldest and most basic trend following strategies:
Go long at the market if the price closes above 50-SMA + ATR(10)
Go short at the market if the price closes below 50-SMA - ATR(10)
Trail the stop on the 50-SMA.
I then coded it in Excel using EOD data of SMH (semi-conductors ETF) and results are very surprising. With a starting capital of $10,000 and 2% risk per trade, it has returned a cumulative total of 85% over 5.5 years, with the ending capital being $18,500 (unless I have made a silly mistake somewhere). In the intervening period, this market has seen bull, bear and sideways phases.
See the spreadsheet attached. You can enter the following values:
- starting capital
- % risked per trade
- penetration factor (1 means the buy trigger is 50-SMA + ATR(10), 2 means 50-SMA + 2ATR(10) and so on).
Not earth shattering results but not bad either. Imagine what this strategy could return if diversified across a range of non-correlated futures markets. Also remember that this is an extremely simple version. For example, it doesn't add positions when a trade works. You can also do a lot of work on portfolio allocation.
This just proves (to me anyway) that one can still get decent return by following simple (and apparently obsolete) strategies, if EOD trading is your game. One can easily programme this on Tradestation and leave it on autopilot.
Go long at the market if the price closes above 50-SMA + ATR(10)
Go short at the market if the price closes below 50-SMA - ATR(10)
Trail the stop on the 50-SMA.
I then coded it in Excel using EOD data of SMH (semi-conductors ETF) and results are very surprising. With a starting capital of $10,000 and 2% risk per trade, it has returned a cumulative total of 85% over 5.5 years, with the ending capital being $18,500 (unless I have made a silly mistake somewhere). In the intervening period, this market has seen bull, bear and sideways phases.
See the spreadsheet attached. You can enter the following values:
- starting capital
- % risked per trade
- penetration factor (1 means the buy trigger is 50-SMA + ATR(10), 2 means 50-SMA + 2ATR(10) and so on).
Not earth shattering results but not bad either. Imagine what this strategy could return if diversified across a range of non-correlated futures markets. Also remember that this is an extremely simple version. For example, it doesn't add positions when a trade works. You can also do a lot of work on portfolio allocation.
This just proves (to me anyway) that one can still get decent return by following simple (and apparently obsolete) strategies, if EOD trading is your game. One can easily programme this on Tradestation and leave it on autopilot.
Attachments
Last edited: