Modelling UVXY trading strategies with Excel

UVXY is an ETF that targets 1.5x the daily returns of a 30-day constant-maturity position in VX futures – the SPVIXSTR index. Before 2018, it targeted 2x returns – but Volmageddon ruined the fun. UVXY has to trade every day: Anyone can trade UVXY in the market, and it trades close to the index because …

Read more

A Simple Trick for Dealing with Overlapping Data

Last week, we looked at simple data analysis techniques to test for persistence. But we only looked at a feature that is measured over a single day – the absolute range. Such a feature makes it easy to test persistence because you don’t have the problem of overlapping data. Each data point is entirely self-contained …

Read more

Beyond Stocks: The Surprising Volatility Returns of Oil and Gold

I’ve previously discussed the Volatility Risk Premium (VRP) and how it differs from the Equity Risk Premium (ERP). Probably the most interesting difference, from the perspective of the trader, is that the VRP may be somewhat amenable to timing – more than the ERP at any rate. In this article, I’ll use some of the …

Read more

How To Be a Quant Trader – Experiments with QuantConnect

  This post presents an analysis of the SPY returns process using the QuantConnect research platform. QuantConnect is a strategy development platform that lets you research ideas, import data, create algorithms, and trade in the cloud, all in one place.  For this research, I’ve used their online research notebook, and it came preinstalled with all …

Read more

Working with Tidy Financial Data in tidyr

Holding data in a tidy format works wonders for one’s productivity. Here we will explore the tidyr package, which is all about creating tidy data. In particular, let’s develop an understanding of the tidyr::pivot_longer and tidyr::pivot_wider functions for switching between different formats of tidy data. In this video, you’ll learn: What tidy data looks like …

Read more

How to Hedge a Portfolio with Put Options

There are 2 good reasons to buy put options: because you think they are cheap because you want downside protection. In the latter case, you are looking to use the skewed payoff profile of the put option to protect a portfolio against large downside moves without capping your upside too much. The first requires a …

Read more