# Category Archives: Technical Indicators

## How to Calculate Renko in Excel

This article explains why many traders benefit from using Renko charts. It also explains how to calculate Renko and get a free Renko Excel spreadsheet. Simplicity is the ultimate sophistication Leonardo Da Vinci Efficient Financial Markets Modern financial markets are highly efficent and they move fast. Trade times are often measured in microseconds. We switch […]

## How to Calculate the Williams %R Using Excel

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

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

## 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 to encourage patient trading.  Using the indicator requires identifying the main trend and then waiting for the price to pull back enough to obtain a […]