Skip to content

Latest commit

 

History

History
405 lines (312 loc) · 19.3 KB

README.md

File metadata and controls

405 lines (312 loc) · 19.3 KB

CRYPTOCURRENCY TOOLS USED IN GOOGLE SHEETS

Link to Google Sheets public template!
Link to the Medium Publication
Link to Google Sheet's Set-up
API Documentation
Discord

FUNCTIONS

| Cryptobalance | Prices on DEX | Staking | Rewards | Lending | Farming | Dollar Valuation by address | DEX 24h Volumes | DEX TVL | DEX fees | Pool Price | Number of Holders per contract | List of Holders | New Tradeable Pairs | Volatility | Futures | Gas price (ETH) | List of Transactions | Binance Withdrawal Fees | Historical OHLC

PREMIUM

| Crypto DEX new pairs | Top Nfts by address | BTC balance with unconfirmed tx | BTC positive flows with unconfirmed tx | Historical OHLC | Max Token Supply | Multiple chain Transactions (BTC, BNB, ETH, OP, MATIC...)

CRYPTOBALANCE

Get your cryptocurrency balance in your Google Sheets.

alt text

=CRYPTOBALANCE("TICKER","ADDRESS", refresh_cell)
EXAMPLE =CRYPTOBALANCE("USDT","0xf977814e90da44bfa03b6295a0616a897441acec", $A$1)

SPECIAL CASES ERC20, BEP20, MATIC, AVAX, TEZOS, SOLANA ... tokens that are not in the available token list:

You can call the balance using its contract address
=CRYPTOBALANCE(" ERC20 contract address","ERC20 holder address")
=CRYPTOBALANCE("b"+ "BEP20 contract address","holder address")
=CRYPTOBALANCE("m"+ "MATIC contract address", "holder address")
=CRYPTOBALANCE("a"+ "AVAX contract address", "holder address")
=CRYPTOBALANCE("f"+ "FANTOM contract address", "holder address")
=CRYPTOBALANCE("arb"+ "ARBITRUM contract address", "holder address")
=CRYPTOBALANCE("movr"+ "MOONRIVER contract address", "holder address")
=CRYPTOBALANCE("celo"+ "CELO contract address", "holder address")
=CRYPTOBALANCE("wan"+ "WANCHAIN smart contract address", "holder address")
=CRYPTOBALANCE("aurora"+ "AURORA smart contract address", "holder address")
=CRYPTOBALANCE("op"+ "OPTIMISTIC smart contract address", "holder address")
=CRYPTOBALANCE("palm"+ "PALM NETWORK smart contract address", "holder address")
=CRYPTOBALANCE("cronos"+ "CRONOS NETWORK smart contract address", "holder address")
=CRYPTOBALANCE("gnosis"+ "GNOSIS NETWORK smart contract address", "holder address")
=CRYPTOBALANCE("evmos"+ "EVMOS contract address", "holder address")
=CRYPTOBALANCE("moon"+ "MOONBEAM contract address", "holder address")
=CRYPTOBALANCE("doge"+ "DOGECHAIN contract address", "holder address")
=CRYPTOBALANCE("TEZOS contract address","holder address")
=CRYPTOBALANCE("SOLANA contract address","holder address")
=CRYPTOBALANCE("TRON contract address","holder address")
=CRYPTOBALANCE("XRP contract address","holder address")

Available coins ERC20-BEP20 Other Blockchains Staking Rewards

LIST ALL TOKEN AMOUNTS ON EVM

Returns the list of all tokens on all chains or on a specific chain like eth, matic, bsc, xdai, ftm, avax, op, arb, celo, movre, cvo, aurora etc ...

alt text

=CRYPTOTOKENLIST("ADDRESS","CHAIN optional")
You can also retrieve the list of tokens on
  • solana (sol)
  • tezos (xtz)
  • terra (luna)
  • tron (tron)
  • cardano (ada)
  • wanchain (wan)
EXAMPLE =CRYPTOTOKENLIST("0xdb3b93c27442c1dcb52537d6fca7b8a1d7f8c50b")
EXAMPLE =CRYPTOTOKENLIST("BV3kgWcxB7txcfVMywYp3ZqwkYujrd3HePMkujAK5xFR")

DEX

CRYPTOCURRENCY PRICES ON DEX

Returns prices of cryptocurrency prices on different decentralized exchanges, 1INCH, UNI, CAKE, SUSHI, MATIC, PANGOLIN, FANTOM, OSMOSIS, DEXLAB are available for the moment.

List of networks/exchanges ticker to use

