{"paper_id":"2309.06393","title":"Real-time VaR Calculations for Crypto Derivatives in kdb+/q","authors":["Yutong Chen","Paul Bilokon","Conan Hales","Laura Kerr"],"paper_date":"2023-09-11","paper_type":"empirical","paper_url":"https://arxiv.org/pdf/2309.06393v1","page_url":"https://thequant.space/flowcharts/real-time-var-calculations-for-crypto-derivatives-in-kdb+/q/","scores":{"empirical_rigor":7.5,"math_complexity":6,"quadrant":"Holy Grail"},"proposes":{"status":"available","statement":"The paper proposes a real-time VaR calculation workflow for cryptocurrency derivative portfolios using kdb+ and analytical approximations.","quote":"The objective of this thesis is to build a real-time computation workflow that provides VaR estimates for non-linear portfolios of cryptocurrency derivatives.","summary":"Cryptocurrency market is known for exhibiting significantly higher volatility than traditional asset classes. Efficient and adequate risk calculation is vital for managing risk exposures in such market environments where extreme price fluctuations occur in short timeframes. The objective of this…","strategy":null},"assumptions":{"status":"available","items":[{"assumption":"A frictionless market is assumed for realised variance to be a consistent estimator of quadratic variance.","type":"market","stated":"explicit","quote":"For realised variance to be used as a consistent estimator of quadratic variance (QV), an important assumption is a frictionless market, or in stochastic process term, the log-price process must be a continuous semimartingale."},{"assumption":"Error terms in GARCH models are assumed to follow non‑Gaussian distributions such as Student‑t.","type":"model","stated":"explicit","quote":"it is common to assume error terms follow non-Gaussian distributions, such as Student-t, skewed Student-t and generalised normal distribution."},{"assumption":"High‑frequency market data are assumed to be available and can be processed in real time.","type":"data","stated":"explicit","quote":"We present a calculation workflow which harnesses the information embedded in high-frequency market data and the computation simplicity inherent in analytical estimation procedures."},{"assumption":"Delta‑gamma‑theta approach approximates the tail behaviour of the portfolio return distribution.","type":"model","stated":"explicit","quote":"To further reduce the calculation latency, delta-gamma-theta approach is chosen as a replacement of the commonly used historical or Monte Carlo simulation approach, to approximate the non-Gaussian distribution of portfolio returns."},{"assumption":"The covariance matrix elements are forecasted independently, implying positive semi‑definiteness is not guaranteed.","type":"model","stated":"implied","quote":"In the context of our inference algorithm, the elements within the covariance matrix are forecasted independently."},{"assumption":"Parallel processing is assumed to be available but only minimally exploited due to the limited number of underlyings.","type":"execution","stated":"implied","quote":"kdb+ is capable of supporting parallel processings with threads and multi-processes. In this work, we could only exploit this benefit to a minimal extent, given there are only two indices within the scope of this work."}]},"datasets":{"status":"available","items":[{"name":"Deribit exchange data","provider":"Deribit","kind":"options","access":"unknown","period":null,"universe":"Bitcoin (BTC) and Ethereum (ETH) futures and European‑style cash‑settled options","quote":"In this thesis, financial time series data are sourced from Deribit exchange, a leading cryptocurrency exchange that specialises in the futures and European-style options market.","known_id":"deribit"}],"known":[{"id":"deribit","name":"Deribit","provider":"Deribit","kind":"options","access":"public","quote":"e groups: • data service responsible for collecting, processing and storing market data • calculation service responsible for calculating VaR estimate in real time • user interface responsible for delivering calculation result and other market data analytics 10 Real-time VaR Calculations A PREPRINT Figure 6: Architecture Diagram 3.2 Real-time Data Sourcing with kdb+ Regarding the primary data source, we employed the ","mentions":21,"used_in":5}],"sample":{"start":null,"end":null,"market":null,"asset_class":null,"frequency":null},"data_resolution":"tick"},"transaction_costs":{"status":"not_applicable","modeled":"n/a","headline_net_of_costs":null,"detail":null,"quote":null,"source":"front_matter","rule":"R3","candidates":{"front_matter":"n/a","evidence_card":"n/a","evidence_card_quoted":false},"meaning":"the paper reports no trading or execution result"},"results":{"status":"available","evaluation_type":"unclear","findings":[{"finding":"The HAR model achieved the best inference accuracy, passing all back‑test criteria (9/9).","kind":"performance","quote":"Overall, HAR has the best performance in terms of accuracy."},{"finding":"EWMA exhibited the lowest calculation latency but suffered from clustered violations and risk underestimation.","kind":"performance","quote":"EWMA exhibited superior performance in terms of calculation latency due to its computational simplicity, it fell short in adequately capturing the dynamics of volatility, resulting in clustered violations and underestimations of the risk level."},{"finding":"The real‑time workflow delivers VaR estimates with latencies on the order of milliseconds.","kind":"performance","quote":"This workflow yields reasonably robust VaR estimates with calculation latencies on the order of milliseconds."},{"finding":"DCC‑GARCH estimator showed more profound underestimation compared to EWMA, as indicated by a larger number of violations across VaR levels.","kind":"statistical","quote":"the issue of underestimation is more profound in DCC-GARCH estimator than EWMA estimator as indicated by the larger number of violations across the three VaR levels."},{"finding":"HAR passed unconditional coverage and independence tests for all three VaR levels, while EWMA and GARCH were rejected at higher confidence levels.","kind":"statistical","quote":"For HAR estimator, while it showed a robust performance for 95% 1‑day VaR metrics, it should be rejected at 99% confidence level for 97.5% and 99% 1‑day VaR."}],"reported_performance":null,"out_of_sample":{"method":"unclear","headline_out_of_sample":null}},"independent_evidence":{"status":"none_found","supports":[],"contradicts":[],"qualifies":[],"compared_with":28,"citations":{"cited_by_in_corpus":0,"by_independent_authors":0,"how_cited":{"used_as_baseline":0,"uses_method_or_data":0,"extends":0,"discusses_findings":0,"mentions":0,"unclassified":0},"independent_papers":[],"scope":"Citations between papers in this corpus only; citations from outside it are not counted."}},"implementation":{"status":"available","public":false,"code_url":null,"note":"No repository presented by the authors as their own was found in the paper. Absence here is not proof that no code exists."},"replication":{"status":"none_found","card":null,"note":"No replication of this paper has been run by thequant.space yet."},"extraction":{"text_source":"fulltext","model":"openai/gpt-oss-120b","version":1,"extracted_at":"2026-11-14T18:22:16Z"},"provenance":{"claims":"Everything here is what the authors state in the paper. Nothing was re-run or reproduced by the platform.","quotes":"Assumptions, datasets, cost detail and findings were extracted by a language model. Every quote is verbatim paper text. Where an item has `support`, \"full\" means every figure in it appears in the quoted sentences and \"partial\" means a figure is stated elsewhere in the paper; items with a figure found nowhere in the paper were discarded.","datasets_known":"datasets.known lists well-known vendors and public datasets by a stable id, found by a dictionary over the full text where the sentence says the data is used; it is independent of the model and covers only names in the dictionary.","flags":"transaction_costs.modeled, results.evaluation_type and results.out_of_sample.method are platform classifications (structured-decision models); see https://thequant.space/score-guide/#penalty-flags","comparisons":"supports / contradicts / qualifies are a language model's reading of two papers' quoted findings, restricted to closely related papers that share no author. They are pointers to read, not verified replications, and coverage is partial.","implementation":"code_url is a repository the paper itself presents as its own (rule-scored, ambiguous cases judged by a model), checked for liveness when it was recorded."},"docs":"https://thequant.space/agents/"}