Skip to main content

​
Types

When using TT functions in Token Terminal Sheets, there are a few inputs that are important to understand:
  • TICKER: ticker, token symbol, project name, or project id. (from =TT_PROJECTS)
  • METRIC_ID: the metric_id returned from a metric row (=TT_METRICS)
  • GRANULARITY: week | month | quarter | year
  • TIME_INTERVAL: 7d | 30d | 90d | 180d | 365d | 1m | 1y | 2y | 3y | 5y | max
Single tickers and arrays: Anywhere that you can pass a TICKER to a function, you can also pass an array of tickers or a range reference (i.e. A1:A2) that has ticker values in it. Arrays can be defined using the syntax {'ticker_1', 'ticker_2'}

​
Functions

Functions in Token Terminal Sheets allows you to easily access data from Token Terminal inside of your spreadsheet. There a few useful functions to help you retrieve a list of projects or metrics and then to retrieve specific data points for those projects and metrics.

​
Get latest data for a project

The simplest way to get data with Token Terminal Sheets is to use the =TT() function. You can pass it a ticker or array of tickers to receive the latest data point for any metric.
Here are a few examples to demonstrate how you can pull metrics for different projects.

​
Get list of supported projects

If you’re not sure about what ticker you should use for a project, asset, or chain, you can use TT_PROJECTS to get a list of all supported projects.
You can check out a list of all supported projects in our Projects.

​
Get list of supported metrics

Like the projects function, TT_METRICS helps you know which metrics are available and how they’re abbreviated with the Token Terminal API. You can use this function as a reference point for getting the correct metrics names when building out your spreadsheet models. When using this function, you will get a list of all supported metrics.
You can check out a list of all supported metrics in our Metrics.

​
Get a financial statement for a project

Financial Statements on Token Terminal allow users to easily understand a project in a familiar format: quarterly financial statements for key metrics. You can easily generate a quarterly statement for any project inside of your sheet.
In the following example, we’ll pull a full year’s financial statement broken into quarters for Ethereum.

​
Get time series data for a project

Time series allow pulling historical data for a specific project, pulling in daily metrics for the time range specified in the function.
In the following example, we’ll pull the Bitcoin price from 2022-01-01 to 2022-10-01 in ascending order.
We also allow you to pull data in descending order by adding the param "DESC".

​
Get time series data for multiple metrics for a project

Project time series allows pulling historical data for multiple metrics for a specific project, pulling in daily data for each metric for the time range specified in the function.