How to use Coin...

Example Paramet...

Usage

Setup

Using the console

Using custom fu...

Using templates

Helpful Resources:

> Returns values for an index.

## How to use Coinmetrics data in Excel & Googlesheets with Cryptosheets

This article demonstrates three examples of how to pull Coinmetrics data into your spreadsheet using the `side panel console`,  `custom functions` and `templates`.

<img src="https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/providers/coinmetrics/console/get-index-values-data---v3-pro.gif" />

Explore more Coinmetrics endpoints [here](https://app.cryptosheets.com/#/browse/Coinmetrics)

## Example Parameters:

- indexId: `CMBI10`
- reference_time: ``
- direction: `forward`
- limit: `100`
- latest: ``
- level_type: `close`
- Authorization: `Your_Authorization`

## Usage

Cryptosheets data can be pulled through multiple surfaces:

<details>
  <summary>Setup</summary>

### Setup

  1. Install the Cryptosheets add-in from Microsoft [AppSource Store](https://appsource.microsoft.com/en-us/product/office/WA104381695?src=intercom-Coinmetrics)
  2. Make sure you are logged into your Cryptosheets account

  <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" />

</details>

<details>
  <summary>Using the console</summary>

### Using the console
  1. From the Cryptosheets ribbon click `data`
  2. Type in type in "Coinmetrics..." then click on `Get Index Values Data - V3 Pro` 
  3. Scroll through the console parameters and input your values
  4. Select the cell you want to place the data into
  5. 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 src="https://res.cloudinary.com/cryptosheets/image/upload/v1568230681/cryptosheets-docs/providers/coinmetrics/console/get-index-values-data---v3-pro.gif" />

</details>

<details>
  <summary>Using custom functions</summary>

### Using custom functions

1. In any cell type the following: `=CS.QUERY("Coinmetrics","Get Index Values Data - V3 Pro",{"indexId","CMBI10";"reference_time","";"direction","forward";"limit","100";"latest","";"level_type","close";"Authorization","Your_Authorization"})`
2. 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("Coinmetrics","Get Index Values Data - V3 Pro")`

<img src="https://res.cloudinary.com/cryptosheets/image/upload/cryptosheets-docs/providers/coinmetrics/functions/get-index-values-data---v3-pro.gif" />

</details>

<details>
  <summary>Using templates</summary>

### Using templates
  1. From the Cryptosheets ribbon click `templates` OR click on the `templates tab` in the browse section
  2. Load the template called `Query Builder` and type Coinmetrics and Get Index Values Data - V3 Pro
  3. You can also try searching "Coinmetrics..." for other templates specific or related to `Get Gains` 

<img src="https://res.cloudinary.com/cryptosheets/image/upload/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>
    <a href="https://appsource.microsoft.com/en-us/product/office/WA104381695?src=docs-Coinmetrics">
      Get Cryptosheets for Microsoft Excel
    </a>
  </li>
  <li>
    <a href="https://gsuite.google.com/u/2/marketplace/app/cryptosheets/898843532532?hl=en&pann=sheets_addon_widget&src=docs-Coinmetrics">
      Get Cryptosheets for Googlesheets
    </a>
  </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 Coinmetrics [here](https://coinmetrics.io)

Troubleshooting: please reference the following troubleshooting code: QUE-1248-3337. Learn more [here](https://intercom.help/cryptosheets/en/)

---
Tags: endpoint

How to pull Get Index Values Data - V3 Pro data from Coinmetrics into Excel and Google Sheets