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 dapp, the better. …
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 current level of earnings remains constant, the P/E can be interpreted as the number of years it will take for the company to pay back the amount paid for each share. …
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:
UPDATE 7Jan 2020: New GeckoChange %, GeckoHist formula
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.
Second step, I’ll describe the use of each function.
If you are looking to retrieve the latest price for any cryptocurrency, you will need to use the GECKOPRICE() formula. …
Simple Google Sheet Tricks to value your assets without relying on 3rd party apps. Duplicate the sheet and make it your own.
TRY IT OUT: LIVE SAMPLE SHEET
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. …
Objective: Show users how they can easily access the custom built-in CryptoTools formulas in Google Sheet:
ACCESS LIVE SAMPLE SHEET to have a better idea of how they can be used.
You will need:
2. Go to Tools › Script editor
UPDATE TRY IT OUT: LIVE SAMPLE SHEET
I wrote this medium in complement to Pull Crypto Wallet Balance directly on Google Sheets where you can retrieve almost any cryptocurrency (150+ with biggest market cap) balance from a wallet address and the article Pull realtime lending rates from DeFi platforms where I show you how to benefit from arbitrage opportunities on lending rates.
I wrote this medium in complement to the medium Pull Crypto Wallet Balance directly on Google Sheets where you can retrieve almost any cryptocurrency (150+ with biggest market cap) balance from a cold wallet address.
This article will be useful for you, if you want to arbitrage lending platforms. Or if you need to keep a tab/perform some accounting on the cryptocurrency amounts you have earned or the amounts you owe from lending/borrowing cryptocurrencies. I’ll be using Google Sheets, it is a free, web-based program for creating and editing spreadsheets.
At the end of this medium, you will be able to automatically retrieve borrowing and lending rates on the following lending…
UPDATE TRY IT OUT: LIVE SAMPLE SHEET
If you want to get in real time anyone’s wallet balance, you’ll need:
This is what your Google Sheet will look like once you finish the setup: