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).
=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 1mo ago