How to scan the latest pairs added to Pancakeswap ?

By June 17, 2021Ethereum
Click here to view original web page at medium.com
https://pancakeswap.finance/

What is Pancakeswap?

PancakeSwap is a decentralized exchange for swapping BEP-20 tokens. PancakeSwap uses an automated market maker (AMM) model. That means that while you can trade digital assets on the platform, there isn’t an order book where you’re matched with someone else. Instead, you trade against a liquidity pool.

Those pools are filled with other users’ funds. They deposit them into the pool, receiving liquidity provider (or LP) tokens in return. They can use those tokens to reclaim their share, plus a portion of the trading fees.

So, in short, you can trade BEP-20 tokens, or add liquidity and earn rewards.

This is how Pancakeswap’s Decentralized Exchange looks like:

Some of the CryptoTools data analytics users have been interested in finding a way to get the latest tokens trading on Pancakeswap, most probably as a trading analytics tool.

As a result, I’ve created a Google Sheet templates that helps you filter new tradable coins.

The sheet returns all new tradable pairs on Pancakeswap, giving constraints on the Number of Days the pair has been active, the Volume ($), the Liquidity ($), and the number of Transactions.

In order to get Pancakeswap’s analytics I used GraphQL queries. GraphQL is an open-source data query and manipulation language for APIs, and a runtime for fulfilling queries with existing data.

The Graph which is an indexing protocol for querying networks like Ethereum and IPFS helped in creating and testing GraphQL queries. Using TheGraph, you can build and publish open APIs, called subgraphs, making data easily accessible.

In order for the Google Template sheet to run 24/7, I built the queries on private servers.

Example : Code snippet Pancakeswap GraphQL query

Get the first 100 pairs; returns id, symbols, prices, and volumes.

Example of Pancakeswap GraphQL query
query{
pairs( first: 100) {
token0 {
symbol
}
token0Price
token1 {
symbol
}
token1Price
id
volumeUSD
}
}

PANCAKESWAP FUNCTION IN GOOGLE SHEETS:
Returns new tradable pairs on Pancakeswap, giving constraints on the Number of Days the coin is active, the Volume ($), the Liquidity ($), and the number of Transactions.

For example, if I want to get the new Pancakeswap pairs where:

  • the pool was launched in the last 3 Days
  • the daily Volume is greater than $100'000
  • the Liquidity is above $100'000
  • and there has been more than 1'000 Transactions since the launch

The formula becomes:
=PANCAKESWAP(3,100000,100000,1000)

@param {days} the number of Days since the pair is active
@param {volume} the minimum Volume ($)
@param {liquidity} the minimum Liquidity ($)
@param {tx_count} the number of Transactions existant since creation

  • @return a table (see GIF above)with all new tradable pairs and their number of Days since Active, the Volume ($), the Liquidity ($), the number of Transactions. For those interested in getting the new pairs on Uniswap and Sushiswap, I’ve built the same queries which are also available in the the sheet.

Currently on Pancakeswap, I limited to pairs created in the last 5 days since currently reading Pancakeswap’s node takes more time than Uniswap and Sushiswap. It also helps optimize the servers response time. If you wish to have access to more than 5 days of data, drop by at https://t.me/TheCryptoCurious.

More indicators for scanning ?

There are plenty more functionalities that can be added through the TheGraph API. Don’t hesitate to have a look at all available end points like:

https://thegraph.com/explorer/subgraph/vmatskiv/pancakeswap-v2
  • totalSupply
  • untrackedVolumeUSD
  • liquidityProviderCount

If you are interested in getting some help in integrating more personalized indicators, DM me.

Conclusion

An easy accessible way to get the latest pairs on Pancakeswap using Google Sheets which can be used for data analytics, and as a trading tools for screening of new market participants.

All Today's Crypto News In One Place