Comment on page
Syntax & Formulas
Get started with you first =ART() formula!
Using the ART function
=ART("SYMBOL", "METRIC_NAME")
Examples:
=ART("BTC", "PRICE")
pulls the latest Bitcoin price=ART("ETH", "MC")
pulls the latest Ethereum market cap=ART("SOL", "TVL")
pulls the latest Solana TVL=ART("SOL", "DAU")
pulls the latest Solana daily active address count=ART("MATIC", "FEES")
pulls the latest Polygon fees
=ART("SYMBOL", "METRIC_NAME", "DATE")
Examples:
=ART("BTC", "PRICE", "2022-10-10")
pulls the Bitcoin price on2022-10-10
(midnight UTC time)=ART("ETH", "MC", "2022-10-10")
pulls the Ethereum market cap on2022-10-10
For performance reasons, if you're a large amount of historical data, we recommend using the
ARTRANGE
function below. This will also reduce the total number of calls that count towards your daily limit in Google Sheets.
=ARTRANGE("SYMBOL", "METRIC_NAME", "STARTDATE", "ENDDATE")
Example:
=ARTRANGE("BTC", "PRICE", "2022-01-01", "2022-10-01")
pulls the Bitcoin price from2022-01-01
to2022-10-01
in ascending order
=ARTRANGE("SYMBOL", "METRIC_NAME", "STARTDATE", "ENDDATE", "DESC")
Example:
=ARTRANGE("BTC", "PRICE", "2022-01-01", "2022-10-01", "DESC")
pulls the Bitcoin price from2022-10-01
to2022-01-01
in descending order (so2022-10-01
is on top).
Use =ARTINFO function to get
a versatile range of information about assets, metrics, and their classifications.=ARTINFO(parameter1, parameter2)
Use
=ARTINFO() to get a list of all available parameters.
- Parameter 1: Can be set to "ALL" or a specific asset symbol (like "BTC", "UNI", etc.).
- Parameter 2: Varies based on Parameter 1. It can be "SYMBOLS", "TOP100-SYMBOLS", "METRICS", "ASSET-NAME", "CATEGORIES", or "SUB-CATEGORIES".
- When Parameter 1 is "ALL":
- SYMBOLS: Returns every asset symbol along with its name.
- TOP100-SYMBOLS: Retrieves the top 100 asset symbols by market capitalization, including their names.
- METRICS: Provides every metric symbol and its corresponding description.
- When Parameter 1 is a specific symbol (e.g., "UNI"):
- ASSET-NAME: Returns the asset name associated with the given symbol.
- CATEGORIES: Retrieves the category of the asset corresponding to the given symbol.
- SUB-CATEGORIES: Provides the sub-category of the asset for the given symbol.
=ARTINFO("ALL", "METRICS")
returns every metric symbol and metric description=ARTINFO("UNI", "
ASSET-NAME")
returns Uniswap
=ARTRANGE(<cells containing symbols>,<cells containing metric names>,"DATE")
=ART
and =ARTRANGE
both support pulling multiple symbols, metrics, and dates all at once so you can fetch hundreds of datapoints in one go--this is great for keeping your spreadsheet performant.Examples:
=ART(B6:B10,C5:I5,B4)
=ART(B3,C5:I5,B43,B6,"DESC")
=ART(C5:F5,B3,B43,B6,"DESC")
NOTE: you can only pick 2 out of the 3 (symbol, metric, date) as a range of cells. Otherwise, the data output would be three-dimensional and would not output correctly in GSheet or Excel.
In case of duplicate symbols, use the coingecko ID in ART formulas.
Example:
=ART("degate", "PRICE")
pulls the DeGate (symbol: DG) price=ART("decentral-games", "PRICE")
pulls the Decentral Games (symbol: DG) price
The coingecko ID can be found in the Coingecko token page, in API id field.

Last modified 22d ago