calculate technical indicators in Excel

Use These Technical Indicators to Boost Your Trading Results

Technical indicators and chart patterns are a vital part of trading. See you how you can leverage their power by learning how to calculate technical indicators in Excel.

Most traders use technical indicators every day. We use them to identify:

  • Good trading opportunities
  • When volatility is at historically high or low levels
  • Whether volume is supporting or undermining the recent price moves
  • If the price has just broken out from a range
  • Whether the dominant market trend is upwards, downwards or sideways
  • If market conditions are conducive to the start of a strong new trend

21 More Technical Indicators

This eBook is a follow up to my previous book – How to Calculate 21 Technical Indicators Using Excel. In this book, I investigate 21 new indicators and chart patterns.

I show exactly how each one of them is calculated using Excel formulas. I also describe what the indicators do and show many examples of the indicators on charts.

This book is packed full of suggestions and ideas about how you can use these technical indicators to improve your trading. This includes recommendations for how to use the indicators, ideas for trading strategies and examples of when they worked well.

The eBook comes with a free Excel spreadsheet containing all the indicators. Once you have the book, you can get the spreadsheet and start work straight away.

Why Calculate Technical Indicators?

Trading is a tough business; it is hard to make money year after year. The markets are always moving and changing. Traders need to be able to adapt and change when necessary.

The best data available to a trader is how the markets behaved in the past. We can use this historical data to observe and analyse which indicators and strategies worked well, and which ones worked badly.

Excel

Excel is an excellent tool for handling data. Once you program your indicators and trading patterns into Excel you can get quantifiable data.

Using Excel, you can check for seasonal and time of day patterns. You can assess whether your theories about the markets are accurate or not. Excel can also be used to backtest your strategies under different conditions and over different time periods.

What Indicators and Chart Patterns Are Included?

The book shows you how to calculate many different types of indicators and patterns. These include oscillators, trend followers, volatility and Japanese candlesticks. Some of the indicators are:

  • Impulse Indicator
  • Balance of Power
  • TRIX
  • Glitch Index
  • Dynamic RSI
  • Aroon
  • Money Flow Index
  • Harami Patterns
  • Double Top

How do I get the eBook?

calculate technical indicators in Excel

The book is available from the Amazon Kindle Store. Click on the link below to see more.

Click Here to Order Online Now!