股票 · 美国 · ETF · 每月 Free

投资新策略：可持续 ETF 的观察

登录后收藏

学术论文

投资新策略：关于可持续交易所交易基金（ETF）的观察

作者Nini Johana Marín‐Rodríguez; Juan David González-Ruíz; Sergio Botero-Botero

机构

Universidad de Medellín
Universidad Nacional de Colombia

论文链接https://doi.org/10.3390/world6010008

导读

投资标的：SPY、EFA、EEM、VNQ、DBC、GLD、TLT、IEF、HYG。再平衡：每月。Universe: SPY, EFA, EEM, VNQ, DBC, GLD, TLT, IEF, HYG. Parameters: rebalance=monthly.

策略概要

该策略投资于 SPY、EFA、EEM、VNQ、DBC、GLD、TLT、IEF、HYG，按 126 日过去收益排序并等权持有前 3 名，按月再平衡。由于可持续标签主信号不可用，回测用多资产动量规则保留主题。论文用科学计量与文献计量梳理可持续 ETF 研究版图、关键作者与从简单 ESG 筛选到复杂技术的演进。

经济逻辑

相关证据来自“投资新策略：关于可持续交易所交易基金（ETF）的观察”：投资者把 ESG 纳入决策后，可持续 ETF 同时成为组合工具与研究对象；主题资金流可能强化短期动量，但也带来拥挤风险。公开数据里没有论文的原始信号，实验室改为在SPY、EFA、EEM、VNQ、DBC、GLD、TLT、IEF、HYG.上运行同一再平衡规则。绩效来自这次可交易替代回测，不是论文原表。

入场与出场

入场

每月按 126 日收益排序 SPY, EFA, EEM, VNQ, DBC, GLD, TLT, IEF, HYG，等权持有最强的 3 只。

出场

跌出前 3 即卖出，换入新的领涨标的。

所需行情数据

需要 SPY, EFA, EEM, VNQ, DBC, GLD (+3 more) 至少 126 根复权收盘价，才能形成第一个有效信号。ETF 仅交易日有行情。实验室通过 backtest.data.load_daily_prices 读取 Yahoo Finance。

标的

SPY, EFA, EEM, VNQ, DBC, GLD, TLT, IEF, HYG

频率

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

所需历史

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

字段

复权收盘价（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 投资新策略：可持续 ETF 的观察 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 · 42 lines

"""
Quant Buffet interactive lab — 投资新策略：可持续ETF的观察
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 = ['SPY', 'EFA', 'EEM', 'VNQ', 'DBC', 'GLD', 'TLT', 'IEF', 'HYG']
LOOKBACK = 126
TOP_N = 3
INVERT = False  # True = short-term reversal (rank ascending)

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

    def on_day(engine: PortfolioEngine, dt: pd.Timestamp) -> None:
        row = rets.loc[dt]
        if row.isna().all():
            return
        key = (dt.year, dt.month)
        if state["last"] == key:
            return
        state["last"] = key
        ranked = row.dropna().sort_values(ascending=INVERT)
        picks = list(ranked.head(TOP_N).index)
        if not INVERT:
            picks = [s for s in picks if ranked[s] > 0] or picks[:1]
        w = {} if not picks else {s: 1.0 / len(picks) for s in picks}
        engine.set_target_weights(dt, w)

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

"""
Quant Buffet interactive lab — 投资新策略：可持续ETF的观察
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 = ['SPY', 'EFA', 'EEM', 'VNQ', 'DBC', 'GLD', 'TLT', 'IEF', 'HYG']
LOOKBACK = 126
TOP_N = 3
INVERT = False  # True = short-term reversal (rank ascending)

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

def on_day(engine: PortfolioEngine, dt: pd.Timestamp) -> None:
        row = rets.loc[dt]
        if row.isna().all():
            return
        key = (dt.year, dt.month)
        if state["last"] == key:
            return
        state["last"] = key
        ranked = row.dropna().sort_values(ascending=INVERT)
        picks = list(ranked.head(TOP_N).index)
        if not INVERT:
            picks = [s for s in picks if ranked[s] > 0] or picks[:1]
        w = {} if not picks else {s: 1.0 / len(picks) for s in picks}
        engine.set_target_weights(dt, w)

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

6.54%

Sharpe

0.50

Max DD

-45.81%

Vol

14.88%

Sortino

0.78

Beta

0.36

Stored preview only. Run backtest to simulate every daily session from Yahoo Finance adjusted closes.

Run the backtest to load orders, then mark them on the equity chart.

Equity curve (indexed = 100)

Accent = strategy · dashed grey = buy-and-hold benchmark. Hover or tap any point for its date and values.

Drawdown

Metrics bar chart

Monthly returns

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: Momentum rotationAssets: SPY, EFA, EEM, VNQ, DBC, GLD, TLT, IEF, HYG

# Generated from Quant Buffet → QuantConnect LEAN
# Strategy: 投资新策略：可持续 ETF 的观察
# Detected pattern: Momentum rotation
# 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", "EFA", "EEM", "VNQ", "DBC", "GLD", "TLT", "IEF", "HYG"]
        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: Hold top 3 by 126-day return; monthly.

    def Rebalance(self):
        scores = {}
        for symbol in self.symbols:
            hist = self.History(symbol, 126 + 5, Resolution.Daily)
            if hist.empty: continue
            close = hist["close"]
            if hasattr(close, "unstack"):
                close = close.unstack(level=0).iloc[:, 0]
            if len(close) < 126 + 1: continue
            scores[symbol] = float(close.iloc[-1] / close.iloc[-126 - 1] - 1)
        ranked = sorted(scores.items(), key=lambda kv: kv[1], reverse=True)[:3]
        for symbol in self.symbols:
            self.SetHoldings(symbol, 0)
        if ranked:
            w = 1.0 / len(ranked)
            for symbol, _ in ranked:
                self.SetHoldings(symbol, w)

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