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).
Last modified 11d ago