Trade Data

Overview
Syntax is as simple as =CRYPTOFINANCE("KRAKEN:BTC/USD", "last_trades")
The last 1,000 trades will be returned and cached for 5 minutes.
The data is provided by the Cryptowatch Public API​
Example: Last trades for KRAKEN:BTC/USD
On a new sheet, in cell A1 enter:
=CRYPTOFINANCE("KRAKEN:BTC/USD", "last_trades")
A 4×1000 table with a header will be returned, showing the market last trades.
Pro Tip — Use conditional formatting to reveal large orders.

Last modified 3mo ago