Commodity · Global · futures · Daily · Global Free

WTI-Brent Spread Reversion via 20-Day SMA

Onsite backtest IDE

Quant Buffet native backtest IDE

Edit and run Quant Buffet Python for WTI-Brent Spread Reversion via 20-Day SMA in the browser. Results update live with equity, drawdown, and metrics charts. Allowed: backtest.data, backtest.engine, backtest.metrics, numpy, pandas. Define ASSETS and make_on_day(prices). Shortcut: Ctrl+Enter. API docs →

IDE · 40 lines

"""
Quant Buffet interactive lab — trading-wti-brent-spread
Allowed: backtest.data / backtest.engine / backtest.metrics, numpy, pandas.
Required: ASSETS = [...] and def make_on_day(prices): -> (on_day, ready)
"""
from __future__ import annotations

import numpy as np
import pandas as pd

from backtest.data import load_daily_prices
from backtest.engine import EngineConfig, PortfolioEngine
from backtest.metrics import compute_metrics

ASSETS = ['GLD', 'SLV', 'DBC', 'GSG', 'USO', 'UNG', 'DBA']
SMA_DAYS = 200

def make_on_day(prices: pd.DataFrame):
    cols = [c for c in ASSETS if c in prices.columns]
    sma = prices[cols].rolling(SMA_DAYS, min_periods=SMA_DAYS).mean()
    state = {"last": None}

def on_day(engine: PortfolioEngine, dt: pd.Timestamp) -> None:
        if sma.loc[dt].isna().all():
            return
        key = (dt.year, dt.month)
        if state["last"] == key:
            return
        state["last"] = key
        long = [
            s for s in cols
            if pd.notna(prices.at[dt, s]) and pd.notna(sma.at[dt, s])
            and prices.at[dt, s] > sma.at[dt, s]
        ]
        w = {} if not long else {s: 1.0 / len(long) for s in long}
        engine.set_target_weights(dt, w)

ready = sma.dropna(how="all").index.min() if sma.notna().any().any() else None
    return on_day, ready

Quant Buffet syntax cheat sheet (copy / insert)

Paste these fragments into the editor. The sandbox rejects QuantConnect, os, and network libraries.

Required imports

Only these libraries are allowed in the sandbox.

from __future__ import annotations

import numpy as np
import pandas as pd

from backtest.data import load_daily_prices
from backtest.engine import EngineConfig, PortfolioEngine
from backtest.metrics import compute_metrics

ASSETS list (whitelisted ETFs)

Module-level list. Tickers must be in the Quant Buffet whitelist.

ASSETS = ["SPY", "QQQ", "TLT", "GLD", "BIL"]

make_on_day contract

Must return (on_day, ready). on_day calls engine.set_target_weights.

def make_on_day(prices: pd.DataFrame):
    cols = [c for c in ASSETS if c in prices.columns]
    sma = prices[cols].rolling(200, min_periods=200).mean()
    state = {"last": None}

    def on_day(engine: PortfolioEngine, dt: pd.Timestamp) -> None:
        if sma.loc[dt].isna().all():
            return
        key = (dt.year, dt.month)
        if state["last"] == key:
            return
        state["last"] = key
        long = [
            s for s in cols
            if pd.notna(prices.at[dt, s]) and pd.notna(sma.at[dt, s])
            and prices.at[dt, s] > sma.at[dt, s]
        ]
        weights = {} if not long else {s: 1.0 / len(long) for s in long}
        engine.set_target_weights(dt, weights)

    ready = sma.dropna(how="all").index.min() if sma.notna().any().any() else None
    return on_day, ready

Set target weights

Weights should sum to about 1.0. Empty dict = 100% cash.

engine.set_target_weights(dt, {"SPY": 0.60, "BIL": 0.40})

Live backtest performance

CAGR

4.48%

Sharpe

0.31

Max DD

-64.58%

Vol

22.27%

Sortino

0.47

Beta

0.17

Up days

