Equity · Global · CFDs, ETFs, funds, futures · Monthly · Global Free

Oil-Driven Equity Allocation via Monthly Regression

Onsite backtest IDE

Quant Buffet native backtest IDE

Edit and run Quant Buffet Python for Oil-Driven Equity Allocation via Monthly Regression 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 · 50 lines

"""
Quant Buffet interactive lab — crude-oil-predicts-equity-returns
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 = ['SHY', 'BIL']
LOOKBACK = 252
CASH = 'BIL'

def make_on_day(prices: pd.DataFrame):
    cols = [c for c in ASSETS if c in prices.columns]
    if CASH not in cols and CASH in prices.columns:
        cols = cols + [CASH]
    risky = [c for c in cols if c != CASH]
    rets = prices[cols].pct_change(LOOKBACK)
    state = {"last": None}

def on_day(engine: PortfolioEngine, dt: pd.Timestamp) -> None:
        key = (dt.year, dt.month)
        if state["last"] == key:
            return
        state["last"] = key
        scores = {
            s: float(rets.at[dt, s])
            for s in risky
            if s in rets.columns and pd.notna(rets.at[dt, s])
        }
        if not scores:
            engine.set_target_weights(dt, {CASH: 1.0} if CASH in cols else {})
            return
        best = max(scores, key=scores.get)
        if scores[best] > 0:
            engine.set_target_weights(dt, {best: 1.0})
        elif CASH in cols:
            engine.set_target_weights(dt, {CASH: 1.0})
        else:
            engine.set_target_weights(dt, {})

ready = rets.dropna(how="all").index.min() if rets.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

2.05%

Sharpe

1.50

Max DD

-2.23%

Vol

1.36%

Sortino

2.53

Beta

-0.02

Up days

59%

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: Absolute momentumAssets: SPY, TLT, GLD, BIL

# Generated from Quant Buffet → QuantConnect LEAN
# Strategy: Oil-Driven Equity Allocation via Monthly Regression
# Detected pattern: Absolute momentum
# 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 with positive 252-day return; equal-weight; monthly.

    def Rebalance(self):
        # Pattern: abs_momentum — Long assets with positive 252-day return; equal-weight; monthly.
        # Default: equal-weight. Port your make_on_day weights here via SetHoldings.
        w = 1.0 / len(self.symbols) if self.symbols else 0.0
        for symbol in self.symbols:
            self.SetHoldings(symbol, w)

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

Screenshot from the original paper

Strategy in a nutshell

Several types of oil can be used (Brent, WTI, Dubai, etc.) without big differences in results. The

Economic rationale

Equity predictability is explained by the underreaction hypothesis. It seems that it takes time before information about oil price changes become fully reflected in stock market prices. Underreaction can occur due to a possible difficulty for investors to assess the impact of information on the value of stocks, or when investors react to information at different points in time.

III. SOURCE PAPER

Striking Oil: Another Puzzle? [Click to Open PDF]

Gerben Driesprong, Erasmus University Rotterdam - Rotterdam School of Management ; Ben Jacobsen, Tilburg University - TIAS School for Business and Society; Massey University ; Benjamin Maat, APG Asset Management

Changes in oil prices predict stock market returns worldwide. In our thirty year sample of monthly returns for developed stock markets, we find statistically significant predictability for twelve out of eighteen countries as well as for the world market index. Results are similar for our shorter time series of emerging markets. We find no evidence that our results can be explained by time varying risk premia. Even though oil price shocks increase risk, investors seem to underreact to information in the price of oil: a rise in oil prices does not lead to higher stock market returns, but drastically lowers returns. For instance, an oil price shock of one standard deviation (around 10 percent) predictably lowers world market returns by one percent. Oil price changes also significantly predict negative excess returns. Our findings are consistent with the hypothesis of a delayed reaction by investors to oil price changes. In line with this hypothesis the relation between monthly stock returns and lagged monthly oil price changes becomes substantially stronger once we introduce lags of several trading days between monthly stock returns and lagged monthly oil price changes.

Backtest performance

Annualised return2.05%

Volatility1.36%

Beta-0.02

Sharpe ratio1.50

Sortino ratio2.53

Maximum drawdown-2.23%

Win rate59%