Tag Archives: Excel

3 Profitable Ichimoku Trading Strategies

Tradinformed Ichimoku Strategies

In this article, I show three strategies using the Ichimoku trading system. In fact, because the system is so versatile, I look at three different Ichimoku trading strategies. I then show you the results of how these trading strategies perform on the EUR/USD forex pair. I carried out these analyses to find out how good […]

Backtesting a EUR/USD Trading Strategy Using an ATR Trailing Stop

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

A Simple 15 Minute Binary Option Candlestick Trading Strategy

This article discusses why candlestick trading is an ideal way to trade binary options. Viewing price action in the form of Japanese candlesticks was popularised by Steve Nison. Candlesticks are now the default view in most trading software and glancing at a chart shows why. The use of colours to distinguish bull and bear bars makes […]

How to Calculate the PSAR Indicator using Excel

How to Calculate the PSAR Indicator Using Excel

This Article and PSAR Calculation has been superseded by a new version. The new article is better and easier to follow. Check out the new article: How to Calculate the PSAR Indicator – New Version The PSAR Indicator is a technical indicator that can be used to trade the financial markets. This article shows how the […]

How to Calculate a Trailing Stop-Loss Using Excel

EURUSD Trailing Stop

This post shows how an Excel backtest model can be used to calculate a trailing stop-loss for a trading strategy. You can now purchase spreadsheets directly from my website: Trading Spreadsheets Trailing Stop-Losses Trailing stops are popular among many different types of traders. The key aspect of them is to try to capture as much […]

Backtesting a SuperTrend Trading Strategy Using Excel

SuperTrend on S&P500

As the name suggests, the SuperTrend technical indicator helps to identify market trends. This article introduces a SuperTrend trading strategy and shows how the strategy can be backtested using Excel. To get a different perspective on the SuperTrend. See this recent article where I show how it can be profitable to reverse the indicator: A […]

How to Calculate the Stochastic Indicator using Excel

How to Calculate the Stochastic Oscillator Using Excel

The Stochastic Oscillator is a hugely popular trading indicator.  The indicator was developed by George Lane. Tracking Momentum The stochastic oscillator is comprised of two lines, %K and %D. The main line is called %K and it tracks price momentum. Price momentum is calculated by comparing the current price with the highest and lowest prices over […]