Crypto Tools

Using data analytics to gain insight into the Cryptocurrency market

[Crypto Tools @CryptoT00LS]

NEW FUNCTION: CRYPTOHOLDERS
Returns a table with the biggest holders by contract address and by chain:

=CRYPTOHOLDERS("0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82","bep")

https://t.co/ne21IxBDz8

[Crypto Tools @CryptoT00LS]

Coingecko Google Sheet Code Set-Up
https://t.co/nGoKd1aI3q

[Crypto Tools @CryptoT00LS]

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:

https://t.co/GccCIERhjR

[Crypto Tools @CryptoT00LS]

CryptoTools Discord
https://t.co/f5sfb2B1lS

[Crypto Tools @CryptoT00LS]

Function #Binance Withdrawal #Fees
=BINANCEWIDRAWFEE("1INCH","BSC")
https://t.co/GJdlxfdxu4

#sheets #google #analytics

[Crypto Tools @CryptoT00LS]

#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")

https://t.co/Ez1XqQCRzK

[Crypto Tools @CryptoT00LS]

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.

https://t.co/x164vf3hCn
#dex #data #sheets

[Crypto Tools @CryptoT00LS]

CRYPTOLENDINGREWARD https://t.co/v3nGxPIVby
#apy #reward #comp #stkaave

[Crypto Tools @CryptoT00LS]

LIST ALL TOKEN AMOUNTS IN GOOGLE SHEETS

#solana #terra #wanchain #ethereum #cardano #tezos #tron

https://t.co/5MgWYdf8Mw

[Crypto Tools @CryptoT00LS]

I am verifying my ownership of Coingecko in Google Sheets on Gitcoin Grants at https://t.co/kyEYwEvktT. 🙌🎁🎆🙌🎉👍

[Crypto Tools @CryptoT00LS]

@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.

[Crypto Tools @CryptoT00LS]

@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.

[Crypto Tools @CryptoT00LS]

@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!

[Crypto Tools @CryptoT00LS]

@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.

[Crypto Tools @CryptoT00LS]

#NEW Terra Luna tokens added to Cryptobalance https://t.co/bu6f4UVYh4

#terraluna #data #sheets

[Crypto Tools @CryptoT00LS]

LIST ALL TOKEN AMOUNTS ON ERC ADDRESS https://t.co/TJIk6CbbDG

#SHEETS #erc #data #analysis #accounting #crypto

[Crypto Tools @CryptoT00LS]

#NEW #Gnosis chain added to Cryptobalance https://t.co/MUDzvcFkdR
#XDAI

[Crypto Tools @CryptoT00LS]

#NEW CRYPTOTOOLS FUNCTION https://t.co/5f8wMOCpIl

#blockchain #evm #data #sheets #usdbalance

[Crypto Tools @CryptoT00LS]

CRYPTOBALANCE SPECIAL CASES https://t.co/zGhrSPIi8u

#cronos #cro #data