Get Started

Types of Custom...

Core Functions

Reference Funct...

Specialty Funct...

Technical Indic...

Utility Functions

Troubleshooting

Tips & Tricks

Additional Reso...

Find Fields


> Get started with **custom functions** to pull dynamic, customized data into your worksheet with highly flexible formulas.

![Example 1](https://res.cloudinary.com/cryptosheets/image/upload/v1586128921/cryptosheets-docs/functions/excel-vs-googlesheets.png)

> **IMPORTANT** Using Cryptosheets custom functions in Excel vs Googlesheets is almost exactly the same with a few very slight differences.
>
> - In **Excel there is a "." (period) between the CS and the function name** so `=CS.TA()`
> - In **Googlesheets there is NO "." (period)** after the CS so the formula is simply `=CSTA()`
> - Some international users may need to substitute commas `","` in custom functions with semicolons `";"` so for something like `=CS.TA("BTC","USD")` try `=CS.TA("BTC";"USD")` instead

## Get Started

<iframe
  width="560"
  height="315"
  src="https://www.youtube.com/embed/videoseries?list=PLBg8GR5ao-ayGE74T7X8ojr-N_hdSg0E-&autoplay=1&mute=1"
  frameborder="0"
  allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture"
  allowfullscreen
></iframe>

1. Browse through the functions below
2. Start with our **[custom functions templates](https://app.cryptosheets.com/#/templates)** by clicking the **templates button** in the ribbon

![img](https://paradigmas.blob.core.windows.net/paradigmas-content/sharex/Book1_-_Excel_847x138.png)

3. Learn how to use our quick start **[auto templates in the help center](https://intercom.help/cryptosheets/en/articles/3469879-templates-custom-functions)**

## Types of Custom Functions

### Core Functions

Core functions are designed to pull in specific, large data sets including market and on chain data.

[`=CS.EXRATE()`](https://docs.cryptosheets.com/functions/exrate/)

[`=CS.OHLCV()`](https://docs.cryptosheets.com/functions/ohlcv/)

[`=CS.OHLCVA()`](https://docs.cryptosheets.com/functions/ohlcva/)

[`=CS.ORDERBOOKS()`](https://docs.cryptosheets.com/functions/orderbooks/)

[`=CS.ORDERBOOKSA()`](https://docs.cryptosheets.com/functions/orderbooksa/)

[`=CS.ORDERBOOKSL3A()`](https://docs.cryptosheets.com/functions/orderbooksl3a/)

[`=CS.PRICE()`](https://docs.cryptosheets.com/functions/price/)

[`=CS.PRICEA()`](https://docs.cryptosheets.com/functions/pricea/)

[`=CS.QUERY()`](https://docs.cryptosheets.com/functions/query/)

[`=CS.QUERYA()`](https://docs.cryptosheets.com/functions/querya/)

[`=CS.TRADES()`](https://docs.cryptosheets.com/functions/trades/)

[`=CS.TRADESA()`](https://docs.cryptosheets.com/functions/tradesa/)


### Reference Functions

Reference functions are metadata functions to assist in pulling Core functions.

[`=CS.ENDPOINTS()`](https://docs.cryptosheets.com/functions/endpoints/)

[`=CS.EXCHANGES()`](https://docs.cryptosheets.com/functions/exchanges/)

[`=CS.FIELDS()`](https://docs.cryptosheets.com/functions/fields/)

[`=CS.METRICSMETADATA()`](https://docs.cryptosheets.com/functions/metricsmetadata/)

[`=CS.PARAMETERS()`](https://docs.cryptosheets.com/functions/parameters/)

[`=CS.PROVIDERS()`](https://docs.cryptosheets.com/functions/providers/)

[`=CS.SYMBOLS()`](https://docs.cryptosheets.com/functions/symbols/)

[`=CS.TAMETADATA()`](https://docs.cryptosheets.com/functions/metadata/)


### Specialty Functions

Specialty functions are designed to pull in specific, focused data sets and advanced metrics. These are in constant development and new functions are rolled out on a frequent basis.

[`=CS.ADDRESS()`](https://docs.cryptosheets.com/functions/address/)

[`=CS.ATH()`](https://docs.cryptosheets.com/functions/ath/)

[`=CS.CHAIN()`](https://docs.cryptosheets.com/functions/chain/)

[`=CS.CLUSTERS()`](https://docs.cryptosheets.com/functions/clusters/)

[`=CS.IDEAS()`](https://docs.cryptosheets.com/functions/ideas/)

[`=CS.METRICS()`](https://docs.cryptosheets.com/functions/metrics/)

[`=CS.METRICSA()`](https://docs.cryptosheets.com/functions/metricsa/)

[`=CS.TA()`](https://docs.cryptosheets.com/functions/ta/)

[`=CS.TAHIS()`](https://docs.cryptosheets.com/functions/tahis/)


### Technical Indicator Functions

Technical indicator functions are designed to calculate specific indicators on any dataset.

[`=CS.AD()`](https://docs.cryptosheets.com/functions/technical-indicators/ad/)

[`=CS.ADOSC()`](https://docs.cryptosheets.com/functions/technical-indicators/adosc/)

[`=CS.ADX()`](https://docs.cryptosheets.com/functions/technical-indicators/adx/)

[`=CS.APO()`](https://docs.cryptosheets.com/functions/technical-indicators/apo/)

[`=CS.AROON()`](https://docs.cryptosheets.com/functions/technical-indicators/aroon/)

[`=CS.AROONOSC()`](https://docs.cryptosheets.com/functions/technical-indicators/aroonosc/)

[`=CS.ATR()`](https://docs.cryptosheets.com/functions/technical-indicators/atr/)

[`=CS.BBANDS()`](https://docs.cryptosheets.com/functions/technical-indicators/bbands/)

[`=CS.BETA()`](https://docs.cryptosheets.com/functions/technical-indicators/beta/)

[`=CS.CCI()`](https://docs.cryptosheets.com/functions/technical-indicators/cci/)

[`=CS.CDLINNECK()`](https://docs.cryptosheets.com/functions/technical-indicators/cdlinneck/)

[`=CS.CDLMARUBOZU()`](https://docs.cryptosheets.com/functions/technical-indicators/cdlmarubozu/)

[`=CS.CORREL()`](https://docs.cryptosheets.com/functions/technical-indicators/correl/)

[`=CS.DEMA()`](https://docs.cryptosheets.com/functions/technical-indicators/dema/)

[`=CS.DX()`](https://docs.cryptosheets.com/functions/technical-indicators/dx/)

[`=CS.EMA()`](https://docs.cryptosheets.com/functions/technical-indicators/ema/)

[`=CS.EXP()`](https://docs.cryptosheets.com/functions/technical-indicators/exp/)

[`=CS.FLOOR()`](https://docs.cryptosheets.com/functions/technical-indicators/floor/)

[`=CS.LINEARREG()`](https://docs.cryptosheets.com/functions/technical-indicators/linearreg/)

[`=CS.LINEARREG_ANGLE()`](https://docs.cryptosheets.com/functions/technical-indicators/linearreg_angle/)

[`=CS.LINEARREG_INTERCEPT()`](https://docs.cryptosheets.com/functions/technical-indicators/linearreg_intercept/)

[`=CS.LINEARREG_SLOPE()`](https://docs.cryptosheets.com/functions/technical-indicators/linearreg_slope/)

[`=CS.LN()`](https://docs.cryptosheets.com/functions/technical-indicators/ln/)

[`=CS.MACD()`](https://docs.cryptosheets.com/functions/technical-indicators/macd/)

[`=CS.MACDEXT()`](https://docs.cryptosheets.com/functions/technical-indicators/macdext/)

[`=CS.MACDFIX()`](https://docs.cryptosheets.com/functions/technical-indicators/macdfix/)

[`=CS.MFI()`](https://docs.cryptosheets.com/functions/technical-indicators/mfi/)

[`=CS.MOM()`](https://docs.cryptosheets.com/functions/technical-indicators/mom/)

[`=CS.NATR()`](https://docs.cryptosheets.com/functions/technical-indicators/natr/)

[`=CS.OBV()`](https://docs.cryptosheets.com/functions/technical-indicators/obv/)

[`=CS.ROC()`](https://docs.cryptosheets.com/functions/technical-indicators/roc/)

[`=CS.ROCP()`](https://docs.cryptosheets.com/functions/technical-indicators/rocp/)

[`=CS.ROCR()`](https://docs.cryptosheets.com/functions/technical-indicators/rocr/)

[`=CS.RSI()`](https://docs.cryptosheets.com/functions/technical-indicators/rsi/)

[`=CS.SAREXT()`](https://docs.cryptosheets.com/functions/technical-indicators/sarext/)

[`=CS.SMA()`](https://docs.cryptosheets.com/functions/technical-indicators/sma/)

[`=CS.STDDEV()`](https://docs.cryptosheets.com/functions/technical-indicators/stddev/)

[`=CS.STOCH()`](https://docs.cryptosheets.com/functions/technical-indicators/stoch/)

[`=CS.T3()`](https://docs.cryptosheets.com/functions/technical-indicators/t3/)

[`=CS.TEMA()`](https://docs.cryptosheets.com/functions/technical-indicators/tema/)

[`=CS.TRANGE()`](https://docs.cryptosheets.com/functions/technical-indicators/trange/)

[`=CS.TRIX()`](https://docs.cryptosheets.com/functions/technical-indicators/trix/)

[`=CS.TSF()`](https://docs.cryptosheets.com/functions/technical-indicators/tsf/)

[`=CS.ULTOSC()`](https://docs.cryptosheets.com/functions/technical-indicators/ultosc/)

[`=CS.VAR()`](https://docs.cryptosheets.com/functions/technical-indicators/var/)

[`=CS.WCLPRICE()`](https://docs.cryptosheets.com/functions/technical-indicators/wclprice/)

[`=CS.WILLR()`](https://docs.cryptosheets.com/functions/technical-indicators/willr/)

[`=CS.WMA()`](https://docs.cryptosheets.com/functions/technical-indicators/wma)


### Utility Functions

The utility functions are designed to provide a quick and easy way to check the status of your login, the API and market data connectivity.

[`=CS.LOGIN()`](https://docs.cryptosheets.com/functions/login/)

[`=CS.STATUS()`](https://docs.cryptosheets.com/functions/status/)

[`=CS.TIME()`](https://docs.cryptosheets.com/functions/time/)


_Click on each custom function above to visit its dedicated support and resources page._

> - The goal is to keep our custom functions as easy and natural for users to remember and use. That means they are designed to be broadly useable with hundreds of different provider/endpoint combinations.

> - Future releases will include additional custom functions for more advanced use cases as well as additional tools and universal parameters. Stay up to date with our latest by visiting our **roadmap** and joining our **mailing list.**

## Troubleshooting

---

![Example 1](https://res.cloudinary.com/cryptosheets/image/upload/v1580304997/cryptosheets-docs/google/functions/csquery-side-by-side.png)

1. Check your syntax for **=CS.PARAMETERS()** carefully, different functions for the same data may have slightly different required syntax
2. Check the **required arguments** for **=CS.PARAMETERS()** vs the **optional arguments**
3. Check your data & API quotas and limits
4. Check your formulas carefully
5. Check your relative references (**=CS.PARAMETERS("CryptUnit", "earnings-auto")** vs. **=CS.PARAMETERS("A1", "B1")**)
6. Use Excel's **error checking tools**
7. Check Excel's help sections: [Link](https://support.office.com/en-us/article/function-arguments-65b29fb5-ec7b-4c0b-a54b-a67923571519)
8. Find **additional troubleshooting resources** and tips **[here](https://app.cryptosheets.com/#/resources/troubleshooting)**
9. Error Response Codes Reference

**[See more troubleshooting tips & tricks here](https://app.cryptosheets.com/#/resources/troubleshooting)**

**Formula Syntax Error:**

![Example Error](https://res.cloudinary.com/cryptosheets/image/upload/v1568655136/cryptosheets-docs/errors/cs-custom-functions-query-error2_rmrl1n.png)

**Login error:**

![Example Error](https://res.cloudinary.com/cryptosheets/image/upload/v1568669257/cryptosheets-docs/errors/cs-custom-function-error-login_lofmnb.png)

### Tips & Tricks

**Pull up the full Excel function argument dialog box**

- Begin typing the function into any cell (for example **=CS.QUERY**) then press **cntrl + A** and it will open the popup dialog window
- Use the **formatDates** argument in custom functions to save significant time and effort reformatting and converting datetime data and columns **[read the article here](https://help.cryptosheets.com/en/articles/3577487-date-formatting-with-custom-functions)**

## Additional Resources

_For Microsoft Excel_

- [**Web browsers used by add-ins:**](https://docs.microsoft.com/en-us/office/dev/add-ins/concepts/browsers-used-by-office-web-add-ins)
- [**Office versions and requirement sets:**](https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets)
- [**How to check your Office version:**](https://docs.microsoft.com/en-us/office/dev/add-ins/develop/office-versions-and-requirement-sets#how-to-check-your-office-version)
- [**Install the latest version of Office:**](https://docs.microsoft.com/en-us/office/dev/add-ins/develop/install-latest-office-version)
- [**Custom Function Requirements:**](https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture)

_For Googlesheets_

- [**Throughput Quotas & Limits:**](https://developers.google.com/apps-script/guides/services/quotas)

---

## Find Fields

(Coming soon, please check back)


How to pull data from all available custom functions into Excel and Google using Cryptosheets

Functions