# Glassnode Excel Add-In

Bring Glassnode metrics into Excel with simple formulas—no code, scripts, or connectors required. Use GN.METRIC to pull metrics into your sheet, and GN.ASSETS to discover available tickers.

### Example file

We have prepared an example file to show you what can be done and how the formulas can be used. You are welcome to use this file as a starting point, or you can go straight to the '[Formula](https://docs.glassnode.com/guides-and-tutorials/glassnode-excel-add-in#formula-reference)' section of this page to learn how to write your first queries.

<figure><img src="https://2190898932-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Ldi5WtVBeQ2iFbdqJ1a%2Fuploads%2Fgit-blob-42e2a858f35037b003d880d709c2f9ea9e684493%2Fscreenshot.png?alt=media" alt="Screenshot Glassnode Excel Add-In"><figcaption></figcaption></figure>

{% file src="<https://2190898932-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Ldi5WtVBeQ2iFbdqJ1a%2Fuploads%2Fgit-blob-acb09b6804f2e2b06f8f69f6ae6bd7a5cee45c30%2FGlassnode%20-%20Excel%20Playground.xlsx?alt=media&token=c66c3e72-a802-4169-be5f-efcb3ec72de8>" %}

### Install

* Install from[ Microsoft AppSource](https://appsource.microsoft.com/en-us/product/saas/wa200008970?tab=overview) either on Excel on Windows, Mac or Web
* Open Excel and launch the Glassnode add-in
* Enter your Glassnode API key in the add-in’s settings pane

{% hint style="warning" %}
**API access required**

To use the Excel add-in, you need an active Glassnode API add-on. You can acquire this by [contacting our sales team](https://glassnode.com/contact/sales).
{% endhint %}

### Data resolution

* Currently daily (24h) data only.
* Intraday (1h, 10m) support will be added in the future.
* For “latest” values use yesterday’s close, e.g., TODAY()-1.

### Quick start

* List all assets:

```excel
=GN.ASSETS()
```

* Single value (yesterday’s BTC USD close):

```excel
=GN.METRIC("BTC", "/market/price_usd_close", TODAY()-1)
```

* Date range (last 10 days of BTC USD close):

```excel
=GN.METRIC("BTC", "/market/price_usd_close", TODAY()-11, TODAY()-1)
```

### Formula reference

#### GN.ASSETS(limit?)

Returns available asset tickers.

* Parameters:
  * limit (optional): maximum number of assets to return
* Examples:

```excel
=GN.ASSETS()
=GN.ASSETS(50)
```

#### GN.METRIC(asset, metric, startDate, endDate?, parameter1?, parameter2?, parameter3?, parameter4?, pick?)

Fetches metric data from Glassnode.

* Parameters:
  * asset (required): e.g., "BTC", "ETH"
  * metric (required): API metric path starting with "/", e.g., "/market/price\_usd\_close" or "/addresses/active\_count"
  * startDate (required): Excel date serial or "YYYY-MM-DD"
  * endDate (optional): Excel date serial or "YYYY-MM-DD"
    * Note: endDate is exclusive (data up to but not including endDate)
  * parameter1..parameter4 (optional): Additional API parameters as "key=value" strings (e.g., "e=binance", "c=usd", "network=base")
  * pick (optional): For metrics that return objects, pick a field to return (e.g., "value")

{% hint style="info" %}
You can copy the metric path directly from Glassnode Studio using the “Copy API URL” button below each chart. Use only the path part that starts with “/” (for example, “/addresses/active\_count”) as the metric parameter.
{% endhint %}

* Returns:
  * Single value when endDate is omitted
  * A 2-column dynamic array (Date, Value) when endDate is provided
  * *A 2+-column dynamic array (Date, Value\_col1, Value\_col2, ..) for objects when the `pick` parameter is not specified - see the section* **Object metrics and the pick parameter** below for more information.
* Usage patterns:

```excel
// Single value
=GN.METRIC("BTC", "/market/price_usd_close", DATE(2025,8,1))

// Date range (table)
=GN.METRIC("BTC", "/market/price_usd_close", DATE(2025,8,1), DATE(2025,8,10))

// “Latest close” given daily data
=GN.METRIC("BTC", "/market/price_usd_close", TODAY()-1)

// With parameters (exchange and network filters)
=GN.METRIC("ETH", "/distribution/balance_exchanges", "2025-07-20", "2025-07-25", "e=binance")
=GN.METRIC("ETH", "/distribution/balance_exchanges", "2025-07-20", "2025-07-25", "e=binance", "network=base")

// With currency parameter
=GN.METRIC("BTC", "/market/price_close", "2025-08-01", "2025-08-10", "c=usd")
```

**Object metrics and the pick parameter**

Some endpoints return an object (not just a single “value”). By default this will display all available properties in your table. You can however select which property to return using the pick parameter (9th argument).

Example: HODL Waves provide an object of supply ranges such as “more\_10y” (10+ years) and “3y-5y” (3 to 5 years):

```excel
=GN.METRIC("BTC", "/supply/hodl_waves", "2025-08-01",,,,,,"more_10y")
```

Depending on the property you wish to display, you can replace 'more\_10y' with another available property, such as '3y-5y'. Only this property will then be returned. If you leave 'pick' unset, all properties will be returned.

### Single value vs. table output

* Single value: provide only startDate.

  * Example: yesterday’s close

  ```excel
  =GN.METRIC("BTC", "/market/price_usd_close", TODAY()-1)
  ```
* Table with dates: provide both startDate and endDate (endDate exclusive).

  * Example: last 30 days

  ```excel
  =GN.METRIC("BTC", "/market/price_usd_close", TODAY()-30, TODAY())
  ```

The table expands as a dynamic array: first column is Date, second column is the metric value.

### Finding the metric path

* In Glassnode Studio, open a chart and click “Copy API URL”.
* Example URL:
  * <https://api.glassnode.com/v1/metrics/addresses/active\\_count?a=BTC\\&i=24h>
* Pass only the metric path that starts with “/” as the second parameter:
  * Use "/addresses/active\_count"
  * Do not include query string parameters (a=, i=); add those via function parameters if needed.

### Optional parameters (parameter1..parameter4)

* Format: "key=value"
* Common examples:
  * "e=binance" filter by exchange
  * "c=usd" choose currency
  * "network=base" choose network
  * "miner=FoundryUSAPool" filter by mining pool
* Up to 4 parameters can be provided and are passed through to the API.

### Supported content

* The add-in supports metrics/charts (single-series line data).
* Workbenches and complex breakdowns are not supported at this time.

### Date handling tips

* Use Excel serials or ISO strings ("YYYY-MM-DD").
* endDate is exclusive: to include 2025-08-10, set endDate to 2025-08-11.
* Since data is daily, use TODAY()-1 for the most recent complete value.

### Date formatting and locales

By default, the add-in formats dates as YYYY-MM-DD (for example, 2025-08-01). In some locales this format may not display as expected when returning a table.

Workaround: call GN.METRIC once per row (without endDate) so the add-in returns a single value for each date you provide.

| A                 | B                                                  |
| ----------------- | -------------------------------------------------- |
| =DATE(2025, 8, 1) | =GN.METRIC("BTC", "/market/price\_usd\_close", A1) |
| =DATE(2025, 8, 2) | =GN.METRIC("BTC", "/market/price\_usd\_close", A2) |
| =DATE(2025, 8, 3) | =GN.METRIC("BTC", "/market/price\_usd\_close", A3) |