PARAMETERS

=CS.PARAMETERS()

In its simplest form, the CS.PARAMETERS function says =CS.PARAMETERS(name of provider, name of endpoint you want to return all of the possible parameters for)

Scenario

Use =CS.PARAMETERS() when you need to quickly lookup the custom functions profile of a specific provider's endpoint to check what the parameters are. This function is a helpful reference for beginners learning the particular arguments and syntax of specific provider endpoints. It can also be very handy for advanced users working with multiple providers and endpoints that need a quick reference tool.

Function arguments

1. Arguments: =CS.PARAMETERS("provider", "endpoint")

2. Values: =CS.PARAMETERS("CryptUnit", "earnings-auto")

   NOTE: arguments like additional parameters that are wrapped in brackets [like this] are optional, all other arguments should be considered required

Function argument descriptions

• provider: Data provider, ex. Cryptunit (required)
• endpoint: Data endpoint of provider, ex. 'earnings-auto' (required)

Click to search for data providers and endpoints

Examples

1. Example 1:

   =CS.PARAMETERS("CryptUnit", "earnings-auto")

2. Example 2:

   =CS.PARAMETERS("Paradigm", "ico ieo sto")

Example 1 - output:

Example 2 - output:

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. Error Response Codes Reference

   • #N/A OK – Everything worked as expected
   • #BUSY Unauthorized – Your User/Password API Keys are incorrect
   • #LIMIT Forbidden – You are not subscribed to the data feed requested
   • Other Something else? – Click here for full list of Excel error explanation

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

---