Ethereum Smart chain UNI - Uniswap V2 on ERC20 - 1INCH - 1INCH on ERC20 - SUSHI - Sushiswap on ERC20
Binance Smart Chain - CAKE - Pancakeswap V2 on BEP20 - BABY - Babyswap on BEP20
Matic/Polygon Smart Chain - QUICK - Quickswap on polygon - MATIC - Sushiswap on Polygon/Matic
Fantom Chain- BOO - Spookyswap on Fantom - FTM - Sushiswap on Fantom
Solana Chain - FIDA - Bonfida on Solana - DXL - DEXLabs on Solana
Cosmos Chain - OSMO - Osmosis on Cosmos
Celo Chain - CELO - Sushiswap on Celo
Avalanche Chain - PNG - Pangolin on Avalanche - JOE - TraderJoe on Avalanche
Aurora Chain - TRI - Trisolaris/Near on Aurora - WANNA - Wannaswap on Aurora

DEXPRICE

=CRYPTODEXPRICE(ticker1/contract_address_1, ticker2/contract_address_2, exchange ticker)
EXAMPLE =CRYPTODEXPRICE("ETH","BAL","1INCH")

Prices from Sushiswap's exchange on the Polygon/Matic network

DEXPRICE_MaticSushi

EXAMPLE =CRYPTODEXPRICE("WMATIC","WETH","MATIC")

Prices from Sushiswap's exchange on the Fantom network

DEXPRICE_FantomSushi

EXAMPLE =CRYPTODEXPRICE("WMFTM","USDC","FTM")

Prices from Pangolin's exchange on the Avalanche network

DEXPRICE_AvaxPangolin

EXAMPLE =CRYPTODEXPRICE("ETH","WAVAX","PNG")

Prices from DexLab's exchange on the Solana network

DEXPRICE_DexLabSolana

EXAMPLE =CRYPTODEXPRICE("BTC","USDC","DXL")

Prices from Osmosis' exchange on the Cosmos network

DEXPRICE_OsmosisCosmo

EXAMPLE =CRYPTODEXPRICE("ATOM","OSMO","OSMO")

Prices from Quickswap's exchange on Matic's network

DEXPRICE_QuickswapMatic

EXAMPLE =CRYPTODEXPRICE("WBTC","USDC","QUICK")

Prices from Sushiswap's exchange on Celo's network

DEXPRICE_SushiswapCelo

EXAMPLE =CRYPTODEXPRICE("BTC","CUSD","CELO")

Prices from Spookyswap's exchange on Fantom's network

DEXPRICE_FantomSUSHISWAP

EXAMPLE =CRYPTODEXPRICE("FUSDT","WFTM","BOO")

Prices from TraderJoe's exchange on Avalanche's network

DEXPRICE_AVAXJOE

EXAMPLE =CRYPTODEXPRICE("WAVX","BNB","JOE")

Prices from Trisolaris' / NEAR exchange on Aurora EVM

DEXPRICE_AURORATRI

EXAMPLE =CRYPTODEXPRICE("SAFE","WETH","TRI")

Prices from Wannaswap's exchange on Aurora EVM

DEXPRICE_AURORAWANNA

EXAMPLE =CRYPTODEXPRICE("LOCK","USDT","WANNA")

CRYPTOSTAKING

Returns the amount STAKED on PoS cryptocurrencies

EOS(EOS) TEZOS(XTZ) COSMOS(ATOM) NANO(NANO)
Support for other major altcoins is coming later in 2019.

CRYPTOREWARDS

Returns REWARDS on the staked cryptocurrencies

TEZOS(XTZ) COSMOS(ATOM)
Support for other major PoS altcoins is coming later in 2019.

alt text alt text alt text

=CRYPTOBALANCE("TICKER","ADDRESS", refresh_cell)
EXAMPLE =CRYPTOBALANCE("XTZ","tz1MtsStCawfc8cHUnUKhTJV2QxrH9Z7aM7W",$A$1)

=CRYPTOSTAKING("TICKER","ADDRESS", refresh_cell)
EXAMPLE =CRYPTOSTAKING("XTZ","tz1MtsStCawfc8cHUnUKhTJV2QxrH9Z7aM7W",$A$1)

=CRYPTOREWARDS("TICKER","ADDRESS", refresh_cell)
EXAMPLE =CRYPTOREWARDS("XTZ","tz1MtsStCawfc8cHUnUKhTJV2QxrH9Z7aM7W",$A$1)

CRYPTOLENDING

Get the cryptocurrency lending rate from multiple lending platforms.

