All Kraken Markets In One Listing

This function call will return the list of all markets along with all their data point. It is recommended to use this to avoid the Google Sheets imposed API call quota.

=CRYPTOFINANCE("KRAKEN")

The following market data will be returned:

  • 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, by default it is the current ask price.
  • ask, the best ask price currently in the order book.
  • bid, the best bid price currently in the other book.
  • open, the 24h open price.
  • high, the 24h high price.
  • low, the 24h low price.
  • last, the price of the last trade.
  • vwap, the volume weighted average over the last 24h.
  • base_volume, the volume traded over the last 24h in BASE currency (so that’s XBT for XBT/USD).

Specific Kraken Market Data

Current Price

This will return Litecoin price (by default the best ask price) in Bitcoin as currently traded on the exchange.

=CRYPTOFINANCE("KRAKEN:LTC/XBT")

Same thing as calling =CRYPTOFINANCE("KRAKEN:LTC/XBT", "price") or =CRYPTOFINANCE("KRAKEN:LTC/XBT", "ask").

Best Ask Price

This call will return Litecoin best ask in Bitcoin currently in the order book.

=CRYPTOFINANCE("KRAKEN:LTC/XBT", "ask")

Best Bid Price

This call will return Litecoin bid price in Bitcoin currently in the order book.

=CRYPTOFINANCE("KRAKEN:LTC/XBT", "bid")

Last Price

This call will return Litecoin last trade price in Bitcoin.

=CRYPTOFINANCE("KRAKEN:LTC/XBT", "last")

VWAP (Price)

This call will return Litecoin volume-weighted average price in Bitcoin over the last 24h.

=CRYPTOFINANCE("KRAKEN:LTC/XBT", "open")

Open Price

This call will return Litecoin open price in Bitcoin as of 24h ago.

=CRYPTOFINANCE("KRAKEN:LTC/XBT", "open")

24h Lowest Price

This call will return Litecoin lowest price in Bitcoin over the last 24 hours.

=CRYPTOFINANCE("KRAKEN:LTC/XBT", "low")

24h Highest Price

This call will return Litecoin highest price in Bitcoin over the last 24 hours.

=CRYPTOFINANCE("KRAKEN:LTC/XBT", "high")

Market Base Volume

This call will return Litecoin volume in Bitcoin over the last 24 hours.

=CRYPTOFINANCE("KRAKEN:LTC/XBT", "base_volume")