clear all
use "EPL-2001-2025.dta"

* Expected outcomes from bookmaker odds ****************************************************************************************************************************************************************************************************************************


mvencode whh,mv(-1)
mvencode whd,mv(-1)
mvencode wha,mv(-1)
mvencode iwh,mv(-1)
mvencode iwd,mv(-1)
mvencode iwa,mv(-1)
mvencode b365h,mv(-1)
mvencode b365d,mv(-1)
mvencode b365a,mv(-1)


gen whhx=whh*(whh>=0)+iwh*(whh<0)*(iwh>0)+b365h*(whh<0)*(iwh<0)
tab whhx
gen whdx=whd*(whd>=0)+iwd*(whd<0)*(iwd>0)+b365d*(whd<0)*(iwd<0)
gen whax=wha*(wha>=0)+iwa*(wha<0)*(iwa>0)+b365a*(wha<0)*(iwa<0)

sum whhx whdx whax

gen sumodds=(1/whhx)+(1/whdx)+(1/whax)

sum sumodds

gen phome=(1/whhx)/((1/whhx)+(1/whdx)+(1/whax))
gen pdraw=(1/whdx)/((1/whhx)+(1/whdx)+(1/whax))
gen paway=(1/whax)/((1/whhx)+(1/whdx)+(1/whax))
gen check=phome+pdraw+paway
sum phome pdraw paway check

**************************************
gen THA=(hometeam=="Arsenal")
gen THB=(hometeam=="Aston Villa")
gen THC=(hometeam=="Chelsea")
gen THD=(hometeam=="Everton")
gen THE=(hometeam=="Liverpool")
gen THF=(hometeam=="Man City")
gen THG=(hometeam=="Man United")
gen THH=(hometeam=="Newcastle")
gen THI=(hometeam=="Tottenham")
gen THJ=(hometeam=="West Ham")


gen TAA=(awayteam=="Arsenal")
gen TAB=(awayteam=="Aston Villa")
gen TAC=(awayteam=="Chelsea")
gen TAD=(awayteam=="Everton")
gen TAE=(awayteam=="Liverpool")
gen TAF=(awayteam=="Man City")
gen TAG=(awayteam=="Man United")
gen TAH=(awayteam=="Newcastle")
gen TAI=(awayteam=="Tottenham")
gen TAJ=(awayteam=="West Ham")

bysort Seizoen: sum THA THB THC THD THE THF THG THH THI THJ 

gen Homewin=(fthg>ftag)
gen Awaywin=(ftag>fthg)
gen SurpHwin=Homewin-phome
gen SurpAwin=Awaywin-paway

*gen Ehomepoints=(phome*3+pdraw)
*gen Eawaypoints=(paway*3+pdraw)
*gen Homepoints=((fthg>ftag)*3+(fthg==ftag))
*gen Awaypoints=((fthg<ftag)*3+(fthg==ftag))
*gen SurHpoints=Homepoints-Ehomepoints
*gen SurApoints=Awaypoints-Eawaypoints

gen Ehomepoints=(fthg>ftag)
gen Eawaypoints=(fthg<ftag)

gen ABwin=(THA==1)*(TAB==1)*(Ehomepoints)+(TAA==1)*(THB==1)*(Eawaypoints)
gen ACwin=(THA==1)*(TAC==1)*(Ehomepoints)+(TAA==1)*(THC==1)*(Eawaypoints)
gen ADwin=(THA==1)*(TAD==1)*(Ehomepoints)+(TAA==1)*(THD==1)*(Eawaypoints)
gen AEwin=(THA==1)*(TAE==1)*(Ehomepoints)+(TAA==1)*(THE==1)*(Eawaypoints)
gen AFwin=(THA==1)*(TAF==1)*(Ehomepoints)+(TAA==1)*(THF==1)*(Eawaypoints)
gen AGwin=(THA==1)*(TAG==1)*(Ehomepoints)+(TAA==1)*(THG==1)*(Eawaypoints)
gen AHwin=(THA==1)*(TAH==1)*(Ehomepoints)+(TAA==1)*(THH==1)*(Eawaypoints)
gen AIwin=(THA==1)*(TAI==1)*(Ehomepoints)+(TAA==1)*(THI==1)*(Eawaypoints)
gen AJwin=(THA==1)*(TAJ==1)*(Ehomepoints)+(TAA==1)*(THJ==1)*(Eawaypoints)

