Market Order Book

Google Sheets & Excel
Airtable
Overview
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:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "ob")
​
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
=CRYPTOFINANCE("KRAKEN:BTC/USD", "ob", 1000)
This will group the bids and asks in thousands.
Currently not available for Airtable. Coming soon...
Last modified 21d ago