missdemo.blogg.se - Http query for cryptocurrency prices mac excel

#Http query for cryptocurrency prices mac excel how to#

=CRYPTOFINANCE("DASH/CAD") returns the current rate of Dash in Canadian Dollar, same thing as calling =CRYPTOFINANCE("DASH/CAD", "price").=CRYPTOFINANCE("ETC/EUR") returns the current rate of Ethereum Classic in Euro, same thing as calling =CRYPTOFINANCE("ETC/EUR", "price").=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 CoinMarketCap Currency listing.BTC , ETH , DASH , etc.) and YYY is the destination currency (eg. Top 100 with Ether as 3rd currency: =CRYPTOFINANCE("COINMARKETCAP", "ETH", 100)Ĭall the function with =CRYPTOFINANCE("XXX/YYY") where XXX is the origin currency symbol (eg.Top 10: =CRYPTOFINANCE("COINMARKETCAP", "", 10).You can show only the top N coin (by marketcap) with the 3rd argument: With South African Rand: =CRYPTOFINANCE("COINMARKETCAP", "ZAR").With Ether: =CRYPTOFINANCE("COINMARKETCAP", "ETH").

You can show the prices in a 3rd currency (in addition to USD and BTC), examples: Column 5 is where the price is, you can change it to 8 for marketcap info, etc.

INDEX will look at the cryptodata sheet and return the value that is at the row where bitcoin is, and at the column 5.

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

=INDEX(cryptodata!A1:Z, MATCH("bitcoin",cryptodata!A1:A,0), 5)

#Http query for cryptocurrency prices mac excel how to#

Here is how to make your cell references sticky: Note that the order of coins may change at each refresh, as they are sorted by marketcap. =cryptodata!E2 (this will show BTC price for CoinMarketcap) 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"): This will create as many rows as there are coins tracked on CoinMarketCap, over 1,500 as of now. (From Documentation) Get all of CoinMarketCap data in a single sheet:Īs I did, create a new sheet, name it cryptodata, then on cell A1 type the formula: