> Live and historical institutional quality market data for digital assets from the world's lading exchanges. Find examples for accessing every **Kaiko** endpoint using **Cryptosheets** through: - `side panel console` - `custom functions` (Excel & Googlesheets) - `templates` ## Excel

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | --------------------------------------------------- | -------- | ----------- | | Try It | [Docs](/providers/kaiko/assets) | **Assets** | =CS.QUERY("Kaiko","Assets") | =CS.PARAMETERS("Kaiko","Assets") | 0 | | Try It | [Docs](/providers/kaiko/exchanges) | **Exchanges** | =CS.QUERY("Kaiko","Exchanges") | =CS.PARAMETERS("Kaiko","Exchanges") | 0 | | Try It | [Docs](/providers/kaiko/instruments) | **Instruments** | =CS.QUERY("Kaiko","Instruments") | =CS.PARAMETERS("Kaiko","Instruments") | 0 | | Try It | [Docs](/providers/kaiko/historical-trades) | **Historical Trades** | =CS.QUERY("Kaiko","Historical Trades") | =CS.PARAMETERS("Kaiko","Historical Trades") | 10 | | Try It | [Docs](/providers/kaiko/recent-trades) | **Recent Trades** | =CS.QUERY("Kaiko","Recent Trades") | =CS.PARAMETERS("Kaiko","Recent Trades") | 7 | | Try It | [Docs](/providers/kaiko/spot-price) | **Spot Price** | =CS.QUERY("Kaiko","Spot Price") | =CS.PARAMETERS("Kaiko","Spot Price") | 9 | | Try It | [Docs](/providers/kaiko/order-book-snapshot-(full)) | **Order Book Snapshot (Full)** | =CS.QUERY("Kaiko","Order Book Snapshot (Full)") | =CS.PARAMETERS("Kaiko","Order Book Snapshot (Full)") | 13 | | Try It | [Docs](/providers/kaiko/historical-ohlcv-(candles)) | **Historical OHLCV (Candles)** | =CS.QUERY("Kaiko","Historical OHLCV (Candles)") | =CS.PARAMETERS("Kaiko","Historical OHLCV (Candles)") | 11 | | Try It | [Docs](/providers/kaiko/recent-ohlcv) | **Recent OHLCV** | =CS.QUERY("Kaiko","Recent OHLCV") | =CS.PARAMETERS("Kaiko","Recent OHLCV") | 7 | | Try It | [Docs](/providers/kaiko/historical-vwap-(prices)) | **Historical VWAP (Prices)** | =CS.QUERY("Kaiko","Historical VWAP (Prices)") | =CS.PARAMETERS("Kaiko","Historical VWAP (Prices)") | 11 | | Try It | [Docs](/providers/kaiko/recent-vwap) | **Recent Vwap** | =CS.QUERY("Kaiko","Recent Vwap") | =CS.PARAMETERS("Kaiko","Recent Vwap") | 11 | | Try It | [Docs](/providers/kaiko/historical-count-ohlcv-vwap) | **Historical COUNT OHLCV VWAP** | =CS.QUERY("Kaiko","Historical COUNT OHLCV VWAP") | =CS.PARAMETERS("Kaiko","Historical COUNT OHLCV VWAP") | 11 | | Try It | [Docs](/providers/kaiko/recent-count-ohlcv-vwap) | **Recent Count OHLCV Vwap** | =CS.QUERY("Kaiko","Recent Count OHLCV Vwap") | =CS.PARAMETERS("Kaiko","Recent Count OHLCV Vwap") | 7 | | Try It | [Docs](/providers/kaiko/direct-exchange-rate-(aggregated-price)) | **Direct Exchange Rate (Aggregated Price)** | =CS.QUERY("Kaiko","Direct Exchange Rate (Aggregated Price)") | =CS.PARAMETERS("Kaiko","Direct Exchange Rate (Aggregated Price)") | 11 | | Try It | [Docs](/providers/kaiko/usd-exchange-rate) | **USD Exchange Rate** | =CS.QUERY("Kaiko","USD Exchange Rate") | =CS.PARAMETERS("Kaiko","USD Exchange Rate") | 11 | | Try It | [Docs](/providers/kaiko/order-book-snapshot-(raw)) | **Order Book Snapshot (Raw)** | =CS.QUERY("Kaiko","Order Book Snapshot (Raw)") | =CS.PARAMETERS("Kaiko","Order Book Snapshot (Raw)") | 11 | | Try It | [Docs](/providers/kaiko/order-book-snapshot-(depth)) | **Order Book Snapshot (Depth)** | =CS.QUERY("Kaiko","Order Book Snapshot (Depth)") | =CS.PARAMETERS("Kaiko","Order Book Snapshot (Depth)") | 10 | | Try It | [Docs](/providers/kaiko/order-book-snapshot-(slippage)) | **Order Book Snapshot (Slippage)** | =CS.QUERY("Kaiko","Order Book Snapshot (Slippage)") | =CS.PARAMETERS("Kaiko","Order Book Snapshot (Slippage)") | 12 | | Try It | [Docs](/providers/kaiko/order-book-aggregations-(full)) | **Order Book Aggregations (Full)** | =CS.QUERY("Kaiko","Order Book Aggregations (Full)") | =CS.PARAMETERS("Kaiko","Order Book Aggregations (Full)") | 13 | | Try It | [Docs](/providers/kaiko/order-book-aggregations-(depth)) | **Order Book Aggregations (Depth)** | =CS.QUERY("Kaiko","Order Book Aggregations (Depth)") | =CS.PARAMETERS("Kaiko","Order Book Aggregations (Depth)") | 11 | | Try It | [Docs](/providers/kaiko/order-book-aggregations-(slippage)) | **Order Book Aggregations (Slippage)** | =CS.QUERY("Kaiko","Order Book Aggregations (Slippage)") | =CS.PARAMETERS("Kaiko","Order Book Aggregations (Slippage)") | 13 | | Try It | [Docs](/providers/kaiko/futures) | **Futures** | =CS.QUERY("Kaiko","Futures") | =CS.PARAMETERS("Kaiko","Futures") | 4 | | Try It | [Docs](/providers/kaiko/perpetual-futures) | **Perpetual Futures** | =CS.QUERY("Kaiko","Perpetual Futures") | =CS.PARAMETERS("Kaiko","Perpetual Futures") | 4 | | Try It | [Docs](/providers/kaiko/options) | **Options** | =CS.QUERY("Kaiko","Options") | =CS.PARAMETERS("Kaiko","Options") | 4 |

