Researching trading ideas in Excel

In this webinar, James explores a simple seasonality effect and finds that there’s more to the story than an upwardly sloping equity curve. Watch the video to see how you can use Excel to explore market phenomena efficiently and gather evidence that you can use to make practical trading decisions. If you’d like to master …

Read more

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

Quick fix: Yahoo Finance data access with Excel

Having a reliable source of free data is extremely handy for the independent trader. It allows you to move fast and look into your ideas quickly. Yahoo Finance recently changed how you can access their historical stock data. No more simple downloads from the website and programmatic access now requires a different approach. For the …

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