thanks for your help so far. let me clarify some things
Quote:
Originally Posted by gaming_mouse
don't do it like that. i don't know what the term "rotation" means,
rotation number is basically the unique id of the team for that day. so there will be 501, 502, 503, 504, etc. usually team 501 will be vs 502. if you check out this site, you will see what i mean:
http://www.pinnaclesports.com/League...A/1/Lines.aspx
so in my example, 509 vs 510 is spurs vs nets. i didnt know if i should put in the full game as one row in the db or each individual team.
Quote:
Originally Posted by gaming_mouse
then a third table called "lines" ...
so 3 tables, one of which will hold most of your info and grow large. if space becomes an issue, you can write a script to archive or delete old rows, as it sounds like you only need them to find good bets? what does "chases steam" mean?
Quote:
Originally Posted by Gullanian
Then extend your Odds table with BookieID
i'm not sure if this is the best way. "chase steam" means find websites (books) which have 'off' odds. so if the whole market has -9.5, and one book has -10, then thats an opportunity (albeit small)
but the whole market moves as a whole. so i was gonna input a new row into the db each time i scrape a new line. so in my example above, you can see that at pinnacle, the line moved at 1pm a half point, so i entered a new row. likewise at 3pm at 5dimes website, their line moved as well.
so if i put all this info in the "lines" (or gullianian's "Odds") table, then i dont know how i would be able to compare the lines at the books programmatically. so in my example, 5dimes was slow to move compared to pinnacle. so i could write a program to compare the last row of pinnacle (1pm, -10) and the last row at 5dimes (3pm, -9.5) and see the discrepancy, and send myself an alert somehow. if the "lines" table is just constantly adding rows to the bottom, i guess i could still compare the latest, id just have to learn the sql query to get the last pinnancle row and the last 5dimes row
actually if you check out this site:
http://www.sbrforum.com/betting-odds/
click on any of the odds and you will see the history, this is what i mean that the odds are constnatly changing throughout the day, so i want to be able to programmatically find the differences instead of sitting and staring at that site all day
Last edited by greg nice; 02-11-2012 at 03:02 PM.