MarketXLS

Minus Directional Indicator

Live
Returns the Minus Directional Indicator, used to determine downtrends.

How calculated

Smoothed Negative directional movement/Average True Range

Example usage

=MinusDirectionalIndicator("MSFT") - Returns MinusDirectionalIndicator value for 14 day period
=MinusDirectionalIndicator("MSFT",30) - Returns MinusDirectionalIndicator value for 30 day period
=MinusDirectionalIndicator("MSFT",30,"9/1/2022") - Returns MinusDirectionalIndicator value for 30 day period with start date 1 September 2022

Notes

When +DI and -DI crossover, it indicates the possibility of a new trend

Assets

Stocks, ETFs, Mutual Funds, Currencies, Cryptocurrencies