Example of available exchanges: MAKER - COMPOUND - YEARN - DYDX - NUO - NEXO - CELSIUS - AAVE - FULCRUM -NEXO
Example of available cryptocurrencies: ETH - DAI- USDC- BAT- ZRX- WBTC - SAI - USDT - SNX etc...

LENDINGARRAY

=CRYPTOLENDING("LENDING PLATFORM","TICKER","SIDE", refresh_cell)
EXAMPLE =CRYPTOLENDING("COMPOUND","ETH","APR_BORROW", refresh_cell)

LENDINGARRAY2

CRYPTO FARMING

Returns apy and tvl from tokens or pools on decentralized exchanges

CRYPTOFARMING

List of exchanges
  • CAKE
  • CRV
  • FARM
  • SUSHI
  • XVS
  • YEARN
  • BUNNY
  • PNG
  • BOO
  • AUTO
  • SPIRIT
  • BABY
  • WAULT
  • MDEX
  • YFI
  • ...
EXAMPLE =CRYPTOFARMING("SUSHI","UNI-WETH","APY")
EXAMPLE =CRYPTOFARMING("SUSHI","UNI-WETH","TVL")

DOLLAR VALUATION BY ADDRESS

Returns the USD total amount of ERC20, BEP20 or MATIC address

CRYPTO_SUM$

EXAMPLE =CRYPTOSUMUSD("holder's address","network" as optional)

DEX VOLUMES

Returns DEXes' (decentralized exchanges) 24H Volume.

DEXVOLUME

=CRYPTODEXVOLUME("DEX ticker/name")
EXAMPLE =CRYPTODEXVOLUME("LEND")

DEX TVL

alt text

Returns DEXes' (decentralized exchanges) Total Cryptocurrency Value Locked ($)

TVL

=CRYPTOTVL("DEX ticker/name")
EXAMPLE =CRYPTOTVL("UNI")

DEX Fees

Returns DEXes' (decentralized exchanges) takers fee that compensates liquidity providers.

DEXFEE

=CRYPTODEXFEE("DEX PLATFORM ticker/name")
EXAMPLE =CRYPTODEXFEE("MAKER")

POOL PRICE

Returns prices from decentralized Pool tokens.

CRYPTOPOOLPRICE

EXAMPLE =CRYPTOPOOLPRICE("YVCURVE-BBTC","YEARN")

CRYPTOSUPPLY

Returns the max supply on a list of erc20, bep20, matic, avalanche, fantom, moon-river and arbitrum tokens.
Available Networks
- ERC (erc20)
- BEP (binance smart chain)
- MATIC (polygon smart chain)
- ARB (arbitrum smart chain)
- AVAX (avalanche smart chain)
- FTM (fantom smart chain)
- MOVR (moon-river smart chain)

CRYPTOSUPPLY

=CRYPTOSUPPLY(Ticker or smart contract, network)
EXAMPLE =CRYPTOSUPPLY("ETH","ERC")
EXAMPLE =CRYPTOSUPPLY("0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82","BEP")
EXAMPLE =CRYPTOSUPPLY(E39:E100,F39:F100)

CRYPTOHOLDERCOUNT

Returns the number of holders on a list of erc20, bep20, matic, avalanche, fantom, moon-river and arbitrum tokens.
Available Networks
- ERC (erc20)
- BEP (binance smart chain)
- MATIC (polygon smart chain)
- AVAX (avalanche smart chain)
- FTM (fantom smart chain)
- MOVR (moon-river smart chain)

CRYPTOHOLDERS

=CRYPTOHOLDERCOUNT(Ticker or smart contract, network)
EXAMPLE =CRYPTOHOLDERS("ETH","ERC")
EXAMPLE =CRYPTOHOLDERS("0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82","BEP")
EXAMPLE =CRYPTOHOLDERS(E39:E100,F39:F100)

CRYPTO_HOLDER

Returns the list of holders on ERC20 and BEP20

CRYPTO_HOLDERERC

EXAMPLE =CRYPTO_HOLDER_ERC20("holder's address")

CRYPTO_HOLDERBEP

EXAMPLE =CRYPTOTX_HOLDER_BEP20("holder's address")

New tradable pairs

Returns new tradable pairs on Uniswap, Sushiswap (Arbitrum+Ethereum) , Pancakeswap giving constraints on the number of Days Active, the Volume ($), the Liquidity ($), the number of Transactions

UNISWAP

=UNISWAP(days,volume,liquidity,tx_count)
EXAMPLE =UNISWAP(5,10000,10000,100)
=SUSHISWAP(days,volume,liquidity,tx_count)
EXAMPLE =SUSHISWAP(5,10000,10000,100)

VOLATILITY

