# 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.
Screenshot Glassnode Excel Add-In
{% file src="/files/y27G1gRBq5q6wYz0a64Y" %} ### 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: * * 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) | --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.glassnode.com/guides-and-tutorials/glassnode-excel-add-in.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.