Finacial-Edu: Your Financial Knowledge Source
Accounting & Finance
Asset Management
Calculators & Converters
Consulting & Strategy
Industry Research
- more
Real Estate
Trading & Investing
- more
Guides & Courses
Mathematics & Statistics
- more
Investing & Trading
Futures & Options
Online Services
Quotes & Data
Real Estate & REITS
- more
Security & Privacy
Access Control
Anti-Spam & Anti-Spy Tools
Anti-Virus Tools
Covert Surveillance
Encryption Tools
- more
Business & Finance
Home & Education
Investing & Trading Software
PDA & Mobile
- more
Tools & Models
Forms & Templates
Graphing & Charting Tools
Risk & Portfolio Models
Trading Models
- more

EZ-Files Technical Indicator Library: Technical Indicators for Excel

Price: $89.95
Buy Now

See a sample file



The EZ-Files Technical Indicator Library contains 26 technical analysis indicators pre-built in Excel Spreadsheet Format. These Excel files are tremendously useful for constructing securities trading, technical analysis, or statistical models in Excel. EZ-Files save you countless hours of research and calculation time, and each indicator is guaranteed to have 100% correct formulas.

EZ-Files can be combined to build sophisticated trading models that perfectly suit your particular investment criteria. All indicators are pre-built in Excel format with "open source" formulas left unlocked to enable easy adjustment and modification. The indicators cover 300 periods of data, and can be expanded as desired.


  • Eliminates 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.
  • Guaranteed 100% correct!
  • Learn how each indicator works (a key for institutional audits and transparency).
  • Modify the formulas to suit your own analysis needs.

    Technical Requirements

  • Microsoft Excel
  • WinZip software to unzip the files

    See a sample file
    Trend Indicators
    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.

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

    see image
    Triangular Moving Average (TMA)
    A moving average in which the middle values are weighted more than the early and late values to enhance smoothing.

    see image
    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.

    see image
    Average Directional Movement Index (ADX)
    Measures the directionality of price movement over time to identify trending and non-trending periods.

    see image
    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 above.

    see image
    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.

    see image
    Percentage Price Oscillator (PPO)
    Similar to the MACD indicator, but normalized on a percentage basis for easy comparison across different securities.

    see image
    Stochastic Oscillator
    A highly sensitive indicator used to catch tops and bottoms early.

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

    see image
    Volatility Indicators
    Standard Deviation
    The fundamental indicator used to measure volatility over time.

    see image
    Bollinger Bands
    Used to visually judge the relationship between price and volatility changes.

    see image
    Average True Range (ATR)
    Dynamically measures the typical range between price high/low/close over a set period.

    see image
    Momentum and Strength Indicators
    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.

    see image
    Relative Strength Index (RSI)
    Measures price relative to past prices. The indicator is front-weighted for sensitivity, but filters out noise well.

    see image
    Chaikin Oscillator
    This indicator combines both price and volume to measure momentum from a security's accumulation and distribution in the market.

    see image
    Momentum Oscillator
    A simple indicator which compares later prices to earlier prices to gauge strength and momentum.

    see image
    Rate of Change (ROC)
    A simple indicator which compares later prices to earlier prices to gauge the speed and direction of price movements.

    see image
    Volume Indicators
    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.

    see image
    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.

    see image
    Accumulation/Distribution Line (AD)
    Measures the amount of buying and selling pressure by weighting it with the relative location of price.

    see image
    Chaikin Money Flow (CMF)
    This indicator enhances the usefulness of the AD by dividing a running total by a running total of volume.

    see image
    Percentage Volume Oscillator (PVO)
    This indicator is excellent for judging changing levels of interest and momentum in a security's movement.

    see image
    Intermarket and Breadth Indicators
    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.

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

    see image
    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.

    see image


    Build an Automated Trading System in Microsoft Excel
          -learn more  
    Home | Guides + Courses | Tools + Models |
    Copyright 2000-2013 All rights reserved.