48%

Run the backtest to populate charts.

Export to your platform

Transform Quant Buffet lab code (ASSETS + make_on_day / PortfolioEngine) into native classes for a third-party IDE — then copy and paste.

Target platform

Run in: QuantConnect Cloud or LEAN CLI · QCAlgorithm with Equity securities and monthly rebalance.

Detected pattern: SMA trendAssets: SPY, TLT, GLD, BIL

# Generated from Quant Buffet → QuantConnect LEAN
# Strategy: WTI-Brent Spread Reversion via 20-Day SMA
# Detected pattern: SMA trend
# Source uses Quant Buffet lab APIs (ASSETS + make_on_day / PortfolioEngine).
# Review fees, data, and risk before live trading — educational export only.

from AlgorithmImports import *


class QuantBuffetExport(QCAlgorithm):
    def Initialize(self):
        self.SetStartDate(2010, 1, 1)
        self.SetCash(100000)
        tickers = ["SPY", "TLT", "GLD", "BIL"]
        self.symbols = []
        for t in tickers:
            if "-" in t:  # crypto proxy e.g. BTC-USD
                self.symbols.append(self.AddCrypto(t.replace("-USD", ""), Resolution.Daily).Symbol)
            else:
                self.symbols.append(self.AddEquity(t, Resolution.Daily).Symbol)
        self.Schedule.On(
            self.DateRules.MonthStart(self.symbols[0]),
            self.TimeRules.AfterMarketOpen(self.symbols[0], 30),
            self.Rebalance,
        )
        # Logic: Long assets where close > SMA(200); equal-weight; monthly.

    def Rebalance(self):
        longs = []
        for symbol in self.symbols:
            hist = self.History(symbol, 200 + 5, Resolution.Daily)
            if hist.empty: continue
            close = hist["close"].unstack(level=0).iloc[:, 0] if hasattr(hist["close"], "unstack") else hist["close"]
            if len(close) < 200: continue
            if float(close.iloc[-1]) > float(close.iloc[-200:].mean()):
                longs.append(symbol)
        weight = 1.0 / len(longs) if longs else 0.0
        for symbol in self.symbols:
            self.SetHoldings(symbol, weight if symbol in longs else 0.0)

Exported code uses the platform’s native classes and libraries. Install dependencies in your third-party IDE, then run. Validate before live trading.

Academic paper

Trading and filtering futures spread portfolios: Further applications of threshold and correlation filters

AuthorsChristian L. Dunis; Jason Laws; Ben J. Evans

Institute

Liverpool John Moores University
?Professor of Banking and Finance at Liverpool Business School, Liverpool John Moores University,
DEFriedrich-Ebert-Stiftung e.V.
?GBT – Trading, Friedrich-Ebert-Straße, Kassel, 34119, Germany
?GBT – Trading, Friedrich-Ebert-Straße

Paper linkhttps://link.springer.com/article/10.1057/jdhf.2009.24

Screenshot from the original paper

Strategy in a nutshell

A 20-day moving average of WTI/Brent spread is calculated each day. If the current spread value is above SMA 20, then we enter a short position in the spread on close (betting that the spread will decrease to the fair value represented by SMA 20). The trade is closed at the close of the trading day when the spread crosses below fair value. If the current spread value is below SMA 20, then we enter a long position betting that the spread will increase, and the trade is closed at the close of the trading day when the spread crosses above fair value.

Economic rationale

Both oils differ in chemical compositions, and they also differ in production and transportation attributes. These differences are reflected in the price spread between both futures contracts. The spread is mean reverting because most of the price shocks are only temporal, so the spread moves back to its long term economic equilibrium, and therefore it is possible to create a trading strategy based on this mean reversion. Caution should be only needed in utilizing parameters from the

Backtest performance

Annualised return4.48%

Volatility22.27%

Beta0.17

Sharpe ratio0.31

Sortino ratio0.47

Maximum drawdown-64.58%

Win rate48%