Tag Archives: Trading Strategies

How to Calculate and use the MACD Indicator in Microsoft Excel


This video article describes how you can calculate the MACD Indicator in Microsoft Excel.  I believe the MACD is a particularly useful indicator on the weekly chart and can help to create a long-term trading strategy. Formulas Used: EMA Factor =2/(periods+1) EMA =((current + previous average)*EMA Factor) + previous average Trade Entry =IF(L39>0,IF(L38<0,”trade”,””),””)

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

3 Profitable Ichimoku Trading Strategies

Tradinformed Ichimoku Strategies

In this article, I show three Ichimoku trading strategies. I then show you the results of how these trading strategies perform on the EUR/USD forex pair. You can also watch a video of me demonstrating the strategies. I carried out these analyses to find out how good the Ichimoku system is at identifying trends. The […]

Insights into the World of Algorithmic Trading

Trading into the future Algorithmic trading is more popular than ever. No longer the preserve of Wall Street and hedge funds, it is moving into the mainstream. Driven by increasing processing power and worldwide connectivity, algorithmic trading systems are more widely available than ever. I am fascinated by the idea of using technology and quantitative approaches […]

This site uses cookies, find out more: