a ¯ èi—ã@sšddlZddlZddlZddlZddlZe d¡e d¡ZgZ eD]HZ z6ej e ddZ ej  e ¡ d¡de d<e  e ¡WqDYqD0qDeje dd Z e jgd ¢d Z eje d dd de d <e jd gd  d ¡jddZ de dde dde de d<de de de d<de de de d<de de de d<e dde dde de d<e dde dde de d<e dde dde de d<dZdZd Zd!Zd"eefd#d$„Zefd%d&„Zefd'd(„Zgd)¢Zd*Zd+Ze d,eed-eefƒe ƒd.Z!e e! "d/d0d1d2d3d4d5d6d7¡ ƒe d8ƒeD]v\Z#Z$Z%ee&e$ƒee%ƒZ'ee'eeƒ\Z(Z)Z*Z+Z ee'eeƒZ,e d9 "e#e-e'ƒe(e+e)e*e .e,d:¡e /e,¡e .e,d;¡¡ ƒqPe ƒe d<ƒe d= "d>d?d@dAdB¡ƒed"gedCƒZ0edDd"gedCƒZ1eZ2eZ3e4e0d j5j6 7¡ƒZ8e8D]ÌZ9e0e0d j5j6e9kZ:e1e1d j5j6e9kZ;e: <¡D]6\Z=Z>e?e>dEeeƒZ@eAe2e@e2e>dFdGƒZ2q^e; <¡D]6\Z=Z>e?e>dEeeƒZ@eAe3e@e3e>dFdGƒZ3qže dH "e9e-e:ƒe2e-e;ƒe3¡ƒq*e ƒe dIƒed"gedCƒZ0e dJ "dKd1d2d3d5d7¡ƒdLD]dZBee0eBe?eBd*ƒƒ\Z(Z)Z*Z+Z=ee0eBe?eBd*ƒƒZ,e dM "dNeBd-e(e+e)e .e,d:¡e .e,d;¡¡ƒq0dS)OéNÚignorezE:/soccer/league_data/*.csvz utf-8-sig)ÚencodingÚ_ZleagueT)Z ignore_index)ÚB365HÚB365DÚB365AÚPSHÚPSDÚPSAÚFTRÚDate)Zsubsetr Zcoerce)ZdayfirstÚerrors©Zdropérr r ZoverÚpHÚpDÚpArÚedgeHrÚedgeDrÚedgeAiÐg@@gš™™™™™©?écÚAcCsbg}|D]}|dkrdtd|ktd|k@}t| ¡}|ddk|d<|d|d<|d|d<n¢|d krºtd |ktd |k@}t| ¡}|dd k|d<|d |d<|d |d<nLtd |ktd|k@}t| ¡}|ddk|d<|d|d<|d|d<||d<| |¡qt |¡ d¡jdd}|jdd„dd|d<|jdd„dd|d<|S)NÚHrrr ÚwonÚoddsrÚpÚDrrrrrrrZoutcomer TrcSs2t|d|ddd|d|dddƒS)Nrrrr)Úmax©Úr©r ú%E:\soccer\misc\archive\mc_analysis.pyÚ:ózbuild_pool..r)ZaxisÚ raw_kellycSs|dr|ddSdS)Nrrrgð¿r rr r r!r";r#Úpnl_unit)ÚdfÚcopyÚappendÚpdÚconcatÚ sort_valuesÚ reset_indexZapply)ÚoutcomesZedge_minÚodds_maxÚpartsÚoÚmaskÚbÚpoolr r r!Ú build_pool s6         ÿ r4cCsþ|}|djd|fg}|}d}g}| ¡D]‚\} } t| d||ƒ} | |} | | d} t|| dƒ}t||ƒ}t||||ƒ}| t ||¡¡|}| | d|f¡q,t |¡dkrÜt |¡t |¡t  d¡nd}|t dd}|||||fS) zFSingle compounded Kelly run in date order. Returns list of (date, br).r rr$r%ç{®Gáz„?éüg’$I’$IÂ?r) ZilocÚiterrowsÚminrr(ÚnpÚlogZstdZmeanZsqrtÚSTART)r3ÚkmÚmax_pctZbankrollÚbrÚpathZpeakÚmax_ddZlog_retsrÚrowÚfracZstakeZpnlZbr_newÚsharpeÚcagrr r r!Úkelly_compound_run>s$  0rEc CsŒtj d¡}|dj}|dj}t |¡}t|ƒD]T}| t|ƒ¡} t} | D]0} t || ||ƒ} t | | | || dƒ} qL| ||<q2|S)Nrr$r%r5) r9ZrandomZ default_rngÚvaluesÚemptyÚrangeZ permutationÚlenr;r8r) r3r<r=ÚnÚrngZraw_kZpnl_uÚfinalsÚiÚidxr>ÚjrBr r r!Ú monte_carloSs      rP))z Away onlyrr)z Away (odds<6)rç@)z Home onlyrr)z Draw onlyrr)z Home+AwayÚHAr)zHome+Away (A<6)rRrQ)zAll 3ÚHDAr)z All 3 (A<6)rSrQçÐ?çš™™™™™¹?zTKelly multiplier: %.2fx | Max stake: %.0f%% of bankroll | Start: $%.0f | MC sims: %dédz:{:<22} {:>5} {:>10} {:>8} {:>7} {:>7} {:>9} {:>9} {:>9}ZStrategyZBetszFinal BRZCAGRZMaxDDZSharpezMC p10zMC medzMC p90zi---------------------------------------------------------------------------------------------------------zV{:<22} {:>5} {:>10,.0f} {:>7.1%} {:>7.1%} {:>7.2f} ${:>8,.0f} ${:>8,.0f} ${:>8,.0f}é éZzJ=== Year-by-year compounded bankroll: Away (odds<6) vs Home+Away (A<6) ===z${:<6} {:>10} {:>10} {:>10} {:>10}ZYearz Bets(A<6)zBR(A<6)zBets(HA)zBR(HA)rQrr$r%r5z,{:<6} {:>10} {:>10,.0f} {:>10} {:>10,.0f}z3=== Kelly multiplier sensitivity: Away (odds<6) ===z&{:<8} {:>10} {:>8} {:>7} {:>9} {:>9}ZKelly)rUrTgà?gè?gð?z:{:<8} {:>10,.0f} {:>7.1%} {:>7.1%} ${:>8,.0f} ${:>8,.0f}z%.0f%%)CZpandasr)ZglobÚosZnumpyr9ÚwarningsÚfilterwarningsÚfilesZdfsÚfZread_csvr&r?ÚbasenameÚsplitr(r*ZdropnaZ to_datetimer+r,ZN_SIMr;ZEDGEZODDSMAXr4rErPZconfigsZKMZMAXPCTÚprintZhdrÚformatÚnamer-r.Úlistr3r>r@rCrDrLrIZ percentileZmedianZpool_AZpool_HAZbr_AZbr_HAÚsortedZdtZyearÚuniqueZyearsZyrZgAZgHAr7rrAr8rBrr<r r r r!Úsš(  ($$$    þ  ÿÿ þ