Mass Index

The Mass Index examines the range between the high and low prices to identify trend reversals based on range expansion. It identifies “reversal bulges” where the range expands beyond a certain threshold, often signaling a change in the current trend.

MASS

=MASS(data, emaPeriod, sumPeriod)

Example Usage

=MASS(A2:F500, 9, 25)

Parameters

Parameter Type Description Status
data
Range
The input range of columns containing the Date, Open, High, Low, Close, and Volume data.
 Required
emaPeriod
Number
The period for the Single and Double EMAs. Default is 9.
 Optional
sumPeriod
Number
The period for summing the EMA ratios. Default is 25.
 Optional

Returns

A two-column array of dates and their corresponding Mass Index values.

Mass Index Formula Result in Google Sheets