Utility Functions

=CS.STATUS()

=CS.PROVIDERS()

=CS.ENDPOINTS()

=CS.EXCHANGES()

=CS.HEALTHCHECK()

=CS.SOCKETHEALT...

Troubleshooting

Tips & Tricks

Additional Reso...


> Get started with Cryptosheets **utlity custom functions** to quickly pull diagnositc and status information about your enviornement to help troubleshoot

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

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

---


Cryptosheets utility functions allow you to quickly diagnose issues, check your login status and local environment for efficient troubleshooting

utility Functions