#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""生成「第一票 · 亮黄历史」看板页：读 CSV → 输出 /root/work/kpl/第一票.html
每日由 daily_update.sh 调用。
"""
import csv, os, statistics, time, html
CSV_PATH = "/root/work/kpl/竞价主表/第一票_亮黄历史.csv"
OUT = "/root/work/kpl/第一票.html"
rows = []
with open(CSV_PATH, encoding="utf-8-sig") as f:
for r in csv.DictReader(f):
rows.append(r)
def num(v):
try:
return float(v)
except (TypeError, ValueError):
return None
done = [r for r in rows if num(r.get("T1收盘盈亏%")) is not None]
rets = [num(r["T1收盘盈亏%"]) for r in done]
wins = [x for x in rets if x > 0]
stat = dict(n=len(rets),
win=len(wins) / len(rets) * 100 if rets else 0,
avg=sum(rets) / len(rets) if rets else 0,
med=statistics.median(rets) if rets else 0)
years = {}
for r in done:
y = r["日期"][:4]
years.setdefault(y, []).append(num(r["T1收盘盈亏%"]))
def yrow(y, v):
w = sum(1 for x in v if x > 0) / len(v) * 100
return "
%s
%d
%.1f%%
%+.2f%%
%+.2f%%
" % (
y, len(v), w, sum(v) / len(v), statistics.median(v))
yrows = "".join(yrow(y, v) for y, v in sorted(years.items()))
latest = rows[0] if rows else {}
last_day = latest.get("日期", "—")
def cls(v):
x = num(v)
if x is None:
return ""
return "up" if x > 0 else ("down" if x < 0 else "")
trs = []
for i, r in enumerate(rows):
t1c = r.get("T1收盘盈亏%") or ""
t1h = r.get("T1最高盈亏%") or ""
trs.append(
'