I want to create a program based on statistical information that is available at a specific website that lists all NCAA basketball teams (273) and gives the yearly schedule for each team (approximately 25-30 games, including opponent, date, pointspread, score, game site, and result (win or loss) against the spread. The information available will cover the years 1999-2007 and can be obtained from the website.
I want the program to tell me a team's record against the pointspread on a given date (giving the team's pointspread record at home if playing at home-visitor pointspread if visitor) and the opponent's pointspread (home or visitor) on that date along with the result (win or loss) against the pointspread. If possible, I would like to input a given pointspread record (home or visitor) against a given pointspread record for the opponent (home or visitor) and determine the results (win and loss) for all games a given year. In addition I would like to input a given pointspread (e.g.+3 home)and determine the results including the teams, dates, which team won against that pointspread, and the teams involved and their pointspread record (home record for home team and visitor record for visiting team)on the date each game was played.