a i@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\ZZZdejeejded<edededed<edd ked!<ed"d#ked$<ed%eeed&ed!ed'ed !d(ed"!edj#$d)ed*<eed!Z%d{d-d.Z&ed/ed0ed1e&e%d+d,d2Z'ed3d*d4d5d6d7d5d8d9d5d:d9d5d;d<d5d=d>d5d?d>d5d@dAedBe'(D]\Z)Z*e+e*dCdDe+e*dEe*dCZ,e*dFdGZ-ee*d*d4d5e+e*dEd7d5e*dHdId5e*dJdId5e,d<d5e-d5e*d?dKd5e*dLdMd@qTe'd?j.dNZ/e'd?"Z0e'd? Z1e'j2e'd?3d*fZ4e'd?5e'd?Z6e6"Z7e7e'd?5e63dOZ8ee'Z9edPedQedRedSedTe/dUdVe/dWdXdYedZe0dUd[e4d\ed]e7dUdVe8dXd^ed_e9ed`e%d$:dOdXdaedPedbedRedcd>dddedfddd@dAdddgd9dddhd> diD]Z;e&e%e;d,d2ZedkZAee;dOdjdme>dndde>dodpdqe@drdkeArdsndtd> qVeduedvedweddxddd6d<ddded>ddd@dAdddgd9 eD]ZBe%e%deBkZCeCj=rvqVe&eCd+d,d2Zedzdde>dodMdqe@drda qVdS)|N)Z1920Z2021Z2122Z2223Z2324Z2425Z2526ZEPLZ ChampionshipzLigue 1zSerie A)ZE0ZE1ZF1ZI1cCs:d|d|d|}d||d||d||fS)N)hdaZoverrr%E:\soccer\misc\archive\compounding.py remove_marginsrzE:/soccer/league_data/_z.csvz utf-8-sig)encodingZSeasonZLeagueT)Z ignore_index)FTRDateB365APSCHPSCDPSCA)Zsubsetr )Zdayfirst)ZdropcCst|d|d|dS)Nrrr)r)rrrrrr)Zaxis)indexZ PSC_fair_Ar Zedge皙?Z qualifiesr AwonzTotal matches: zQualifying bets: z Date range: z to WWeek皙?@@cCs|}g}t|d}|D]}||d|k}t|} | dkrBq||} | | } d} d} |D]6\}}|dr| | |dd7} | d7} qb| | 8} qb|| 7}|t|| t| dt| dt| dt|d| t| | ddt||dd |dkrtd |d qqt |S) Nrrrr rd) rN_betsPer_bet Week_stakeWeek_PLBankrollWinsZWR Bankroll_xz BUST at week !) sorteduniqueleniterrowsappendstrroundprintpdZ DataFrame)data stake_pctstarting_bankrollZedge_thresholdZbankrollhistoryZweeksZweekZ week_betsnZ week_stakeZper_betZweek_plZwinsr Zbetrrr run_compound4sB    r5z[ ==========================================================================================uICOMPOUNDING SIMULATION — Away CLV >5%, stake 80% per week, start £1000zZ==========================================================================================)r1r2 z<14 ZBetsz>4ZStakez>8zPer BetzW/Lz>5zWeek P&Lz>10r#xz>6zK---------------------------------------------------------------------------r$/rr"z>+10.2fr!z>8.2fr z>10.2fr%z>6.2frz= ============================================================ZSUMMARYz<============================================================u! Starting bankroll: £1,000.00u Final bankroll: £z,.2fz ( z.1fzx)u Peak bankroll: £z (week )u Max drawdown: £z%)z Weeks with bets: z Overall win rate: %u8SENSITIVITY — stake % vs final bankroll (start £1000)zStake %z uFinal £z>12zMax DD%z Went Bust) g?g?g333333?g?g?g333333?gffffff?rg?g?z>9.0fz% ZBUSTu% £z>11,.2fiz>6.1fzx z>7.1fZYESZnozG ======================================================================u2PER-SEASON: start each season at £1000, stake 80%zF======================================================================z<10u £z>9,.2f)rrr)DZpandasr/ZnumpyZnpZseasonsZleaguesrZdfsitemscodenamesZread_csvrr+concatZdfZdropnacopyZ to_datetimeZ sort_valuesZ reset_indexzipZapplyZtHZtDZtAZSeriesrr.r)summindatemaxZdtZ to_periodZ qualifyingr5Zhistr*r rowintZwlZpl_strZilocfinalZpeakZtroughZlocZidxmaxZ peak_weekZcummaxZ max_dd_rowZmax_ddZ max_dd_pctZ total_weeksZmeanZpctremptyfZpkZddZbustZseasonsubrrrrs, *H& f  . D.