Excel Technical Indicators Library

26 Technical Analysis Indicators Pre-Built in Excel

Excel Technical Indicator Screenshot

Our Excel Technical Indicators Library contains 26 technical analysis indicators pre-built using formulas in Excel spreadsheet format.

These Excel files are tremendously useful for constructing trading, investing, technical analysis or statistical models in Excel. The pre-built technical indicator formulas save you countless hours of research and calculation time.  The Excel Technical Indicators can be combined to build sophisticated trading models that perfectly suit your particular investment criteria.

All indicators are pre-built in Excel with formulas left unlocked to enable easy adjustment and modification. The indicators cover 300 periods of data, and can be expanded as desired. Each indicator is guaranteed to have 100% correct formulas.

All you need is Microsoft Excel and WinZip or a similar file extractor to unzip the files.

 

Key Benefits

  • Eliminate the time and expense of constructing your own formulas.
  • Easily combine indicators to build your own custom trading or analysis systems.
  • Save money by eliminating recurring software costs.
  • Learn how each indicator works (a key for debugging your models and institutional audits).
  • Modify the formulas to suit your own analysis needs.
  • Guaranteed 100% correct!

Excel Technical Indicators Included

Trend Indicators

Excel Technical Indicators Exponential Moving Average

Exponential Moving Average

A responsive moving average that closely tracks price movements. The EZ-File allows you to easily adjust the moving average length by changing a single variable cell.

Excel Technical Indicators Regression Line

Regression

A linear approximation of price movements over time that is excellent for catching tops and bottoms.

Excel Technical Indicators Triangular Moving Average (TMA)

Triangular Moving Average (TMA)

A moving average in which the middle values are weighted more than the early and late values to enhance smoothing.

Excel Technical Indicators Sine-Weighted Moving Average (SWMA)

Sine-Weighted Moving Average (SWMA)

A moving average using a sine factor to take into account both time and price movements. Very good at catching tops and bottoms, while filtering out unnecessary noise.

Excel Technical Indicators Average Directional Movement Index (ADX)

Average Directional Movement Index (ADX)

Measures the directionality of price movement over time to identify trending and non-trending periods.

Excel Technical Indicators Vertical Horizontal Filter (VHF)

Vertical-Horizontal Filter (VHF)

Measures the directionality of price movement over time by capturing the relative location of price compared to its range in a set lookback period. Simpler and more sensitive than ADX.

Oscillators

Excel Technical Indicators Stochastic Oscillator

Stochastic Oscillator

A highly sensitive indicator used to catch tops and bottoms early.

Excel Technical Indicators Williams %R

Williams %R

Measures the relative location of closing price in relation to the high-low range over a set time period.

Excel Technical Indicators Commodity Channel Index (CCI)

Commodity Channel Index (CCI)

An indicator which measures price excursions from an average of the 11 previous price periods. Good for catching tops and bottoms.

Excel Technical Indicators Percentage Price Oscillator (PPO)


Percentage Price Oscillator (PPO)

Similar to the MACD indicator, but normalized on a percentage basis for easy comparison across different securities.

Volatility Indicators

Excel Technical Indicator Standard Deviation

Standard Deviation

The fundamental indicator used to measure volatility over time.

Excel Technical Indicators Bollinger Bands

Bollinger Bands

Used to visually judge the relationship between price and volatility changes.

Excel Technical Indicators Average True Range (ATR)

Average True Range (ATR)

Dynamically measures the typical range between price high/low/close over a set period.

Momentum & Strength Indicators

Excel Technical Indicators Moving Average Convergence-Divergence (MACD)

Moving Average Convergence-Divergence (MACD)

An indicator that shows changes in the relative movements of shorter and longer moving averages. Good for identifying changes in momentum.

Excel Technical Indicators Relative Strength Index (RSI)

Relative Strength Index (RSI)

Measures price relative to past prices. This indicator is front-weighted for sensitivity, but filters out noise well.

Excel Technical Indicators Chaikin Oscillator (CHKO)

Chaikin Oscillator

This indicator combines both price and volume to measure momentum from a security’s accumulation and distribution in the market.

Excel Technical Indicators Momentum Oscillator

Momentum Oscillator

A simple indicator which compares later prices to earlier prices to gauge strength and momentum.

Excel Technical Indicators Rate of Change (ROC)

Rate of Change (ROC)

A simple indicator which compares later prices to earlier prices to gauge the speed and direction of price movements.

Volume Indicators

Excel Technical Indicators On Balance Volume (OBV)

On Balance Volume (OBV)

This indicator adds and subtracts volume to a running total, depending on whether price moves up or down. A good confirming indicator.

Excel Technical Indicators Money Flow Index (MFI)

Money Flow Index (MFI)

Similar to OBV, but enhanced by the addition of momentum characteristics based on relative location of price. Can be used as both a primary and confirming indicator.

Excel Technical Indicators Accumulation Distribution

Accumulation/Distribution Line (AD)

Measures the amount of buying and selling pressure by weighting it with the relative location of price.

Excel Technical Indicators Chaikin Money Flow CMF

Chaikin Money Flow (CMF)

This indicator enhances the usefulness of the AD by dividing a running total by a running total of volume.

Excel Technical Indicators Percentage Volume Oscillator (PVO)

Percentage Volume Oscillator (PVO)

This indicator is excellent for judging changing levels of interest and momentum in a security’s movement.

Intermarket & Breadth Indicators

Excel Technical Indicators Percentage Price Relative (PPR)

Percentage Price Relative (PPR)

This indicator compares the relative price movements of two different securities or indices to help allocate capital better and give insight into future price moves.

Excel Technical Indicators Intermarket Spread

Intermarket Spread

Measures the gap between the prices of two different securities or indices to identify arbitrage or directional investment opportunities.

Excel Technical Indicators Dual-Market Percentage Price Oscillator (DMPPO)

Dual-Market Percentage Price Oscillator (DM-PPO)

A Percentage Price Oscillator applied to the moving averages of two different securities or indices to identify tops and bottoms in directional momentum and strength.

GET YOUR 5 FREE TECHNICAL INDICATORS

Enter your email address and we will send them instantly!

Success! Your indicators are on their way!

Free 10 Steps to Create a Trading System in Excel

FREE GETTING STARTED GUIDE

Enter your email address and we will send it to you instantly!

Success! Your guide is on its way!

FREE Spread Trading Contract Calculator in Excel

GET YOUR FREE SPREAD TRADING CALCULATOR

Enter your email address and we will send it to you instantly!

Success! Your calculators are on their way!

FREE Yahoo Finance Stock Split Adjuster

GET YOUR FREE YAHOO FINANCE STOCK SPLIT ADJUSTER FOR EXCEL

Enter your email address and we will send it to you instantly!

Success! Your stock split adjuster is on its way!