Syntax for using Token Terminal Sheets
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
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'}
=TT()
function. You can pass it a ticker or array of tickers to receive the latest data point for any metric.
TT_PROJECTS
to get a list of all supported projects.
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.
"DESC"
.