BTC UTXO Weighted Average Age

For instance outputs in the category 12-18m are unspent outputs (UTXOs) from transactions that occurred 12-18m ago. Time is measured relative to blocktime assuming 6 blocks are generated per hour. This means that the proportion of UTXOs in the <1d category were generated less than or equal to 144 blocks ago (6 blocks * 24 hours).

How to use TokenAnalyst data in Excel & Googlesheets with Cryptosheets

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

Explore more TokenAnalyst endpoints here

Example Parameters:

  • limit: 2
  • window: 1d
  • token: btc
  • key: API_KEY
  • format: json

Usage

Cryptosheets data can be pulled through multiple surfaces:

Setup

Setup

  1. Install the Cryptosheets add-in from Microsoft AppSource Store

  2. Make sure you are logged into your Cryptosheets account

Using the console

Using the console

  1. From the Cryptosheets ribbon click data
  2. Type in type in "TokenAnalyst..." then click on BTC UTXO Weighted Average Age
  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

Using custom functions

Using custom functions

  1. In any cell type the following: =CS.QUERY("TokenAnalyst","BTC UTXO Weighted Average Age",{"limit","2";"window","1d";"token","btc";"key","API_KEY";"format","json"})
  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

Hint: If you need help remembering the exact parameters for any function, you can always just type in any cell: =CS.PARAMETERS("TokenAnalyst","BTC UTXO Weighted Average Age")

Using templates

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 TokenAnalyst and BTC UTXO Weighted Average Age
  3. You can also try searching "TokenAnalyst..." for other templates specific or related to Get Gains

Signing up for Cryptosheets is free get crypto data in 30 seconds or less

Note: you must have one of the supported versions of Microsoft Office or Excel for custom functions to work. Learn more here

Helpful Resources:

Visit the API documentation for TokenAnalyst here

Troubleshooting: please reference the following troubleshooting code: QUE-1593-691. Learn more here


Tags: analytics,metrics,onchain,metrics,forensics