a 1igZc@sdZddlZddlZddlmZddlmZddl Z e ddZ dZ dZ gd Zd d d d dddddZgdZddddddddddddd d!d"d#Zd$d%Zed&ed'Zeed(ed(<d)d*ejDZd+d*ejDZeeZeed,d-kgd.eZgd.d/d*eDe_eed,dkd0geZd0gd1d*eDe_ejed0d2d3Zed4ed5k e!ed6<ed7e"ed8d9ed:gd;Z#gZ$e%D]Z&e#D]Z'dZ(zxeje(d?d@Z)dAe)jvsdBe)jvrWqe)j*gdCdDZ)eje)dEdFdGdHe)dE<e)j*dEgdDZ)e&e)dI<e$+e)Wn Yn0qqej,e$dFdJZ-e.e-j/dKdLd-dM\Z0Z1Z2ej3e2e-j4dNe-dO<d-e-dOe-dP<e-dAe-dPe-dPe-dQ<ed7e"e-d8dRedSed(j56dTedU<e-dEj56dTe-dU<dVdWdXdYdZd[d\d]d^d_d_d`dadbdcdddddededfdgdhdidjdjdkdldmdndodpdqdrdsdtdudvdwdxdydzd{d|d}d~dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd d d d d dddddddddddddddddddddddddd d!d"d#d$d%dd&d'd(d)d*d+d,d-d.d/d0d1dud2d3d4d5d6d7d8d9d:d;d<d=d>d?d@dAdBdCdDdEdFdGdHdIdJdKdLdMdNdOdPdQdRdSdTdUdVdWdXdYdZd[d\d]d]d^d_d_d`dadbdcdddedfdfdgdhdididjdkdkdldmdndodpd/dndqdqdrdsdqdtduddvdwdxdydzd{d|d}d~ddddddddddddbZ7ddZ8ed/e8ed<ed/e8ed<e-d/e8e-d<e-d/e8e-d<eje-gdgdd2d3Z9e"e9e"edkr@eed0:e9d0Z;e;D]8\Z?Z@e@rdd*e@DZAede?deAqed7e"e9d8ddd*eDZBdd*eDZCgZDe.eBeCD]<\ZEZFdeEddZGe9eEe9eFe9eG<eD+eGqeBeCeDZHed7e"eHdedgZIeD]*ZJe9e9deJkj*eHdDZKe9e9deJkj*eHdDZLe"eKdk sRe"eLdk redeJde"eKde"eLdqeKeHjMZNeKd6jMZOeLeHjMZPeddddddZQeeQdddZReRSeNeOeRTePddd-fZUeLZLeUeLd<eeJZVe"eLZWeLdQe kXZYeLde kXZZeLeLde keLdQe k@Z[eLeLdQe kZ\eLeLde kZ]e"e[Z^e[_D]\Z`ZaeadAd-ZbeadOZcebdk redecebd-ecebdndZeeedk rܐ qeadAeadPeadPdZfeI+eadUeVegeadIeadIeadIeadeadeadeheagd rXe!eadndeheagd r~e!eadndeheagd re!eadndeheagd re!eadnde!eaddkeieadAdeieadPdeiefdeieaddeieedeiecdd qddZjeje\\ZkZlZmeje]\ZnZoZpeje[\ZqZrZsedeVdeWdedekdědemdƛdeldțdɝede dendědepdƛdeodțdɝ edeqdědesdƛderdțdɝqeteIud(jvdFd͍Zwedΐdϛede edϛede"ewd8edewd(xdewd(dedewdydd֛dɝewdd-zewdd-kdZ{ede{yddٛdɝede{Xdۛdܝed݃ew<dD]\Z'Z|e|dd-ze|dd-kdZ}ede'de"e|děde|dydd֛de}yddۛdɝ qJed߃ew<dj~dddvZew<d/ddLjMed<eeddkjudddZe_D]h\Z`Zaedeaddde!eaddědeaddd֛deaddۛdɝ qDede ddeD]Ze Ze ZdZew_D]v\Z`ZexededZeeZedr(eedd-ne ZedeedZedeeZedeeeeZqededdeddee d֛dedd֛dɝ qʐdZewjeddNedeeddS(z Random Forest + CLV combined strategy. Walk-forward: train RF on prior seasons to predict away win probability, then bet only when BOTH model pA >= threshold AND CLV > 5%. N)RandomForestClassifier)CalibratedClassifierCVignoreg@@g?gףp= ?)g??g?17181819192020212122222323242425)iiii)rrrrZEPLZ Championshipz League OnezLa LigaZSegundazSerie AzSerie BZ Bundesligaz 2.BundesligazLigue 1Z EredivisiezBelgian Pro Leaguez Super LigzGreek SLz Scottish Prem)ZE0ZE1ZE2ZSP1ZSP2ZI1ZI2ZD1ZD2ZF1ZN1ZB1ZT1ZG1ZSC0cCs:d|d|d|}d||d||d||fS)N)hdaZoverrr&E:\soccer\misc\archive\rf_clv_model.py remove_margin%srzLoading features...z$E:/soccer/raw_api/match_features.csvdatecCsg|]}d|vr|qS)Z_w5r.0crrr /rcCsg|]}d|vr|qS)Z_w10rrrrrr0rZis_homer) fixture_idrdivseason home_team away_team home_goals away_goalscCsg|]}d|qSZh_rrrrrr6rrcCsg|]}d|qSZa_rrrrrr9rinner)ZonZhowr%r$away_winz ,z matches with featureszLoading odds...) rrrr r r r r Z2526zE:/soccer/league_data/_z.csvz utf-8-sig)encodingB365APSCH)FTRr-B365HB365Dr.PSCDPSCA)ZsubsetZDateTZcoerce)Zdayfirsterrorsr )Z ignore_indexcCst|d|d|dS)Nr.r2r3)r)rrrrTrr6)Zaxis)indexp_A PSC_fair_Aedge_Az matches with oddszMerging features with odds...z%Y-%m-%ddate_strzman cityz man unitedz nott'm forestZ tottenhamZ newcastleZwolveszwest hamZ leicesterZleedsZbrightonZ bournemouthsheffield unitedZburnleycrystal palacez ath madridz ath bilbaoZbetisZsociedadZ valladolidZceltaZalavesZ vallecanoZcadizZalmeria las palmasZ barcelona real madridzparis sgZmonacoZlyonZ marseillez st etienneZ strasbourgZrennesZreimsZlensZlilleZnantesZbordeauxZangers clermont footZtroyesZtoulouseZlorientZajaccioZbrestZ montpellierZnicezle havreZdortmundz m'gladbach bayern munichZ leverkusen rb leipzigz ein frankfurtZ stuttgartZ wolfsburgZfreiburgz union berlinzfc kolnZ hoffenheimZaugsburg werder bremenZ heidenheimZherthaZ bielefeldZbochumz schalke 04greuther furthfortuna dusseldorfZ darmstadt holstein kielzst pauliinterZmilanZromaZnapoliZlaziojuventusatalantaZsassuoloZveronabolognaudinese sampdoriagenoaZ salernitanatorinoZ fiorentinaZlecceempolispeziaZ cremonesecagliarivenezia frosinonemonzacomoparmaajax feyenoordZpsv az alkmaarZtwenteZ heerenveen fc utrechtZ groningenvitessesparta rotterdamZwaalwijkZnecZcambuurgo ahead eaglesZvolendam excelsiorz almere cityz fort sittard pec zwolleZheracles willem ii nac bredaz club bruggeZantwerp anderlechtZgenkZstandardZgent oh leuvenz st gilloise cercle bruggeZmechelen charleroiZkortrijkz st truidenrwdmZeupenZ beerschotseraingZwaaslandwesterloZdendercelticrangersaberdeenhearts hibernian motherwellz st johnstonedundee livingston ross county kilmarnockz st mirrenz dundee utd galatasaray fenerbahcebesiktas trabzonsporZ basaksehiradana demirspor antalyaspor sivasspor kayserispor alanyaspor konyaspor kasimpasaZ gaziantep ankaragucu hatayspor giresunsporZumraniye istanbulspor pendiksporrizespor samsunspor bodrum fkeyupsporZ olympiakos panathinaikosZpaokZarisZaekZvolosasteras tripolisionikosofi atromitosZgianninalamia levadiakos panserraikos kallitheaZmainzZ paderbornZnurnbergZhannoverZdresdenZ regensburgZkaiserslautern hamburger svZ karlsruheZ magdeburgZ braunschweigzerzgebirge aueZulmpreussen munsterZ elversbergZapollonroda de graafschapZ eindhovenzden haagchievoZhamiltonz la corunaZespanolz sociedad b villarreal b barcelona bZ majadahondaguingampcaenz west bromZqprzsheffield wedsZswanseaZstokeZhullZcardiffZcoventryZnorwichwatfordZ blackburn bristol citymillwall middlesbrough sunderlandZprestonZlutonZplymouthZipswichZ rotherhamZ huddersfieldZ birminghamreading blackpoolZwiganbarnsleyZderbyZ peterborough portsmouthZboltonz oxford utdZcharltonZexeter port valeZ shrewsburyfleetwood townz cambridge utdZ cheltenhamZburtonZwycombe morecambeZ accringtonZlincolnmk donsz racing santZzaragozaZoviedoZhuescaZferrolZ cartagenaZmirandesZeibarZtenerifeZleganeselchemalagaalbaceteZburgos ponferradinalugoibizazsp gijonZgranadalevanteregginaperugiaspal beneventobresciaascoliternanacosenza cittadellapisabarisudtirolpalermo catanzaromodenareggiana juve stabiamantovacesena carrarese(bzmanchester cityzmanchester unitedznottingham forestztottenham hotspurznewcastle unitedzwolverhampton wandererszwest ham unitedzleicester cityz leeds unitedzbrighton & hove albionzbrighton hove albionzafc bournemouthr<z burnley fcr=uatlético madridzatletico madridz athletic clubzathletic bilbaoz real betisz real sociedadzreal valladolidz celta vigoudeportivo alavészdeportivo alaveszrayo vallecanoucádizualmeríar>z fc barcelonar?zparis saint germainz as monacozolympique lyonnaiszolympique de marseilleuas saint-étiennezrc strasbourg alsacezstade rennais fczstade de reimszrc lensz losc lillez fc nanteszgirondins de bordeauxz angers scor@z estac troyesz toulouse fcz fc lorientz ac ajacciozstade brestois 29zmontpellier hsczogc nicez le havre aczborussia dortmunduborussia mönchengladbachzborussia monchengladbachrAzbayer 04 leverkusenzbayer leverkusenrBzeintracht frankfurtz vfb stuttgartz vfl wolfsburgz sc freiburgz1. fc union berlinu 1. fc kölnz 1. fc kolnu 1. fc k”lnztsg hoffenheimz1899 hoffenheimz fc augsburgzsv werder bremenrCz1. fc heidenheimz1. fc heidenheim 1846z hertha berlinz hertha bsczarminia bielefeldz vfl bochumz fc schalke 04ugreuther fürthrDufortuna düsseldorfrEz darmstadt 98zsv darmstadt 98rFz fc st. paulirGZinternazionalezac milanzas romaz ssc napolizss laziorHrIzus sassuolo calcioz hellas veronazbologna fc 1909rJrKz uc sampdoriarMzus salernitana 1919rNzacf fiorentinazus leccerOrPz us cremoneserQrRrSrTrUrVrWrXz psv eindhovenrYZazz fc twentez sc heerenveenrZz fc groningenr[r\z rkc waalwijkz nec nijmegenz sc cambuurr]z fc volendamr^zalmere city fczfortuna sittardr_zheracles almelor`razclub brugge kvz royal antwerprbzkrc genkustandard liègezstandard liegezkaa gentrczunion saint-gilloisezunion st. gilloiserdz kv mechelenrez kv kortrijkzsint-truidense vvrfzas eupenz beerschot vargzwaasland-beverenrhz fc denderrirjrkzheart of midlothianrlrmrnz st. johnstonerorprqrrz st. mirrenz dundee unitedrsrtu fenerbahçeruu beşiktaşrvzistanbul basaksehiruistanbul başakşehirrwrxryrzr{r|r}u kasımpaşaz gaziantep fku ankaragücür~rru ümraniyesporrrrrru eyüpsporrzolympiacos piraeusrzpaok thessaloniki fczaris thessalonikisz aek athens fcz volos nfcrrrrz pas gianninarrrrz fsv mainz 05zmainz 05z1. fsv mainz 05zsc paderborn 07z fc nurnbergu1. fc nürnbergz hannover 96ubayern münchenubayern mnchenzdynamo dresdenzjahn regensburgzfc kaiserslauternz1. fc kaiserslauternrz karlsruher scz fc magdeburgz1. fc magdeburgzeintracht braunschweigzfc erzgebirge auez ssv ulm 1846rz fc elversbergzapollon smirniszolympiakos piraeusrrz fc eindhovenz ado den haagrzhamilton academicalzdeportivo la corunaZespanyolzreal sociedad iiz villarreal iirzrayo majadahondaz saint etiennerrzwest bromwich albionzqueens park rangerszsheffield wednesdayz swansea cityz stoke cityz hull cityz cardiff cityz coventry cityz norwich cityrzblackburn roversrrrrzpreston north endz luton townzplymouth argylez ipswich townzrotherham unitedzhuddersfield townzbirmingham cityrrzwigan athleticrz derby countyzpeterborough unitedrzbolton wanderersz oxford unitedzcharlton athleticz exeter cityrzshrewsbury townrzcambridge unitedzcheltenham townz burton albionzwycombe wanderersrz accrington stzaccrington stanleyz lincoln cityrzmilton keynes donszracing santanderz real zaragozaz real oviedoz sd huescaz racing ferrolz fc cartagenau cd mirandész cd mirandeszsd eibarz cd tenerifeu cd leganész cd leganesrumálagarrz burgos cfrrrrz ud las palmasusporting gijónzsporting gijonz granada cfrureal sporting de gijónrrz como 1907rrrrrrrrru südtirolrrrrrLrrrrrcCsddl}ddl}t|}|d|ddd}|tvrJt|S| dd|}| dd|}|tvr~t|St ||S) NrZNFKDasciirzK\b(fc|afc|sc|cf|cd|sd|ss|us|uc|rc|ac|as|og|rk|sv|vf[blr]|tsg|ssv|1\.|ssc)\bz\s+ ) unicodedatarestrlowerstripZ normalizeencodedecodeTEAM_MAPsubget)srrs2rrrnorm srr"h_normr#a_normZHomeTeamZAwayTeam)r;r rrr-r0r1r8r9r:r/FTHGFTAGHTHGHTAG)r;r rrg?cCs:tt|dtttd|jkdddS)Nrr )listsetuniqueodds_dfnamegrrrr6<rz WARNING: Only dz.0fz"% matched. Unmatched team samples:cCsg|]}|ddqS)rreplace)rr)rtrrrrArz z: z matched (features + odds)cCsg|]}d|qSr&rrrrrrGrcCsg|]}d|qSr'rrrrrrHrZdiff_z model featuresz Walk-forward training...r!i2z Season z: skipping (train=z, test=)i, *)Z n_estimatorsZ max_depthZmin_samples_leafZ random_stateZn_jobsrZisotonic)Zcvmethodmodel_pAr/rrrrrA)rr!leagueZ league_coder"r#Z actual_resultr$r%Zht_homeZht_awaywonoddsZ pinnacle_fairclv_pctrkelly_fractionZp_win_pinnaclecCsLt|dkrdSdd|D}t|t|t|d|ddfS)Nr)rrrcSs,g|]$\}}|ddkr$|ddndqS)r/rr-rrr)rr+r5rrrrrzflat_roi..rr))leniterrowssummean)ZdfZplsrrrflat_roisrz Season z (z matches):z CLV only (>5%): n=z>4z WR=z5.1fz% ROI=z+6.1f%z Model only (pA>=z ): n=z Combined (CLV + model): n=)Zdrop zF======================================================================z,COMBINED STRATEGY: CLV >5% + RF model pA >= z Total OOS bets: z Date range: z to z Win rate: rz.1frz Flat ROI: z+.2fz Total flat P&L: z+.1fz unitsz By season:z n=z By league (min 10 bets):r)rcount)rr)nwrcCs$|dd|ddkddS)Nrrrrr)whererrrrrr6rZroir F)Z ascendingz<22z n=rz Kelly compounding (from z,.0fz):grrz.2fz x Kelly: z>12,.2fz (z x) MaxDD=zE:\soccer\bets_rf_clv.csvz Saved to zDone.)__doc__ZpandasZpdZnumpyZnpZsklearn.ensemblerZsklearn.calibrationrwarningsfilterwarningsZSTARTZ CLV_THRESHZ PA_THRESHZ KELLY_MULTSZ seasons_mapZOOS_API_SEASONSZ league_namesrprintZread_csvZfeatZ to_datetimecolumnsZw5_colsZw10_colsZ feature_colscopyZ home_featZ away_featmergeZmatchesZastypeintrZ csv_seasonsZall_oddskeyscoderpathrZdropnaappendconcatrzipZapplyZtHZtDZtAZSeriesr7ZdtstrftimerrZmergedZisinZ unmatchedgroupbyZum_teamsitemsr ZteamsZsafeZ h_featuresZ a_featuresZ diff_featuresZhcZacZdiff_colZX_colsZall_betsZ test_seasonZtraintestvaluesZX_trainZy_trainZX_testZrfZcal_rfZfitZ predict_probaZpAZ season_strZn_totalrZn_clvZn_modelZcombinedZclv_onlyZ model_onlyZ n_combinedrr+r5bpmaxZkelly_frrZnotnaroundrZn_cZroi_cZwr_cZn_mZroi_mZwr_mZn_bZroi_bZwr_bZ DataFrameZ sort_valuesZ reset_indexZbetsminrrZflat_plZgrpfpZaggZlgZkmZbkZpeakZmax_ddrowfZstakeZploutZto_csvrrrrs                 @   *    ,      ( &&&&    084 (("" "Z    $b$ J