Advanced crypto asset portfolio management strategies and tools.
Easily access live trading account data including orders, trades, balance, P&L, margin, greeks & more. Learn how to perform complex analysis & market risk calculations with simple, automatically refreshing formulas using Cryptosheets.
This article highlights several use case examples from an institutional crypto fund manager including (actual) screenshots of advanced dashboards & models they have built using the Deribit API integration with Cryptosheets. This content is intended for active traders, analysts, institutional investors, portfolio managers and advanced operators.
In this article we will:
- Background: Showcase the advantages of using Deribit API data with the Cryptosheets add-in(Jump to section on how to add the API to Cryptosheets, here).
- How to Get Data: Explore different ways to search, find & extract key data.
- Examples: Highlight relevant examples using specific API endpoints & formulas.
- UPDATE: You can now also access & easily use the Genesis Volatility GraphQL API endpoints (both professional and API LITE versions) in Cryptosheets along with the Deribit API!
Example Crypto Fund Dashboard automatically updating in real time with positions, counterparty exposures, P&L, market betas and much more.
Deribit has been the best in class crypto options exchange since their inception. Their experienced team, outstanding tech stack, markets and a well maintained, comprehensive API service represent a competitive edge when applied using Cryptosheets.
Crypto derivatives are a critical necessity for mainstream institutional adoption. Options are often used by the most sophisticated funds & trading desks for managing risk.
Deribit is one of the only directly & natively integrated secure exchange APIs (outside of enterprise accounts). This is a genuine gamechanger for options traders, analysts & portfolio managers from small to world class funds who can easily access their entire Deribit account including all the available & advanced data — from the comfort and familiarity of their Excel or Google Spreadsheets.
- Securely connect to your Deribit account & subaccounts.
- Access the entire Deribit API including public & private endpoints.
- Leverage Cryptosheets tools including global parameters & technical indicator functions with any Deribit data.
- Automatically refresh any API endpoint data at any custom interval.
- Combine data including Genesis Volatility (using the fully integrated Gvol.io API) to build dynamic risk management models.
How to get data
This article highlights the unique advantages of using the Deribit API through Cryptosheets including several ways to leverage the platform to easily access real time account & market data.
Combining access to real time account data including positions, trades, orders, P&L with advanced market analytics like greeks, implied volatility and much more for thousands of options trading on the Deribit exchange — all through simple, automatically refreshing spreadsheet formulas is a gamechanger.
Accessing historical account trades using the formula builder to easily create simple formulas in Google Sheets or Excel
Simple formulas and basic account data can quickly be modeled into dynamic dashboard providing real time market insights and data driven analysis…
Example Crypto Fund Dashboard automatically updating in real time with positions, counterparty exposures, P&L, market betas and much more.
NOTE: This post was co-written by a ghostwriter from an active crypto hedge fund and long time institutional Cryptosheets account who has requested to remain anonymous — we are grateful for their help and willingness to share what they have created.
Background
Deribit API allows you to pull real-time information regarding your portfolio and markets. Harnessing this data as an institutional investor may allow you to make better real-time trading decisions and provide historical tracking of portfolio performance. Using Cryptosheets allows you to pull this information right into excel, making it easy for everyone to analyze this information. We have investors that are not technically proficient enough to use python, and love seeing this data in spreadsheet form.
A few examples of utility:
- Tracking your Portfolio Balance is a really important step in Portfolio Risk Management. We are given insight into how we have performed in different market regimes. Deribit pulls information from all your subaccounts on the platform, allowing you to take snapshots.
Pull BTC / ETH Equity Balances:
- One of the ways one could look at why our portfolio moved in a certain way is by tracking our current and historical delta and theta. This shows how we were positioned ahead of some moves in the market. This is important as you want to make sure you have the correct amount of exposure on, for the move you anticipate.
Get Open Orders:
Open via CryptoSheets app here.
Accessing open orders on all your positions using the formula builder to easily create simple formulas in Google Sheets or Excel.
Get Open Positions:
Open via CryptoSheets app here.
Get live market pricing & risk on all your positions using the formula builder to easily create simple formulas in Google Sheets or Excel.
…using the Cryptosheets built in global parameters, we can easily transform and format the response to return only the exact data fields we need in the exact order we need…
Get SubAccounts:
Open via CryptoSheets app here.
(Keep in mind that you will have to do this number of positions that you have. If you set up the fields in the form of a string, this will be easy to mass pull positions).
- Other metrics such as the amount of Premium Outstanding allow us to see what our portfolio greeks were composed of. You can further bucket this information into Call Premium & Put Premium. These statistics can be used to understand the exposure of your strategy (IE Call Overwriting / Collaring / Put Underwriting).
- Combining these tools, we can create dashboards that convey useful information regarding your portfolio.
Other Useful Formulas
Time Stamp Input in excel:
- =+(A1-DATE(1970,1,1))*86400000
Order History (12/1/2021 to 12/14/2021):
Deribit Bankruptcies:
Deribit Funding Rate History:
Helpful Tips:
- CS.TIME() for refresh.
- Data refresh, url.
- At the end of your query add “time”, CS.Time(“120”) to refresh every 2 minutes (see example below).
Note: CS.TIME() requires a premium paid Cryptosheets subscription.
Example: Using the CS.TIME Cryptosheets formula to automatically refresh any formula at any custom interval:
Additional Resources
Dedicated Deribit resources for Cryptosheets:
Downloads
Get Excel add-in:
Get Google Sheets add-in:
Additional
Troubleshooting
- See FAQ and troubleshooting help topic in the help center here.
- Explore troubleshooting tips & tricks in the quick docs section here.
Tutorials
- Explore tutorials here.
How to add your Deribit API key in Cryptosheets
Update your Cryptosheets settings with your Deribit API key to instantly access all of your positions, orders & trades in real time.
Follow these quick steps to enable full access to all of your Deribit account data from inside Cryptosheets in Excel or Googlesheets.
Adding your API key
Follow these steps:
1. Get your Deribit API key from your account page on the Deribit API website.
2. Login to your Cryptosheets account.
3. Go to the settings section.
4. Select All Integrations.
5. Activate your Deribit integration.
6. Follow the steps to enter your required credentials (see pictures below). including your:
Test a Deribit API Private Endpoint to Verify
Follow these steps:
1. From Cryptosheets select a Deribit private endpoint.
2. Press Make Request OR enter a custom function.
Excel:
Google Sheets:
3. Verify to see your holdings.
4. For larger accounts remember there are defaults on results returned but you can easily adjust these to return your entire portfolio.
Explore Deribit Tutorials & Help Docs
1. Visit the Cryptosheets Docs portal.
2. Select Deribit from the left menu (under providers)
Use quick access support resources
1. Cryptosheets Docs portal dedicated endpoint page.
2. Provider’s native API docs page.
3. YouTube example & tutorial link.
Click the provider support link to launch the Deribit API docs page for additional support.
Important: Deribit maintains strict geographical and jurisdictional based KYC/AML restrictions which may preclude you from using the Deribit / Cryptosheets integration based on your IP address, please contact us with any issues or questions.
AUTHOR(S)
Hundreds of providers. Thousands of data sets. Real time streaming data into your worksheets. Markets, onchain, metrics, derivatives, defi, NFT, taxonomy, stocks, bonds, ETFs, indices. More crypto data than anywhere else, combined. Crypto data just got easy.