Syntax / Formulas

Get started with you first =ART() formula!

Using the ART function
Pulling Live Data
=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
Pulling Historical Data
=ART("SYMBOL", "METRIC_NAME", "DATE")
Examples:
=ART("BTC", "PRICE", "2022-10-10") pulls the Bitcoin price on 2022-10-10 (midnight UTC time)
=ART("ETH", "MC", "2022-10-10") pulls the Ethereum market cap on 2022-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. 
Pulling a Range of Historical Data
=ARTRANGE("SYMBOL", "METRIC_NAME", "STARTDATE", "ENDDATE")
Example:
=ARTRANGE("BTC", "PRICE", "2022-01-01", "2022-10-01") pulls the Bitcoin price from 2022-01-01 to 2022-10-01 in ascending order
To pull in descending order, add the param "DESC". 
=ARTRANGE("SYMBOL", "METRIC_NAME", "STARTDATE", "ENDDATE", "DESC")
Example: 
=ARTRANGE("BTC", "PRICE", "2022-01-01", "2022-10-01", "DESC") pulls the Bitcoin price from 2022-10-01 to 2022-01-01 in descending order (so 2022-10-01 is on top). 

Artemis Sheets - Previous

Pricing

Next - Artemis Sheets

Supported Tokens

Last modified 11d ago