Wins + Losses for Sports Teams at Different Points

[alex58392]

Hi all,
First time posting and looking for some help regarding a set of sports statistics. I am looking to analyze the effect of home court advantage in the 2018-2019 season and wanted to be able to control for how many wins each team has at a certain time in the season. I currently have a set of 1230 games. Each row has the score of the game for the away team and the home team along with neighboring columns stating the identity of the home team and the away team. I was wondering if it is possible to create a formula that can analyze the scores of each game and which team they correspond to so as to calculate a sort of "running wins and losses total" that borders each game played. For example, if the Golden State Warriors have played 6 games and won 5 of them, I would like the row indicating their seventh game to have 5 wins next to it so I can attempt to control for individual team performance (a better team wins more games) in regressing for home court advantage. Thank you in advance for any help, please let me know if you have any questions. Thanks!

 

[AlanY]

please you post a small sample and desired output of the data here

 

[alex58392]

[TABLE="width: 1365"]
<colgroup><col width="65" span="21" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="width: 65"][/TD]
[TD="width: 65"]ROAD TEAM[/TD]
[TD="width: 65"]HOME TEAM[/TD]
[TD="width: 65"]Away Points Scored[/TD]
[TD="width: 65"]Home Points Scored[/TD]
[TD="width: 65"]Difference[/TD]
[TD="width: 65"]Away Days Rest[/TD]
[TD="width: 65"]Home Days Rest[/TD]
[TD="width: 65"]Attend.[/TD]
[TD="width: 65"]Away 3IN4-B2B[/TD]
[TD="width: 65"]Away B2B[/TD]
[TD="width: 65"]Away 3IN4[/TD]
[TD="width: 65"]Away 1[/TD]
[TD="width: 65"]Away 2[/TD]
[TD="width: 65"]Away 3More[/TD]
[TD="width: 65"]Home 3IN4-B2B[/TD]
[TD="width: 65"]Home B2B[/TD]
[TD="width: 65"]Home 3IN4[/TD]
[TD="width: 65"]Home 1[/TD]
[TD="width: 65"]Home 2[/TD]
[TD="width: 65"]Home 3More[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/16/18[/TD]
[TD]Philadelphia 76ers[/TD]
[TD]Boston Celtics[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]18[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]18624[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/16/18[/TD]
[TD]Oklahoma City Thunder[/TD]
[TD]Golden State Warriors[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"]8[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]19596[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Milwaukee Bucks[/TD]
[TD]Charlotte Hornets[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]-1[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]17889[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Brooklyn Nets[/TD]
[TD]Detroit Pistons[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]103[/TD]
[TD="align: right"]3[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]20332[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]New Orleans Pelicans[/TD]
[TD]Houston Rockets[/TD]
[TD="align: right"]131[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]-19[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]18055[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Memphis Grizzlies[/TD]
[TD]Indiana Pacers[/TD]
[TD="align: right"]83[/TD]
[TD="align: right"]111[/TD]
[TD="align: right"]28[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]17923[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Denver Nuggets[/TD]
[TD]Los Angeles Clippers[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]98[/TD]
[TD="align: right"]-9[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]19068[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Atlanta Hawks[/TD]
[TD]New York Knicks[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]126[/TD]
[TD="align: right"]19[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]18249[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Miami Heat[/TD]
[TD]Orlando Magic[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]3[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]19191[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Dallas Mavericks[/TD]
[TD]Phoenix Suns[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]121[/TD]
[TD="align: right"]21[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]18055[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Utah Jazz[/TD]
[TD]Sacramento Kings[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]117[/TD]
[TD="align: right"]-6[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]17583[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Minnesota Timberwolves[/TD]
[TD]San Antonio Spurs[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]4[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]18354[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/17/18[/TD]
[TD]Cleveland Cavaliers[/TD]
[TD]Toronto Raptors[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]116[/TD]
[TD="align: right"]12[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]19915[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/18/18[/TD]
[TD]Chicago Bulls[/TD]
[TD]Philadelphia 76ers[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"]127[/TD]
[TD="align: right"]19[/TD]
[TD]3More[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]20302[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/18/18[/TD]
[TD]Los Angeles Lakers[/TD]
[TD]Portland Trail Blazers[/TD]
[TD="align: right"]119[/TD]
[TD="align: right"]128[/TD]
[TD="align: right"]9[/TD]
[TD]3More[/TD]
[TD]3More[/TD]
[TD="align: right"]19996[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/18/18[/TD]
[TD]Miami Heat[/TD]
[TD]Washington Wizards[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]-1[/TD]
[TD]B2B[/TD]
[TD]3More[/TD]
[TD="align: right"]20409[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/19/18[/TD]
[TD]New York Knicks[/TD]
[TD]Brooklyn Nets[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]17732[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/19/18[/TD]
[TD]Oklahoma City Thunder[/TD]
[TD]Los Angeles Clippers[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]14816[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/19/18[/TD]
[TD]Atlanta Hawks[/TD]
[TD]Memphis Grizzlies[/TD]
[TD="align: right"]117[/TD]
[TD="align: right"]131[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]17019[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/19/18[/TD]
[TD]Indiana Pacers[/TD]
[TD]Milwaukee Bucks[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]118[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]17341[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/19/18[/TD]
[TD]Cleveland Cavaliers[/TD]
[TD]Minnesota Timberwolves[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]131[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]18978[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/19/18[/TD]
[TD]Sacramento Kings[/TD]
[TD]New Orleans Pelicans[/TD]
[TD="align: right"]129[/TD]
[TD="align: right"]149[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]18337[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/19/18[/TD]
[TD]Charlotte Hornets[/TD]
[TD]Orlando Magic[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]-32[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]17668[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/19/18[/TD]
[TD]Boston Celtics[/TD]
[TD]Toronto Raptors[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]19800[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/19/18[/TD]
[TD]Golden State Warriors[/TD]
[TD]Utah Jazz[/TD]
[TD="align: right"]124[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]-1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]18306[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]Detroit Pistons[/TD]
[TD]Chicago Bulls[/TD]
[TD="align: right"]118[/TD]
[TD="align: right"]116[/TD]
[TD="align: right"]-2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]21289[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]Minnesota Timberwolves[/TD]
[TD]Dallas Mavericks[/TD]
[TD="align: right"]136[/TD]
[TD="align: right"]140[/TD]
[TD="align: right"]4[/TD]
[TD]3IN4-B2B[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]20205[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]Phoenix Suns[/TD]
[TD]Denver Nuggets[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"]119[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]19592[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]Brooklyn Nets[/TD]
[TD]Indiana Pacers[/TD]
[TD="align: right"]103[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"]29[/TD]
[TD]3IN4-B2B[/TD]
[TD]3IN4-B2B[/TD]
[TD="align: right"]17007[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]Houston Rockets[/TD]
[TD]Los Angeles Lakers[/TD]
[TD="align: right"]124[/TD]
[TD="align: right"]115[/TD]
[TD="align: right"]-9[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]18997[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]Charlotte Hornets[/TD]
[TD]Miami Heat[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]-1[/TD]
[TD]3IN4-B2B[/TD]
[TD]3IN4[/TD]
[TD="align: right"]19600[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]Boston Celtics[/TD]
[TD]New York Knicks[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]-11[/TD]
[TD]B2B[/TD]
[TD]3IN4-B2B[/TD]
[TD="align: right"]19427[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]Orlando Magic[/TD]
[TD]Philadelphia 76ers[/TD]
[TD="align: right"]115[/TD]
[TD="align: right"]116[/TD]
[TD="align: right"]1[/TD]
[TD]3IN4-B2B[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]20300[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]San Antonio Spurs[/TD]
[TD]Portland Trail Blazers[/TD]
[TD="align: right"]108[/TD]
[TD="align: right"]121[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]19461[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/20/18[/TD]
[TD]Toronto Raptors[/TD]
[TD]Washington Wizards[/TD]
[TD="align: right"]117[/TD]
[TD="align: right"]113[/TD]
[TD="align: right"]-4[/TD]
[TD]3IN4-B2B[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]16185[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/21/18[/TD]
[TD]Atlanta Hawks[/TD]
[TD]Cleveland Cavaliers[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]111[/TD]
[TD="align: right"]-22[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]19432[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/21/18[/TD]
[TD]Golden State Warriors[/TD]
[TD]Denver Nuggets[/TD]
[TD="align: right"]98[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD]B2B[/TD]
[TD="align: right"]19520[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/21/18[/TD]
[TD]Houston Rockets[/TD]
[TD]Los Angeles Clippers[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"]115[/TD]
[TD="align: right"]3[/TD]
[TD]B2B[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]16149[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]10/21/18[/TD]
[TD]Sacramento Kings[/TD]
[TD]Oklahoma City Thunder[/TD]
[TD="align: right"]131[/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]-11[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]18203[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

Here is a subset of the data, I would like to create two new columns, one containing the number of cumulative wins for the specific home team playing and another for the away team. If it is easier, I can reorient the data so that it is in alphabetical order by data (to group the same home and away teams together). Please let me know if this is better.

 

[AlanY]

have a look if this is what you're after

Book1
	A	B	C	D	E	F	V	W
1	ROAD TEAM	HOME TEAM	Away Points Scored	Home Points Scored	Difference	Away Days Rest	HOME wins	AWAY wins
2	10/16/18	Philadelphia 76ers	Boston Celtics	87	105	18	0	1
3	10/16/18	Oklahoma City Thunder	Golden State Warriors	100	108	8	0	1
4	10/17/18	Milwaukee Bucks	Charlotte Hornets	113	112	-1	1	0
5	10/17/18	Brooklyn Nets	Detroit Pistons	100	103	3	0	1
6	10/17/18	New Orleans Pelicans	Houston Rockets	131	112	-19	1	0
7	10/17/18	Memphis Grizzlies	Indiana Pacers	83	111	28	0	1
8	10/17/18	Denver Nuggets	Los Angeles Clippers	107	98	-9	1	0
9	10/17/18	Atlanta Hawks	New York Knicks	107	126	19	0	1
10	10/17/18	Miami Heat	Orlando Magic	101	104	3	0	1
11	10/17/18	Dallas Mavericks	Phoenix Suns	100	121	21	0	1
12	10/17/18	Utah Jazz	Sacramento Kings	123	117	-6	1	0
13	10/17/18	Minnesota Timberwolves	San Antonio Spurs	108	112	4	0	1
14	10/17/18	Cleveland Cavaliers	Toronto Raptors	104	116	12	0	1
15	10/18/18	Chicago Bulls	Philadelphia 76ers	108	127	19	0	1
16	10/18/18	Los Angeles Lakers	Portland Trail Blazers	119	128	9	0	1
17	10/18/18	Miami Heat	Washington Wizards	113	112	-1	1	0
18	10/19/18	New York Knicks	Brooklyn Nets	105	107	2	0	1
19	10/19/18	Oklahoma City Thunder	Los Angeles Clippers	92	108	16	0	1
20	10/19/18	Atlanta Hawks	Memphis Grizzlies	117	131	14	0	1
21	10/19/18	Indiana Pacers	Milwaukee Bucks	101	118	17	0	1
22	10/19/18	Cleveland Cavaliers	Minnesota Timberwolves	123	131	8	0	1
23	10/19/18	Sacramento Kings	New Orleans Pelicans	129	149	20	0	1
24	10/19/18	Charlotte Hornets	Orlando Magic	120	88	-32	1	1
25	10/19/18	Boston Celtics	Toronto Raptors	101	113	12	0	2
26	10/19/18	Golden State Warriors	Utah Jazz	124	123	-1	1	0
27	10/20/18	Detroit Pistons	Chicago Bulls	118	116	-2	1	0
28	10/20/18	Minnesota Timberwolves	Dallas Mavericks	136	140	4	0	1
29	10/20/18	Phoenix Suns	Denver Nuggets	91	119	28	0	1
30	10/20/18	Brooklyn Nets	Indiana Pacers	103	132	29	0	2
31	10/20/18	Houston Rockets	Los Angeles Lakers	124	115	-9	1	0
32	10/20/18	Charlotte Hornets	Miami Heat	113	112	-1	2	0
33	10/20/18	Boston Celtics	New York Knicks	112	101	-11	1	1
34	10/20/18	Orlando Magic	Philadelphia 76ers	115	116	1	0	2
35	10/20/18	San Antonio Spurs	Portland Trail Blazers	108	121	13	0	2
36	10/20/18	Toronto Raptors	Washington Wizards	117	113	-4	1	0
37	10/21/18	Atlanta Hawks	Cleveland Cavaliers	133	111	-22	1	0
38	10/21/18	Golden State Warriors	Denver Nuggets	98	100	2	1	2
39	10/21/18	Houston Rockets	Los Angeles Clippers	112	115	3	1	2
40	10/21/18	Sacramento Kings	Oklahoma City Thunder	131	120	-11	1	0
Sheet2

Cell Formulas
Range	Formula
V2	=SUMPRODUCT(--($B$2:B2=B2),--($F$2:F2<0))
W2	=SUMPRODUCT(--($C$2:C2=C2),--($F$2:F2>0))