In this article and video, I show how to calculate the Williams %R using Excel. The Williams %R is a technical indicator developed by Larry Williams. It is an oscillator that is used by traders to identify underlying market strength. Video: How to Calculate Williams %R Williams Percent Range The %R is a fast-moving oscillator that is […]
In this article, I talk about how to calculate the PSAR indicator. I show how the indicator can be used and describe the formulas for calculating it in Excel. I have also recorded a video showing how to calculate the PSAR indicator using Excel. I suggest you check out the video because it contains additional information that is not in […]
Welcome to this detailed guide about how to trade and calculate the Awesome Oscillator and its partner the Acc/Dec Indicator. The Awesome and Acc/Dec Indicator are an exciting indicator pair that could help you get some sensational winning trades. Video – Calculate the Awesome Oscillator and Acceleration/Deceleration Indicator Many people prefer to watch rather than […]
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 Previous Videos in this Series […]
Learn How to Backtest Your Trading Strategies Using Excel Do you want to improve your trading skills and profitability? If so, one of the best ways is to learn how to test your own trading strategies. Tradinformed Backtest Models are built in an Excel spreadsheet. They are a way for anyone to test their strategies […]
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 […]
