Debunking market myths in Excel

Having the ability to call bullshit on market claims is a superpower. There’s some ancient trader lore that says it’s a bad idea to hold SPY when it’s under the 12-month moving average of its price. Is there anything to this idea? Check out the webinar below to see how we put this idea to …

Read more

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

Intuitive Options Pricing

In this article, we’ll use simulation and simple visualisations to build intuition around how different variables drive the price of an option. Building this intuition is important because it helps you react quickly and make decisions without relying on complex pricing models. Let’s get to it. The value of a call option at expiration A …

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

Getting Started with the Interactive Brokers Native API

Here at Robot Wealth, we trade with Interactive Brokers (IB) primarily because they offer access to global markets at a reasonable price. In recent times, IB has put some time and effort into upping its tech game, including development of an API for interacting with its desktop trading applications. An application that interacts with IB’s …

Read more