Market Order Book
Google Sheets & Excel
Airtable
- Syntax is as simple as
=CRYPTOFINANCE("KRAKEN:BTC/USD", "ob")
- Order book data is cached for 5 minutes.
- Output is truncated at 100 orders on each side (bids and asks), with a depth of 100.
On a new sheet, in cell
A2
enter:=CRYPTOFINANCE("KRAKEN:BTC/USD", "ob")

A
4×100
table with a header will be returned, showing the market current order book.

Kraken order book
=CRYPTOFINANCE("KRAKEN:BTC/USD", "ob", 1000)
This will group the
bids
and asks
in thousands.Currently not available for Airtable. Coming soon...