Skip to main content
Artemis Sheets allows you to pull in time-series metrics into a single cell. Using one of these functions would sum the requested metric across a given time period and return a value in a single cell. Supported time frames:
  • L7 - last 7 days
  • L30 - last 30 days
  • L90 - last 90 days
Sample Syntax
  • Sample syntax #1: =ART(“ETH”,“L7_REVENUE”)
    • The above formula would pull the sum of the past 7 days Revenue from DefiLlama.
  • Sample syntax #3: =ART(“SOL”,“L30_REVENUE”,“2025-10-01”)
    • The above formula would pull the Revenue sum from Sep 1 to Sep 30 (inclusive). So it calculates 30 days before the given date, but excludes the passed date itself.
Note: pulling TokenTerminal data requires a valid API key generated from a TokenTerminal Pro account. This can be entered in Extensions -> Artemis Sheets in Google Sheets and the Ribbon / Taskpane in Excel.