Links

DEX (Decentralized Exchange) Data

Cryptofinance enables users to pull in data from various DEXs.
Pricing: This data point requires standard subscription plan.
Google Sheet & Excel
Airtable

Supported Exchanges

  • uniswap-v3
  • sushiswap
  • traderjoe
  • pancakeswap
  • curve
  • balancer
  • quickswap

Full Listing

Returns a list of the top pools ordered by TVL .
=CRYPTOFINANCE("exchange name here")
Example:
=CRYPTOFINANCE("uniswap-v3")
The following pool data will be returned:
  • Symbol
  • Pool
  • Price
  • TVL USD
  • APY %
  • APY 30D AVG %
  • Volume USD 24H
  • Volume USD 7d
  • Last Updated

Exchange Pool Data

The following fields can be fetched for a single pool.
=CRYPTOFINANCE("exchange:symbol", "attribute")
Example:
=CRYPTOFINANCE("pancakeswap:CAKE-WBNB", "pool")
=CRYPTOFINANCE("pancakeswap:CAKE-WBNB", "price")
=CRYPTOFINANCE("pancakeswap:CAKE-WBNB", "tvl")
=CRYPTOFINANCE("pancakeswap:CAKE-WBNB", "apy")
=CRYPTOFINANCE("pancakeswap:CAKE-WBNB", "avg_apy_1m")
=CRYPTOFINANCE("pancakeswap:CAKE-WBNB", "volume")
=CRYPTOFINANCE("pancakeswap:CAKE-WBNB", "volume_1w")

Full Pool Listing

List of all pools on a DEX along with each pool's data points.
1. From the sidebar click Exchange Data. 2. Select a DEX. (Click here to see list of DEX) 3. Make sure All Markets is selected as Type. 4. Click run.

Pool Specific Data

You can fetch the following data for the specific pools:
  • Pool
  • Price
  • TVL
  • APY
  • AVG APY 1M
  • Volume
  • Volume 1W
1. From the sidebar click Exchange Data. 2. Select a DEX. (Click here to see list of DEX) 3. Make sure Specific Markets is selected as Type. 4. Select Market Field which points to the field where you entered the market pairs. (Example pair: BTC/USD.) 5. Select the metrics you want to fetch. 6. Click run.