"""本益成長比策略用開收均價成交：三項穩健性驗證（/blog/custom-backtest-price-series 驗證段的數字來源）。

選股條件與文章的本益成長比範例相同，只是成本改用 sim() 預設、不截斷結束日：
- 本益成長比 = 本益比 / 營業利益成長率
- 近 3 月平均營收 / 近 12 月平均營收 > 1.1，且當月營收 / 上月營收 > 0.9
- 符合條件、本益成長比為正的股票取最小的 10 檔，每月營收公布後換股，停損 10%
- 成交價：開盤價與收盤價的均價（還原價），估值仍用還原收盤價
- 成本：sim() 預設手續費 0.1425% 與證交稅 0.3%（原文用手續費三折）

文章用的是舊版 finlab 的 TWMarketInfo；新版直接把價格表傳給 trade_at_price，結果相同。

三項檢查：
1. 鄰近參數：持股檔數 8、10、12 乘上營收加速門檻 1.05、1.1、1.15，9 組日夏普要有 7 組以上高於同期 0050 含息
2. 前後兩段：期間對半切，兩段都要高於 0050 含息
3. 交易成本：sim() 預設手續費與證交稅

統計口徑：日夏普 = 日報酬平均 / 標準差 × √252，不扣無風險利率；
0050 含息 = etl:adj_close 還原價買進持有，與策略同一段期間、不扣成本。
執行後會在目前目錄輸出 data.csv（淨值曲線）與 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 = "本益成長比（開收均價成交）"
TOP_N = 10
REV_ACCEL = 1.1
TOP_N_GRID = [8, 10, 12]
REV_ACCEL_GRID = [1.05, 1.1, 1.15]


def build_report(trade_at_price, top_n=TOP_N, rev_accel=REV_ACCEL, **cost):
    pe = data.get("price_earning_ratio:本益比")
    rev = data.get("monthly_revenue:當月營收")
    operating_growth = data.get("fundamental_features:營業利益成長率")
    peg = pe / operating_growth
    cond = (rev.average(3) / rev.average(12) > rev_accel) & (rev / rev.shift() > 0.9)
    result = peg * cond
    position = result[result > 0].is_smallest(top_n).reindex(rev.index_str_to_date().index, method="ffill")
    return sim(position, stop_loss=0.1, trade_at_price=trade_at_price, 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(report) -> pd.Series:
    """從第一次有部位的前一天起算。"""
    creturn = report.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 {"strategy": curve_stats(creturn), "benchmark_0050": curve_stats(bench),
            "window": f"{creturn.index[0].date()}/{creturn.index[-1].date()}"}


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()
    price = ((data.get("etl:adj_open") + data.get("etl:adj_close")) / 2).round(2)

    runs = {(n, a): trimmed(build_report(price, n, a)) for n in TOP_N_GRID for a in REV_ACCEL_GRID}
    creturn = runs[TOP_N, REV_ACCEL]
    main_stats = window_stats(creturn, bench_all)
    c = curve_stats(trimmed(build_report("close")))
    grid = {f"{n}|{a}": window_stats(curve, bench_all) for (n, a), curve in runs.items()}
    mid = creturn.index[creturn.index.searchsorted(creturn.index[0] + (creturn.index[-1] - creturn.index[0]) / 2)]
    halves = {"first": window_stats(creturn.loc[:mid], bench_all),
              "second": window_stats(creturn.loc[mid:], bench_all)}
    no_cost = trimmed(build_report(price, fee_ratio=0, tax_ratio=0))

    s, b = main_stats["strategy"], main_stats["benchmark_0050"]
    print(f"期間 {main_stats['window']}")
    print(f"開收均價：年化 {s['cagr']:.2%}，日夏普 {s['daily_sharpe']:.2f}，最大回撤 {s['max_drawdown']:.2%}")
    print(f"收盤價：年化 {c['cagr']:.2%}，日夏普 {c['daily_sharpe']:.2f}，最大回撤 {c['max_drawdown']:.2%}")
    print(f"0050 含息：年化 {b['cagr']:.2%}，日夏普 {b['daily_sharpe']:.2f}，最大回撤 {b['max_drawdown']:.2%}")
    wins = sum(g["strategy"]["daily_sharpe"] > g["benchmark_0050"]["daily_sharpe"] for g in grid.values())
    print(f"鄰近參數：{wins}/9 組日夏普高於 0050 含息")
    for key, g in grid.items():
        n, a = key.split("|")
        print(f"  前 {n} 檔、營收加速 {a}：日夏普 {g['strategy']['daily_sharpe']:.2f}（0050 {g['benchmark_0050']['daily_sharpe']:.2f}）")
    for key, h in halves.items():
        print(f"{key} {h['window']}：{h['strategy']['daily_sharpe']:.2f} 對 {h['benchmark_0050']['daily_sharpe']:.2f}")

    bench = bench_all.reindex(creturn.index)
    curves = pd.DataFrame({STRATEGY_NAME: creturn / creturn.iloc[0], "0050含息": bench / bench.iloc[0]})
    curves.index.name = "date"
    curves.round(6).to_csv("data.csv")
    metrics = {
        "window": main_stats["window"],
        "star": STRATEGY_NAME,
        "variants": {STRATEGY_NAME: s, "本益成長比（收盤價成交）": c},
        "benchmark_0050": b,
        "no_cost": curve_stats(no_cost),
        "grid": grid,
        "halves": halves,
        "run_date": str(pd.Timestamp.today().date()),
        "finlab_version": finlab.__version__,
        "generated_by": "static/blog/custom-backtest-price-series/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()
