Plus Directional Indicator (+DI)

Returns the Plus Directional Indicator, which measures the strength of upward price movement. Part of the Directional Movement Index (DMI) system developed by J. Welles Wilder.

DMI System Overview

Indicator Measures
+DI Strength of upward movement
-DI Strength of downward movement
ADX Overall trend strength (derived from +DI and -DI)

Trading Signals

  • +DI > -DI: Bullish trend dominates
  • +DI < -DI: Bearish trend dominates
  • +DI crossover above -DI: Bullish signal
  • Rising +DI: Strengthening uptrend

Parameters

Parameter Description Default
Symbol Stock ticker symbol Required
Days Number of periods 14
StartDate Calculate as of this date Today

Examples

=PlusDirectionalIndicator("AAPL")
14-day +DI for Apple
=PlusDirectionalIndicator("AAPL", "14")
Explicitly 14-day +DI
=PlusDirectionalIndicator("MSFT", "20")
20-day +DI for Microsoft
=PlusDirectionalIndicator("SPY", "14")
14-day +DI for SPY
=PlusDirectionalIndicator("AAPL", "14", DATE(2024,1,15))
Historical +DI
=PlusDirectionalIndicator(A1)
Symbol from cell reference

When to Use

  • Identify bullish trend strength
  • Compare with -DI for directional bias
  • Generate crossover trading signals
  • DMI/ADX trading system implementation
  • Confirm uptrend continuation

When NOT to Use

Scenario Use Instead
Need bearish direction MinusDirectionalIndicator()
Need overall trend strength TechnicalIndicator() with ADX
Need overbought/oversold RelativeStrengthIndex()
Need volatility AverageTrueRange()

Common Issues & FAQ

Q: Why is +DI returning "NA"? A: Check that:

  • The symbol is valid and actively traded
  • There is sufficient historical data for the period
  • OHLC data is available for the calculation

Q: How do I use +DI with -DI? A: Compare both values:

  • When +DI > -DI: Bullish bias
  • When -DI > +DI: Bearish bias
  • Crossovers can signal trend changes

Q: What is a typical +DI range? A: +DI typically ranges from 0 to 50+, with higher values indicating stronger upward pressure.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Plus Directional Indicator (+DI) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions