Unified Functions

=CS.PARAMETERS()

=CS.QUERY()

Core Functions

=CS.EXRATE()

=CS.PRICE()

=CS.ORDERBOOKS()

=CS.OHLCV()

=CS.TRADES()

=CS.TA()

=CS.ATH()

Specialty Core ...

=CS.ADDRESS()

=CS.CHAIN()

=CS.CLUSTERS()

=CS.METRICS()

=CS.IDEAS()

=CS.PARADIGM()

Utility Functions

=CS.STATUS()

=CS.PROVIDERS()

=CS.ENDPOINTS()

=CS.EXCHANGES()

=CS.HEALTHCHECK()

=CS.SOCKETHEALT...

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)

> **REMINDER** 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()`

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)**

#### Unified Functions

---

- The **parameters** and **query** functions allow users universal access to all data providers available in Cryptosheets

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

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

#### Core Functions

---

- The **core** functions are designed to pull in specific, large data sets including market and on chain data

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

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

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

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

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

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

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



#### Specialty Core Functions

---

- The **specialty core** 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://app.cryptosheets.com/#/functions/address)

### [`=CS.CHAIN()`](https://app.cryptosheets.com/#/functions/address)

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

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

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

### [`=CS.PARADIGM()`](https://app.cryptosheets.com/#/functions/paradigm)

#### 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.STATUS()`](https://app.cryptosheets.com/#/functions/status)

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

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

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

### [`=CS.HEALTHCHECK()`](https://app.cryptosheets.com/#/functions/healthcheck)

### [`=CS.SOCKETHEALTHCHECK()`](https://app.cryptosheets.com/#/functions/sockethealthcheck)

_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

---

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: 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)

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

Functions

Overview