Tuesday, 4 August 2020

Buckle Up for Virgin Galactic

Without looking too closely Virgin Galactic (ticker SPCE) struck me as a theme park company. Albeit a pretty darn fun one. And premium too. A cool quarter million for 5 minutes of weightlessness. This perception was further supported by the recent appointment of the former head of Disney's parks as the company's CEO. Galactic has teased that they might one day extend their product to point-to-point supersonic commercial travel. But it has been careful not to do so in any of its SEC disclosures. This trend continued Monday as the company dropped three pieces of news:

One the left is the announcement of a proposed $460m equity raising for "general corporate purposes". In the middle is the announcement of financial results, with zero revenue and more than $120m burned in the six months of this year to date (about a third of its remaining cash on hand). On the right is the announcement of a non-binding agreement with Rolls Royce to explore engine development for high speed commercial aircraft.

Company insiders chose to emphasise the latter news. Galactic Chairman, and all round slick talker, Chamath Palihapitiya shared some sexy renders:

The first two pieces of news are the meat, and the third is the potato. Rolls Royce recently announced a development agreement with Boom Supersonic, a company strictly focused on developing a supersonic commercial aircraft. There is no obligation to Rolls Royce and need not be any incremental effort from them while they garner some PR value from the Virgin Galactic news. Virgin Galactic accrues some hype to support its capital raising efforts. A cynical ploy that will probably work. But if Galactic was serious about supersonic travel there might be some mention of it in their SEC filings. There remains none as of this writing. And if the company were serious about technology development it might not have appointed a career theme park manager as CEO. 

Incidentally Boom Supersonic has raised just $150m to date, which has supported six years of development to the launch of its supersonic prototype in the coming year. It's difficult to tell what is really going on under the covers of these companies, but on the surface it appears Boom is vastly more capital efficient and focused on delivering commercial value than Virgin Galactic is. But that has not stopped the public markets giving Galactic about 10 times the capital and 5 times the valuation that the private markets have given Boom.

- Vincent

[Disclosure: I am a private investor in Boom Supersonic, and may or may not go long Virgin Galactic as a short term momentum play on this news] 

Monday, 13 January 2020

Navigating the Options Cycle on Tesla

Tesla is one of the most volatile large cap stocks in the market. It's a battleground stock with the war between longs and shorts waged in each buy or sell order, and each resulting fluctuation of its stock price. In about a year the price has gone from $377 in December 2018, halving to $177 in June 2019, subsequently tripling to close at $525 most recently on the 13th of January 2020.

The stock war is waged not just in the direct purchase or sale of the stock, or in the media, but in the options market too, where insufficient attention is paid by the ordinary investor, and where much descriptive value may be found. The options market can exhibit reflexivity, a circular relationship between cause and effect. The strike price of price of an option can act as a magnet pulling the underlying stock price, creating a virtuous, or vicious, cycle depending on where you have placed your own bets. The options activity in Tesla is unique in several respects, and understanding this will aide understanding of the volatility in the underlying stock price.

According to the Options Clearing Corporation the open interest in put options on Tesla stock amounted to 160 million units on the 13th of January. This is more than the number of shares in Tesla's float, an unusually large number of open options that suggests a large degree of influence over the underlying stock. There were 80 million call options on this date for a 2:1 Put-Call ratio. This is in contrast to an approximate 1:1 Put-Call ratio across the market and suggests a high degree of bearish sentiment toward Tesla stock.
The Put-Call ratio is a common, albeit crude, measure of investor sentiment. In the case of Tesla it is is significantly misleading, as less superficial analysis will reveal. Not all options are created equally and not all options should be weighted equally.

Two of the key factors in the relationship between a call or put option and the underlying stock price are the strike price of the option, and the expiration date. This is where two important facts will emerge.

1) Most put option volume on Tesla stock is currently deep out of the money, and most call option volume is in the money, as the following volume chart segmented by option strike price reveals:
Based on the 13th of Jan closing price of about $525 per share of Tesla stock, more than 99% of put options are out of the money, and 65% of call options are in the money.

2) Nearly half of call and put option volume expires on the 17th of Jan, as the following volume chart segmented by option expiry date reveals:
This means that there is only a narrow window of time remaining for movements in the underlying stock price to effect the intrinsic value of the outstanding options.

Combining the above facts under the assumption that counterparties have hedged their exposure, we can determine what has been the impact to the underlying stock demand of these contracts, and how this might change in response to changes in the underlying stock price. Options pricing theory provides just such a mechanism - Delta Hedging. For our purposes the most important thing to know about Delta Hedging is that the more likely an options contract is to be exercised, the greater the number of underlying shares the counterparty to that contract needs to transact in to hedge their exposure.
The chart above contrasts the gross number of options reported with the number of underlying share transactions that would currently be required to offset counterparty exposure to that option contract. The 80 million call options equate to 50 million share purchases. The 160 million put options equate to 5 million short sales.

The same options pricing theory that provided us with Delta-Hedging, the Black-Scholes model, also provides a mechanism to calculate the value of the call and put options, and the calculated values of these options track closely to recent trade prices of those options. This implies this is not simply a theoretical exercise but has some basis in reality with regards to the any underlying share transactions to offset the exposure on these options, and the observed activity in Tesla stock.

