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
-
Install the Cryptosheets add-in from Microsoft AppSource Store
-
Make sure you are logged into your Cryptosheets account
Using the console
Using the console
- From the Cryptosheets ribbon click
data
- Type in type in "TokenAnalyst..." then click on
BTC UTXO Weighted Average Age
- Scroll through the console parameters and input your values
- Select the cell you want to place the data into
- Click
make request
Using custom functions
Using custom functions
- 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"})
- 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 theclipboard 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
- From the Cryptosheets ribbon click
templates
OR click on thetemplates tab
in the browse section - Load the template called
Query Builder
and type TokenAnalyst and BTC UTXO Weighted Average Age - 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