Historical Price Data

How to Download Price Data From Yahoo Finance into Excel

In this article and video, I show you how to import Yahoo Finance price data directly into an Excel spreadsheet. Yahoo Finance is the best source of free historical price [...]

2 Comments

Trading Strategies

Profitable ETF Gap Trading Strategies

I tested three different ETFs to answer the question: Can you profitably trade opening gaps? And if so: what markets and factors increase your chances of big winning trades? To [...]

Trading Information

How to Improve And Clean Historical Price Data

Do you trade Stocks, Forex, ETFs, Futures, Indices, Bonds or Commodities? There is one thing that every successful trader needs. Whether starting out, moving to the next level or developing [...]

Candlestick Trading Excel Trading Technical Indicators Uncategorized

How to Calculate Renko in Excel

This article explains why many traders benefit from using Renko charts. It also explains how you calculate them and get a free Renko Excel spreadsheet. Simplicity is the ultimate sophistication [...]

Trading Strategies

A Simple RSI Mean Reversion Strategy

One of the most important lessons that every trader needs to learn is to trade a strategy that fits your personality. It happens all the time that people end up [...]

Excel Trading Uncategorized

Get Live Stock and ETF Data in Excel 365 – Really Fast!

It is really useful to have live price data in Excel. And Microsoft has now made it much easier to import this data into our spreadsheets. Once you have set [...]

How to Hedge

Are you Ready for a Stock Market Crash?

This article looks at how you can prepare yourself for a future stock market crash. I look at what has happened in the past and what you can do now [...]

Trading Books Trading Psychology

Are you struggling to make good trading decisions? These 5 tips might help

Two traders start their day. They both wake up at 7 am ready to face the markets. They check what the markets have done overnight and read the latest articles on [...]

Trading Strategies

A Profitable Nasdaq QQQ Long-Term Strategy

This article describes a Nasdaq QQQ trading strategy. The strategy is easy to manage and it will keep you on the right side of the all the major trends. You [...]

Google Sheets Relative Strength

Monitor a Relative Strength Strategy using Google Sheets

Imagine you are watching a horse race. The runners and riders are at the starting gate. The starter’s flag does down, and the horses are away. Your horse starts well [...]

Trading Strategies

Best Strategy for the Current Markets

The storm clouds burst in the financial markets in early 2018 The skies were blue and clear in 2017. But lightning has hit the financial markets very frequently since then. [...]

Trading Information Trading Psychology

6 Things I Learned from a Market Downturn

Last week I was like most traders around the world. As the markets fell, I was biting my nails, drinking gallons of coffee and waiting anxiously for the next leg [...]

Cryptocurrencies Trading Strategies

How to Trade Bitcoin Like a Pro

2017 saw Bitcoin and the other cryptocurrencies blow up from nowhere to become the world’s most popular financial story. Digital millionaires were being made overnight and everyone wants to trade [...]

Trading Strategies

4 Ways to Trade the Santa Claus Rally

At this time of year investors and traders are looking forward to a bit of festive cheer. December has historically been seen as the best month for stocks. In this [...]

Trading Information Trading Psychology

Improve your Trading by Changing your Thinking

In this article, I look at how a pair of research psychologists have revolutionised how we think. I discuss how their work helps explain why a few traders are very [...]

Trading Strategies

How to Trade a EUR/USD Breakout Strategy

Why a Breakout Strategy is an Essential Part of Your Portfolio Every trader should consider including a breakout strategy in their portfolio. Breakout strategies are simple to understand and trade. [...]

Trade Ideas Trading Strategies

How to Time S&P 500 Entries Using the VIX

I recently received an email from Dr Alexander Elder in which he mentions using the VIX Volatility Index as an entry signal for the S&P 500. I particularly like that [...]

Trading Information

The Best Sources of Free Historical Price Data

One of the questions that I am asked most often is: where can I get free online historical price data? In this article, I look at some the best sources of [...]

How to Backtest Relative Strength Trading Strategies

How to Backtest a Stock Market Trading Strategy

In this article, I show how you can use Excel to test your own stock market trading strategies. The strategy in this article uses the concept of Relative Strength and [...]

Trading Psychology

How this Psychology Experiment Can make You a Better Trader

I recently thought about the similarities between becoming a successful trader and successfully losing weight. Both of them can be very challenging and need a combination of knowledge, discipline and [...]

Trading Information

How to Calculate Lots for Fixed Fractional Position Sizing

All forex traders will admit that they found lot size a confusing issue when they first started trading. It is more complicated than other markets. However, with the explanation below you will soon [...]

MT4 Trading Automation

How to Create an EA for a SuperTrend Trading Strategy v.2

