kascevenue.blogg.se - Excel symbols in cell with price

EXCEL SYMBOLS IN CELL WITH PRICE HOW TO

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)

EXCEL SYMBOLS IN CELL WITH PRICE 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: