![]() =INDEX(cryptodata!A1:Z, MATCH("bitcoin",cryptodata!A1:A,0), 5) 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:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |