How to scan the latest pairs added to Uniswap ?
NEW July -> Telegram bot for: Created pools in the past 15min & $Volume >$3'000 & $Liquidity >$10'000 & Nb transaction >30
UPDATE 2021: Added SUSHISWAP & PANCAKESWAP to Template Sheet
What is Uniswap?
Uniswap is a decentralized exchange protocol built on Ethereum. To be more precise, it is an automated liquidity protocol. There is no order book or any centralized party required to make trades. Uniswap allows users to trade without intermediaries, with a high degree of decentralization and censorship-resistance.
Traders can exchange Ethereum tokens (ERC20) on Uniswap without having to trust anyone with their funds. Meanwhile, anyone can lend their crypto to special reserves called liquidity pools. In exchange for providing money to these pools, they earn fees.
This is how Uniswap’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 Uniswap, 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 Uniswap, 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 Uniswap’s analytics I used The Graph which is an indexing protocol for querying networks like Ethereum and IPFS. Anyone can use, build and publish open APIs, called subgraphs, making data easily accessible.
UNISWAP FUNCTION IN GOOGLE SHEETS:
Returns new tradable pairs on Uniswap, 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 Uniswap pairs where:
- the pool was launched in the last 7 Days
- the daily Volume is greater than $20'000
- the Liquidity is above $30'000
- and there has been more than1'000 Transactions since the launch
The formula becomes:
=UNISWAP(7,20000,30000,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 on Uniswap and their number of Days since Active, the Volume ($), the Liquidity ($), the number of Transactions, exactly like the Token Scan view below:
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:
- 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 Uniswap 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.
Thank you so much for investing your time in reading this article.
Take care of yourself & your family in these challenging times!
Join Coinmonks Telegram Channel and Youtube Channel get daily Crypto News
