Supported Metrics
Here's a list of all the metrics we support for Artemis Sheet
π For a list of all the metrics we provide, please use =ARTINFO("ALL","METRICS")
Market Data (CoinGecko)
Here's a list of all supported symbols: All CoinGecko assets
Here's a list of all metrics we support: All Artemis metrics
π Stablecoins are also supported:
USDC
USDT
DAI
BUSD
etc
Note: All historical market data is fetched as of 12PM UTC
π Equity Data
To pull stock price into sheets, use =ART("EQ-COIN", "PRICE") for Coinbase price.
Instructions
Find the stock symbol for a stock from Yahoo Finance.
Examples:
for SPDR S&P 500 ETF Trust (SPY)
GBTC
for Grayscale Bitcoin TrustCOIN
for Coinbase
Append "EQ-" in front of the stock symbol name.
Example: For Coinbase you'd want to have
"EQ-COIN"
Use the following formula =ART("EQ-[Stock Symbol]", "PRICE") to return the price of the stock
Example: For Coinbase you'd want use
=ART("EQ-COIN", "PRICE")
Notes
Equities prices forward fill from last close on holidays / weekends.
Artemis Terminal
Supported Symbols: all chains on app.artemis.xyz
Note: Not all chains have all metrics listed below - check app.artemis.xyz for a list of chain to metric pairings
π Artemis - Blockchain Activity Monitor
Supported Applications: all applications on Artemis Applications
Supported Categories: all category names on Artemis Blockchain Activity Monitor
Supported Chains: all chain names on Artemis Blockchain Activity Monitor
For symbol name for a given application, please find the associated symbol ID from Coingecko for the application (e.g symbol UNI
for application name Uniswap)
For chain symbol, please simply use the symbol for the given chain e.g Ethereum
is ETH
For category on-chain usage for a chain, please append category name-chain so DeFi-ETH
Examples
ART("AAVE","DAU")
returns Aave daily active addresses across all chainsART("AAVE-ETH","DAILY_TXNS")
returns Aave daily transactions on EthereumART("AAVE-MATIC","GAS_USD")
returns Aave daily gas usage in USD on PolygonART("DeFi-ETH", "DAU")
returns DeFi daily active addresses on EthereumART("Layer_2-ETH","GAS_USD")
returns daily Layer 2 Gas usage in USD on Ethereum
Artemis - Perpetuals
VRTX
,DYDX
,dYdX_v4
,RBX
,VRTX
,HYPERLIQUID
,GMX
,SNX
,MCB
,DRIFT
,GNS
,LVL
,PERP
Note:
π
dYdX_v4
includesTRADING_VOLUME
,TRADING_FEES
,TXN_FEES
but not yetUNIQUE_TRADERS
which is coming soonMetrics for
dYdX
are just for dYdX v3*Currently only for dYdX_v4
π Artemis - Lending
Supported Symbols: all lending exchanges on the Artemis Terminal
π Artemis - DEX
Supported Symbols: UNI
, CAKE
, SUSHI
π Artemis - Liquid Staking
Supported Symbols: LDO
, RPL
, FXS
DefiLlama
Supported Symbols: All chains and protocols on DefiLlama
Fees, Revenue, TVL, and DEX Volumes can be fetched by protocol version in the Sheets Plug-In. For example: =ART("uniswap-v3", "fees")
is supported!
For assets that don't have an Artemis ID like friend.tech from https://defillama.com/fees/friend.tech, you can just grab the string after fees/ or =ART("friend.tech","revenue")
to get revenue over the last 24 hours.
TokenTerminal
Supported Symbols: all tokens on TokenTerminal
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.
NFT Data (CoinGecko)
Supported Symbols: all CoinGecko NFT IDs are supported.
To find an NFT collection's CoinGecko NFT ID:
Navigate to the collection's Coingecko page. E.g. https://www.coingecko.com/en/nft/degods
The CoinGecko NFT ID is the right-most URL paramter. E.g., for https://www.coingecko.com/en/nft/degods, it is
degods
.
Last updated