Full listing
Kraken full listing is not available at this moment. Their API output needs too much rewriting to fit a sheet format.
Specific market data
In a nutshell, call =CRYPTOFINANCE("KRAKEN:BTC/USD")
to get the current Bitcoin price in US Dollar.
All information are returned from the Kraken public API. All ticker information available can be retrieved.
In the following examples, XXX
is the base currency symbol (eg. XTC
, ETH
, DASH
, etc.) and YYY
is the quote currency (eg. USD
, EUR
, GBP
, etc.).
Only currencies traded on Kraken are available. Both XBT
and BTC
symbols can be used for Bitcoin.
Get a currency pair exchange rates
Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "ask")
to get the ask price.Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "bid")
to get bid price.Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "open")
to get today’s opening price.Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "closed")
to get the last trade closed price.Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "low", "today")
to get today’s lowest price.Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "low", "last_24h")
to get the lowest price over the last 24 hours.Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "high", "today")
to get today’s height price.Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "high", "last_24h")
to get the highest price over the last 24 hours.
Get a currency pair volume data
Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "ask", "whole_lot_volume")
to get the current ask price whole lot volume.Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "ask", "lot_volume")
to get the current ask price lot volume.Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "bid", "whole_lot_volume")
to get the current bid price whole lot volume.Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "bid", "lot_volume")
to get the current ask price lot volume.Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "volume", "today")
to get the volume since the day started (midnight past 1 second).Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "volume", "last_24h")
to get the volume over the last 24 hours.Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "weighted_volume", "today")
to get the volume since the day started (midnight past 1 second).Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "weighted_volume", "last_24h")
to get the volume over the last 24 hours.Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "closed", "lot_volume")
to get the last trade closed lot volume.Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "nb_trade", "today")
to get the number of trades today.Call
=CRYPTOFINANCE("KRAKEN:XXX/YYY", "nb_trade", "last_24h")
to get the number of trades over the last 24 hours.