Specialty Core ...

=CS.ADDRESS()

=CS.CHAIN()

=CS.CLUSTERS()

=CS.METRICS()

=CS.IDEAS()

=CS.PARADIGM()

Troubleshooting

Tips & Tricks

Additional Reso...


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

![Example 1](https://res.cloudinary.com/cryptosheets/image/upload/v1571966039/cryptosheets-docs/excel/functions/exrate-hp-9.gif)

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

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

---

_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

---


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

Specialty Functions