In December 2013 I wrote an article on How to Create an MT4 EA for a SuperTrend trading strategy. Since then the MQL4 programming language has had a few changes. [...]

Trading Information

A Chess Grandmaster and Trading Strategy

What Picture are We Painting? Playing chess is like trying to paint a masterpiece while someone is tugging at your sleeve Gary Kasparov On June 21 1999, Garry Kasparov began [...]

Google Sheets Trading Automation

Import and Store Live Price Data in Google Sheets

This article shows you how you can import live price data into your Google Sheets spreadsheet. Google Sheets spreadsheets are part of the Google Docs office suite. They are currently free [...]

Chart Patterns

Calculate Double Top Chart Patterns Using Excel

Double Top and Double Bottom are classic chart reversal patterns. In this article, I show how you can use Excel to calculate these chart patterns. Being able to program the [...]

Trading Strategies

Invest Profitably Using Relative Strength

In this article I show you can invest profitably in the Nasdaq and S&P500 using a relative strength strategy. I show my I have chosen these markets and explain how [...]

MT4

How to Set Up MT4 for Push Alerts

This article shows how you can use MetaTrader 4 to get push alerts for Android and iPhone. You can set up trade alerts to tell you when you need to check [...]

Trading Strategies

Get Better Trading Results – Improving Your Trade Exits

People spend a lot of time thinking about how and when to enter a trade. However, how you exit a trade is probably even more important. In this article I [...]

Learn to Trade Trading Strategies

How to Calculate and Trade With the TSF

The Time Series Forecast (TSF) indicator uses the Linear Regression to predict the future price. In this article I show how you can calculate the TSF in Excel. I also [...]

Trading Strategies

A Forex SuperTrend Trading Strategy

In this article, I show a trading strategy that uses the SuperTrend indicator to trade the EUR/USD forex pair. I also show you how you can take this basic strategy and [...]

Trading Strategies

A Simple Swing Trading Strategy for the S&P 500

Swing trading is a way of taking advantage of market retracements to get better entries and more profitable trades. In this article I show a simple method to trade the [...]

Trading Strategies

How to Trade the S&P500 Using The Impulse Indicator

In this article I look at whether the Impulse Indicator is a good tool for trading the S&P 500 index. In my analysis I got some surprising results and I [...]

How to Backtest Trading Strategies

Backtesting a Trading Strategy – Example

This article shows you a step-by-step process for backtesting a trading strategy. All traders can benefit from testing their trading strategies. It can highlight strengths and weaknesses and show you [...]

Trading Strategies

Double Your Stock Market Returns Using Seasonality

I like to take a quantitative approach to the markets and I find seasonal factors very interesting. In this article, I investigate whether trading on different days of the month can deliver [...]

Essential Traders Library Trading Books

12 Lessons from Reminiscences of a Stock Operator

Written almost 100 years ago, few trading books have had the influence and lasting popularity as Edwin Lefèvre’s trading classic. This extraordinary book is still relevant today, and this article [...]

Trading Strategies

Another Fibonacci Trading Strategy

Fibonacci retracements are one of the best ways to understand market price action. Whether you trade stocks, commodities or FX, markets have a tendency to retrace. This article shows a way [...]

Excel Trading Trading Information

Calculate Fibonacci Retracements Automatically

Like many traders, I love using Fibonacci Retracements on my charts. They are an excellent way to make sense of what the market is doing. They can be used for [...]

Trading Strategies

How to Calculate Your Trading Edge

Every trader should understand their edge in their trading. If we have an edge, we have the ability to make a profit trading the financial markets. In this article, I look at [...]

Interviews with Traders

How to Use Big Volume to Predict the Price Direction

I have been keen to do an interview with Mike DiBari for a while now. He has a fascinating way of understanding the markets that I have never heard about [...]

Excel Trading Trading Strategies

How to Trade 3 Line Break Charts Profitably

“A more subtle form of point and figure charts” 3 Line Break Charts are a fascinating type of charting system that originated in Japan. They are particularly useful for identifying the [...]

Trade Ideas Trading Strategies

Analyzing a Forex Fibonacci Retracement Strategy

Fibonacci retracements look great on charts but how useful are they for forex traders? I wanted to know whether they are helpful and if they can be used as part of [...]

Trading Strategies

Trade Volume using the Money Flow Index

Volume is often overlooked in technical analysis. However, volume contains fascinating information about the strength of the market feeling. High volume combined with a strong price move shows us that [...]

Algorithmic Trading

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

Trading Strategies

Pyramid Your Trading Profits Using the Gator

In this article, I describe the Gator Oscillator and how you can use it as part of a pyramid entry trading system. I show the results of a Gator trading [...]

