DEX (Decentralized Exchange) Data
Cryptofinance enables users to pull in data from various DEXs.
Google Sheet & Excel
Airtable
uniswap-v3
sushiswap
traderjoe
pancakeswap
curve
balancer
quickswap
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
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")
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.

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.

Last modified 2mo ago