I do some betting on NFL and CFB ats with some friends. I am trying to set up a pretty basic excel file that will automatically pull the current scores for both NFL and CFB games. I want to then show if each person is winning the game for their side of the bet ats. I also want to have a + or - for each game. Lets say the spread has Team A as -3 and you take that team. Team A wins by 10 so I want to show a win for that team as well as a + 7 for winning ats by 7. Any help on doing this? I was trying to use the Data - From Web but can't make it do all of the functions. I just need something that can automatically pull the info from the web and show at any time whether people are winning their bet and what their + or - points would be.

I was thinking these would be the columns I would need but I really don't know enough about Excel formulas to make this work.

Home Team, Away Team, Spread, Team picked to win, Home Team Score, Away Team Score, Win or Loss, "+ or - points"

Thanks!