a <j @sdZddlZddlZddlZddlmZedeedZd\Z Z Z eddZ d d Z eD] Zeed d d dZeeD]ZeddkrqedededfZedpdZdD]Ze edeZe ededZe edeZe eefZedurTedurTdekr0dkrTnn erTededeeefereed<qqWdqb1sz0Yqbe D]Zedqedee dedd d!d"d#d$d%d&d'd(d)d*d+d,ed-e dd.D]Z!e!d/Z"gZ#e $D]~\Z%ZedZes.qe%d0ZeedkrFd1nd2kZ&e'd3d4edDdZ(e(durrqe(\Z)ZZZe#e)eee&fqe#jd5dd6dZ*Z+d7Z,e Z-e#D]\Z)ZZZ&e*d7Z*deeZ.e/ee.dee.d7Ze0ee e Z1e2e1e-d8Z3e3d9krd9Z3e3e-kr0e2e-d8Z3e&rTe+d7Z+e,e.7Z,e-e3e.7Z-ne,d8Z,e-e38Z-qe*rzd:e,e*ndZ4d:e-e e Z5ee!d e*d"e+d$e*rd:e+e*ndd;e4d<e-d=e5d>qdS)?a What-if sweep: lower the CLV entry floor, measured both flat-unit and as a COMPOUNDED 1/4-Kelly bankroll. Using live_data/*.csv pre-kickoff snapshots, for each fixture+side find the FIRST moment Kalshi CLV >= X%, enter at that snapshot's ask, settle via ftr. Sweep X = 1..12. Kelly: p = pin_fair_ at entry, b = (1-ask)/ask, f = max((p*b-(1-p))/b, 0), stake = min(f*0.25, 0.25)*bankroll, floor $1. N) defaultdictz E:\soccerzlive_data\*.csv)?rg@@cCs gddS)N)rowsftrrrr/E:\soccer\research\analysis\_clv_floor_sweep.pyrc Cs0zt||dWSttfy*YdS0dS)N)floatget TypeError ValueError)rkrrrfvalsrr zutf-8replace)newlineencodingerrorsZstatusZPREZ game_datehomeawayr)rrZ clv_kalshi_Zkalshi_Z_askZ pin_fair_rZ timestampzfixture-sides observed:  zX%z>3Nz>6Wz>5zWR%z>7zflatROI%z>10zKellyBR$z>11zKelly%z>9z3---------------------------------------------------gY@HAccs*|]"\}}}}|tkr||||fVqdS)N)thr).0tsclvaskpfrrr ;r r&cCs|dS)Nrr)xrrrr@r )keygg?dz>6.1fz>+10.1fz>11.2fz>+9.1f)6__doc__ZcsvZglobos collectionsrchdirsortedfilesZ KELLY_MULTZ MAX_BET_PCTZSTARTZseriesrfpopenfZ DictReaderrr baserZsider#r$r%dappendvaluessortprintlenrangeXr Zentriesitemsr(winnexter"nwZflatbrbmaxminZfracroundZstakeZflatroiZkpctrrrrs      6. 2