Crypto Tools

NEW FUNCTION: CRYPTOHOLDERS Returns a table with the biggest holders by contract address and by chain: =CRYPTOHOLDERS("0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82","bep") raw.githubusercontent.com/Eloise1988/CRY…

Coingecko Google Sheet Code Set-Up youtube.com/watch?v=___BlV…

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/Eloise1988/CRY…

CryptoTools Discord discord.com/channels/10083…

Function #Binance Withdrawal #Fees =BINANCEWIDRAWFEE("1INCH","BSC") patreon.com/posts/function… #sheets #google #analytics

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

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-upda… #dex #data #sheets

CRYPTOLENDINGREWARD patreon.com/posts/cryptole… #apy #reward #comp #stkaave

LIST ALL TOKEN AMOUNTS IN GOOGLE SHEETS #solana #terra #wanchain #ethereum #cardano #tezos #tron patreon.com/posts/new-list…

I am verifying my ownership of Coingecko in Google Sheets on Gitcoin Grants at gitcoin.co/grants/5017/co…. 🙌🎁🎆🙌🎉👍

@daniel_ingles If you need personalized real time data for a set of tickers and exchanges, I do provide this but for a fee. DM if interested.

@daniel_ingles There are 2 types of refreshing: - the google sheet resfreshing time - the coingecko/cryptotools refreshing time For cryptodexprice, I only refresh the data every 2 to 5min.

@CryptoT00LS hello, I am using your cryptoTools google sheets, I need to change the pricing refresh from 5 minutes to less, how to do? Thanks in advance!

@daniel_ingles If you are using both, the Coingecko and the Cryptotools script, you would need to change that value in both codes. Hope that helps!

@daniel_ingles You need to go in the Extension app scripts. By default, as shown on the above picture the cache is 10 minutes (600 seconds). If you wish to lower it, you can change it manually. For example if you wish for 5min, you would need to put 300 instead of the 600 seconds.

#NEW Terra Luna tokens added to Cryptobalance patreon.com/posts/new-terr… #terraluna #data #sheets

LIST ALL TOKEN AMOUNTS ON ERC ADDRESS patreon.com/posts/list-all… #SHEETS #erc #data #analysis #accounting #crypto

#NEW #Gnosis chain added to Cryptobalance patreon.com/posts/new-gnos… #XDAI

#NEW CRYPTOTOOLS FUNCTION patreon.com/posts/new-cryp… #blockchain #evm #data #sheets #usdbalance

CRYPTOBALANCE SPECIAL CASES patreon.com/posts/cryptoba… #cronos #cro #data