Stablecoin Active addresses
This endpoint returns the active addresses of stabelecoin tokens for every day of their existence. An address is defined as 'active' if it has transacted during the given day.
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:
- token:
usdc
- window:
1d
- from_date:
2018-11-11
- to_date:
2018-11-12
- 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
Stablecoin Active addresses
- 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","Stablecoin Active addresses",{"token","usdc";"window","1d";"from_date","2018-11-11";"to_date","2018-11-12";"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","Stablecoin Active addresses")

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 Stablecoin Active addresses - 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-713. Learn more here
Tags: analytics,metrics,onchain,metrics,forensics,stable active addresses