USD Exchange Rate

This endpoint returns the price of any asset in USD. The USD price is calculated based on the path of the highest liquidity. This means that, even though an asset might trade directly against USD on one or more exchanges, the price might still be established by using cross-rates1. In cases where the most liquid path changed over time, this will be taken into account in the calculation of the price for each interval. To have an overview of what data was used to calculate the USD price, set the sources parameter to true. Setting the sourcesparameter to false (default) will yield a faster response time. By making use of the sort parameter, data can be returned in ascending asc (default) or descending desc order. Access includes daily intervals. For full access to intervals ranging from 1 second to 1 day, please contact Kaiko for an API key.

How to use Kaiko data in Excel & Googlesheets with Cryptosheets

This article demonstrates three examples of how to pull Kaiko API data into your spreadsheet using the side panel console, custom functions and templates.

Explore more Kaiko endpoints here

Example Parameters:

  • commoditydataversion: trades.v1
  • data_version: ``
  • base_asset: btc
  • quote_asset: usd
  • exchanges: ``
  • start_time: ``
  • end_time: ``
  • page_size: 100
  • sources: false
  • interval: 1h
  • X-Api-key: Your X-Api-key

Excel:

=CS.QUERY("Kaiko","USD Exchange Rate",{"commoditydataversion","trades.v1";"data_version","";"base_asset","btc";"quote_asset","usd";"exchanges","";"start_time","";"end_time","";"page_size","100";"sources","false";"interval","1h";"X-Api-key","Your X-Api-key"})

Googlesheets:

=CSQUERY("Kaiko","USD Exchange Rate",{"commoditydataversion","trades.v1";"data_version","";"base_asset","btc";"quote_asset","usd";"exchanges","";"start_time","";"end_time","";"page_size","100";"sources","false";"interval","1h";"X-Api-key","Your X-Api-key"})

NOTE: Some international users may need to substitute commas "," in custom functions with semicolons ";" so for something like =CS.TA("BTC","USD") try =CS.TA("BTC";"USD") instead

Usage

Cryptosheets data can be pulled through multiple interfaces:

Setup

Setup

  1. Install the Cryptosheets add-in from the Microsoft AppSource Store

  2. Install the Cryptosheets add-in from the Google GSuite Marketplace

  3. After it is installed, make sure you are logged into your Cryptosheets account through the Cryptosheets side panel

Using the console

Using the console

  1. From the Cryptosheets Excel ribbon click data
  2. From the Googlesheets Add-ons menu click Cryptosheets then select Launch side-bar
  3. Type in Kaiko... then click on USD Exchange Rate
  4. Scroll through the console parameters and input your values
  5. Select the cell you want to place the data into
  6. Click make request

img

img

Using custom functions

Using custom functions

Tip: For both Excel and Googlesheeets you can use either the QUERY or QUERYA custom function

  1. Excel In any cell type the following:

=CS.QUERY("Kaiko","USD Exchange Rate",{"commoditydataversion","trades.v1";"data_version","";"base_asset","btc";"quote_asset","usd";"exchanges","";"start_time","";"end_time","";"page_size","100";"sources","false";"interval","1h";"X-Api-key","Your X-Api-key"})

  1. Googlesheets In any cell type the following:

=CSQUERY("Kaiko","USD Exchange Rate",{"commoditydataversion","trades.v1";"data_version","";"base_asset","btc";"quote_asset","usd";"exchanges","";"start_time","";"end_time","";"page_size","100";"sources","false";"interval","1h";"X-Api-key","Your X-Api-key"})

  1. In any console, after selecting the parameters to configure the query string as desired, simply click the radio button to toggle the the function/formula builder, then click the clipboard icon to copy the full formula string and paste it into any cell see detailed examples and tutorial

Hint: If you need help remembering the exact parameters for any function, you can always just type in any cell: =CS.PARAMETERS("Kaiko","USD Exchange Rate") for Excel or =CSPARAMETERS("Kaiko","USD Exchange Rate") for Googlesheets

Using templates

Using templates

  1. From the Cryptosheets Excel ribbon click templates OR click on the templates tab in the browse section
  2. From the Googlesheets Add-ons menu click Cryptosheets then select Templates
  3. Load the template called Query Builder and type Kaiko and USD Exchange Rate
  4. You can also try searching "Kaiko..." for other templates

Signing up for Cryptosheets is free get crypto data in 30 seconds or less

Note: you must have one of the supported versions of Microsoft Office or Excel for custom functions to work. Learn more here

Helpful Resources:

  • Visit the API documentation for Kaiko here
  • See tutorials and examples for Kaiko on the Cryptosheets YouTube channel
  • Troubleshooting: please reference the following troubleshooting code: QUE-1426-780. Learn more here

Tags: USD Exchange Rate Kaiko endpoint