# Tag Archives: Microsoft Excel

## How to Calculate the Williams %R Using Excel

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 […]

## How to Calculate the PSAR Indicator – New Version

Table of Contents The PSAR The Next Step: Get More Winning Trades Video How to Calculate the PSAR Calculate More Indicators 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 […]

## How to Trade and Calculate the Awesome Oscillator and Acc/Dec Indicator

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 […]

## Optimise Trading Strategies using Excel and Tips for Good Practice

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 […]

## How to Backtest a MACD Trading Strategy using Excel

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 […]

## Use Excel to Backtest a Trading Strategy using an ATR Stop-loss

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 […]

## An Easy Way to use Excel to Backtest a Trading Strategy – Part 2

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 […]