How to get rates and data from Kraken

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.