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
💡 Info
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).

​
To pull in the dates associated with time-series datasets, use the param "showDates" (additional True / False parameter).

=ARTRANGE("SYMBOL", "METRIC_NAME", "STARTDATE", "ENDDATE", "DESC", TRUE) Example:
  • =ARTRANGE("BTC", "PRICE", "2022-01-01", "2022-10-01", "DESC", TRUE) pulls the dates and the Bitcoin price from 2022-10-01 to 2022-01-01 in descending order (so 2022-10-01 is on top).

​
To hide data fields that fall on weekend dates, use the param "hideWeekends" (additional True / False parameter).

=ARTRANGE("SYMBOL", "METRIC_NAME", "STARTDATE", "ENDDATE", "DESC", TRUE, TRUE) Example:
  • =ARTRANGE("BTC", "PRICE", "2022-01-01", "2022-10-01", "DESC", TRUE, TRUE) pulls the dates and the Bitcoin price from 2022-10-01 to 2022-01-01 in descending order (so 2022-10-01 is on top) and hides the data fields that fall on weekend dates.

​
🆕 ARTINFO

Use =ARTINFO function to geta versatile range of information about assets, metrics, and their classifications. =ARTINFO(parameter1, parameter2, filtered, excludedSymbols)
💡 Info
Use =ARTINFO() to get a list of all available parameters.

​
Description

  • Parameter 1: “all”, a specific asset symbol (like “btc”, “uni”, etc.), or a category (like “defi”, “stablecoin”, etc.) used to filter topN-symbols.
  • Parameter 2: One of the following: symbols, topN-symbols (N is any number), metrics, asset-name, categories, sub-categories, coingecko-id, mc-rank, supported-metrics, equities.
  • Filtered: Optional default filter for topN-symbols. Filtered categories are ‘stablecoin’ and ‘staked, bridged, or wrapped asset’. Defaults to False.
  • ExcludedSymbols: Optional comma-separated list of symbols to exclude. Example: “TUSD,USDC,$RCGE”

​
Functionality

  • 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.
    • CATEGORIES: Returns all available symbol categories.
    • EQUITIES: Returns every equity symbol and equity name.
  • 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.
    • COINGECKO-ID: Returns the Coingecko id associated with the given symbol.
    • MC-RANK: Returns the current market cap rank of the given symbol.
    • SUPPORTED-METRICS: Returns the supported metrics of the given symbol.
  • When Parameter 1 is “ALL” and Parameter 2 is “TOP100-SYMBOLS”:
    • FILTERED: If true, applies the default filter for topN-symbols.
    • EXCLUDEDSYMBOLS: Excludes the provided symbols.

​
Examples

  • =ARTINFO("ALL", "METRICS") returns every metric symbol and metric description
  • =ARTINFO("UNI", "ASSET-NAME") returns Uniswap
  • =ARTINFO("OSMO", "COINGECKO-ID") returns osmosis
  • =ARTINFO("all", "top100-symbols") returns the top 100 symbols by market cap
  • =ARTINFO("all", "top100-symbols", TRUE) returns the top 100 symbols by market cap, after removing ‘stablecoin’ and ‘staked, bridged, or wrapped asset’ symbols
  • =ARTINFO("all", "top100-symbols", TRUE, "TUSD,USDC,$RCGE) returns the top 100 symbols by market cap, after removing ‘stablecoin’ and ‘staked, bridged, or wrapped asset’ symbols and TUSD, USDC and $RCGE symbols
  • =ARTINFO("all", "top100-symbols", FALSE, "TUSD,USDC,$RCGE) returns the top 100 symbols by market cap, after removing TUSD, USDC and $RCGE symbols

​
Pulling Lots of Data

=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:

​
Pulling multiple symbols and metrics for a single date:

  • =ARTRANGE(B6:B10,C5:I5,B4) (see a live example here)
  • =ART(B6:B10,C5:I5,B4)

​
Pulling multiple metrics and dates for a single symbol:

  • =ARTRANGE(B3,C5:I5,B43,B6,"DESC") (see a live example here)
  • =ART(B3,C5:I5,B43,B6,"DESC")

​
Pulling multiple symbols and dates for a single metric:

  • =ARTRANGE(C5:F5,B3,B43,B6,"DESC") (see a live example here)
  • =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.

​
Duplicate symbols

In case of duplicate symbols, use the Coingecko ID in ART formulas with the prefix CG- Example:
  • =ART("CG-DEGATE", "PRICE") pulls the DeGate (symbol: DG) price
  • =ART("CG-DECENTRAL-GAMES", "PRICE") pulls the Decentral Games (symbol: DG) price
The Coingecko ID can be found by using =ARTINFO("symbol", "COINGECKO-ID")or in the Coingecko token page, in API id field.