=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 A1
type 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.MATCH
will search for xbt/usd
in the sheet cryptodata
on the column B
and return the matching row number.INDEX
will look at the cryptodata
sheet and return the value that is at the row number returned by MATCH
and at the column 3
. Column 3
is where the price is, you can change it to 14
for volume info, and so on.VALUE()
to be able to format the cell.=B4
: =VALUE(B4)
.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.