股票 · 欧洲 · 每日 Free

欧冠比赛日做空足球股票策略

登录后收藏

学术论文

理解投资者情绪：以足球为例

作者Gennaro Bernile; Evgeny Lyandres

机构

University of Miami
University of Miami - Department of Finance
Tel Aviv University
Tel-Aviv University

论文链接https://papers.ssrn.com/sol3/papers.cfm?abstract_id=1343685

导读

投资标的：VGK、EWU、EWG、EWQ、EWI、SPY。再平衡：每月。Universe: VGK, EWU, EWG, EWQ, EWI, SPY. Parameters: rebalance=monthly.

策略概要

该策略投资于流动性较好、公开交易的足球俱乐部股票。在欧冠或其他重要比赛前一交易日收盘做空参赛俱乐部股票，持有一日；若当日有多家俱乐部比赛，则等权配置。

经济逻辑

论文认为，股市对足球赛果反应低效，一个重要原因是投资者对赛果概率分布存在系统性信念偏差。博彩赔率由少数专家编制，并不反映投资者主观信念，而股价会反映。

入场与出场

入场

每月由 make_on_day 决定目标权重。当前宇宙：VGK, EWU, EWG, EWQ, EWI, SPY。请对照实验室代码中的 engine.set_target_weights。

出场

权重被设为空或该标的权重为 0 即视为出场。引擎按 5 bps 佣金 + 2 bps 滑点执行。

所需行情数据

需要 VGK, EWU, EWG, EWQ, EWI, SPY 至少 60 根复权收盘价，才能形成第一个有效信号。ETF 仅交易日有行情。实验室通过 backtest.data.load_daily_prices 读取 Yahoo Finance。

标的

VGK, EWU, EWG, EWQ, EWI, SPY

频率

每日 · 日频复权收盘价；信号按月再平衡（用当月最后一个有效交易日）

所需历史

每个标的至少 60 根交易日 K 线（约 3 个交易月），外加数根缓冲才能发出第一个信号。

字段

复权收盘价（Adj Close / auto_adjust Close）
交易日日期索引

凭证

回测与实验室：无需密钥
实盘下单才需要券商 / 交易所 API

API 与数据源

Quant Buffet 数据 API

实验室用 load_daily_prices 拉取 ASSETS 的复权收盘价面板，磁盘缓存后回测可复现。

提供方: backtest.data.load_daily_prices
鉴权: 回测无需密钥
接口: load_daily_prices(ASSETS, start="2000-01-01")

API / docs → /zh/docs/data-api

Yahoo Finance（yfinance）

美股 / ETF 复权 OHLCV，免费研究接口，有速率限制。

提供方: yfinance → Yahoo Finance
鉴权: 公开历史无需密钥
接口: Ticker.history / yf.download(auto_adjust=True)

API / docs → github.com/ranaroussi/yfinance

Onsite backtest IDE

Quant Buffet 原生回测 IDE

Edit and run Quant Buffet Python for 欧冠比赛日做空足球股票策略 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 · 43 lines

"""
Quant Buffet interactive lab — 欧冠比赛日做空足球股票策略
Allowed: backtest.data / backtest.engine / backtest.metrics, numpy, pandas.
Required: a module-level ASSETS list, and def make_on_day(prices) returning (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 = ['VGK', 'EWU', 'EWG', 'EWQ', 'EWI', 'SPY']
REBALANCE_ONCE = False

def make_on_day(prices: pd.DataFrame):
    cols = [c for c in ASSETS if c in prices.columns]
    state = {"last": None, "done": False}

    def on_day(engine: PortfolioEngine, dt: pd.Timestamp) -> None:
        available = [s for s in cols if pd.notna(prices.at[dt, s])]
        if not available:
            return
        if REBALANCE_ONCE:
            if state["done"]:
                return
            state["done"] = True
            engine.set_target_weights(dt, {s: 1.0 / len(available) for s in available})
            return
        key = (dt.year, dt.month)
        if state["last"] == key:
            return
        state["last"] = key
        engine.set_target_weights(dt, {s: 1.0 / len(available) for s in available})

    counts = prices[cols].notna().sum(axis=1)
    need = max(1, len(cols) // 2)
    eligible = counts[counts >= need]
    ready = eligible.index.min() if not eligible.empty else None
    return on_day, ready

"""
Quant Buffet interactive lab — 欧冠比赛日做空足球股票策略
Allowed: backtest.data / backtest.engine / backtest.metrics, numpy, pandas.
Required: a module-level ASSETS list, and def make_on_day(prices) returning (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 = ['VGK', 'EWU', 'EWG', 'EWQ', 'EWI', 'SPY']
REBALANCE_ONCE = False

def make_on_day(prices: pd.DataFrame):
    cols = [c for c in ASSETS if c in prices.columns]
    state = {"last": None, "done": False}

def on_day(engine: PortfolioEngine, dt: pd.Timestamp) -> None:
        available = [s for s in cols if pd.notna(prices.at[dt, s])]
        if not available:
            return
        if REBALANCE_ONCE:
            if state["done"]:
                return
            state["done"] = True
            engine.set_target_weights(dt, {s: 1.0 / len(available) for s in available})
            return
        key = (dt.year, dt.month)
        if state["last"] == key:
            return
        state["last"] = key
        engine.set_target_weights(dt, {s: 1.0 / len(available) for s in available})

counts = prices[cols].notna().sum(axis=1)
    need = max(1, len(cols) // 2)
    eligible = counts[counts >= need]
    ready = eligible.index.min() if not eligible.empty 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

5.56%

Sharpe

0.36

Max DD

-62.88%

Vol

21.96%

Sortino

0.55

Beta

0.98

Up days

48%

Run the backtest to populate charts.

Order records

Run the backtest to load every order fill alongside performance.

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: Custom / hybridAssets: VGK, EWU, EWG, EWQ, EWI, SPY

# Generated from Quant Buffet → QuantConnect LEAN
# Strategy: 欧冠比赛日做空足球股票策略
# Detected pattern: Custom / hybrid
# 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 = ["VGK", "EWU", "EWG", "EWQ", "EWI", "SPY"]
        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: Custom Quant Buffet logic — adapt the signal block to match your lab on_day().

    def Rebalance(self):
        # Pattern: custom — Custom Quant Buffet logic — adapt the signal block to match your lab on_day().
        # 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)

导出代码使用目标平台的原生类与库。请在第三方 IDE 中安装依赖后运行；实盘前请自行验证。