How to easily obtain the latest coin listing information on Uniswap?

As the leader of DeFi, Uniswap’s trading volume has surpassed many small and medium-sized exchanges. Observing the new token trading pairs on Uniswap will help us understand the latest trends.

This article teaches you how to use Google Spreadsheets to easily customize your own tracking tools without writing code, so you can stay updated on new trading pairs on Uniswap. At the end of the article, some suggestions for extended gameplay will also be provided. If you are interested, remember to save it.

Uniswap is a decentralized trading protocol built on Ethereum. It provides an automatic market maker mechanism that enables instant trading without placing orders or counterparties. Prices are automatically calculated by smart contract algorithms. The emergence of Uniswap allows users to trade without intermediaries, realizing a highly decentralized autonomous trading method.

On Uniswap, traders can trade ERC20 tokens, or inject their own cryptocurrencies into the liquidity token pool to provide liquidity for other traders. In return, they can earn transaction fees.

Uniswap provides a list of tokens

In this worksheet, all new tradable token pairs on Uniswap will be returned based on your selection criteria. The screening criteria include the number of active days online, transaction amount (USD), liquidity depth (USD), and transaction volume of the token pair.

You can change your own filtering conditions, and the worksheet will automatically update the corresponding token information. In order to help domestic users, the Blockchain Study Society has translated the important contents of the original worksheet:

How to create it? First open the document link:

https://docs.google.com/spreadsheets/d/1rWLBg3s14G4zgf6UnhfcM3S6fmiJ2fPmNZ2LzEqOwOY/edit?usp=sharing

After logging in, click the File menu bar and select Create a copy from the drop-down options to get your own version. Based on this, you can modify the style or content.

Using the UNISWAP function in Google Sheets. We added the filter condition and immediately got the corresponding token pair results in the Uniswap trading pool, precisely because we used a custom function like UNISWAP.

• The pool was online within the last 7 days
• Daily transaction volume is greater than $10,000.
• The fund depth in the liquidity pool exceeds 30,000 US dollars

• Since its launch, there have been over 1,00 transactions.

Then, the screening formula I need to use is: UNISWAP(7,10000,30000,100)

In fact, in the table above, we have put these complicated tasks behind the scenes. All you need to do is to select conditions such as online time, transaction amount, transaction depth and transaction volume, and then get your own watch list.

You can also modify the ready-made templates to create your own unique tracking tools according to your needs. However, for most situations, the existing indicators are sufficient. If you need to further study, you can use this as an introduction to do more homework.

Another solution

If you prefer to use an existing tool, we also provide an additional option, https://tokenscan.xyz.

The function of this page is the same as the above worksheet. After entering your own filtering criteria, click the "Search Uniswap Pools" button to get the results.

Click on the workbook for the Portfolio Pivot Table

Here you can add the tokens and corresponding addresses you hold in your digital asset wallet. In the quantity column, the corresponding amount will be automatically queried based on your token symbol and token address. In the price column, the price of the corresponding token will also be obtained from the Internet, thereby calculating your holdings data.

Through the GoogleCoinGecko tool, you can directly query the price, 24-hour trading volume, market value, etc. of the corresponding token through the interface of the CoinGecko platform. Although you can query these data from the website and copy them into your own analysis table, these methods built into Google Sheets can improve your analysis efficiency and save you from having to do these repetitive tasks.

Due to space limitations, this part will not be expanded. Here are some related article links for interested readers to check out.

For example, how to add the staking status of PoS tokens to the worksheet, you can refer to this article: https://medium.com/the-cryptocurious/staking-balances-rewards-on-pos-tokens-tezos-cosmos-nano-eos-6353dcc1553f

How to get real-time interest rate information on DeFi platforms, you can read this article: https://medium.com/the-cryptocurious/arbitrage-get-realtime-lending-rates-from-defi-platforms-dee24830ee85?source=collection_home

If you have any questions, you are welcome to leave a message and we can discuss it together.

Of course, Uniswap is an open DEX, and along with the so-called wealth code, there are also risks that come with it. Fortunately, you who read this article should also be a reader with strong independent thinking ability and can make your own investment judgment. The tools proposed in this article are only for reference. In the actual investment process, they can be used as clues for further research and investigation. After all, investment is not a trivial matter, and there is still a lot of homework to be done.

-END-

Author: Eloise

Translation: Jing Kai

Source: https://medium.com/coinmonks/how-to-scan-the-latest-pairs-added-to-uniswap-31c4400cc2a6

Statement: This article is the author’s independent opinion, does not represent the position of Blockchain Research Society (public account), and does not constitute any investment opinion or suggestion.