Search:

You might have 2.7, if you have neither just download python 2.6

I took the ai-class course last year and I enjoyed it. Received a certificate of accomplishment sealed and signed by the professors who administered the course. The concept goes far beyond just...

it doesn't work in OO calc, which doesn't support microsoft VBA routines, has to be excel

Here is the new playoff matchups excel file

You can ignore the simulator sheet (except for the predicted lines), its just for fun, and its an older simulator, i think my first one, so its very...

typically get an error if you entered the wrong parameters (i.e. W% > 1 or < 0), though it could be on my end

you can just ignore the VIG option, and enter the win probability as a percentage

I've since updated that one, but Ganchrow's below is far more versatile and flexible then mine, so i suggest using...

win probability converted to ML

you can change the naming conventions of the UDFs to avoid confusion, i don't mind

nice :an_clap:

yeah that was last year's playoff sheet, i haev to make a new one sigh, playoffs about to start

linear EFF% was the best fit winning percentage for the team compared to the entire league given...

That was one of my better efforts. As far as I know I'm the only person in history to develop a line given the NFL future win total, using the Inverse Pythagorean Formula.

:an_dance:

Do you extract through XML? XML is more robust than HTML procedures that are contingent on the format of the website and server issues.

AN NBA one would be no problem, would just have to change PInnacle XML parameters

If the NBA data was an invasive data extraction from statfox then it probably was my site.

Been slacking on my python progamming, but created an excel sheet that grab's mlb lines from Pinnacle everyday at 11 AM, and exports to a database

Everything is automated and runs on a scheduler. ...

the site for that sports (mlb.com, nba.com...

i abuse statfox and have yet to be banned

that's because "sht" doesn't exist as a sheet. There is something wrong with your naming conventions

I.E. this is how my range, "NFLTeams" is structured

Arizona2009
Atlanta2009
.......

did you define this range?


For i = 1 To Range("NFLteams").Rows.Count

click debug and tell me what line it highlights

stick a comment,', before the "On Error Resume Next" sequence, then post the error message, if any

it could be merely statfox being offline, or a bad internet connection

There certainly are ways to isolate the table you want without trial and error, I suggest to google the DOM method of website data extraction, which essentially allows you to look for text inside the...

For each sport you should record a macro importing the data then run a loop around it. To help you out though here is the table extracting code for Statfox NCAAB

...
Sheets(sht).Select
With...

Here is the excel macro VB code to get NFL data from Statfox


'
' Get NFL Date from Statfox -- Enter specified years in the appropriate variable definitions
'

'
On Error Resume Next...

python is very nice, but the scraping power of excel is vastly underrated

with just some fundamental understanding of vb, you can scrape years and years worth of data and display it in a nice...

great thread, looking forward to continue reading