Tag Archives: Microsoft Excel

How to Calculate the Williams %R Using Excel

Williams Percent R on EUR/USD

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. In this article I show how to calculate the %R using Excel. Williams Percent Range The %R is a fast moving oscillator similar to the stochastic oscillator. It calculates how the current price compares […]

How to Calculate the PSAR Indicator – New Version

Tradinformed - How to Calculate PSAR in Excel

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

How to Trade and Calculate the Awesome Oscillator and Acceleration/Deceleration Indicator

About the Indicators The Awesome and Acc/Dec Indicator are an interesting pair that are normally used together. Awesome Oscillator Despite the cool name, the Awesome Oscillator is a very simple indicator.  As I set out in the video below, it is actually just a moving average crossover.  It has fixed settings of 5 and 34 […]

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 Excel. They are a way for anyone to test their strategies with different […]

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