It's important to recognise that the number of shares required to offset an options position is not static and changes, most importantly, with the price of the underlying stock. The following chart shows the Delta Hedged volumes segmented by different underlying stock prices:
The chart shows that between the underlying stock price of $500 and $525 the number of share purchases required to offset the call position increases from 45 million to 50 million as more call options are deeper in the money and more likely to be exercised. Conversely, the number of short sales required to to offset the put position reduces from 8 million to 5 million as more put options are deeper out of the money and less likely to be exercised. This equates to a net increase in demand for Tesla stock of 8 million shares. Such a price move therefore induces as much demand for Tesla stock as the third largest institutional investor in Tesla, the Saudi Public Investment Fund, has accumulated over time.

The actual stock price increase of $47 on the 13th of Jan is enough to stimulate demand for nearly 17 million shares of Tesla stock, more than the single largest institutional investor in Tesla, Baillie Gifford, has accumulated, and all in a single day. This reflects a virtuous (or vicious) cycle where a stock price increase induces further demand for Tesla stock which all else equal will push the price up further as further counterparty share purchases are required to offset their options exposure. The reverse is also true, as a reduction in the share price would have the exact opposite effect. This self-reinforcing cycle explains the volatility and periods of momentum we have seen in Tesla stock to a significant degree, but there are caveats. There will be differences in timing and extent to which counterparties hedge their exposure. And other factors influence the stock price too, principally market participants deciding whether to continue to participate, or to place their chips elsewhere.

- Vincent

[Disclosure: long time holder of Tesla stock]

Sunday, 24 November 2019

The Man Who Solved the Market

By now many of you will be familiar with the investment record of Renaissance Technologies. A book on the subject came out earlier this month.
For the uninitiated their Medallion Fund has compounded at 66% p.a. for multiple decades, 39% p.a. after the most delicious fees in the industry. $1 invested in 1988 would be worth $19,500 in 2018. That is if you were fortunate enough to remain invested, as many early LP's were not. The fund size has apparently been capped at around $10 billion, in order to preserve high percentage returns.

We can never completely rule out that this is a blind-folded monkey throwing darts. But if that is the case then it is one hell of a monkey. Or it's an 800 pound gorilla.

This performance is even more striking because the fund apparently employs few, if any, finance domain experts. Mathematician Isadore Singer described Renaissance as having "the best physics and mathematics department in the world". This capability is combined with a data-driven, quantitative approach across multiple asset classes, and a reported 2 day average holding period.

It's a powerful story of just what is possible with data, and I love it because of that. But unless you also have a team of world class scientists, their approach may not be one that you want to try to emulate exactly. There may or may not be room for a few more players deploying similar strategies to the Medallion fund, and at similar scale. But their very existence suggests that for many others with a quantitative focus, their efforts may best be expended by doing what the Medallion Fund does not.

- Vincent

Tuesday, 27 August 2019


Another day, another great investment site. This one is Pininvest which curates investment themes, amongst other things. It's a great place to generate ideas and insight into domains which are topical and which you find interesting.

- Vincent

[Disclosure: uses Sharadar data]

Tuesday, 15 January 2019

Latest Updates

Here at Sharadar HQ we are pretty obsessed with expanding our datasets and making them increasingly valuable to our customers. A downside of the singular focus on expanding our datasets is that we are not particularly good at taking the time to tell our customers about these improvements.

This post is an effort to remedy this situation. We'll list recent updates to the datasets, and we'll keep adding to this same post for future updates. We have many future updates in the pipeline, so you can keep checking back here. At some point we'll also backfill the full history of updates, because we're sticklers for completeness.

This post can be read in conjunction with our progress post which charts the high-level long term trend in our expansion efforts.

Latest updates:

15 January 2019 - Added current & historical S&P500 constituents as a free update for our fundamentals customers (here).

15 January 2019 - Added corporate actions as a free update for our fundamentals and equity prices customers (here, here, here and here). Focused initially on stock splits and expanding in the future to cover a broader array of corporate actions.

5 January 2019 - Passed the 20,000 ticker milestone for coverage in our equity and fund prices offering (here).

26 December 2018 - Added Exchange Traded Debt (ETD) as a free update for our fund price customers (here and here).

2 November 2018 - Added daily resolution of price-based metrics as a free update for our fundamentals customers (here and here).

14 October 2018 - Added preferred stock and stock warrants to coverage as a free update for our equity prices customers (here, and here).

7 June 2018 - Passed the 15,000 ticker milestone for coverage in our equity and fund prices offering (here).

7 June 2018 - Launched our EOD fund price offering (here, and bundled with equity prices here). Focused initially on ETFs, CEFs and ETNs and subsequently expanded to include Exchange Traded Debt (ETD).

24 April 2018 - Added indicator (field) descriptions that are retrievable via API as a free update for our fundamentals, insiders, institutional holdings, equity prices and the bundle customers.

24 April 2018 - Added rich ticker/company meta data that is retrievable via API as a free update for fundamentals, equity prices and the bundle

- Vincent

Wednesday, 28 November 2018


Another excellent investor tool joins the ranks - Koyfin

I've learnt a lot from using it, and recommend that you check it out too.

- Vincent

[Disclosure: uses Sharadar data]

Wednesday, 24 October 2018


Udacity has launched a new nanodegree program focused on artificial intelligence for trading.
It uses Sharadar data for part of the curriculum and so of course I think the course is great. But in this case it is actually true. It has been a pleasure to deal with Udacity throughout. It was also kinda cool since Udacity played a big part in me personally upskilling from an advanced spreadsheet jockey to computer programmer all those years ago. I still recommend their free CS 101 course as the best way to get started.

Update: sadly it appears Udacity no longer offers the same introductory course I took years back, the prior link will now redirect you to a replacement course which is quite a bit different. The course I took and recommended was titled "Building a Search Engine", taught by the excellent David Evans.

- Vincent