tanshunyuan/COINGECKO

CoinGecko Real Time Spreadsheet Feed: Prices, Volumes, Market Cap

COINGECKO

CoinGecko Spreadsheet Feed: Prices, Volumes, Market Cap

PUBLICATION LINKS

Link to Google Sheets public template!

Link to Coingecko's Youtube video

Link to the Medium Publication

Link to Google Sheet's Set-up

GECKOPRICE

Imports CoinGecko's cryptocurrency prices into Google spreadsheets.

=GECKOPRICE(ticker,currency, refresh_cell)

EXAMPLE =GECKOPRICE("BTC", "USD","$A$1")

EXAMPLE =GECKOPRICE(A1:A10)

GECKOVOLUME

Imports CoinGecko's cryptocurrency volumes into Google spreadsheets.

=GECKOVOLUME(ticker,currency, refresh_cell)

EXAMPLE =GECKOVOLUME("BTC", "USD","$A$1")

EXAMPLE =GECKOVOLUME(A1:A10, "EUR")

GECKOCAP

Imports CoinGecko's cryptocurrency market capitalization into Google spreadsheets.

=GECKOCAP(ticker,currency, refresh_cell)

EXAMPLE =GECKOCAP("BTC", "USD","$A$1")

EXAMPLE =GECKOCAP(A1:A10, "EUR")

GECKOPRICEBYNAME

Imports CoinGecko's cryptocurrency prices into Google spreadsheets. The Id of cryptocurrency ticker can be found in the following coingecko web page (https://api.coingecko.com/api/v3/search?locale=fr&img_path_only=1)

=GECKOPRICEBYNAME(ticker,currency, refresh_cell)

EXAMPLE =GECKOPRICEBYNAME("bitcoinV", "USD","$A$1")

GECKOATH GECKOATL

Imports CoinGecko's cryptocurrency All Time High AND Low Prices into Google spreadsheets.

=GECKOATH(ticker,currency, refresh_cell)

EXAMPLE =GECKOATH("BTC", "USD","$A$1")

EXAMPLE =GECKOATH(A1:A10, "EUR")

=GECKOATL(ticker,currency, refresh_cell)

EXAMPLE =GECKOATL("BTC", "USD","$A$1")

EXAMPLE =GECKOATL(A1:A10, "EUR")

GECKO24HPRICECHANGE

Imports CoinGecko's 24h Price % change into Google spreadsheets.

=GECKOATH(ticker,currency, refresh_cell)

EXAMPLE =GECKO24HPRICECHANGE("BTC", "USD","$A$1")

EXAMPLE =GECKO24HPRICECHANGE(A1:A10, "EUR")

GECKOCHANGE

Imports CoinGecko's cryptocurrency price change, volume change and market cap change into Google spreadsheets.

=GECKOCHANGE(ticker,type, nb_days, refresh_cell)

GECKO PRICE CHANGE decimal form

EXAMPLE =GECKOCHANGE("BTC","USD","PRICE",1,"$A$1")

GECKO VOLUME CHANGE decimal form

EXAMPLE =GECKOCHANGE("BTC","USD","VOLUME",365,"$A$1")

GECKO MARKET CAP CHANGE, decimal form

EXAMPLE =GECKOCHANGE("BTC","USD","MARKETCAP",365,"$A$1")

GECKOHIST, decimal form, gets the list of historical prices, volumes, market cap

EXAMPLE =GECKOHIST("ethereum","usd","price",datevalue("12-31-2020"),datevalue("08-31-2020"))

Depending on the timezone of your sheet either datevalue('mm-dd-yyyy') or datevalue('dd-mm-yyyy')

GECKOCAPTOT, gets the current total market cap of cryptocurrencies

EXAMPLE =GECKOCAPTOT()

GECKOCAPDOMINANCE, gets the % market cap dominance by cryptocurrencies

EXAMPLE =GECKOCAPDOMINANCE("BTC")

GECKOSUPPLY gets the coin's circulating, max & total supply

Imports the circulating supply

EXAMPLE =GECKOSUPPLY("ETH")

Imports the maximum supply

EXAMPLE =GECKOSUPPLY("BTC","MAX_SUPPLY")

Imports the total supply

EXAMPLE =GECKOSUPPLY("BTC","TOTAL_SUPPLY")

FORMULA REFRESHING & MAKING SURE NOT TO TRIGGER GOOGLE LIMITS

EXAMPLE =if($C$10=true, GECKOPRICE(B12:B32,"usd",$B$10),"Tick Box to Refresh")