## Google Sheets

| App Url | Docs Url | Name | Example | Parameters | # of Parameters | | --------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------ | -------- | ----------- | | Try It | [Docs](/providers/kaiko/assets) | **Assets** | =CSQUERY("Kaiko","Assets") | =CSPARAMETERS("Kaiko","Assets") | 0 | | Try It | [Docs](/providers/kaiko/exchanges) | **Exchanges** | =CSQUERY("Kaiko","Exchanges") | =CSPARAMETERS("Kaiko","Exchanges") | 0 | | Try It | [Docs](/providers/kaiko/instruments) | **Instruments** | =CSQUERY("Kaiko","Instruments") | =CSPARAMETERS("Kaiko","Instruments") | 0 | | Try It | [Docs](/providers/kaiko/historical-trades) | **Historical Trades** | =CSQUERY("Kaiko","Historical Trades") | =CSPARAMETERS("Kaiko","Historical Trades") | 10 | | Try It | [Docs](/providers/kaiko/recent-trades) | **Recent Trades** | =CSQUERY("Kaiko","Recent Trades") | =CSPARAMETERS("Kaiko","Recent Trades") | 7 | | Try It | [Docs](/providers/kaiko/spot-price) | **Spot Price** | =CSQUERY("Kaiko","Spot Price") | =CSPARAMETERS("Kaiko","Spot Price") | 9 | | Try It | [Docs](/providers/kaiko/order-book-snapshot-(full)) | **Order Book Snapshot (Full)** | =CSQUERY("Kaiko","Order Book Snapshot (Full)") | =CSPARAMETERS("Kaiko","Order Book Snapshot (Full)") | 13 | | Try It | [Docs](/providers/kaiko/historical-ohlcv-(candles)) | **Historical OHLCV (Candles)** | =CSQUERY("Kaiko","Historical OHLCV (Candles)") | =CSPARAMETERS("Kaiko","Historical OHLCV (Candles)") | 11 | | Try It | [Docs](/providers/kaiko/recent-ohlcv) | **Recent OHLCV** | =CSQUERY("Kaiko","Recent OHLCV") | =CSPARAMETERS("Kaiko","Recent OHLCV") | 7 | | Try It | [Docs](/providers/kaiko/historical-vwap-(prices)) | **Historical VWAP (Prices)** | =CSQUERY("Kaiko","Historical VWAP (Prices)") | =CSPARAMETERS("Kaiko","Historical VWAP (Prices)") | 11 | | Try It | [Docs](/providers/kaiko/recent-vwap) | **Recent Vwap** | =CSQUERY("Kaiko","Recent Vwap") | =CSPARAMETERS("Kaiko","Recent Vwap") | 11 | | Try It | [Docs](/providers/kaiko/historical-count-ohlcv-vwap) | **Historical COUNT OHLCV VWAP** | =CSQUERY("Kaiko","Historical COUNT OHLCV VWAP") | =CSPARAMETERS("Kaiko","Historical COUNT OHLCV VWAP") | 11 | | Try It | [Docs](/providers/kaiko/recent-count-ohlcv-vwap) | **Recent Count OHLCV Vwap** | =CSQUERY("Kaiko","Recent Count OHLCV Vwap") | =CSPARAMETERS("Kaiko","Recent Count OHLCV Vwap") | 7 | | Try It | [Docs](/providers/kaiko/direct-exchange-rate-(aggregated-price)) | **Direct Exchange Rate (Aggregated Price)** | =CSQUERY("Kaiko","Direct Exchange Rate (Aggregated Price)") | =CSPARAMETERS("Kaiko","Direct Exchange Rate (Aggregated Price)") | 11 | | Try It | [Docs](/providers/kaiko/usd-exchange-rate) | **USD Exchange Rate** | =CSQUERY("Kaiko","USD Exchange Rate") | =CSPARAMETERS("Kaiko","USD Exchange Rate") | 11 | | Try It | [Docs](/providers/kaiko/order-book-snapshot-(raw)) | **Order Book Snapshot (Raw)** | =CSQUERY("Kaiko","Order Book Snapshot (Raw)") | =CSPARAMETERS("Kaiko","Order Book Snapshot (Raw)") | 11 | | Try It | [Docs](/providers/kaiko/order-book-snapshot-(depth)) | **Order Book Snapshot (Depth)** | =CSQUERY("Kaiko","Order Book Snapshot (Depth)") | =CSPARAMETERS("Kaiko","Order Book Snapshot (Depth)") | 10 | | Try It | [Docs](/providers/kaiko/order-book-snapshot-(slippage)) | **Order Book Snapshot (Slippage)** | =CSQUERY("Kaiko","Order Book Snapshot (Slippage)") | =CSPARAMETERS("Kaiko","Order Book Snapshot (Slippage)") | 12 | | Try It | [Docs](/providers/kaiko/order-book-aggregations-(full)) | **Order Book Aggregations (Full)** | =CSQUERY("Kaiko","Order Book Aggregations (Full)") | =CSPARAMETERS("Kaiko","Order Book Aggregations (Full)") | 13 | | Try It | [Docs](/providers/kaiko/order-book-aggregations-(depth)) | **Order Book Aggregations (Depth)** | =CSQUERY("Kaiko","Order Book Aggregations (Depth)") | =CSPARAMETERS("Kaiko","Order Book Aggregations (Depth)") | 11 | | Try It | [Docs](/providers/kaiko/order-book-aggregations-(slippage)) | **Order Book Aggregations (Slippage)** | =CSQUERY("Kaiko","Order Book Aggregations (Slippage)") | =CSPARAMETERS("Kaiko","Order Book Aggregations (Slippage)") | 13 | | Try It | [Docs](/providers/kaiko/futures) | **Futures** | =CSQUERY("Kaiko","Futures") | =CSPARAMETERS("Kaiko","Futures") | 4 | | Try It | [Docs](/providers/kaiko/perpetual-futures) | **Perpetual Futures** | =CSQUERY("Kaiko","Perpetual Futures") | =CSPARAMETERS("Kaiko","Perpetual Futures") | 4 | | Try It | [Docs](/providers/kaiko/options) | **Options** | =CSQUERY("Kaiko","Options") | =CSPARAMETERS("Kaiko","Options") | 4 |

[Signing up for Cryptosheets is free](https://app.cryptosheets.com/#/register) get crypto data in 30 seconds or less **Get Cryptosheets for Microsoft Excel** **Get Cryptosheets for Googlesheets** \*Note: you must have one of the [supported versions](https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-architecture) of Microsoft Office or Excel for custom functions to work **Click here** for additional documentation from Kaiko Learn more [here](https://intercom.help/cryptosheets/en/) --- Tags: `Kaiko` `provider`