gen BAwin=(THB==1)*(TAA==1)*(Ehomepoints)+(TAB==1)*(THA==1)*(Eawaypoints)
gen BCwin=(THB==1)*(TAC==1)*(Ehomepoints)+(TAB==1)*(THC==1)*(Eawaypoints)
gen BDwin=(THB==1)*(TAD==1)*(Ehomepoints)+(TAB==1)*(THD==1)*(Eawaypoints)
gen BEwin=(THB==1)*(TAE==1)*(Ehomepoints)+(TAB==1)*(THE==1)*(Eawaypoints)
gen BFwin=(THB==1)*(TAF==1)*(Ehomepoints)+(TAB==1)*(THF==1)*(Eawaypoints)
gen BGwin=(THB==1)*(TAG==1)*(Ehomepoints)+(TAB==1)*(THG==1)*(Eawaypoints)
gen BHwin=(THB==1)*(TAH==1)*(Ehomepoints)+(TAB==1)*(THH==1)*(Eawaypoints)
gen BIwin=(THB==1)*(TAI==1)*(Ehomepoints)+(TAB==1)*(THI==1)*(Eawaypoints)
gen BJwin=(THB==1)*(TAJ==1)*(Ehomepoints)+(TAB==1)*(THJ==1)*(Eawaypoints)


gen CAwin=(THC==1)*(TAA==1)*(Ehomepoints)+(TAC==1)*(THA==1)*(Eawaypoints)
gen CBwin=(THC==1)*(TAB==1)*(Ehomepoints)+(TAC==1)*(THB==1)*(Eawaypoints)
gen CDwin=(THC==1)*(TAD==1)*(Ehomepoints)+(TAC==1)*(THD==1)*(Eawaypoints)
gen CEwin=(THC==1)*(TAE==1)*(Ehomepoints)+(TAC==1)*(THE==1)*(Eawaypoints)
gen CFwin=(THC==1)*(TAF==1)*(Ehomepoints)+(TAC==1)*(THF==1)*(Eawaypoints)
gen CGwin=(THC==1)*(TAG==1)*(Ehomepoints)+(TAC==1)*(THG==1)*(Eawaypoints)
gen CHwin=(THC==1)*(TAH==1)*(Ehomepoints)+(TAC==1)*(THH==1)*(Eawaypoints)
gen CIwin=(THC==1)*(TAI==1)*(Ehomepoints)+(TAC==1)*(THI==1)*(Eawaypoints)
gen CJwin=(THC==1)*(TAJ==1)*(Ehomepoints)+(TAC==1)*(THJ==1)*(Eawaypoints)


gen DAwin=(THD==1)*(TAA==1)*(Ehomepoints)+(TAD==1)*(THA==1)*(Eawaypoints)
gen DBwin=(THD==1)*(TAB==1)*(Ehomepoints)+(TAD==1)*(THB==1)*(Eawaypoints)
gen DCwin=(THD==1)*(TAC==1)*(Ehomepoints)+(TAD==1)*(THC==1)*(Eawaypoints)
gen DEwin=(THD==1)*(TAE==1)*(Ehomepoints)+(TAD==1)*(THE==1)*(Eawaypoints)
gen DFwin=(THD==1)*(TAF==1)*(Ehomepoints)+(TAD==1)*(THF==1)*(Eawaypoints)
gen DGwin=(THD==1)*(TAG==1)*(Ehomepoints)+(TAD==1)*(THG==1)*(Eawaypoints)
gen DHwin=(THD==1)*(TAH==1)*(Ehomepoints)+(TAD==1)*(THH==1)*(Eawaypoints)
gen DIwin=(THD==1)*(TAI==1)*(Ehomepoints)+(TAD==1)*(THI==1)*(Eawaypoints)
gen DJwin=(THD==1)*(TAJ==1)*(Ehomepoints)+(TAD==1)*(THJ==1)*(Eawaypoints)


