Trading Using the Fibonacci Retracement Strategy

In this article

What Is Fibonacci Retracement?

Fibonacci retracement is a technical analysis method that marks likely pullback levels at 23.6%, 38.2%, 50%, and 61.8% of a prior price move. In an uptrend from a swing low L to a swing high H, each level is H - ratio x (H - L); for example, a move from $100 to $150 has a 38.2% retracement at $130.90 and a 61.8% retracement at $119.10. Traders watch these levels for a pause or reversal, usually alongside other indicators, because the levels alone are not reliable. This article is educational, not investment advice.

See it in actionMarketXLS video

Try it in your own spreadsheet

Get the free MarketXLS sample workbook (.xlsx).

No account needed. MarketXLS live data requires a paid plan. Preview workbook

Explore more videos
Trading Using The Fibonacci Retracement Strategy - technical indicators and chart patterns in Excel with MarketXLS

Where the ratios come from

Leonardo of Pisa (Leonardo Pisano) was an Italian mathematician. He was nicknamed Fibonacci and he found an interesting pattern in a certain set of numbers. That pattern or sequence is known as the Fibonacci sequence. In the Fibonacci sequence of numbers, after 0 and 1, each number is the sum of the two prior numbers. Each number is around 1.618 times greater than the previous number. This value of 1.618 is called phi or the golden ratio. The ratio appears in many natural patterns. The inverse of this number 0.618 is also used quite frequently in trading.
The numbers used in Fibonacci retracement are not the numbers from the sequence but they are derived from the mathematical relationship between the numbers in the sequence.

The basis of the “golden” Fibonacci ratio of 61.8% comes from dividing a number in the Fibonacci series by the number that follows it. For example – 89/144 = 0.618.

The 38.2 % ratio is obtained by dividing a number in the Fibonacci series by the number which is 2 places to the right. For example – 89/233 = 0.3819

The 23.6% ratio is derived from dividing a number in the Fibonacci series by the number three places to the right. For example: 89/377 = 0.2360.

The Fibonacci Retracement Strategy –

A retracement is a technical term used to identify a minor pullback or change in the direction of a financial instrument, such as a stock or index. Retracements are temporary in nature and do not indicate a shift in the larger trend. Fibonacci retracement means identifying levels using the Fibonacci ratios to determine where to take a position for trading.
The levels are placed using the Fibonacci retracement tool by dragging it across the lowest point of a price on the chart up to the highest point of the price if it’s an uptrend.
If it’s a downtrend, we drag the tool from the highest point to the lowest point of the chart to map the levels.
Fibonacci retracement levels are depicted by taking high and low points on a chart and marking the key Fibonacci ratios of 23.6%, 38.2%, and 61.8% horizontally to produce a grid. These horizontal lines are used to identify possible price reversal points. It is often used as a part of a trend trading strategy.
For example – if a certain stock is moving in a downtrend and hits the Fibonacci 0 level, traders assume that it will rally a bit up to the next Fibonacci level and hence they take a long position until the 0.382 level or the 0.5 level. When the stock reaches the desired level, traders either book profit or take a short position to earn along with the trend.

Here in the above image, you can see that the stock fell from point A(1 level) to point B
(0 levels). At point B a trader usually goes long till the price reaches the next Fibonacci level at 0.382 and then the price eventually settles down and continues to go along the trend.

There can also be a trend reversal if the price breaks the 0.5 mark. Traders love the 0.618 mark as it can be a strong indicator of trend reversal and hence they take suitable positions once the price nears the 61.8% mark.

Bottom Line –

Fibonacci retracement is about riding the trend. A related tool, Fibonacci extension, projects price targets beyond the prior high or low.
Traders use the Fibonacci retracement strategy along with other technical indicators to make a decision. Fibonacci retracement on its own is not a reliable indicator of price levels, so traders confirm it with other signals.
The last thing to note is that the time period can be very helpful while using this strategy, using it on a daily chart might not be as useful as using it on a weekly chart.

Track Fibonacci Retracement levels in your excel sheet with MarketXLS!

MarketXLS has a Fibonacci retracement template for tracking the retracement levels of a stock in Excel. See MarketXLS templates.

MarketXLS brings stock, options, ETF, and mutual fund data into Excel, where you can analyze it with these templates. Book a demo to see the features.

Important Disclaimer

The information provided in this article is for educational and informational purposes only and should not be construed as investment advice, a recommendation, or an offer to buy or sell any securities. MarketXLS is a financial data platform and is not a registered investment advisor, broker-dealer, or financial planner. Always conduct your own research and consult with a qualified financial professional before making any investment decisions. Past performance is not indicative of future results. Trading and investing involve substantial risk of loss.

Explore MarketXLS in Excel
Download a free sample workbook (.xlsx). MarketXLS is a paid subscription.

See MarketXLS in action

Bring this workflow into Excel.

Book a demo with our team to see how MarketXLS supports your market research.

Ankur
AnkurFounder & CEO, MarketXLS
Book a demo