It is one of the simple momentum indicator that uses price data only to generate buy and sell signal

How calculated

(Latest price/price given days ago-1)*100

Example usage

=Momentum("MSFT") - Returns Momentum value for 10 day period
=Momentum("MSFT",20) - Returns Momentum value for 20 day period
=Momentum("MSFT",20,"9/1/2021") - Returns Momentum value for 20 day period with start date 1 September 2021


Positive momentum can indicate a potential bullish trend while negative momentum can indicate a bearish trend


Stocks ETFs Mutual Funds Currencies Cryptocurrencies

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to to avail the extention

From all of us at MarketXLS, thank you!