I need to web scrap the website [login to view URL], both the off shore and vegas odds for all sports.
All the initial values then needs to be put into a database table as "opening lines" and kept. The same script then needs to read the website every 15 minutes or so and then put updated information into the same table as "current lines" and put any numbers that have "changed" data into another table, with opening value, last value, new value, sport type, type of line (over/under vs total point vs points by team) to be emailed later by a different script (not included in this project). Even though these tables wont be getting big, I need the values to be numbers whenever possible, with lookup tables when needed (ie Sport type, Over/under).