​
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.

=TT("TICKER", "METRIC_ID")

Here are a few examples to demonstrate how you can pull metrics for different projects.

// Pull latest Circulating market cap from Aave
=TT("aave", "market_cap_circulating")

// Pull latest Ethereum TVL
=TT("ethereum", "tvl")

// Pull latest Solana daily active users count
=TT("solana", "user_dau")

// Pull latest Polygon revenue
=TT("polygon", "revenue")

​
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.

=TT_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.

=TT_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.

=TT_FINANCIAL_STATEMENT("TICKER", "GRANULARITY", "TIME_INTERVAL")

In the following example, we’ll pull a full year’s financial statement broken into quarters for Ethereum.

=TT_FINANCIAL_STATEMENT("ethereum", "quarter", "365d")

​
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.

=TT_TIMESERIES("TICKER", "METRIC_ID", "START_TIME", "END_TIME")

In the following example, we’ll pull the Bitcoin price from 2022-01-01 to 2022-10-01 in ascending order.

=TT_TIMESERIES("bitcoin", "price", "2022-01-01", "2022-10-01")

We also allow you to pull data in descending order by adding the param "DESC".

=TT_TIMESERIES("bitcoin", "price", "2022-01-01", "2022-10-01", "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.

=TT_TIMESERIES("bitcoin", {"price", "market_cap"}, "2022-01-01", "2022-10-01")