Williams %R (WPR)

Williams %R (WPR) is a momentum oscillator that measures overbought and oversold levels. It moves between 0 and -100 and helps identify potential reversals.

Key Levels

  • 0 to -20: Overbought (Potential for price drop)
  • -80 to -100: Oversold (Potential for price rise)

WPR

=WPR(data, period)

Example Usage

=WPR(A2:F500, 14)

Parameters

Parameter Type Description Status
data
Range
The input range of columns containing the Date, Open, High, Low, Close, and Volume data.
 Required
period
Number
The lookback period (e.g., 14).
 Required

Return Value

A two-column array of dates and their corresponding Williams %R values.

Williams %R Formula Result in Google Sheets