Trading Information

How to Calculate the PSAR Indicator – New Version

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

Trading Strategies

What is Aroon and How to Trade it on the S&P 500

Aroon – Dawn’s Early Light The S&P 500 index is a great way to invest, trade and make money out of the stock market. In this article, I show a [...]

Trading Strategies

3 Profitable Ichimoku Trading 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 [...]

Trading Strategies

A Long-Term Stock Index Trading Strategy

In this article I describe a long-term stock index trading strategy. I then show how the strategy performed on the S&P 500 index. The strategy was inspired by the Zig-Zag [...]

Trading Strategies

A Simple, Profitable Heikin-Ashi Trading System

Heikin-Ashi candlesticks are a slightly different way of viewing the markets. In this article, I will show how they are used as part of a profitable trading strategy. Heikin-Ashi Candlesticks [...]

MT4 Trading Automation

How to use MT4 to get Trading Alerts via Email

MetaTrader 4 (MT4) is a hugely popular platform for forex traders around the world. In this article, I will show how the MT4 terminal can be used to create sound [...]

Excel Trading Trading Strategies

EUR/USD Backtested – Technical Indicators and Random Entry

Random Entry This article is the second in a series investigating how effective random entry can be in a trading strategy. In this article, I am looking at combining a random [...]

Excel Trading Trading Strategies

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 random entry signal. [...]

Essential Traders Library Trading Information

5 Trend Following Indicators for Forex Traders

In this article, I discuss five technical indicators that are used by trend following forex traders. In 2004, Michael Covel published the book Trend Following. The book revealed a world of famous and less [...]

Essential Traders Library

8 Trading Lessons From Market Wizards

In this article I discuss the book, Market Wizards, by Jack D. Schwager. The book is one of the best books on trading ever written and a source of inspiration for many [...]

Trading Psychology

Trading and Rock, Paper, Scissors

What do trading the financial markets have to do with the game Rock, Paper, Scissors? In this article I look at why researchers organised a competition at a university in [...]

Economic Growth

European Economic Forecasts and Trading the Euro

The European Commission (EC) published economic forecasts for European Union countries on May 5th 2014. The forecasts are produced by the Directorate-General for Economic and Financial Affairs (ECFIN). Forex trading is [...]

Binary Options Learn to Trade

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

Excel Trading Trading Information

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

Binary Options Trading Information

Why Trade Binary Options?

Binary Options are a growth part of the trading business.  In this article I look at what I think is interesting about binary options and why new traders should consider [...]

Excel Trading

How to Calculate a Trailing Stop-Loss Using Excel

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

Economic Growth

The Best Economic Indicators for Measuring Economic Trends

Many traders and investors carefully watch the release of economic indicators such as PMI data to get a glimpse of how the economy is performing. A release that is perceived [...]

MT4

Optimizing a SuperTrend Trading Strategy Expert Advisor

This article shows you how to optimize a MT4 Expert Advisor (EA) and turn a good trading strategy into a great one. The article follows on directly from How to Create [...]

MT4

Create an Expert Advisor for a SuperTrend Trading Strategy

In this article, I will show you how to build an Expert Advisor for a SuperTrend Trading Strategy. MT4 is a massively popular trading platform that is offered by a [...]

Trading Strategies

Backtesting a SuperTrend Trading Strategy Using Excel

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

Learn to Trade

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

Trading Information

How to Calculate the Stochastic Indicator 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 [...]

Essential Traders Library Trading Book Reviews

Essential Trader’s Library: Come into my Trading Room

“There is only one rational reason to trade – to make money” – Dr. Alexander Elder First on my list of the Essential Trader’s Library is Come Into My Trading Room: [...]

Trading Information

How to Calculate the Elder Ray Technical Indicator using Excel

The Elder Ray technical indicator was created by Dr. Alexander Elder.  The indicator is useful for timing trade entries. What is the Elder Ray? The purpose of the indicator is [...]

Technical Indicators

How to Calculate Bollinger Bands Using Excel – Video

This article and video shows you how to calculate Bollinger Bands using Excel. Traders use these bands for their remarkable predictive power as well as their simplicity and ease of [...]

Trading Information

How to Calculate the RSI Indicator using Excel – Video

This article shows how to calculate the RSI indicator developed by J. Welles Wilder. It includes the Excel formulas and a video showing the steps. You can skip straight to [...]

Trading Information

How to Calculate the SuperTrend Indicator using Excel

This article shows you how to calculate the SuperTrend Indicator. Watch the video to see me demonstrate the calculations. The article also explains why the indicator works, how to identify [...]

Ebook Trading Information

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