Awesome
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.
=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 ...
=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
=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
EXAMPLE =CRYPTODEXPRICE("WMATIC","WETH","MATIC")
Prices from Sushiswap's exchange on the Fantom network
EXAMPLE =CRYPTODEXPRICE("WMFTM","USDC","FTM")
Prices from Pangolin's exchange on the Avalanche network
EXAMPLE =CRYPTODEXPRICE("ETH","WAVAX","PNG")
Prices from DexLab's exchange on the Solana network
EXAMPLE =CRYPTODEXPRICE("BTC","USDC","DXL")
Prices from Osmosis' exchange on the Cosmos network
EXAMPLE =CRYPTODEXPRICE("ATOM","OSMO","OSMO")
Prices from Quickswap's exchange on Matic's network
EXAMPLE =CRYPTODEXPRICE("WBTC","USDC","QUICK")
Prices from Sushiswap's exchange on Celo's network
EXAMPLE =CRYPTODEXPRICE("BTC","CUSD","CELO")
Prices from Spookyswap's exchange on Fantom's network
EXAMPLE =CRYPTODEXPRICE("FUSDT","WFTM","BOO")
Prices from TraderJoe's exchange on Avalanche's network
EXAMPLE =CRYPTODEXPRICE("WAVX","BNB","JOE")
Prices from Trisolaris' / NEAR exchange on Aurora EVM
EXAMPLE =CRYPTODEXPRICE("SAFE","WETH","TRI")
Prices from Wannaswap's exchange on Aurora EVM
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.
=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...
=CRYPTOLENDING("LENDING PLATFORM","TICKER","SIDE", refresh_cell)
EXAMPLE =CRYPTOLENDING("COMPOUND","ETH","APR_BORROW", refresh_cell)
CRYPTO FARMING
Returns apy and tvl from tokens or pools on decentralized exchanges
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
EXAMPLE =CRYPTOSUMUSD("holder's address","network" as optional)
DEX VOLUMES
Returns DEXes' (decentralized exchanges) 24H Volume.
=CRYPTODEXVOLUME("DEX ticker/name")
EXAMPLE =CRYPTODEXVOLUME("LEND")
DEX TVL
Returns DEXes' (decentralized exchanges) Total Cryptocurrency Value Locked ($)
=CRYPTOTVL("DEX ticker/name")
EXAMPLE =CRYPTOTVL("UNI")
DEX Fees
Returns DEXes' (decentralized exchanges) takers fee that compensates liquidity providers.
=CRYPTODEXFEE("DEX PLATFORM ticker/name")
EXAMPLE =CRYPTODEXFEE("MAKER")
POOL PRICE
Returns prices from decentralized Pool tokens.
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(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)
=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
EXAMPLE =CRYPTO_HOLDER_ERC20("holder's address")
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(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
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
EXAMPLE =CRYPTOFUTURES("BTC")
EXAMPLE =CRYPTOFUTURES("ETH")
GAS PRICE
Returns the average GWEI gas price into Google spreadsheets. Only ETH available now.
EXAMPLE =CRYPTOGAS("ETH")
CRYPTOTX
Returns the list of transactions on ERC20 and BEP20
EXAMPLE =CRYPTOTX_ERC20("holder's address")
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
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.
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
EXAMPLE =BINANCEWIDRAWFEE("1INCH","BSC")
LIST TOP NFTS
Returns the top 5 NFTs, dollar value, total sum on an ethereum address. Premium Function.
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.
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.
EXAMPLE =BTCBALANCE_UNCONFIRMEDIN("bc1qh5y7707wtqgyl65vegxrrm46xmlk2pn8mmcwyd")
CRYPTO TRANSACTION LIST
Returns the historical transaction list on a range of addresses. Premium Function for multiple chains/addresses.
