a i1@sddlZddlZgdZdddddZdd ZgZeD]Z\Z Z eD]LZ z:ej d e d e d d dZ e e d<e e d<ee WqFYqF0qFq:ejeddZejgddZeZejeddded<edjddZeejdddd\ZZZejeejded<deded<edded <ededded!<ed!ed ed"<ededd#ked"dk@ed$<eed$Zed%eeed&eed" !d'ed(ed""d)d*ed""d+d,d-ed.ed"#d)d*ed"#d+d,d-ed/ed"$d)d*ed"$d+d,d-edj%&d0ed1<eZ'e'dj%&d0e'd1<e'(d1d")Z*ed2ee* !d'ed3e*"d+d4d5ed6e*#d+d4d5ed7e*$d+d4d5dd:d;Z+e'd<d=ke'd><ed?ed@edAedBdCdDdEdFdDdGdHdDdIdJdDdKdL edMdZ,dND]Z-e+e'e-dOZ.e.j/redPe-d,dQdRdFqhe.dSj0dTZ1e.dS2Z3e3e.dSe3d+$Z4e1d8kZ5dPe-d,dUZ6e,dure5se1dVkrdWndXZ7e,dur,e5s,e1dVkr,e-e1e4fZ,ee6dCdYe1dZdDe1dVd[d\e4d[d]e5r\d^nd_dLe7 qhed`edaedbe+e'dcdOZ.eddd1dedDdfdgdDdhdJdDdidjdDdkdldDdSdldDdGdmedMe.8D]\Z9Z:e;e:dndoe;e:dpe:dnZedxe1dyd*e1dVd4dze3$dyd{e>dyd|e4d4d5 ed`ed}edbe+e'd~dOZ?eddd1dedDdfdgdDdhdJdDdidjdDdkdldDdSdldDdGdmedMe?8D]\Z9Z:e;e:dndoe;e:dpe:dnZrr)Zaxis)indexZp_awayZ PSC_fair_Ar bZedgekelly_fg?Z qualifieszQualifying bets: z$ === Kelly fraction distribution ===z Median Kelly: z.4fz (dz.2fz%)zMean Kelly: zMax Kelly: WWeekz. === Weekly total Kelly stake distribution ===zMedian weekly Kelly total: z.1f%zMean weekly Kelly total: zMax weekly Kelly total: ?@@c Cs|}g}|}|djd|d<t|dD]}||d|k}|jrPq4d}d}d} |D]X\} } | d|} t| d} || } | | 7} | dr|| | d7}|d 7}qd|| 8}qd||7}|t |t |t | d t |d t |d |t ||d d |dkr4qq4t |S) Nr rrrr?wonrr)rN Total_stakedWeek_PLBankrollWins Bankroll_x)copydt to_periodsorteduniqueemptyiterrowsminappendstrlenroundpdZ DataFrame)datakelly_multiplierZstarting_bankrollZbankrollhistoryZweekZ week_betsZweek_plZwinsZ total_stakedr ZbetfZstakerrr run_kelly_sim?sB      r9r ArzG ======================================================================u?KELLY SIMULATION — vary Kelly fraction (with 25% per-bet cap)zF======================================================================zKelly fractionz<20 uFinal £z>12xz>8zMax DD%z>9zBust?z>7zF----------------------------------------------------------------------) g?g333333?g?rg333333?g??g?rg?g@)r6z zx Kelly ZBUSTr%zx Kellyiz <-- optimal?u £z>11,.2fz>8.1fzx z% ZYESZnoz[ ==========================================================================================u&QUARTER KELLY (0.25x) — week by weekzZ==========================================================================================r z<14ZBetsz>4ZStakedzW/Lz>5zWeek P&Lz>10z>6r&/r"r#z>9.2fr$z>+10.2fz>10.2fr'z>6.2fu Final: £z,.2fu x) | Peak: £u | Trough: £z | Max DD: u"HALF KELLY (0.5x) — week by weekr=zB =================================================================u>PER-SEASON — Quarter Kelly (0.25x), start £1000 each seasonzA=================================================================z bets=z>3u £z>9,.2fz x max_dd=)rr)EZpandasr4ZnumpyZnpZseasonsZleaguesrZdfsitemscodenamesZread_csvrr0concatZdfZdropnar(Z to_datetimeZ sort_valuesZ reset_indexzipZapplyZtHZtDZtAZSeriesrZ qualifyingprintr2Zdescriber3ZmedianZmeanmaxr)r*Z qualifying_wgroupbysumZ weekly_kellyr9ZbestZkmrr-Zilocr8ZcummaxZpkZddZbustZlabelZmarkerr.r rowintZwlr/ZtroughZh2f2Zpk2Zdd2Zseasonsubrrrrs$... +.   " D @&`  : @&` 2