Syntax and 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

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