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
-
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 Cash Secured Puts
- 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 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 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"}"})
- 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 Cash Secured Puts")
for Excel or=CSPARAMETERS("GenesisVolatility LITE","LIVE Cash Secured Puts")
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 Cash Secured Puts - 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