Skip to content

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

License

Notifications You must be signed in to change notification settings

Eloise1988/COINGECKO

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

COINGECKO

CoinGecko Spreadsheet Feed: Prices, Volumes, Market Cap

Update March 2023: ISSUES WITH COINGECKO: Coingecko informed me that the old link (which get ids: https://api.coingecko.com/api/v3/search?locale=fr&img_path_only=1), is now deprecated, so I changed it to the new version: https://api.coingecko.com/api/v3/coins/list.

PUBLICATION LINKS

FUNCTIONS

| GECKOPRICE | GECKOVOLUME | GECKOCAP | GECKOPRICEBYNAME | GECKOATH GECKOATL | GECKOCHANGE | GECKO24HPRICECHANGE | GECKOHIST | GECKOCAPTOT | GECKOCAPDOMINANCE | GECKOSUPPLY | GECKORANK | GECKOCAPDILUTED | GECKOCHART | GECKOHISTBYDAY | GECKO24HIGH GECKO24LOW | GECKO_ID_DATA | GECKOLOGO | COINGECKO_ID

GECKOPRICE

Imports CoinGecko's cryptocurrency prices into Google spreadsheets.

CoingeckoPrice

=GECKOPRICE(ticker,currency, refresh_cell)
EXAMPLE =GECKOPRICE("BTC", "USD","$A$1")
EXAMPLE =GECKOPRICE(A1:A10)

GECKOVOLUME

Imports CoinGecko's cryptocurrency volumes into Google spreadsheets.

GeckoVolumeEur

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

alt text

=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/coins/list)

GECKOPRICEBYNAME

=GECKOPRICEBYNAME(ticker,currency, refresh_cell)
EXAMPLE =GECKOPRICEBYNAME("bitcoinV", "USD","$A$1")
NB: The functions GECKOVOLUMEBYNAME, GECKOCAPBYNAME, GECKOCHANGEBYNAME, GECKOLOGOBYNAME can be used in a similar way as GECKOPRICEBYNAME

GECKOATH GECKOATL

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

GECKOATHL

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

GECKO24HIGH GECKO24LOW

Imports CoinGecko's cryptocurrency 24H High and Low Prices into Google spreadsheets.

GECKO24HL

=GECKO24H(ticker,currency, refresh_cell)
EXAMPLE =GECKO24H("BTC", "USD","$A$1")
EXAMPLE =GECKO24H(A1:A10, "EUR")
=GECKO24L(ticker,currency, refresh_cell)
EXAMPLE =GECKO24L("BTC", "USD","$A$1")
EXAMPLE =GECKO24L(A1:A10, "EUR")

GECKO24HPRICECHANGE

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

GECKOATH

=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

GECKOCHANGEPRICE

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

GECKO VOLUME CHANGE

GECKOCHANGEVOL

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

GECKO MARKET CAP CHANGE

GECKOCHANGECAP

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

GECKOHIST

Imports the list of historical prices, volumes, market cap

GECKOHIST

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')

GECKOHISTBYDAY

Imports the historical prices, volumes, market cap by date (european format dd-mm-yyyy)

GECKOHISTBYDAY

EXAMPLE =GECKOHISTBYDAY("btc","usd","price","01-01-2022")

GECKOCHART

Imports the chart sparkline for historical prices, volumes, market cap by number of days

Prices

GECKOCHARTPRICES

EXAMPLE =SPARKLINE(GECKOCHART("btc","usd","price",365))

Volumes

GECKOCHARTVOLUME

EXAMPLE =SPARKLINE(GECKOCHART("btc","usd","volume",365))

Market Cap

GECKOCHARTMKT

EXAMPLE =SPARKLINE(GECKOCHART("btc","usd","marketcap",365))

GECKOCAPTOT

Imports the current total market cap of cryptocurrencies

GECKOCAPTOT

EXAMPLE =GECKOCAPTOT()

GECKOCAPDOMINANCE

Imports the % market cap dominance by cryptocurrencies

GECKOCAPDOMINANCE

EXAMPLE =GECKOCAPDOMINANCE("BTC")

GECKOCAPDILUTED

Imports CoinGecko's cryptocurrency market capitalization diluted into Google spreadsheets.

alt text

=GECKOCAPDILUTED(ticker,currency, refresh_cell)
EXAMPLE =GECKOCAPDILUTED("BTC", "USD","$A$1")
EXAMPLE =GECKOCAPDILUTED(A1:A10, "EUR")

GECKOSUPPLY

Imports the circulating supply

GECKOSUPPLY

EXAMPLE =GECKOSUPPLY("ETH")

Imports the maximum supply

GECKOMAXSUPPLY

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

Imports the total supply

GECKOTOTALSUPPLY

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

GECKORANK

Imports the ranking of cryptocurrencies by market capitalization ($)

GECKOCAPDOMINANCE

EXAMPLE =GECKORANK("BTC")

GECKO ID DATA

If you are looking to retrieve the SPECIFIC data endpoints, for example scores, community data, ...

GECKOIDDATA

EXAMPLE =GECKO_ID_DATA(“LTC”,”market_data/price_change_percentage_7d_in_currency/usd”)

GECKOLOGO

Imports the logo of a cryptocurrency

GECKOLOGO

EXAMPLE =IMAGE(GECKOLOGO("BTC"))

COINGECKO ID

Imports the coingecko id name which is useful when tickers have duplicates

GECKOID

EXAMPLE =COINGECKO_ID("BTC")

FORMULA REFRESHING & MAKING SURE NOT TO TRIGGER GOOGLE LIMITS

TickerBox

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

About

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

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published