WILLR

<nav class="toc"><ol class="toc-level toc-level-1"><li class="toc-item toc-item-h3"><a class="toc-link toc-link-h3" href="#sample-usage">Sample Usage</a></li><li class="toc-item toc-item-h3"><a class="toc-link toc-link-h3" href="#syntax">Syntax</a></li><li class="toc-item toc-item-h3"><a class="toc-link toc-link-h3" href="#see-also">See Also</a></li><li class="toc-item toc-item-h3"><a class="toc-link toc-link-h3" href="#troubleshooting">Troubleshooting</a></li><li class="toc-item toc-item-h3"><a class="toc-link toc-link-h3" href="#additional-resources">Additional Resources</a></li></ol></nav><blockquote> <p>Williams' %R</p> </blockquote> <h3 id="sample-usage">Sample Usage</h3> <p><strong>Default</strong> =CS.WILLR( E2:E101, F2:F101, G2:G101) </p> <p><strong>Required and Optional</strong> =CS.WILLR( E2:E101, F2:F101, G2:G101, 0, 100, 14) </p> <p><strong>Full Example, with Global Parameters</strong> =CS.WILLR( E2:E101, F2:F101, G2:G101, 0, 100, 14, A20:B24) </p> <blockquote> <p>For a full list of common parameters, <a href="/functions/common/">Click Here</a>.</p> </blockquote> <h3 id="syntax">Syntax</h3> <pre><code>=CS.WILLR( high, low, close, [startIdx], [endIdx], [optInTimePeriod], [globalArgs]) </code></pre> <ul> <li><strong>high</strong> - The highest price reached during the period. Array of floats.</li> <li><strong>low</strong> - The lowest price reached during the period. Array of floats.</li> <li><strong>close</strong> - The price at which the period closed. Array of floats.</li> <li><strong>startIdx</strong> - [OPTIONAL] - Start index for input data</li> <li><strong>endIdx</strong> - [OPTIONAL] - End index for input data</li> <li><strong>optInTimePeriod</strong> - [OPTIONAL] - Number of period</li> <li><strong>globalArgs</strong> - [OPTIONAL] - Global arguments available on all functions. See <a href="/functions/common">common</a> for all available options.</li> </ul> <h3 id="see-also">See Also</h3> <p><a href="/functions/technical-indicators/adx">ADX</a> - Average Directional Movement Index<br> <a href="/functions/technical-indicators/apo">APO</a> - Absolute Price Oscillator<br> <a href="/functions/technical-indicators/aroon">AROON</a> - Aroon<br> <a href="/functions/technical-indicators/aroonosc">AROONOSC</a> - Aroon Oscillator<br> <a href="/functions/technical-indicators/cci">CCI</a> - Commodity Channel Index<br> <a href="/functions/technical-indicators/dx">DX</a> - Directional Movement Index<br> <a href="/functions/technical-indicators/macd">MACD</a> - Moving Average Convergence/Divergence<br> <a href="/functions/technical-indicators/macdext">MACDEXT</a> - MACD with controllable MA type<br> <a href="/functions/technical-indicators/macdfix">MACDFIX</a> - Moving Average Convergence/Divergence Fix 12/26<br> <a href="/functions/technical-indicators/mfi">MFI</a> - Money Flow Index<br> <a href="/functions/technical-indicators/mom">MOM</a> - Momentum<br> <a href="/functions/technical-indicators/roc">ROC</a> - Rate of change : ((price/prevPrice)-1)*100<br> <a href="/functions/technical-indicators/rocp">ROCP</a> - Rate of change Percentage: (price-prevPrice)/prevPrice<br> <a href="/functions/technical-indicators/rocr">ROCR</a> - Rate of change ratio: (price/prevPrice)<br> <a href="/functions/technical-indicators/rsi">RSI</a> - Relative Strength Index<br> <a href="/functions/technical-indicators/stoch">STOCH</a> - Stochastic<br> <a href="/functions/technical-indicators/trix">TRIX</a> - 1-day Rate-Of-Change (ROC) of a Triple Smooth EMA<br> <a href="/functions/technical-indicators/ultosc">ULTOSC</a> - Ultimate Oscillator<br> <a href="/functions/technical-indicators/willr">WILLR</a> - Williams' %R </p> <hr> <h3 id="troubleshooting">Troubleshooting</h3> <ol> <li>Check your formula syntax for carefully, different functions for the same data may have slightly different required syntax</li> <li>Check the <strong>required arguments</strong> for your function vs the <strong>optional arguments</strong></li> <li>Check your data &#x26; API quotas and limits</li> <li>Check your formulas carefully</li> <li>Check your relative references</li> <li>Use Excels <strong>error checking tools</strong></li> </ol> <h3 id="additional-resources">Additional Resources</h3> <p><em>For Microsoft Excel</em></p> <ul> <li>Web browsers used by add-ins</li> <li>Office versions and requirement sets</li> <li>How to check your Office version</li> <li>Install the latest version of Office</li> <li>Custom Function Requirements</li> </ul> <p><em>For Googlesheets</em></p> <ul> <li>Throughput Quotas &#x26; Limits</li> </ul>