Market Order Book

Pricing: This data point requires standard subscription plan.
Google Sheets & Excel


  • 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.
  • The data is provided by Cryptowatch Public API

Example: Market Order Book for KRAKEN:BTC/USD

On a new sheet, in cell A2 enter:
A 4×100 table with a header will be returned, showing the market current order book.
Pro Tip — Use conditional formatting to reveal buy/sell walls
Kraken order book

Example: Grouping Orders

This will group the bids and asks in thousands.
Currently not available for Airtable. Coming soon...