gen EAwin=(THE==1)*(TAA==1)*(Ehomepoints)+(TAE==1)*(THA==1)*(Eawaypoints)
gen EBwin=(THE==1)*(TAB==1)*(Ehomepoints)+(TAE==1)*(THB==1)*(Eawaypoints)
gen ECwin=(THE==1)*(TAC==1)*(Ehomepoints)+(TAE==1)*(THC==1)*(Eawaypoints)
gen EDwin=(THE==1)*(TAD==1)*(Ehomepoints)+(TAE==1)*(THD==1)*(Eawaypoints)
gen EFwin=(THE==1)*(TAF==1)*(Ehomepoints)+(TAE==1)*(THF==1)*(Eawaypoints)
gen EGwin=(THE==1)*(TAG==1)*(Ehomepoints)+(TAE==1)*(THG==1)*(Eawaypoints)
gen EHwin=(THE==1)*(TAH==1)*(Ehomepoints)+(TAE==1)*(THH==1)*(Eawaypoints)
gen EIwin=(THE==1)*(TAI==1)*(Ehomepoints)+(TAE==1)*(THI==1)*(Eawaypoints)
gen EJwin=(THE==1)*(TAJ==1)*(Ehomepoints)+(TAE==1)*(THJ==1)*(Eawaypoints)


gen FAwin=(THF==1)*(TAA==1)*(Ehomepoints)+(TAF==1)*(THA==1)*(Eawaypoints)
gen FBwin=(THF==1)*(TAB==1)*(Ehomepoints)+(TAF==1)*(THB==1)*(Eawaypoints)
gen FCwin=(THF==1)*(TAC==1)*(Ehomepoints)+(TAF==1)*(THC==1)*(Eawaypoints)
gen FDwin=(THF==1)*(TAD==1)*(Ehomepoints)+(TAF==1)*(THD==1)*(Eawaypoints)
gen FEwin=(THF==1)*(TAE==1)*(Ehomepoints)+(TAF==1)*(THE==1)*(Eawaypoints)
gen FGwin=(THF==1)*(TAG==1)*(Ehomepoints)+(TAF==1)*(THG==1)*(Eawaypoints)
gen FHwin=(THF==1)*(TAH==1)*(Ehomepoints)+(TAF==1)*(THH==1)*(Eawaypoints)
gen FIwin=(THF==1)*(TAI==1)*(Ehomepoints)+(TAF==1)*(THI==1)*(Eawaypoints)
gen FJwin=(THF==1)*(TAJ==1)*(Ehomepoints)+(TAF==1)*(THJ==1)*(Eawaypoints)

gen GAwin=(THG==1)*(TAA==1)*(Ehomepoints)+(TAG==1)*(THA==1)*(Eawaypoints)
gen GBwin=(THG==1)*(TAB==1)*(Ehomepoints)+(TAG==1)*(THB==1)*(Eawaypoints)
gen GCwin=(THG==1)*(TAC==1)*(Ehomepoints)+(TAG==1)*(THC==1)*(Eawaypoints)
gen GDwin=(THG==1)*(TAD==1)*(Ehomepoints)+(TAG==1)*(THD==1)*(Eawaypoints)
gen GEwin=(THG==1)*(TAE==1)*(Ehomepoints)+(TAG==1)*(THE==1)*(Eawaypoints)
gen GFwin=(THG==1)*(TAF==1)*(Ehomepoints)+(TAG==1)*(THF==1)*(Eawaypoints)
gen GHwin=(THG==1)*(TAH==1)*(Ehomepoints)+(TAG==1)*(THH==1)*(Eawaypoints)
gen GIwin=(THG==1)*(TAI==1)*(Ehomepoints)+(TAG==1)*(THI==1)*(Eawaypoints)
gen GJwin=(THG==1)*(TAJ==1)*(Ehomepoints)+(TAG==1)*(THJ==1)*(Eawaypoints)

gen HAwin=(THH==1)*(TAA==1)*(Ehomepoints)+(TAH==1)*(THA==1)*(Eawaypoints)
gen HBwin=(THH==1)*(TAB==1)*(Ehomepoints)+(TAH==1)*(THB==1)*(Eawaypoints)
gen HCwin=(THH==1)*(TAC==1)*(Ehomepoints)+(TAH==1)*(THC==1)*(Eawaypoints)
gen HDwin=(THH==1)*(TAD==1)*(Ehomepoints)+(TAH==1)*(THD==1)*(Eawaypoints)
gen HEwin=(THH==1)*(TAE==1)*(Ehomepoints)+(TAH==1)*(THE==1)*(Eawaypoints)
gen HFwin=(THH==1)*(TAF==1)*(Ehomepoints)+(TAH==1)*(THF==1)*(Eawaypoints)
gen HGwin=(THH==1)*(TAG==1)*(Ehomepoints)+(TAH==1)*(THG==1)*(Eawaypoints)
gen HIwin=(THH==1)*(TAI==1)*(Ehomepoints)+(TAH==1)*(THI==1)*(Eawaypoints)
gen HJwin=(THH==1)*(TAJ==1)*(Ehomepoints)+(TAH==1)*(THJ==1)*(Eawaypoints)

