LIVE Basis and dollar spread
Inputs: Exchange: Deribit, Bit.com, OkexCurrency Symbol: BTC, ETH Why do traders like this endpoint? Futures, by definition, settle to spot prices (aka "index price") upon expiration. Due to these derivatives expiring sometime in the future, the prices today may deviate from spot. These deviations from spot create an "implicit" interest rate to the futures contract. This futures contract is also known as the "basis".Why would anyone pay an implicit interest rate when they could merely trade spot? Futures provide leverage and are therefore capital-efficient. The basis, in part, can be thought of as the cost of capital for the leverage. (In reality the basis, which is a function of supply and demand, is traded for many reasons beyond cost of capital). Calculation: Raw Basis = [(Midprice) / (index price)] - 1Annualized Percent Spread = (Raw Basis) X [(525,600)/ (minutes until futures expiration)]Dollar Spread = Midprice - Index Price Endpoint Output Details: Granularity: 100msDataset
How to use GenesisVolatility LITE data in Excel & Googlesheets with Cryptosheets
This article demonstrates three examples of how to pull GenesisVolatility LITE API data into your spreadsheet using the side panel console
, custom functions
and templates
.
Explore more GenesisVolatility LITE endpoints here
Example Parameters:
- gvol-lite:
YOUR_GVOL_LITE_KEY
- query:
query CurrentObBasisVolumeOpenInterest($exchange: ExchangeEnumType, $symbol: SymbolEnumType) { CurrentObBasisVolumeOpenInterests: genericCurrentObBasisVolumeOpenInterest( exchange: $exchange symbol: $symbol ) { date instrument indexPrice markPrice midPrice expirationn timeleft dollarSpread annualizedPercentSpread coinVolume openInterestCoin } }
- variables:
{ "exchange": "deribit", "symbol": "BTC"}
Example Fields:
This endpoint has no fields.
Excel:
=CS.QUERY("GenesisVolatility LITE","LIVE Basis and dollar spread",{"gvol-lite","YOUR_GVOL_LITE_KEY";"query"," query CurrentObBasisVolumeOpenInterest($exchange: ExchangeEnumType, $symbol: SymbolEnumType) { CurrentObBasisVolumeOpenInterests: genericCurrentObBasisVolumeOpenInterest( exchange: $exchange symbol: $symbol ) { date instrument indexPrice markPrice midPrice expirationn timeleft dollarSpread annualizedPercentSpread coinVolume openInterestCoin } }";"variables","{ "exchange": "deribit", "symbol": "BTC"}"})
Googlesheets:
=CSQUERY("GenesisVolatility LITE","LIVE Basis and dollar spread",{"gvol-lite","YOUR_GVOL_LITE_KEY";"query"," query CurrentObBasisVolumeOpenInterest($exchange: ExchangeEnumType, $symbol: SymbolEnumType) { CurrentObBasisVolumeOpenInterests: genericCurrentObBasisVolumeOpenInterest( exchange: $exchange symbol: $symbol ) { date instrument indexPrice markPrice midPrice expirationn timeleft dollarSpread annualizedPercentSpread coinVolume openInterestCoin } }";"variables","{ "exchange": "deribit", "symbol": "BTC"}"})
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
-
Install the Cryptosheets add-in from the Microsoft AppSource Store
-
Install the Cryptosheets add-in from the Google GSuite Marketplace
-
After it is installed, make sure you are logged into your Cryptosheets account through the Cryptosheets side panel
Using the console
Using the console
- From the Cryptosheets Excel ribbon click
data
- From the Googlesheets Add-ons menu click
Cryptosheets
then selectLaunch side-bar
- Type in
GenesisVolatility LITE...
then click onLIVE Basis and dollar spread
- Scroll through the console parameters and input your values
- Select the cell you want to place the data into
- Click
make request
Using custom functions
Using custom functions
Tip: For both Excel and Googlesheeets you can use either the QUERY or QUERYA custom function
- Excel In any cell type the following:
=CS.QUERY("GenesisVolatility LITE","LIVE Basis and dollar spread",{"gvol-lite","YOUR_GVOL_LITE_KEY";"query"," query CurrentObBasisVolumeOpenInterest($exchange: ExchangeEnumType, $symbol: SymbolEnumType) { CurrentObBasisVolumeOpenInterests: genericCurrentObBasisVolumeOpenInterest( exchange: $exchange symbol: $symbol ) { date instrument indexPrice markPrice midPrice expirationn timeleft dollarSpread annualizedPercentSpread coinVolume openInterestCoin } }";"variables","{ "exchange": "deribit", "symbol": "BTC"}"})
- Googlesheets In any cell type the following:
=CSQUERY("GenesisVolatility LITE","LIVE Basis and dollar spread",{"gvol-lite","YOUR_GVOL_LITE_KEY";"query"," query CurrentObBasisVolumeOpenInterest($exchange: ExchangeEnumType, $symbol: SymbolEnumType) { CurrentObBasisVolumeOpenInterests: genericCurrentObBasisVolumeOpenInterest( exchange: $exchange symbol: $symbol ) { date instrument indexPrice markPrice midPrice expirationn timeleft dollarSpread annualizedPercentSpread coinVolume openInterestCoin } }";"variables","{ "exchange": "deribit", "symbol": "BTC"}"})
- 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 theclipboard 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("GenesisVolatility LITE","LIVE Basis and dollar spread")
for Excel or=CSPARAMETERS("GenesisVolatility LITE","LIVE Basis and dollar spread")
for Googlesheets
Using templates
Using templates
- From the Cryptosheets Excel ribbon click
templates
OR click on thetemplates tab
in the browse section - From the Googlesheets Add-ons menu click
Cryptosheets
then selectTemplates
- Load the template called
Query Builder
and type GenesisVolatility LITE and LIVE Basis and dollar spread - You can also try searching "GenesisVolatility LITE..." 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 GenesisVolatility LITE here
- See tutorials and examples for GenesisVolatility LITE on the Cryptosheets YouTube channel
- Troubleshooting: please reference the following troubleshooting code: QUE-1912-7104. Learn more here
Tags: LIVE Basis and dollar spread
GenesisVolatility LITE
endpoint