NEW FUNCTION: CRYPTOHOLDERS
Returns a table with the biggest holders by contract address and by chain:
=CRYPTOHOLDERS("0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82","bep")
raw.githubusercontent.com/El…
Coingecko Google Sheet Code Set-Up
youtube.com/watch?v=___BlVNV…
Function CRYPTOHIST
Returns the historical cryptocurrency OHLC. Open, High, Close, Volume, Low.
For example:
=CRYPTOHIST("BTC","CLOSE","2020-01-01","2021-12-31")
Make sure you have the latest version of the cryptotools code which can be found here:
raw.githubusercontent.com/El…
Function #Binance Withdrawal #Fees
=BINANCEWIDRAWFEE("1INCH","BSC")
patreon.com/posts/function-b…
#sheets #google #analytics
1
2
#FUNCTION GECKOHISTBYDAY_ID
Imports CoinGecko's cryptocurrency price, volume and market cap into Google spreadsheets using the API ID from #Coingecko.
=GECKOHISTBYDAY_ID("matic-network","eur","price", "31-12-2021")
patreon.com/posts/function-i…
2
NEW UPDATE CRYPTODEXPRICE
You can now request USD prices on DEX exchanges
=CRYPTODEXPRICE("WETH","USD","UNI")
Will get the WETH price on Uniswap. Let me know if you encounter errors or if data is missing.
patreon.com/posts/new-update…
#dex #data #sheets
I am verifying my ownership of Coingecko in Google Sheets on Gitcoin Grants at gitcoin.co/grants/5017/coing…. 🙌🎁🎆🙌🎉👍
1
#NEW Terra Luna tokens added to Cryptobalance patreon.com/posts/new-terra-…
#terraluna #data #sheets
1
LIST ALL TOKEN AMOUNTS ON ERC ADDRESS patreon.com/posts/list-all-t…
#SHEETS #erc #data #analysis #accounting #crypto
2
CRYPTOBALANCE : PALM NETWORK ADDED patreon.com/posts/cryptobala…
#palmnetwork #evm #explorer #sheets
1
CRYPTOSUPPLY ON ARBITRUM patreon.com/posts/new-crypto…
#arbitrum #sheets #totalcoinsupply #DataAnalytics
1

