Open in app

Sign in

Write

Sign in

How to scan the latest pairs added to Pancakeswap ?

Eloise
Coinmonks

--

https://pancakeswap.finance/

NEW July -> Telegram bot for: Created pools in the past 15min & $Volume >$3'000 & $Liquidity >$10'000 & Nb transaction >30

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:

The PancakeSwap exchange UI

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.

ACCESS LIVE TEMPLATE SHEET HERE

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.

In Google Sheets =PANCAKESWAP(3, 100'000, 100'000, 1'000)

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.
New Tradable Pairs on Uniswap (Left) and Sushiswap (right)

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.

This is ongoing work. If you find errors, please do not hesitate to let me know. Feedback is very welcomed. A telegram chat is also available for support. If this project adds any value to you and/or are looking for personalized coding on your Google Sheets, don’t hesitate to leave a message.

I’ve built more Google Sheet Tools where you can value crypto, stock, liquidity pools.. Don’t hesitate to check my profile if you want to see more.

The opinions expressed are for general informational purposes only and are not intended to provide specific advice or recommendations for any individual or on any specific security or investment product. It is only intended to provide education about the crypto industry.

Thank you so much for investing your time in reading this article.

Join Coinmonks Telegram Channel and learn about crypto trading and investing

Also, Read

--

--

Eloise
Coinmonks

Written by Eloise

674 Followers
Writer for

AI | Data | Blockchain Enthusiast | patreon.com/cryptotools