gen IAwin=(THI==1)*(TAA==1)*(Ehomepoints)+(TAI==1)*(THA==1)*(Eawaypoints)
gen IBwin=(THI==1)*(TAB==1)*(Ehomepoints)+(TAI==1)*(THB==1)*(Eawaypoints)
gen ICwin=(THI==1)*(TAC==1)*(Ehomepoints)+(TAI==1)*(THC==1)*(Eawaypoints)
gen IDwin=(THI==1)*(TAD==1)*(Ehomepoints)+(TAI==1)*(THD==1)*(Eawaypoints)
gen IEwin=(THI==1)*(TAE==1)*(Ehomepoints)+(TAI==1)*(THE==1)*(Eawaypoints)
gen IFwin=(THI==1)*(TAF==1)*(Ehomepoints)+(TAI==1)*(THF==1)*(Eawaypoints)
gen IGwin=(THI==1)*(TAG==1)*(Ehomepoints)+(TAI==1)*(THG==1)*(Eawaypoints)
gen IHwin=(THI==1)*(TAH==1)*(Ehomepoints)+(TAI==1)*(THH==1)*(Eawaypoints)
gen IJwin=(THI==1)*(TAJ==1)*(Ehomepoints)+(TAI==1)*(THJ==1)*(Eawaypoints)

gen JAwin=(THJ==1)*(TAA==1)*(Ehomepoints)+(TAJ==1)*(THA==1)*(Eawaypoints)
gen JBwin=(THJ==1)*(TAB==1)*(Ehomepoints)+(TAJ==1)*(THB==1)*(Eawaypoints)
gen JCwin=(THJ==1)*(TAC==1)*(Ehomepoints)+(TAJ==1)*(THC==1)*(Eawaypoints)
gen JDwin=(THJ==1)*(TAD==1)*(Ehomepoints)+(TAJ==1)*(THD==1)*(Eawaypoints)
gen JEwin=(THJ==1)*(TAE==1)*(Ehomepoints)+(TAJ==1)*(THE==1)*(Eawaypoints)
gen JFwin=(THJ==1)*(TAF==1)*(Ehomepoints)+(TAJ==1)*(THF==1)*(Eawaypoints)
gen JGwin=(THJ==1)*(TAG==1)*(Ehomepoints)+(TAJ==1)*(THG==1)*(Eawaypoints)
gen JHwin=(THJ==1)*(TAH==1)*(Ehomepoints)+(TAJ==1)*(THH==1)*(Eawaypoints)
gen JIwin=(THJ==1)*(TAI==1)*(Ehomepoints)+(TAJ==1)*(THI==1)*(Eawaypoints)


bysort Seizoen: egen ProfABwin=total(ABwin)
bysort Seizoen: egen ProfACwin=total(ACwin)
bysort Seizoen: egen ProfADwin=total(ADwin)
bysort Seizoen: egen ProfAEwin=total(AEwin)
bysort Seizoen: egen ProfAFwin=total(AFwin)
bysort Seizoen: egen ProfAGwin=total(AGwin)
bysort Seizoen: egen ProfAHwin=total(AHwin)
bysort Seizoen: egen ProfAIwin=total(AIwin)
bysort Seizoen: egen ProfAJwin=total(AJwin)

bysort Seizoen: egen ProfBAwin=total(BAwin)
bysort Seizoen: egen ProfBCwin=total(BCwin)
bysort Seizoen: egen ProfBDwin=total(BDwin)
bysort Seizoen: egen ProfBEwin=total(BEwin)
bysort Seizoen: egen ProfBFwin=total(BFwin)
bysort Seizoen: egen ProfBGwin=total(BGwin)
bysort Seizoen: egen ProfBHwin=total(BHwin)
bysort Seizoen: egen ProfBIwin=total(BIwin)
bysort Seizoen: egen ProfBJwin=total(BJwin)