Returns the 30d % volatility of a cryptocurrency against USD, ETH, or BTC

CRYPTO_VOLATILITY

EXAMPLE =CRYPTO_HOLDER_ERC20(TICKER,VS_CURRENCY)
EXAMPLE=CRYPTOVOL30D("ETH")
EXAMPLE=CRYPTOVOL30D("ETH","BTC")

FUTURES

Returns BTC or ETH Futures Prices, basis, volume, open interest

CRYPTOFUTURES_BTC

EXAMPLE =CRYPTOFUTURES("BTC")
EXAMPLE =CRYPTOFUTURES("ETH")

GAS PRICE

Returns the average GWEI gas price into Google spreadsheets. Only ETH available now.

CRYPTOFUTURES_BTC

EXAMPLE =CRYPTOGAS("ETH")

CRYPTOTX

Returns the list of transactions on ERC20 and BEP20

CRYPTOTXERC

EXAMPLE =CRYPTOTX_ERC20("holder's address")

CRYPTOTXBEP

EXAMPLE =CRYPTOTX_BEP20("holder's address")

CRYPTOLATESTPAIRS

Returns new tradable pairs by DEX and chain, giving constraints on the number of Days Active, the Volume ($), the Liquidity ($), the number of Transactions. Premium Function.
Here is the list of all available chain&DEX:
ETH -- UNI-V2, UNI-V3, SUSHI
MATIC -- QUICK, UNI-V3, SUSHI, ALGB
AVAX -- PNG, JOE
MOVR -- SOLAR, SUSHI
FTM -- BOO, SPIRIT
ONE -- VIPERSWAP
ARBITRUM -- UNI-V3, SUSHI
AURORA -- TRI, WANNA

CRYPTOTLATESTPAIRS

EXAMPLE =CRYPTOLATESTPAIRS(10,2000,10000,0,"ETH","UNI-V3")

HISTORICAL OHLC

Returns the historical cryptocurrency OHLC. Open, High, Close, Volume, Low
Premium Plan for historical data greater than 3mth.

CRYPTOHIST

EXAMPLE =CRYPTOHIST("BTC","CLOSE","2020-01-01","2021-12-31")

BINANCE WITHDRAWAL FEES

Returns the list of withdrawal fees from Binance by ticker and network

BINANCEWITHDRAWLFEES

EXAMPLE =BINANCEWIDRAWFEE("1INCH","BSC")

BINANCEFEES

LIST TOP NFTS

Returns the top 5 NFTs, dollar value, total sum on an ethereum address. Premium Function.

TOPNFTS

EXAMPLE =TOPNFT("0xc36442b4a4522e871399cd717abdd847ab11fe88")

BTC BALANCE ACCOUNTING FOR UNCONFIRMED TRANSACTIONS

Returns the balance on a BTC including the unconfirmed transactions from the mempool, you can request up to 5 address in one call. Premium Function.

BTCUNCONFIRMEDTX

EXAMPLE =BTCBALANCE_UNCONFIRMED("17bMJF9LPBVU1aN8YMVg5Y754tzjJiTMzH")

BTC POSITIVE FLOWS WITH UNCONFIRMED TRANSACTIONS

Returns the BTC balance of positive inflows including the unconfirmed transactions from the mempool, you can request up to 5 address in one call. Premium Function.

BTCUNCONFIRMEDTX

EXAMPLE =BTCBALANCE_UNCONFIRMEDIN("bc1qh5y7707wtqgyl65vegxrrm46xmlk2pn8mmcwyd")

CRYPTO TRANSACTION LIST

Returns the historical transaction list on a range of addresses. Premium Function for multiple chains/addresses.

CRYPTOALLTX

EXAMPLE =CRYPTOTX("bc1q0c36c38k2shz4jetd0a6nmlhahxd5alqmz3xcj","BTC")

CRYPTO TOOLS SETUP

1. Open a Google sheet where you wish to use CRYPTOBALANCE(), CRYPTOLENDING(), CRYPTOSTAKING() or CRYPTOREWARDS(), UNISWAP(), DEXPRICES() etc ..
2. Go to Tools › Script editor
3. Copy the content of CRYPTOTOOLS and paste it in the script editor (replace any existing content).
4. Save the script with File › Save, name it CRYPTOTOOLS, then close the script editor
5. Back to your Google sheet, refresh the page, a CRYPTOTOOLS menu will appear next to Help with more information about the , CRYPTOBALANCE, CRYPTOSTAKING, CRYPTOREWADS & CRYPTOLENDING, UNISWAP, DEXPRICES functions.

Now the functions are available for use! Try it out!

Link to Google Sheets!