Glassnode Excel Add-In
A guide to using Glassnode's 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' section of this page to learn how to write your first queries.
Install
Install from Microsoft AppSource 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
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.
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:
=GN.ASSETS()Single value (yesterday’s BTC USD close):
=GN.METRIC("BTC", "/market/price_usd_close", TODAY()-1)Date range (last 10 days of BTC USD close):
=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:
=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")
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
pickparameter is not specified - see the section Object metrics and the pick parameter below for more information.
Usage patterns:
// 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):
=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
=GN.METRIC("BTC", "/market/price_usd_close", TODAY()-1)Table with dates: provide both startDate and endDate (endDate exclusive).
Example: last 30 days
=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.
=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)
Last updated