a i@sddlZgdZddddddd Zd d Zd d ZiZeD]V\ZZ gZ eD]vZ z2ej dede dddZ e e d<e e WqPeyZz&edede deWYdZ[qPdZ[00qPe sq>eje ddZejgddZeedkr ee dq>eZeejdddd\ZZZdejeejd ed!<dejeejd ed"<dejeejd ed#<eee <ee deed$q>ed%ed&ed'ed(d)dd*d+dd,d-dd.d/dd0d1dd2d+ ed3eD]\Z Zd4D]Zeed5ed#dekZd6d7e DZ!ee!\Z"Z#Z$Z%e"d8kre$d9kr\d:ne$dkrjd;ndd?d@e"d-de#dAde$dBde%dCe& qeqed'edDed'ed(d)dd*d+dd,d-dd.d/dd0d1dd2d+ ed3eD]\Z Zd4D]ZeedEed!dekZdFd7e DZ!ee!\Z"Z#Z$Z%e"d8kr$e$d9kr~d:ne$dkrd;ndd?d@e"d-de#dAde$dBde%dCe& q$eqed'edGed'ed(d)dd*d+dd,d-dd.d/dd0d1dd2d+ ed3eD]\Z Zd4D]ZeedHed"dekZdId7e DZ!ee!\Z"Z#Z$Z%e"d8krFe$d9krd:ne$dkrd;ndd?d@e"d-de#dAde$dBde%dCe& qFeq:ed'edJed'ed(d)dd?dVe"d-dWe#dXdYe$dZd[e%d\dPe& q4dS)]N)Z1920Z2021Z2122Z2223Z2324Z2425Z2526ZEPLZ ChampionshipzLigue 1zLa LigaZ BundesligazSerie A)ZE0ZE1ZF1ZS1ZD1ZI1cCsb|sdSdd|D}t|}t|}|t|dt||ddttdd|D|ddfS) N)rrrcSs g|]\}}|r|dndqS)).0owrr+E:\soccer\misc\archive\clv_international.py zsimulate..dcss|]\}}|VqdS)Nr)r_rrrr r zsimulate..r)lensumround)betsZprofitsntotalrrr simulate s rcCs:d|d|d|}d||d||d||fS)Nrr)hdaZoverrrr remove_marginsrzE:/soccer/league_data/rz.csvz utf-8-sig)encodingZSeasonz  z: T)Z ignore_index)FTRB365APSCHPSCDPSCA)Zsubsetz: no data with full oddscCst|d|d|dS)Nrr r!)r)rrrr +r r#r)Zaxis)indexZ PSC_fair_HZ PSC_fair_DZ PSC_fair_Az matcheszV =====================================================================================uOAWAY CLV: B365 opening > Pinnacle closing fair — by league and edge thresholdzU=====================================================================================ZLeaguez<16ZEdgez>6Nz>5zP&Lz>8zROI%z>7zWR%zU-------------------------------------------------------------------------------------){Gz?皙?皙?rcCs$g|]\}}|d|ddkfqSrrArrrr"rrr r >r r z <r z>4.0fz% z>8.2fz>7.2fz>6.1fu<HOME CLV: B365 opening > Pinnacle closing fair — by leagueB365HcCs$g|]\}}|d|ddkfqS)r/rHrr+rrr r Pr u<DRAW CLV: B365 opening > Pinnacle closing fair — by leagueB365DcCs$g|]\}}|d|ddkfqS)r1rDrr+rrr r br u'PER-SEASON Away CLV >2% — all leagues)endz>9gRQ?cCs$g|]\}}|d|ddkfqSr)rr+rrr r yr z>+8.1f%zn/au!COMBINED ALL LEAGUES — Away CLV)rr&r'r(g333333?cCs$g|]\}}|d|ddkfqSr)rr+rrr r r z >z% edge z bets P&L=z>+9.2fz ROI=z>+7.2fz% WR=z.1f))ZpandasZpdZseasonsZleaguesrrZall_league_dataitemscodenameZdfssZread_csvrappend ExceptioneprintconcatZdfZdropnarcopyzipZapplyZtHZtDZtAZSeriesr$ZedgesubZiterrowsrrpZroiwrZmarkervaluesZcombinedrrrr s 26  B 6  B 6  B $