Technical Analysis in Excel

Technical Analysis in Excel
  • Perform Technical Analysis in Excel with 120+ Technical Indicators
  • Run groups of indicators on your data
  • Customize everything including time period, Moving Average types etc
  • Option to runs with default inputs without prompting
  • Discover patterns in your data and analyze its impact
  • Annotate patterns on Candle Stick Charts with a few clicks
  • Scan for patterns with our Pattern-Scan Report – for actionable insights with technical analysis in Excel sheets


See Next Feature

List of Indicators : MarketXLS Technical Analysis in Excel
Overlap StudiesVolatility IndicatorsMomentum IndicatorsCycle IndicatorsVolume IndicatorsPattern RecognitionStatistic FunctionsPrice Transform
Bollinger Bands
Double Exponential Moving Average
Exponential Moving Average
Hilbert Transform – Instantaneous Trendline
Kaufman Adaptive Moving Average
Moving average
MESA Adaptive Moving Average
Moving average with variable period
MidPoint over period
Midpoint Price over period
Parabolic SAR
Parabolic SAR – Extended
Simple Moving Average
Triple Exponential Moving Average T3
Triple Exponential Moving Average
Triangular Moving Average
Weighted Moving Average
Average True Range
Normalized Average True Range
True Range
Average Directional Movement Index
Average Directional Movement Index Rating
Absolute Price Oscillator
Aroon Oscillator
Balance Of Power
Commodity Channel Index
Chande Momentum Oscillator
Directional Movement Index
Moving Average Convergence/Divergence
MACD with controllable MA type
Moving Average Convergence/Divergence Fix 12/26
Money Flow Index
Minus Directional Indicator
Minus Directional Movement
Plus Directional Indicator
Plus Directional Movement
Percentage Price Oscillator
Rate of change : ((price/prevPrice)-1)*100
Rate of change Percentage: (price-prevPrice)/prevPrice)
Rate of change ratio: (price/prevPrice)
Relative Strength Index
Stochastic Fast
Stochastic Relative Strength Index
1-day Rate-Of-Change (ROC) of a Triple Smooth EMA
Ultimate Oscillator
Williams’ %R
Hilbert Transform – Dominant Cycle Period
Hilbert Transform – Dominant Cycle Phase
Hilbert Transform – Phasor Components
Hilbert Transform – SineWave
Hilbert Transform – Trend vs Cycle Mode
Chaikin A/D Line
Chaikin A/D Oscillator
On Balance Volume

Two Crows
Three Black Crows
Three Inside Up/Down
Three-Line Strike
Three Outside Up/Down
Three Stars In The South
Three Advancing White Soldiers
Abandoned Baby
Advance Block
Closing Marubozu
Concealing Baby Swallow
Dark Cloud Cover
Doji Star
Dragonfly Doji
Engulfing Pattern
Evening Doji Star
Evening Star
Up/Down-gap side-by-side white lines
Gravestone Doji
Hanging Man
Harami Pattern
Harami Cross Pattern
High-Wave Candle
Hikkake Pattern
Modified Hikkake Pattern
Homing Pigeon
In-Neck Pattern
Inverted Hammer
Ladder Bottom
Long Legged Doji
Long Line Candle
Matching Low
Mat Hold
Morning Doji Star
Morning Star
On-Neck Pattern
Piercing Pattern
Rickshaw Man
Rising/Falling Three Methods
and many more…
Pearson’s Correlation Coefficient
Linear Regression
Linear Regression Angle
Linear Regression Intercept
Linear Regression Slope
Standard Deviation
Time Series Forecast

Average Price
Median Price
Typical Price
Weighted Close Price

MarketXLS Pattern Scan Report
Generated in couple of clicks this report scans historical data of stocks for candlestick patterns their impact on closing prices. Following is a sample of a scan of 10 year prices of a popular stock.

technical analysis in Excel

MarketXLS Technical Screeners

Every day on our servers we run the many useful technical indicators in all US stocks and store the results in our databases. So, essentially we screen the whole market and collect all filtered stocks on basis of various technical indicators like RSI, MFI etc. All daily filtered stock lists can be obtained using MarketXLS. Following video shows the RSI Screener to get overbought or oversold stocks:

See Next Feature

Supercharge your stock research with MarketXLS. Fast and Easy Dupont analysis in Excel, portfolio analysis and much more with MarketXLS

Questions? Email

See our introductory pricing