LIVE Cash Secured Puts

Inputs: Exchange: Deribit, Bit.com, Okex, Binance, LedgerX Why do traders like this endpoint? The “Cash Secured Put” is a low-risk strategy with a similar payout profile to the “Covered Call”. Traders will sell a naked put but maintain enough cash to purchase the underlying asset at the predetermined strike price. This strategy is relatively low risk because a 100% collateralization ratio is maintained. Note: It’s important that the trader hold cash/stable coin, if the strike price is denominated in fiat.This endpoint will quickly return the annualized yields of various scenarios. Calculation: The “Cash Secured Put” yield data assume the trader maintains enough cash on hand AFTER proceeds from selling the put.EXAMPLE Trader’s cash position BEFORE selling put = $275 Short $300 Put Proceeds = $25 Trader cash balance AFTER short put proceeds = $300 (AKA 100% collateralization ratio)RETURN CALCULATIONS Absolute Yield: $25/$275 Annualized Yield: $25/$275 (525,600 / minutes left until expir

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 cashSecuredPuts($symbol: SymbolEnumType, $exchange: ExchangeEnumType) { genericCashSecuredPuts(symbol: $symbol, exchange: $exchange) { date instrumentName expiration strike putCall bidUsd markUsd askUsd absoluteBidYieldNet absoluteMarkYieldNet absoluteAskYieldNet bidYieldNetAnnual markYieldNetAnnual askYieldNetAnnual } }
  • variables: { "symbol": "BTC", "exchange": "deribit"}

Example Fields:

This endpoint has no fields.

Excel:

=CS.QUERY("GenesisVolatility LITE","LIVE Cash Secured Puts",{"gvol-lite","YOUR_GVOL_LITE_KEY";"query","query cashSecuredPuts($symbol: SymbolEnumType, $exchange: ExchangeEnumType) { genericCashSecuredPuts(symbol: $symbol, exchange: $exchange) { date instrumentName expiration strike putCall bidUsd markUsd askUsd absoluteBidYieldNet absoluteMarkYieldNet absoluteAskYieldNet bidYieldNetAnnual markYieldNetAnnual askYieldNetAnnual } }";"variables","{ "symbol": "BTC", "exchange": "deribit"}"})

Googlesheets:

=CSQUERY("GenesisVolatility LITE","LIVE Cash Secured Puts",{"gvol-lite","YOUR_GVOL_LITE_KEY";"query","query cashSecuredPuts($symbol: SymbolEnumType, $exchange: ExchangeEnumType) { genericCashSecuredPuts(symbol: $symbol, exchange: $exchange) { date instrumentName expiration strike putCall bidUsd markUsd askUsd absoluteBidYieldNet absoluteMarkYieldNet absoluteAskYieldNet bidYieldNetAnnual markYieldNetAnnual askYieldNetAnnual } }";"variables","{ "symbol": "BTC", "exchange": "deribit"}"})

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 GenesisVolatility LITE... then click on LIVE Cash Secured Puts
  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("GenesisVolatility LITE","LIVE Cash Secured Puts",{"gvol-lite","YOUR_GVOL_LITE_KEY";"query","query cashSecuredPuts($symbol: SymbolEnumType, $exchange: ExchangeEnumType) { genericCashSecuredPuts(symbol: $symbol, exchange: $exchange) { date instrumentName expiration strike putCall bidUsd markUsd askUsd absoluteBidYieldNet absoluteMarkYieldNet absoluteAskYieldNet bidYieldNetAnnual markYieldNetAnnual askYieldNetAnnual } }";"variables","{ "symbol": "BTC", "exchange": "deribit"}"})

  1. Googlesheets In any cell type the following:

=CSQUERY("GenesisVolatility LITE","LIVE Cash Secured Puts",{"gvol-lite","YOUR_GVOL_LITE_KEY";"query","query cashSecuredPuts($symbol: SymbolEnumType, $exchange: ExchangeEnumType) { genericCashSecuredPuts(symbol: $symbol, exchange: $exchange) { date instrumentName expiration strike putCall bidUsd markUsd askUsd absoluteBidYieldNet absoluteMarkYieldNet absoluteAskYieldNet bidYieldNetAnnual markYieldNetAnnual askYieldNetAnnual } }";"variables","{ "symbol": "BTC", "exchange": "deribit"}"})

  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("GenesisVolatility LITE","LIVE Cash Secured Puts") for Excel or =CSPARAMETERS("GenesisVolatility LITE","LIVE Cash Secured Puts") 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 GenesisVolatility LITE and LIVE Cash Secured Puts
  4. 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-7092. Learn more here

Tags: LIVE Cash Secured Puts GenesisVolatility LITE endpoint