Tag Archives: Microsoft Excel

How to Calculate the Williams %R Using Excel

Williams Percent R on EUR/USD

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

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 Acc/Dec Indicator

Awesome Oscillator on Crude Oil

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

Renko Capital Graph

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

This site uses cookies, find out more: