How to use Wave...

Example Paramet...

Example Fields:

Usage

Setup

Using the console

Using custom fu...

Using templates

Helpful Resources:

> 1) Get list of pairs info by serialized pairs list; 2) Get all list of pairs info by limit (sort by volume in WAVES)

## How to use Waves Data Service data in Excel & Googlesheets with Cryptosheets

This article demonstrates three examples of how to pull Waves Data Service API data into your spreadsheet using the `side panel console`,  `custom functions` and `templates`.

<img src="https://res.cloudinary.com/cryptosheets/image/upload/v1/cryptosheets-docs/providers/waves-data-service/console/1)-get-list-of-pairs-info-by-serialized-pairs-list;-2)-get-all-list-of-pairs-info-by-limit-(sort-by-volume-in-waves).gif" />

Explore more Waves Data Service endpoints [here](https://app.cryptosheets.com/#/browse/Waves%20Data%20Service)

## Example Parameters:

- matcher: ``
- pairs: ``
- search_by_asset: `bitc`
- search_by_assets: ``
- match_exactly: ``
- limit: `100`

## Example Fields:

> This endpoint has no fields.


**Excel:**

<inline-code functionvalue='=CS.QUERY("Waves Data Service","1) Get list of pairs info by serialized pairs list; 2) Get all list of pairs info by limit (sort by volume in WAVES)",{"matcher","";"pairs","";"search_by_asset","bitc";"search_by_assets","";"match_exactly","";"limit","100"})'>=CS.QUERY("Waves Data Service","1) Get list of pairs info by serialized pairs list; 2) Get all list of pairs info by limit (sort by volume in WAVES)",{"matcher","";"pairs","";"search_by_asset","bitc";"search_by_assets","";"match_exactly","";"limit","100"})</inline-code>

**Googlesheets:**

<inline-code functionvalue='=CSQUERY("Waves Data Service","1) Get list of pairs info by serialized pairs list; 2) Get all list of pairs info by limit (sort by volume in WAVES)",{"matcher","";"pairs","";"search_by_asset","bitc";"search_by_assets","";"match_exactly","";"limit","100"})'>=CSQUERY("Waves Data Service","1) Get list of pairs info by serialized pairs list; 2) Get all list of pairs info by limit (sort by volume in WAVES)",{"matcher","";"pairs","";"search_by_asset","bitc";"search_by_assets","";"match_exactly","";"limit","100"})</inline-code>


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


## Usage

Cryptosheets data can be pulled through multiple interfaces:

<details>
  <summary>Setup</summary>

### Setup

  1. Install the Cryptosheets add-in from the [Microsoft AppSource Store](https://appsource.microsoft.com/en-us/product/office/WA104381695?src=intercom-Waves%20Data%20Service)

  2. Install the Cryptosheets add-in from the [Google GSuite Marketplace](https://gsuite.google.com/u/2/marketplace/app/cryptosheets/898843532532?src=intercom-Waves%20Data%20Service)

  3. After it is installed, make sure you are logged into your Cryptosheets account through the Cryptosheets side panel

  <img src="https://res.cloudinary.com/cryptosheets/image/upload/v1570534844/cryptosheets-docs/excel/install.png" />

  <img src="https://res.cloudinary.com/cryptosheets/image/upload/v1570537238/cryptosheets-docs/excel/login.png" />

  <img src="https://downloads.intercomcdn.com/i/o/223225643/14f5d809cb6dd07fd8e7b8c1/image.png" />

  <img src="https://cryptosheets.intercom-attachments-1.com/i/o/223227015/6af83d71cec3605f4608e834/cryptosheets-docs_google_login_addons-drop-down-menu.png" />

</details>

<details>
  <summary>Using the console</summary>

### Using the console
  1. From the Cryptosheets **Excel ribbon** click `data`
  2. From the **Googlesheets Add-ons menu** click `Cryptosheets` then select `Launch side-bar`
  3. Type in `Waves Data Service...` then click on `1) Get list of pairs info by serialized pairs list; 2) Get all list of pairs info by limit (sort by volume in WAVES)` 
  4. Scroll through the console parameters and input your values
  5. Select the cell you want to place the data into
  6. Click `make request`

[![img](https://res.cloudinary.com/cryptosheets/image/upload/v1570538223/cryptosheets-docs/excel/ribbon/data-browse-providers.png)](https://res.cloudinary.com/cryptosheets/image/upload/v1570538223/cryptosheets-docs/excel/ribbon/data-browse-providers.png)

[![img](https://res.cloudinary.com/cryptosheets/image/v1/upload/cryptosheets-docs/google/menu/data-browse-providers.png)](https://res.cloudinary.com/cryptosheets/image/v1/upload/cryptosheets-docs/google/menu/data-browse-providers.png)


<img src="https://res.cloudinary.com/cryptosheets/image/upload/v1568230681/cryptosheets-docs/providers/waves-data-service/console/1)-get-list-of-pairs-info-by-serialized-pairs-list;-2)-get-all-list-of-pairs-info-by-limit-(sort-by-volume-in-waves).gif" />

</details>

<details>
  <summary>Using custom functions</summary>

### Using custom functions

<video-player></video-player>

> **Tip**: For both Excel and Googlesheeets you can use either the **[QUERY](https://docs.cryptosheets.com/functions/query)** or **[QUERYA](https://docs.cryptosheets.com/functions/querya)** custom function

1. **Excel** In any cell type the following: 

`=CS.QUERY("Waves Data Service","1) Get list of pairs info by serialized pairs list; 2) Get all list of pairs info by limit (sort by volume in WAVES)",{"matcher","";"pairs","";"search_by_asset","bitc";"search_by_assets","";"match_exactly","";"limit","100"})`

2. **Googlesheets** In any cell type the following: 

`=CSQUERY("Waves Data Service","1) Get list of pairs info by serialized pairs list; 2) Get all list of pairs info by limit (sort by volume in WAVES)",{"matcher","";"pairs","";"search_by_asset","bitc";"search_by_assets","";"match_exactly","";"limit","100"})`

3. In any console, after selecting the parameters to configure the query string as desired, simply click the radio button to toggle the the `function/formula builder`, then click the `clipboard icon` to copy the full formula string and paste it into any cell **[see detailed examples and tutorial](https://intercom.help/cryptosheets/en/articles/3472916-using-the-cryptosheets-api-console-query-and-function-formula-builder-for-excel-googlesheets)**

<img src="https://downloads.intercomcdn.com/i/o/161179379/577ba7c6149cd8827b598623/image.png" />

> **Hint**: If you need help remembering the exact parameters for any function, you can always just type in any cell: `=CS.PARAMETERS("Waves Data Service","1) Get list of pairs info by serialized pairs list; 2) Get all list of pairs info by limit (sort by volume in WAVES)")` for Excel or `=CSPARAMETERS("Waves Data Service","1) Get list of pairs info by serialized pairs list; 2) Get all list of pairs info by limit (sort by volume in WAVES)")` for Googlesheets

<img src="https://res.cloudinary.com/cryptosheets/image/upload/v1/cryptosheets-docs/providers/waves-data-service/functions/1)-get-list-of-pairs-info-by-serialized-pairs-list;-2)-get-all-list-of-pairs-info-by-limit-(sort-by-volume-in-waves).gif" />

</details>

<details>
  <summary>Using templates</summary>

### Using templates
  1. From the Cryptosheets Excel ribbon click `templates` OR click on the `templates tab` in the browse section
  2. From the Googlesheets Add-ons menu click `Cryptosheets` then select `Templates`
  2. Load the template called `Query Builder` and type Waves Data Service and 1) Get list of pairs info by serialized pairs list; 2) Get all list of pairs info by limit (sort by volume in WAVES)
  3. You can also try searching "Waves Data Service..." for other templates 

<img src="https://res.cloudinary.com/cryptosheets/image/upload/v1/cryptosheets-docs/templates/gifs/query-builder-provider-endpoint.gif" />

</details>

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less

<ul>
  <li>
    <b><a href="https://appsource.microsoft.com/en-us/product/office/WA104381695?src=docs-Waves Data Service">
      Get Cryptosheets for Microsoft Excel
    </a></b>
  </li>
  <li>
   <b><a href="https://gsuite.google.com/u/2/marketplace/app/cryptosheets/898843532532?hl=en&pann=sheets_addon_widget&src=docs-Waves Data Service">
      Get Cryptosheets for Googlesheets
    </a></b>
  </li>
</ul>

> Note: you must have one of the [supported versions](https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture) of Microsoft Office or Excel for custom functions to work. Learn more [here](https://intercom.help/cryptosheets/en/)

## Helpful Resources:
 - Visit the API documentation for Waves Data Service **[here](https://waveplatform.io/)**
 - See tutorials and examples for Waves Data Service on the **[Cryptosheets YouTube channel]()**
 - Troubleshooting: please reference the following troubleshooting code: QUE-1798-4850. Learn more **[here](https://intercom.help/cryptosheets/en/)**

---
Tags: `1) Get list of pairs info by serialized pairs list; 2) Get all list of pairs info by limit (sort by volume in WAVES)` `Waves Data Service` `endpoint` 

How to pull 1) Get list of pairs info by serialized pairs list; 2) Get all list of pairs info by limit (sort by volume in WAVES) data from Waves Data Service into Excel and Google Sheets

1) Get list of pairs info by serialized pairs list; 2) Get all list of pairs info by limit (sort by volume in WAVES)