Swing trading is a way of taking advantage of market retracements to get better entries and more profitable trades. In this article I show a simple method to trade the S&P 500 using a swing trading system. I look at the historic profitability of the strategy and I also use a random entry test to see how […]
Every trader should understand their edge in their trading. If we have an edge, we have the ability to make a profit trading the financial markets. In this article, I look at how to quantify this edge. I analyse four different technical indicators and see how they have performed as a short-term entry signal on the S&P […]
This post continues the series of video articles about how to use Microsoft Excel to backtest trading strategies. In this post I show how to calculate a stop-loss using the ATR and then how to backtest the trading strategy. For the previous video articles see, An Easy Way to use Excel to Backtest a Trading Strategy – Part […]
Continuing on from the previous article about how to use excel to backtest a trading strategy. For further information about backtesting trading strategies in Excel see the next article in this series: Use Excel to Backtest a Trading Strategy using an ATR Stop-loss. Formulas Used Gross Profit =sumif(range,”>0″) Gross Loss =sumif(range,”<0″) Net Profit =sum(range) Number of […]
Ebook Course – How to Backtest a Trading Strategy Using Excel Do you want to improve your trading skills and profitability? I have a new course available via the Amazon Kindle Store. The course will show you how to program your own Excel Backtest Models. Learn more about the course Easy Way to Use Excel […]
This article explains how to calculate Fibonacci extensions in Excel and how forex traders use them. This is a follow up to How to Calculate and use Fibonacci Retracements in Forex Trading. The first section looks at the Fibonacci sequence and how the extension levels are calculated. The second section provides examples of how extension levels […]
In this article I will show the results of my backtest of a EUR/USD trading strategy. What is interesting about this test is that I used a random entry signal. I also used a trailing stop based on the ATR to close the positions. The results showing that a random entry trading strategy can be […]