"""營收動能分散 20 檔：三項穩健性驗證（/blog/cmoney-paper-trading-python-api 驗證段的數字來源）。

條件與文中示範策略相同，只是不截斷結束日：
- 短期動能：近 5 日平均日報酬
- 收盤站上 20、60、120 日均線
- 月營收近 3 個月平均高於近 12 個月平均
- 近 20 日平均成交量大於 500 張
- 依短期動能取前 20 檔等權、單檔上限 8%、個股停損 10%，2015 年起每月第 11 天後換股，
  sim() 預設手續費 0.1425% 與證交稅 0.3%

三項檢查：
1. 鄰近參數：動能回看天數 3、5、7 乘上持股檔數 15、20、25，9 組日夏普要有 7 組以上高於同期 0050 含息
2. 前後兩段：期間對半切，兩段都要高於 0050 含息
3. 交易成本：sim() 預設手續費與證交稅（另跑不扣成本的對照）

統計口徑：日夏普 = 日報酬平均 / 標準差 × √252，不扣無風險利率；
0050 含息 = etl:adj_close 還原價買進持有，與策略同一段期間、不扣成本。
執行後會在目前目錄輸出 metrics.json（統計）。

    pip install finlab
    python strategy.py

finlab 需要資料時會自動引導登入，不需要在程式裡填 token。
"""

import json

import pandas as pd

import finlab
from finlab import data
from finlab.backtest import sim

STRATEGY_NAME = "營收動能分散 20 檔"
START = "2015-01-01"
MOMENTUM_DAYS = 5  # 短期動能回看天數
TOP_N = 20         # 持股檔數
MOMENTUM_GRID = [3, 5, 7]
TOP_N_GRID = [15, 20, 25]


def build_report(momentum_days=MOMENTUM_DAYS, top_n=TOP_N, **cost):
    close = data.get("price:收盤價")
    volume = data.get("price:成交股數")
    revenue = data.get("monthly_revenue:當月營收")

    momentum = (close / close.shift() - 1).rolling(momentum_days).mean()
    trend = (close > close.average(20)) & (close > close.average(60)) & (close > close.average(120))
    revenue_up = revenue.average(3) > revenue.average(12)
    liquid = volume.average(20) > 500 * 1000

    position = momentum[trend & revenue_up & liquid].is_largest(top_n)
    return sim(position.loc[START:], resample="M", resample_offset="11D", stop_loss=0.1,
               position_limit=0.08, upload=False, name=STRATEGY_NAME, **cost)


def curve_stats(curve: pd.Series) -> dict:
    curve = curve / curve.iloc[0]
    daily = curve.pct_change().dropna()
    years = (curve.index[-1] - curve.index[0]).days / 365.25
    return {
        "cagr": curve.iloc[-1] ** (1 / years) - 1,
        "daily_sharpe": daily.mean() / daily.std() * 252 ** 0.5,
        "max_drawdown": (curve / curve.cummax() - 1).min(),
        "total_return": curve.iloc[-1] - 1,
    }


def trimmed(creturn: pd.Series) -> pd.Series:
    """從第一次有部位的前一天起算。"""
    creturn = creturn.dropna()
    first_move = (creturn != creturn.iloc[0]).argmax()
    return creturn.iloc[max(first_move - 1, 0):]


def window_stats(creturn: pd.Series, bench_all: pd.Series) -> dict:
    bench = bench_all.loc[creturn.index[0]:creturn.index[-1]]
    return {"window": f"{creturn.index[0].date()}/{creturn.index[-1].date()}",
            "strategy": curve_stats(creturn), "benchmark_0050": curve_stats(bench)}


def rounded(obj):
    if isinstance(obj, dict):
        return {k: rounded(v) for k, v in obj.items()}
    return round(float(obj), 6) if isinstance(obj, float) else obj


def main() -> None:
    finlab.login()
    bench_all = data.get("etl:adj_close")["0050"].dropna()
    creturn = trimmed(build_report().creturn)
    mid = creturn.loc[creturn.index[0] + (creturn.index[-1] - creturn.index[0]) / 2:].index[0]
    result = {
        "main": window_stats(creturn, bench_all),
        "no_cost": curve_stats(trimmed(build_report(fee_ratio=0, tax_ratio=0).creturn)),
        "grid": {f"持股 {n} 檔、動能 {m} 日": window_stats(trimmed(build_report(m, n).creturn), bench_all)
                 for n in TOP_N_GRID for m in MOMENTUM_GRID},
        "halves": {"first": window_stats(creturn.loc[:mid], bench_all),
                   "second": window_stats(creturn.loc[mid:], bench_all)},
    }

    wins = sum(g["strategy"]["daily_sharpe"] > g["benchmark_0050"]["daily_sharpe"] for g in result["grid"].values())
    print(f"期間 {result['main']['window']}")
    for label, s in [("策略", result["main"]["strategy"]), ("0050 含息", result["main"]["benchmark_0050"]),
                     ("不扣成本", result["no_cost"])]:
        print(f"{label}：年化 {s['cagr']:.2%}，日夏普 {s['daily_sharpe']:.2f}，最大回撤 {s['max_drawdown']:.2%}")
    print(f"鄰近參數：{wins}/9 組日夏普高於 0050 含息")
    for label, g in result["grid"].items():
        print(f"  {label}：{g['strategy']['daily_sharpe']:.2f}"
              f"（年化 {g['strategy']['cagr']:.2%}；0050 {g['benchmark_0050']['daily_sharpe']:.2f}）")
    for key, part in result["halves"].items():
        print(f"{key} {part['window']}：{part['strategy']['daily_sharpe']:.2f} 對 {part['benchmark_0050']['daily_sharpe']:.2f}")

    metrics = {
        "star": STRATEGY_NAME,
        **result,
        "run_date": str(pd.Timestamp.today().date()),
        "finlab_version": finlab.__version__,
        "generated_by": "static/blog/cmoney-paper-trading-python-api/validation/strategy.py",
    }
    with open("metrics.json", "w", encoding="utf-8") as f:
        json.dump(rounded(metrics), f, ensure_ascii=False, indent=2)


if __name__ == "__main__":
    main()
