=CRYPTOFINANCE('BTC/USD') returns the current rate of Bitcoin in US Dollar, same thing as calling =CRYPTOFINANCE('BTC/USD', 'price').31 fiat destination currencies are available, along with Bitcoin and Ethereum, as a destination currency: AUD, BRL, CAD, CHF, CLP, CNY, CZK, DKK, EUR, GBP, HKD, HUF, IDR, ILS, INR, JPY, KRW, MXN, MYR, NOK, NZD, PHP, PKR, PLN, RUB, SEK, SGD, THB, TRY, TWD, USD, ZAR.All origin currencies are available (over 1,500), as listed on.BTC, ETH, DASH, etc.) and YYY is the destination currency (eg. Top 100 with Ether as 3rd currency: =CRYPTOFINANCE('COINMARKETCAP', 'ETH', 100) Get exchange rates Call the function with =CRYPTOFINANCE('XXX/YYY') where XXX is the origin currency symbol (eg.Top 10: =CRYPTOFINANCE('COINMARKETCAP', ', 10).With South African Rand: =CRYPTOFINANCE('COINMARKETCAP', 'ZAR') You can show only the top N coin (by marketcap) with the 3rd argument:.With Ether: =CRYPTOFINANCE('COINMARKETCAP', 'ETH').You can show the prices in a 3rd currency (in addition to USD and BTC), examples:

INDEX will look at the cryptodata sheet and return the value that is at the row where bitcoin is, and at the column 5.Ĭolumn 5 is where the price is, you can change it to 8 for marketcap info, etc.

MATCH will search for bitcoin in the sheet cryptodata on the column Aand return the matching row number.

Here is how to make your cell references sticky: =INDEX(cryptodata!A1:Z, MATCH('bitcoin',cryptodata!A1:A,0), 5) Here is how it works, in order: The same method is available for Cryptopia, Bittrex and Binance to pull all their markets data with 1 API call, respectively: =CRYPTOFINANCE('CRYPTOPIA'), =CRYPTOFINANCE('BITTREX'), =CRYPTOFINANCE('BINANCE').įrom there you can just reference these data from your portfolio sheet like this (below examples are for =CRYPTOFINANCE('COINMARKETCAP'): =cryptodata!E2 (this will show BTC price for CoinMarketcap) Note that the order of coins may change at each refresh, as they are sorted by marketcap. (From JButy Documentation) Get all of CoinMarketCap data in a single sheet: As I did, create a new sheet, name it cryptodata, then on cell A1 type the formula: =CRYPTOFINANCE('COINMARKETCAP') This will create as many rows as there are coins tracked on CoinMarketCap, over 1,500 as of now.

It will get you the exact same price you see on their website and should represent an average of the price across the exchanges they monitor. The CoinMarketCap API is actually really easy to use and they have a public API that doesn’t require authentication. Posted Decem(edited) Hi, just want to give a quick tutorial on how to set up coinmarketcap API data (automatic feed for beginners) in Excel on Windows If you. Setting up an Excel sheet with an API Sign in to follow this.

Coinmarketcap api for excel mac