Exploring Fibonacci Trading Strategies

In this article

Exploring Fibonacci Trading Strategies

Fibonacci trading uses ratios from the Fibonacci sequence (mainly 23.6%, 38.2%, 50%, 61.8%, and 78.6%) to mark price levels where a trend may pause or reverse. Traders measure a prior price move, apply the ratios to find likely pullback levels, and use those levels to plan entries, stop losses, and targets. The levels are a technical analysis guide, not a prediction, and work best when combined with other signals and strict risk management.

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
Exploring Fibonacci Trading Strategies - technical indicators and chart patterns in Excel with MarketXLS

This article covers Fibonacci retracements, harmonic patterns, support and resistance, and risk management.

Understanding Fibonacci Trading

Fibonacci trading strategies are based on levels of support and resistance. These levels are derived from Fibonacci numbers, as they can be used to determine the trend of a period.

Fibonacci trading strategies are mainly used in Forex and stock markets to identify potential patterns in the financial markets. It can help you identify potential reversals and potential entry/exit points from a short or long position.

Fibonacci Retracement

Fibonacci retracement is one of the most popular Fibonacci trading strategies used to identify levels of support and resistance. The levels are calculated by looking at the length of a previous price trend.

For example, if a currency pair rises from 1.3050 to 1.3150 (a 100-pip move), the 61.8% retracement level is 1.3150 minus 61.8 pips, or about 1.3088. A trader watching for a pullback would look for the price to find support near 1.3088 (or the 38.2% level near 1.3112) before the uptrend continues.

Harmonic Patterns

Harmonic patterns are created by drawing three or more Fibonacci retracement levels. These patterns can be used to identify potential turning points in the market.

For example, a harmonic pattern may be used to identify a possible reversal in the price of a currency pair. The pattern can be used to determine potential entry/exit points and potential price targets.

Support and Resistance

Support and resistance levels can be used to identify potential turning points in the market. The levels are derived from Fibonacci retracement levels and can be used to project where the price might go in the future.

For example, if a currency pair has bounced off the same Fibonacci retracement level more than once, traders treat that level as support, and a clear break below it as a sign the trend may be weakening.

Risk Management

Risk management is an important aspect of trading and is essential when using Fibonacci trading strategies. Knowing when to enter and exit a trade can help you stay disciplined and maximize your profits.

A good risk management strategy includes setting stop loss strategies and price targets. This can help you limit losses and maximize profits.

Conclusion

Fibonacci levels help you mark possible support, resistance, and reversal zones. They are most useful when combined with other technical indicators and price action, and no level guarantees a reversal.

When using Fibonacci trading strategies, set a stop loss beyond the level you are trading and a price target before you enter. This article is educational, not investment advice.

MarketXLS is an add-in for Microsoft Excel and Google Sheets that adds stock quotes, historical prices (for example =QM_GetHistory("AAPL")), and technical indicator functions such as =RSI and =SimpleMovingAverage, which you can use to calculate Fibonacci levels from recent highs and lows.

Relevant blogs that you can read to learn more about the topic

Trading Using The Fibonacci Retracement Strategy

About the authors
Ankur

About Ankur

CEO & Founder, MarketXLS

Ankur is the CEO and founder of MarketXLS. He works with Anagh and Robin on the MarketXLS blog, creating articles together about market data and spreadsheet workflows.

Written collaboratively by Ankur, Anagh and Robin.

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