a í°Ûi„+ã@s¶ dZddlZddlZddlZe d¡ddlmZ ddl m Z ej   d¡dZdZgd¢Zd Zgd ¢Zd Zgd ¢Zd ddddddddddddddddddd d!d"d#œZd$d%„Zed&ƒgZe ¡D]²\ZZeD]¤Zd'e›d(e›d)Zz€ejed*d+Ze eƒd,ksd-ej!vsd.ej!vrWqÌej"gd/¢d0Ze eƒd,kr>WqÌeed1<eed2<eed3<e #e¡WqÌYqÌ0qÌqÀej$ed4d5Z%ej&e%d6d4d7d8e%d6<e%j"d6gd0 'd6¡j(d4d9Z%ed:e e%ƒd;›dd?„d@dAŽ\Z,Z-Z.e% /¡Z%ej0e.e%j1dBe%dC<d@e%dCe%dD<e%d.e%dDe%dDe%dE<e%e%d1 2e¡e%dEek@ /¡Z3gZ4e3 5¡D]‚\Z6Z7e7d.d@Z8e7dCZ9e8dkr¬e:e9e8d@e9e8dƒndZ;e;dkrle4 #e7d6e7d1e7d3e7d.e;e9e7d-dFkdGœ¡qle ¡ ?¡›dIe=d6 :¡ ?¡›dJƒedKe=dL @¡dMdN›dOƒedPe=dQ @¡dMdN›dOƒdRdS„e= 5¡DƒZAedTeBeAƒe eAƒdMdU›dOƒedVƒeD]‚Ze=e=d1ekZCe eCƒdkräq¾dWdS„eC 5¡DƒZDedXe›dYe eCƒdZ›d[eCdL @¡dMdN›d\eBeDƒe eDƒdMd]›dO ƒq¾ed^d_›ƒed`ƒed_›ƒed:dadb›dcddde›d:dfdg›d:dhdg›ƒediƒedjgD]²ZEeZFeZGdkZHe= 5¡D]d\Z6ZIe>eIdleEdmƒZJeFeJZKeFeIdLròeKeIdnd@neK 7ZFe:eGeFƒZGe:eHeGeFeGƒZHq´ed:eEdo›dpeFdq›d:eFedr›dseHdMdt›dO ƒqœed^d_›ƒedued;›dvƒed_›ƒe e=ƒZLe=dnjMZNe=dQjMZOe=dljMZPiZQdwZReD]ÈZEe SePeEdm¡ZTe Ue¡ZVe Ue¡ZWe UeReLd@f¡ZXeeXdd…df<eYeƒD]ðZZej   eL¡eOkZ[eZFeZGdkZHeLd@Z\eYeLƒD]„Z]eFeTe]ZeFe[e]r\eeNe]d@ne 7ZFeFdkr|dZFe]Z\q¶e:eGeFƒZGe:eHeGeFeGƒZHeZeRkr0eFeXeZe]d@f<q0eFeVeZ<eHeWeZ<eZeRkreFdkrdeXeZe\d@d…f<qeVeWeXdxœeQeE<edyeEdo›dzƒed{e ^eV¡ed|›d}e ^eV¡d~›dJƒede _eVd,¡ed|›dfƒed€e _eVd¡ed|›dfƒed‚e _eVdƒ¡ed|›dfƒed„e _eVd…¡ed|›dfƒed†eVek @¡dMdr›dOƒed‡eVedˆk @¡dMdr›dOƒed‰eVed,k @¡dMdr›dOƒedŠeVed‹k @¡dMdr›dOƒedŒe ^eW¡dMdr›dOƒede _eWdŽ¡dMdr›dOƒq¬ed^d›ƒed:dd‘›d’d“eD]ZEed:eEdo›d”d’d“qžeƒed•ƒd–d—d?„fd˜d™d?„fdšd›d?„fdœdd?„fdždŸd?„fd d¡d?„fd¢d£d?„fd¤d¥d?„fd¦d§d?„fd¨d©d?„fg Z`e`D]†\ZaZbed:ead‘›d’d“eD]\ZEeQeEdªZcead¨k ršed:e ^eQeEd«¡dMd¬›dOd’d“ned:ebecƒ›d’d“ qVeƒ q6d­d®d¯dœZde jed@d°d±d²\ZfZgefjhd³ed;›d´eLd;›dµe=d6 >¡ ?¡›dIe=d6 :¡ ?¡›d¶ d,d·d¸egdZieD]vZEeQeEdªZce _ecdŽ¡Zjeijke Secej¡dMd¹edeEeEdo›dºe ^ec¡edN›dfd»d¼eijle ^ec¡edeEd½d¾d¿ q0eijledÀd@dÁdÂdÃei mdÄ¡ei ndÅ¡ei odÆ¡eijpdÇdÈeijq re dÉd?„ƒ¡egd@Zie seLd@¡ZteD]zZEeQeEdÊZuej_eudˆddAZvej_eudËddAZwej_eudŽddAZxeijyetevexdÌedeEdÍeijzetewedeEd½eEdo›dÎdÏ qeij{edÀdÐdÁd¿ei mdÑ¡ei ndÒ¡ei odÓ¡eijpdÇdÈei |dÔ¡eij} re dÕd?„ƒ¡egd½ZieD]bZEeQeEd«dMZ~eijke~dÖd¹edeEeEdo›dºe ^e~¡d×›dOd»d¼eijle ^e~¡edeEd½d¾d¿ qöei mdØ¡ei ndÅ¡ei odÙ¡eijpdÇdÈe  ¡e j€edÚdÛdÜedÝe›ƒedÞƒdS)ßzÖ Monte Carlo on pure Away CLV, OOS-only seasons (2122-2526). No outcome selection -- just Away bets where B365A > Pinnacle fair by >5%. Seasons 1920+2021 treated as the "identification" period; 2122 onward is OOS. éNZAgg)Ú FuncFormatteré*i'g@@)gš™™™™™¹?çÐ?çà?gš™™™™™©?)Ú2122Ú2223Ú2324Ú2425Ú2526zE:\soccer\mc_oos_away_clv.png)Z1920Z2021rrrr r ZEPLZ Championshipz League Onez League TwoZ ConferencezLa LigaZSegundazSerie AzSerie BZ Bundesligaz 2.BundesligazLigue 1zLigue 2Z EredivisiezBelgian Pro Leaguez Primeira Ligaz Super LigzGreek SLz Scottish PremzScottish Champz Scottish L1z Scottish L2)ZE0ZE1ZE2ZE3ZECZSP1ZSP2ZI1ZI2ZD1ZD2ZF1ZF2ZN1ZB1ZP1ZT1ZG1ZSC0ZSC1ZSC2ZSC3cCs:d|d|d|}d||d||d||fS)Né©)ÚhÚdÚaZoverr r ú)E:\soccer\misc\archive\mc_oos_away_clv.pyÚ remove_margin%srzLoading data...zE:/soccer/league_data/Ú_z.csvz utf-8-sig)Úencodingé ÚFTRÚB365A)rrZB365HZB365DÚPSCHÚPSCDÚPSCA)ZsubsetÚSeasonZ LeagueCodeZ LeagueNameT)Z ignore_indexÚDateZcoerce)ZdayfirstÚerrors)Zdropz ú,z matches across z leaguescCst|d|d|dƒS)Nrrr)r)Úrr r rÚBórr )Zaxis)ÚindexZp_AZ PSC_fair_AZedge_AÚA)rrZLeagueÚOddsÚKellyÚp_winÚWonz OOS Away CLV bets (z to ú)z Overall win rate: r&édz.1fú%z Avg Pinnacle fair prob: r%cCs(g|] \}}|dr |ddnd‘qS©r&r#r éÿÿÿÿr ©Ú.0rrr r rÚ br r.z Flat ROI: z+.2fz By season (flat stake):cCs(g|] \}}|dr |ddnd‘qSr*r r,r r rr.ir z z n=z>4z WR=z% ROI=z+.1fÚ zA=================================================================z*DETERMINISTIC KELLY COMPOUNDING (OOS only)z Kelly multz<16ú ÚFinalz>12Úxz>7ZMaxDDz4 --------------------------------------------------gð?gr$rr#z.2fz x Kelly z>12,.2fz>7.1fzx z>6.1fz MONTE CARLO (z simulations, OOS bets only)iô)ÚterminalÚmax_ddsÚpathsz zx Kelly:z Median: ú>8.1fux (£z>10,.0fz P10: z P25: éz P75: éKz P90: éZz P(profit): z P(> 5x): éz P(> 10x): z P(ruin <50%): rz Median MaxDD: z 95th pct DD: é_zF======================================================================ZMetricz<22Ú)Úendzx Kellyz> ------------------------------------------------------------ZMediancCst |¡td›dS)Nú>10.1fr2)ÚnpÚmedianÚSTART©Útr r rr»r ZP10cCst |d¡td›dS)Nrr>r2©r?Ú percentilerArBr r rr¼r ZP25cCst |d¡td›dS)Nr7r>r2rDrBr r rr½r ZP75cCst |d¡td›dS)Nr8r>r2rDrBr r rr¾r ZP90cCst |d¡td›dS)Nr9r>r2rDrBr r rr¿r z P(profit)cCs|tk ¡dd›dS)Nr(ú>9.1fr)©rAÚmeanrBr r rrÀr zP(> 5x)cCs|tdk ¡dd›dS)Nr:r(rFr)rGrBr r rrÁr zP(> 10x)cCs|tdk ¡dd›dS)Nrr(rFr)rGrBr r rrÂr zP(ruin)cCs|tdk ¡dd›dS)Nrr(rFr)rGrBr r rrÃr z Med MaxDDcCst ttd¡dd›dS)Nr4r(r6r))r?r@Ú mc_resultsÚkmrBr r rrÄr r3r4rFZ steelblueZseagreenZ darkorangeé)éé)ZfigsizeuLMonte Carlo: Pure Away CLV (>5% edge vs Pinnacle) — OOS Seasons 2122-2526 z simulations, z bets, zV All leagues, no outcome selection. Outcomes sampled from Pinnacle fair probabilities.Zbold)ÚfontsizeZ fontweightgÍÌÌÌÌÌÜ?zx Kelly median=Znone)ZbinsÚalphaÚcolorÚlabelZ edgecoloréz--)rPÚ linewidthÚ linestyleZgrayú:u Start £1,000)rPrSrTrQuTerminal bankroll (£)Z Frequencyz*Terminal distribution (capped at 95th pct)é)rNcCs d|d›S©Nõ£z,.0fr ©r2rr r rrçr r5é2g¸…ëQ¸¾?)rOrPzx Kelly median)rPrSrQgš™™™™™é?z Bet numberu Bankroll (£)z#Median path +/- 5th-95th percentileÚlogcCs d|d›SrWr rYr r rrør éPz.0fzMax drawdown (%)zMax drawdown distributioné–Ztight)ZdpiZ bbox_inchesz Chart saved to zDone.)Ú__doc__ZpandasZpdZnumpyr?Z matplotlibZuseZmatplotlib.pyplotZpyplotZpltZmatplotlib.tickerrZrandomZseedZN_SIMSrAZ KELLY_MULTSZ EDGE_THRESHZ OOS_SEASONSZPLOT_OUTZseasonsZ league_namesrÚprintZall_dfsÚitemsÚcodeÚnameÚsÚpathZread_csvrÚlenÚcolumnsZdropnaÚappendÚconcatZdfZ to_datetimeZ sort_valuesZ reset_indexZnuniqueÚzipZapplyZtHZtDZtAÚcopyZSeriesr!ZisinÚsubZrowsZiterrowsrrÚbÚpÚmaxZkelly_fZ DataFrameZbetsÚminÚdaterHZflat_plÚsumZsgÚfprJZbkZpeakZmax_ddZbetÚfZstakeÚNÚvaluesZoddsr%ZkellyrIZN_PLOTZminimumZstakesZzerosr3r4r5ÚrangeZsimZoutcomesZlast_iÚir@rEZ rows_tablerQÚfnrCZcolorsZsubplotsZfigZaxesZsuptitleZaxZcapZhistZaxvlineZ set_xlabelZ set_ylabelZ set_titleZlegendZxaxisZset_major_formatterZaranger2ZpthsZp5Zp50Zp95Z fill_betweenZplotZaxhlineZ set_yscaleZyaxisZddZ tight_layoutZsavefigr r r rÚsÀ     õ& $" (  ù :"L ( $ 6           $   *""""          ö   *  ÿÿÿÿü  ÿ      $     ÿ