Categories

# How to calculate fractals forex in excel?

Fractals are geometric patterns that repeat themselves at different scales. In forex trading, fractals are used to identify potential areas of support and resistance. These areas can be used as entry and exit points for trades. Calculating fractals can be done in excel using a few simple formulas. This article will explain how to calculate fractals forex in excel.

### Step 1: Obtain Price Data

The first step in calculating fractals in excel is to obtain price data. This can be done by accessing a forex chart on a trading platform or by downloading historical data from a forex data provider. The data should include the high, low, and close prices for a given period, such as a week or a month.

### Step 2: Calculate the Highest High and Lowest Low

The next step is to calculate the highest high and lowest low for the period. This can be done using the MAX and MIN functions in excel. The MAX function will return the highest value in a range of cells, while the MIN function will return the lowest value.

### Step 3: Determine if a Fractal Has Formed

A fractal is formed when the price has made a higher high or a lower low for two consecutive periods. To determine if a fractal has formed, we need to compare the current high and low prices to the previous high and low prices.

### =AND(B3>B1,B3>B5)

Where B1 is the previous high, B3 is the current high, and B5 is the high two periods ago. The AND function will return TRUE if both conditions are met.