bysort Seizoen: egen ProfCAwin=total(CAwin)
bysort Seizoen: egen ProfCBwin=total(CBwin)
bysort Seizoen: egen ProfCDwin=total(CDwin)
bysort Seizoen: egen ProfCEwin=total(CEwin)
bysort Seizoen: egen ProfCFwin=total(CFwin)
bysort Seizoen: egen ProfCGwin=total(CGwin)
bysort Seizoen: egen ProfCHwin=total(CHwin)
bysort Seizoen: egen ProfCIwin=total(CIwin)
bysort Seizoen: egen ProfCJwin=total(CJwin)

bysort Seizoen: egen ProfDAwin=total(DAwin)
bysort Seizoen: egen ProfDBwin=total(DBwin)
bysort Seizoen: egen ProfDCwin=total(DCwin)
bysort Seizoen: egen ProfDEwin=total(DEwin)
bysort Seizoen: egen ProfDFwin=total(DFwin)
bysort Seizoen: egen ProfDGwin=total(DGwin)
bysort Seizoen: egen ProfDHwin=total(DHwin)
bysort Seizoen: egen ProfDIwin=total(DIwin)
bysort Seizoen: egen ProfDJwin=total(DJwin)

bysort Seizoen: egen ProfEAwin=total(EAwin)
bysort Seizoen: egen ProfEBwin=total(EBwin)
bysort Seizoen: egen ProfECwin=total(ECwin)
bysort Seizoen: egen ProfEDwin=total(EDwin)
bysort Seizoen: egen ProfEFwin=total(EFwin)
bysort Seizoen: egen ProfEGwin=total(EGwin)
bysort Seizoen: egen ProfEHwin=total(EHwin)
bysort Seizoen: egen ProfEIwin=total(EIwin)
bysort Seizoen: egen ProfEJwin=total(EJwin)

bysort Seizoen: egen ProfFAwin=total(FAwin)
bysort Seizoen: egen ProfFBwin=total(FBwin)
bysort Seizoen: egen ProfFCwin=total(FCwin)
bysort Seizoen: egen ProfFDwin=total(FDwin)
bysort Seizoen: egen ProfFEwin=total(FEwin)
bysort Seizoen: egen ProfFGwin=total(FGwin)
bysort Seizoen: egen ProfFHwin=total(FHwin)
bysort Seizoen: egen ProfFIwin=total(FIwin)
bysort Seizoen: egen ProfFJwin=total(FJwin)

bysort Seizoen: egen ProfGAwin=total(GAwin)
bysort Seizoen: egen ProfGBwin=total(GBwin)
bysort Seizoen: egen ProfGCwin=total(GCwin)
bysort Seizoen: egen ProfGDwin=total(GDwin)
bysort Seizoen: egen ProfGEwin=total(GEwin)
bysort Seizoen: egen ProfGFwin=total(GFwin)
bysort Seizoen: egen ProfGHwin=total(GHwin)
bysort Seizoen: egen ProfGIwin=total(GIwin)
bysort Seizoen: egen ProfGJwin=total(GJwin)

bysort Seizoen: egen ProfHAwin=total(HAwin)
bysort Seizoen: egen ProfHBwin=total(HBwin)
bysort Seizoen: egen ProfHCwin=total(HCwin)
bysort Seizoen: egen ProfHDwin=total(HDwin)
bysort Seizoen: egen ProfHEwin=total(HEwin)
bysort Seizoen: egen ProfHFwin=total(HFwin)
bysort Seizoen: egen ProfHGwin=total(HGwin)
bysort Seizoen: egen ProfHIwin=total(HIwin)
bysort Seizoen: egen ProfHJwin=total(HJwin)

bysort Seizoen: egen ProfIAwin=total(IAwin)
bysort Seizoen: egen ProfIBwin=total(IBwin)
bysort Seizoen: egen ProfICwin=total(ICwin)
bysort Seizoen: egen ProfIDwin=total(IDwin)
bysort Seizoen: egen ProfIEwin=total(IEwin)
bysort Seizoen: egen ProfIFwin=total(IFwin)
bysort Seizoen: egen ProfIGwin=total(IGwin)
bysort Seizoen: egen ProfIHwin=total(IHwin)
bysort Seizoen: egen ProfIJwin=total(IJwin)

