#!/usr/bin/env python3
# -*- coding: utf-8 -*-
import json, os
import pandas as pd, numpy as np
D=os.path.dirname(os.path.abspath(__file__))
def jload(p):
    with open(p,encoding='utf-8') as f: return json.load(f)

# ---- 6669 full series from TWSE (Jul-Nov), restored ----
rows=[]
for m in ['20260701','20260801','20260901','20261001','20261101']:
    d=jload(os.path.join(D,f"6669_{m}.json"))
    if d.get('stat')!='OK': continue
    for r in d['data']:
        y,mo,dd=str(r[0]).strip().split('/')
        rows.append(dict(date=pd.Timestamp(int(y)+1911,int(mo),int(dd)),
            volume=float(str(r[1]).replace(',','')), close=float(str(r[6]).replace(',','')),
            high=float(str(r[5]).replace(',','')), low=float(str(r[5]).replace(',','')),
            open_=float(str(r[3]).replace(',',''))))
df=pd.DataFrame(rows).drop_duplicates(subset=['date']).sort_values('date').reset_index(drop=True)
df['adj']=df['date']<pd.Timestamp('2026-09-02')
for c in ('close','high','low','open_'): df.loc[df['adj'],c]/=3.0
df['ma20']=df['close'].rolling(20).mean(); df['ma60']=df['close'].rolling(60).mean()
print("last 5 TWSE 6669:")
print(df.tail(5)[['date','close','volume','ma20','ma60']].to_string(index=False))
print(f"\n20日盤中低(含今)={df['low'].tail(20).min():.0f}  20日高={df['high'].tail(20).max():.0f}")
# excluded-today 20d low
print(f"前19日盤中低(不含今)={df['low'].iloc[-20:-1].min():.0f}")
print(f"前20日盤中低(不含今)={df['low'].iloc[-21:-1].min():.0f}")

# streak + volume calib (口徑 A/B/C)
st=0
for i in range(len(df)-1,-1,-1):
    if pd.notna(df['ma60'].iloc[i]) and df['close'].iloc[i]<df['ma60'].iloc[i]: st+=1
    else: break
seg=df.tail(st); s3=seg['volume'].head(3).mean(); l3=df['volume'].tail(3).mean()
idx=len(df)-st; pre=df.iloc[idx-3:idx]
print(f"\nstreak={st} ({seg['date'].iloc[0].date()}..{seg['date'].iloc[-1].date()})")
print(f"口徑A 段內前3日 {s3:,.0f} -> 近3日 {l3:,.0f} = {(l3-s3)/s3*100:+.1f}%")
print(f"口徑B 段起前3日 {pre['volume'].mean():,.0f} -> 近3日 {l3:,.0f} = {(l3-pre['volume'].mean())/pre['volume'].mean()*100:+.1f}%")
h=len(seg)//2
print(f"口徑C 前半 {seg['volume'].head(h).mean():,.0f} -> 後半 {seg['volume'].tail(h).mean():,.0f} = {(seg['volume'].tail(h).mean()-seg['volume'].head(h).mean())/seg['volume'].head(h).mean()*100:+.1f}%")

# ---- P&L ----
sh1, c1 = 258, 1737.0
sh2, c2 = 15000, 9.43
p1, p2 = 1650.0, 7.52
v1, v2 = sh1*p1, sh2*p2
b1, b2 = sh1*c1, sh2*c2
print(f"\n6669  {sh1}x{p1} = {v1:,.0f}  成本 {b1:,.0f}  P&L {v1-b1:+,.0f} ({(v1/b1-1)*100:+.2f}%)")
print(f"00412A {sh2}x{p2} = {v2:,.0f}  成本 {b2:,.0f}  P&L {v2-b2:+,.0f} ({(v2/b2-1)*100:+.2f}%)")
print(f"合計 {v1+v2:,.0f}  成本 {b1+b2:,.0f}  P&L {v1+v2-b1-b2:+,.0f} ({(v1+v2)/(b1+b2)*100-100:+.2f}%)")
print(f"6669 距 1720 = {(1650-1720)/1720*100:+.1f}% ; 距 1810 = {(1650-1810)/1810*100:+.1f}%")
print(f"6669 距 2030 = {(2030-1650)/1650*100:+.1f}% ; 距 MA20 1962.75 = {(1962.75-1650)/1650*100:+.1f}%")
print(f"00412A 距停損8.00 = {(7.52-8.00)/8.00*100:+.2f}% ; 距停利12.0 = {(12.0-7.52)/7.52*100:+.1f}%")
print(f"6669 RSI Wilder 29.37 vs 門檻28 -> 差 {29.37-28:+.2f}")
print(f"6669 量比 {5733060/5290988.15:.3f}x")

# ---- TWII intraday ----
def yahoo(path):
    d=jload(path); r=d['chart']['result'][0]; ts=r['timestamp']; q=r['indicators']['quote'][0]
    out=[]
    for i,t in enumerate(ts):
        c=q['close'][i]
        if c is None: continue
        out.append(dict(date=pd.Timestamp(t,unit='s').tz_localize(None).normalize(),
            open=q['open'][i],high=q['high'][i],low=q['low'][i],close=c))
    return pd.DataFrame(out)
twii=yahoo(os.path.join(D,'yahoo_%5ETWII.json'))
print("\nTWII last 3:")
print(twii.tail(3).to_string(index=False))
sox=yahoo(os.path.join(D,'yahoo_%5ESOX.json'))
print("\nSOX last 4:")
print(sox.tail(4).to_string(index=False))
for nm,f in [('AMZN','yahoo_AMZN.json'),('MSFT','yahoo_MSFT.json'),('GOOGL','yahoo_GOOGL.json')]:
    d=jahoo(os.path.join(D,f)); print(f"\n{nm} last 2:"); print(d.tail(2).to_string(index=False))
