Sample Usage

Syntax

Troubleshooting

Additional Reso...

> Rate of change : ((price/prevPrice)-1)*100

### Sample Usage

**Default**
<typography-paragraph code copyable>
  =CS.ROC( D2:D101)
</typography-paragraph>

**Required and Optional**
<typography-paragraph code copyable>
    =CS.ROC( D2:D101, 0, 100, 10)
</typography-paragraph>

**Full Example, with Global Parameters**
<typography-paragraph code copyable="=CS.ROC( D2:D101, 0, 100, 10, A20:B24)">
    =CS.ROC( D2:D101, 0, 100, 10, A20:B24)
</typography-paragraph>

> For a full list of common parameters, [Click Here](/functions/common/).

### Syntax

```
=CS.ROC( inReal, [startIdx], [endIdx], [optInTimePeriod], [globalArgs])
```

- **inReal** - Array of floats.
- **startIdx** - [OPTIONAL] - Start index for input data
- **endIdx** - [OPTIONAL] - End index for input data
- **optInTimePeriod** - [OPTIONAL] - Number of period
- **globalArgs** - [OPTIONAL] - Global arguments available on all functions. See [common](/functions/common) for all available options.

### See Also

[ADX](/functions/technical-indicators/adx) - Average Directional Movement Index  
[APO](/functions/technical-indicators/apo) - Absolute Price Oscillator  
[AROON](/functions/technical-indicators/aroon) - Aroon  
[AROONOSC](/functions/technical-indicators/aroonosc) - Aroon Oscillator  
[CCI](/functions/technical-indicators/cci) - Commodity Channel Index  
[DX](/functions/technical-indicators/dx) - Directional Movement Index  
[MACD](/functions/technical-indicators/macd) - Moving Average Convergence/Divergence  
[MACDEXT](/functions/technical-indicators/macdext) - MACD with controllable MA type  
[MACDFIX](/functions/technical-indicators/macdfix) - Moving Average Convergence/Divergence Fix 12/26  
[MFI](/functions/technical-indicators/mfi) - Money Flow Index  
[MOM](/functions/technical-indicators/mom) - Momentum  
[ROC](/functions/technical-indicators/roc) - Rate of change : ((price/prevPrice)-1)*100  
[ROCP](/functions/technical-indicators/rocp) - Rate of change Percentage: (price-prevPrice)/prevPrice  
[ROCR](/functions/technical-indicators/rocr) - Rate of change ratio: (price/prevPrice)  
[RSI](/functions/technical-indicators/rsi) - Relative Strength Index  
[STOCH](/functions/technical-indicators/stoch) - Stochastic  
[TRIX](/functions/technical-indicators/trix) - 1-day Rate-Of-Change (ROC) of a Triple Smooth EMA  
[ULTOSC](/functions/technical-indicators/ultosc) - Ultimate Oscillator  
[WILLR](/functions/technical-indicators/willr) - Williams&#x27; %R  

---

### Troubleshooting

1. Check your formula syntax for carefully, different functions for the same data may have slightly different required syntax
2. Check the **required arguments** for your function vs the **optional arguments**
3. Check your data & API quotas and limits
4. Check your formulas carefully
5. Check your relative references
6. Use Excels **error checking tools**

### Additional Resources

_For Microsoft Excel_

- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/concepts/browsers-used-by-office-web-add-ins" rel="noopener noreferrer" target="_blank">Web browsers used by add-ins</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets" rel="noopener noreferrer" target="_blank">Office versions and requirement sets</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets#how-to-check-your-office-version" rel="noopener noreferrer" target="_blank">How to check your Office version</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/develop/install-latest-office-version" rel="noopener noreferrer" target="_blank">Install the latest version of Office</a>
- <a href="https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture" rel="noopener noreferrer" target="_blank">Custom Function Requirements</a>

_For Googlesheets_

- <a href="https://developers.google.com/apps-script/guides/services/quotas" rel="noopener noreferrer" target="_blank">Throughput Quotas & Limits</a>


How to use ROC in Excel and Google Sheets