bysort Seizoen: egen ProfJAwin=total(JAwin)
bysort Seizoen: egen ProfJBwin=total(JBwin)
bysort Seizoen: egen ProfJCwin=total(JCwin)
bysort Seizoen: egen ProfJDwin=total(JDwin)
bysort Seizoen: egen ProfJEwin=total(JEwin)
bysort Seizoen: egen ProfJFwin=total(JFwin)
bysort Seizoen: egen ProfJGwin=total(JGwin)
bysort Seizoen: egen ProfJHwin=total(JHwin)
bysort Seizoen: egen ProfJIwin=total(JIwin)

tab Seizoen hometeam 

*gen MIS=THB*((Seizoen==2017)+(Seizoen==2018)+(Seizoen==2019))+THF*(Seizoen==2002)+THH*((Seizoen==2010)+(Seizoen==2017))+THJ*((Seizoen==2004)+(Seizoen==2005)+(Seizoen==2012))+TAB*((Seizoen==2017)+(Seizoen==2018)+(Seizoen==2019))+TAF*(Seizoen==2002)+TAH*((Seizoen==2010)+(Seizoen==2017))+TAJ*((Seizoen==2004)+(Seizoen==2005)+(Seizoen==2012))
*tab MIS

collapse ProfABwin ProfACwin ProfADwin ProfAEwin ProfAFwin ProfAGwin ProfAHwin ProfAIwin ProfAJwin ProfBAwin ProfBCwin ProfBDwin ProfBEwin ProfBFwin ProfBGwin ProfBHwin ProfBIwin ProfBJwin ProfCAwin ProfCBwin ProfCDwin ProfCEwin ProfCFwin ProfCGwin ProfCHwin ProfCIwin ProfCJwin ProfDAwin ProfDBwin ProfDCwin ProfDEwin ProfDFwin ProfDGwin ProfDHwin ProfDIwin ProfDJwin ProfEAwin ProfEBwin ProfECwin ProfEDwin ProfEFwin ProfEGwin ProfEHwin ProfEIwin ProfEJwin ProfFAwin ProfFBwin ProfFCwin ProfFDwin ProfFEwin ProfFGwin ProfFHwin ProfFIwin ProfFJwin ProfGAwin ProfGBwin ProfGCwin ProfGDwin ProfGEwin ProfGFwin ProfGHwin ProfGIwin ProfGJwin ProfHAwin ProfHBwin ProfHCwin ProfHDwin ProfHEwin ProfHFwin ProfHGwin ProfHIwin ProfHJwin ProfIAwin ProfIBwin ProfICwin ProfIDwin ProfIEwin ProfIFwin ProfIGwin ProfIHwin ProfIJwin ProfJAwin ProfJBwin ProfJCwin ProfJDwin ProfJEwin ProfJFwin ProfJGwin ProfJHwin ProfJIwin,by(Seizoen)



gen ABwin=(ProfABwin)-(ProfBAwin)
gen ACwin=(ProfACwin)-(ProfCAwin)
gen ADwin=(ProfADwin)-(ProfDAwin)
gen AEwin=(ProfAEwin)-(ProfEAwin)
gen AFwin=(ProfAFwin)-(ProfFAwin)
gen AGwin=(ProfAGwin)-(ProfGAwin)
gen AHwin=(ProfAHwin)-(ProfHAwin)
gen AIwin=(ProfAIwin)-(ProfIAwin)
gen AJwin=(ProfAJwin)-(ProfJAwin)


gen BAwin=(ProfBAwin)-(ProfABwin)
gen BCwin=(ProfBCwin)-(ProfCBwin)
gen BDwin=(ProfBDwin)-(ProfDBwin)
gen BEwin=(ProfBEwin)-(ProfEBwin)
gen BFwin=(ProfBFwin)-(ProfFBwin)
gen BGwin=(ProfBGwin)-(ProfGBwin)
gen BHwin=(ProfBHwin)-(ProfHBwin)
gen BIwin=(ProfBIwin)-(ProfIBwin)
gen BJwin=(ProfBJwin)-(ProfJBwin)

gen CAwin=(ProfCAwin)-(ProfACwin)
gen CBwin=(ProfCBwin)-(ProfBCwin)
gen CDwin=(ProfCDwin)-(ProfDCwin)
gen CEwin=(ProfCEwin)-(ProfECwin)
gen CFwin=(ProfCFwin)-(ProfFCwin)
gen CGwin=(ProfCGwin)-(ProfGCwin)
gen CHwin=(ProfCHwin)-(ProfHCwin)
gen CIwin=(ProfCIwin)-(ProfICwin)
gen CJwin=(ProfCJwin)-(ProfJCwin)

