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:
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.
Copy to Clipboard
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.
Copy to Clipboard
Pull BTC / ETH Equity Balances:
Copy to Clipboard
- 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.
Copy to Clipboard
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.
Copy to Clipboard
(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):
Copy to Clipboard
Copy to Clipboard
Deribit Funding Rate History:
Copy to Clipboard
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:
Copy to Clipboard
Additional Resources
Dedicated Deribit resources for Cryptosheets:
Downloads
Get Excel add-in:
Get Google Sheets add-in:
