Williams Percent Range

The Williams %R, also known as the Williams Percent Range, is a momentum indicator developed by Larry Williams. It measures overbought and oversold levels by showing where the current closing price is in relation to the high-low range over a specific period. The indicator oscillates between 0 and -100, with readings closer to 0 indicating overbought conditions and readings closer to -100 indicating oversold conditions.

Function Syntax

=WILLIAMS_R(data, period)  

• data (array):
  Range of columns containing the date, Open, high, Low, close, volume data.
• period (number):
  Number of (periods) days over which to calculate the WPR.

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

Output Example

Below is an example of the resulting array when applying the custom =WILLIAMS_R() function.