gen DAwin=(ProfDAwin)-(ProfADwin)
gen DBwin=(ProfDBwin)-(ProfBDwin)
gen DCwin=(ProfDCwin)-(ProfCDwin)
gen DEwin=(ProfDEwin)-(ProfEDwin)
gen DFwin=(ProfDFwin)-(ProfFDwin)
gen DGwin=(ProfDGwin)-(ProfGDwin)
gen DHwin=(ProfDHwin)-(ProfHDwin)
gen DIwin=(ProfDIwin)-(ProfIDwin)
gen DJwin=(ProfDJwin)-(ProfJDwin)

gen EAwin=(ProfEAwin)-(ProfAEwin)
gen EBwin=(ProfEBwin)-(ProfBEwin)
gen ECwin=(ProfECwin)-(ProfCEwin)
gen EDwin=(ProfEDwin)-(ProfDEwin)
gen EFwin=(ProfEFwin)-(ProfFEwin)
gen EGwin=(ProfEGwin)-(ProfGEwin)
gen EHwin=(ProfEHwin)-(ProfHEwin)
gen EIwin=(ProfEIwin)-(ProfIEwin)
gen EJwin=(ProfEJwin)-(ProfJEwin)

gen FAwin=(ProfFAwin)-(ProfAFwin)
gen FBwin=(ProfFBwin)-(ProfBFwin)
gen FCwin=(ProfFCwin)-(ProfCFwin)
gen FDwin=(ProfFDwin)-(ProfDFwin)
gen FEwin=(ProfFEwin)-(ProfEFwin)
gen FGwin=(ProfFGwin)-(ProfGFwin)
gen FHwin=(ProfFHwin)-(ProfHFwin)
gen FIwin=(ProfFIwin)-(ProfIFwin)
gen FJwin=(ProfFJwin)-(ProfJFwin)

gen GAwin=(ProfGAwin)-(ProfAGwin)
gen GBwin=(ProfGBwin)-(ProfBGwin)
gen GCwin=(ProfGCwin)-(ProfCGwin)
gen GDwin=(ProfGDwin)-(ProfDGwin)
gen GEwin=(ProfGEwin)-(ProfEGwin)
gen GFwin=(ProfGFwin)-(ProfFGwin)
gen GHwin=(ProfGHwin)-(ProfHGwin)
gen GIwin=(ProfGIwin)-(ProfIGwin)
gen GJwin=(ProfGJwin)-(ProfJGwin)

gen HAwin=(ProfHAwin)-(ProfAHwin)
gen HBwin=(ProfHBwin)-(ProfBHwin)
gen HCwin=(ProfHCwin)-(ProfCHwin)
gen HDwin=(ProfHDwin)-(ProfDHwin)
gen HEwin=(ProfHEwin)-(ProfEHwin)
gen HFwin=(ProfHFwin)-(ProfFHwin)
gen HGwin=(ProfHGwin)-(ProfGHwin)
gen HIwin=(ProfHIwin)-(ProfIHwin)
gen HJwin=(ProfHJwin)-(ProfJHwin)

gen IAwin=(ProfIAwin)-(ProfAIwin)
gen IBwin=(ProfIBwin)-(ProfBIwin)
gen ICwin=(ProfICwin)-(ProfCIwin)
gen IDwin=(ProfIDwin)-(ProfDIwin)
gen IEwin=(ProfIEwin)-(ProfEIwin)
gen IFwin=(ProfIFwin)-(ProfFIwin)
gen IGwin=(ProfIGwin)-(ProfGIwin)
gen IHwin=(ProfIHwin)-(ProfHIwin)
gen IJwin=(ProfIJwin)-(ProfJIwin)

gen JAwin=(ProfJAwin)-(ProfAJwin)
gen JBwin=(ProfJBwin)-(ProfBJwin)
gen JCwin=(ProfJCwin)-(ProfCJwin)
gen JDwin=(ProfJDwin)-(ProfDJwin)
gen JEwin=(ProfJEwin)-(ProfEJwin)
gen JFwin=(ProfJFwin)-(ProfFJwin)
gen JGwin=(ProfJGwin)-(ProfGJwin)
gen JHwin=(ProfJHwin)-(ProfHJwin)
gen JIwin=(ProfJIwin)-(ProfIJwin)

tabstat A* B* C* D* E* F* G* H* I* J*, statistics(sum) col(stat)