=CRYPTOFINANCE("BTC/USD")and other similar calls, but call a full market listing to get all markets data in 1 API request.
cryptodata, then on cell
A1type the formula
=CRYPTOFINANCE("KRAKEN"). This will create as many rows as there are markets tracked on Kraken.
=cryptodata!C2. This will show the price of the first market listed.
MATCHwill search for
xbt/usdin the sheet
cryptodataon the column
Band return the matching row number.
INDEXwill look at the
cryptodatasheet and return the value that is at the row number returned by
MATCHand at the column
3is where the price is, you can change it to
14for volume info, and so on.
VALUE()to be able to format the cell.
CRYPTOFINANCE, are being blocked by the API call quota, even though simple math shows they should be from the quota limit. It is not possible to know how much of the current quota has been use at any given time.