> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Syntax

> Syntax for using Token Terminal Sheets

## 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`

<Note>
  **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'}`
</Note>

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

```javascript theme={null}
=TT("TICKER", "METRIC_ID")
```

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

```javascript theme={null}
// 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.

```javascript theme={null}
=TT_PROJECTS()
```

You can check out a list of all supported projects in our [**Projects**](https://tokenterminal.com/explorer/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.

```javascript theme={null}
=TT_METRICS()
```

You can check out a list of all supported metrics in our [**Metrics**](https://tokenterminal.com/explorer/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.

```javascript theme={null}
=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.

```javascript theme={null}
=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.

```javascript theme={null}
=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.

```javascript theme={null}
=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"`.

```javascript theme={null}
=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.

```javascript theme={null}
=TT_TIMESERIES("bitcoin", {"price", "market_cap"}, "2022-01-01", "2022-10-01")
```