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. …


Simple Google Sheet Tricks to value your digital assets. Duplicate the sheet and make it your own.

TRY IT OUT: LIVE SAMPLE SHEET

Image : Portfolio Valuation Example using Google Sheets

At first, when I created CRYPTOTOOLS, I wanted to have a private flexible way to analyze whale moves on the blockchain, value trades I had made, find arbitrage opportunities and compute statistics in Google Sheets. Then friends got interested, so I made it more efficient and made the sheets public for everyone. I hope you can benefit from my work. …


UPDATE 17th May: Now you can call array of tickers instead of single cells UPDATE 26th April: LIST OF ALL AVAILABLE COINS HERE

For anyone looking to extract automatically cryptocurrency prices from Decentralized Exchanges.

No coding skills are required, made for non developers.

First step is to access the following template sheet to see how the data is retrieved in Google Sheets.

TEST GOOGLE SHEET EXAMPLE HERE


Source : https://sushiswap.fi/

Update: for those interested on having the latest pairs for Uniswap -> go Here

What is Sushiswap ?

SushiSwap is a software running on Ethereum that seeks to incentivize a network of users to operate a platform where users can buy and sell crypto assets. Similar to platforms like Uniswap and Balancer, SushiSwap uses a collection of liquidity pools to achieve this goal. Users first lock up assets into smart contracts, and traders then buy and sell cryptocurrencies from those pools, swapping out one token for another.

One of a growing number of decentralized finance (DeFi) platforms, SushiSwap allows users to trade cryptocurrencies without…


Source: https://defipulse.com/

Live Google Sheet Here

What is TVL — Total Value Locked in DeFi?

According to ZDL Crypto Wiki, Many DeFi tracking sites use Total Locked Value (TVL) as a reference point. Simply put, TVL represents the amount of assets that are currently being staked in a specific protocol. This value is by no means meant to represent the amount of outstanding loans, but rather the total amount of underlying supply being secured by a specific application and/or by DeFi as a whole.”

TVL measures the total value of the tokens locked within these dapps with the argument going that the higher the value locked up in a DeFi…


Image: Prime Investors

What is the Price Earnings Ratio in traditional finance?

The Price Earnings Ratio (P/E Ratio) is the relationship between a company’s stock price and earnings per share (EPS). It is a popular ratio that gives investors a better sense of the value of the company. The P/E ratio shows the expectations of the market and is the price you must pay per unit of current earnings (or future earnings, as the case may be).

Earnings are important when valuing a company’s stock because investors want to know how profitable a company is and how profitable it will be in the future. Furthermore, if the company doesn’t grow and the…


https://uniswap.org/

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…


NEW COINGECKO_V2:
June 2021: Chart Sparklines for price, volume, market cap. May 2021: Request array of tickers GeckoPrice, GeckoVolume, GeckoCap etc.. New function GeckoLogo

For anyone looking to extract automatically data from CoinGecko.

No coding skills are required, made for non developers looking to retrieve cryptocurrency prices, volumes, market-caps… from any currency.

First step is to access the following template sheet to see how the formulas are used in Google Sheets.

TEST GOOGLE SHEET EXAMPLE HERE

Second step, I’ll describe the use of each function.

Cryptocurrency Prices

If you are looking to retrieve the latest price for any cryptocurrency, you will need…


Simple Google Sheet Tools to value your crypto and stock assets. Duplicate the sheet and make it your own.

TRY IT OUT: LIVE SAMPLE SHEET

Image : Portfolio Valuation Example using Google Sheets, Duplicate and Make it your own

At first, when I created CRYPTOTOOLS, I wanted to have a private flexible way to analyze whale moves on the blockchain, value trades I had made, find arbitrage opportunities and compute statistics in Google Sheets. Then friends got interested, so I made it more efficient and made the code public for everyone. I hope you can benefit from my work. And for developers who wish to directly connect to my API, let me know. …

Eloise

Fintech | Blockchain Enthusiast

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store