KRAKEN
" as the exchange. 2018-02-22
in cell B12
:last_updated
, when the data has been fetched from the exchange, timezone is UTC
time.market
, the market name following the syntax BASE/QUOTE
.price
, the current price, either the last
trade price when available or the current ask
price.open
, the 24h open
price.high
, the 24h high
price.low
, the 24h low
price.close
, the 24h close
price, often the same as the last
price.last
, the price of the last trade.change 24h
, the price change in percentage over the last 24h.volume
, the volume traded over the last 24h in quote currency (USD
in BTC/USD
).volume_base
, the volume traded over the last 24h in base currency (BTC
in BTC/USD
).KRAKEN
" as the queried exchange. =CRYPTOFINANCE("KRAKEN:ETH/BTC", "price")
.=CRYPTOFINANCE("KRAKEN:ETH/BTC", "last")
.ETH
over the last 24h on the exchange:KRAKEN
" as the queried exchange. open
, high
, low
, close
, volume
and volume_base
.close
."binance"
"binance-us"
"bisq"
"bitbay"
"bitfinex"
"bitflyer"
"bithumb"
"bitmex"
"bitstamp"
"bittrex"
"cexio"
"coinbase-pro"
(coinbase is transparently mapped to coinbase-pro)"coinone"
"deribit"
"ftx"
"ftx-us"
"gateio"
"gemini"
"hitbtc"
"huobi"
"kraken"
"kraken-futures"
"kucoin"
"liquid"
"luno"
"okcoin"
"okx"
(priorly "okex"
— both work)"poloniex"
"uniswap-v2"
"zonda"
(priorly "bitbay"
— both work)coinbase
” and “coinbase-pro
” will return the same results.