An introduction to research

**trevlyn1983** · 04-16-11, 06:23 PM

Could you post the VB code please ? For some reason his isnt showing up for me .

**hoyas2007** · 04-16-11, 06:25 PM

If you copy the button that is posted in this thread and then paste it in microsoft excel, the real code will show up. The button in the thread doesn't work for me either, but that's how I got around it

**uva3021** · 04-16-11, 11:36 PM

Originally posted by hoyas2007

If you copy the button that is posted in this thread and then paste it in microsoft excel, the real code will show up. The button in the thread doesn't work for me either, but that's how I got around it

nice

**demens** · 04-17-11, 04:01 PM

Originally posted by demens

Can you tell me what =per2line is?

........

**uva3021** · 04-18-11, 10:30 AM

Originally posted by demens

........

win probability converted to ML

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

**hoyas2007** · 04-18-11, 11:55 AM

UVA: Do you have any idea what "Runtime error 9: subscript out of range" might refer to? Is there anything else that I need to do in terms of defining the data in order to get this to work?
Thanks a lot

**demens** · 04-18-11, 12:01 PM

Originally posted by uva3021

win probability converted to ML

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

It would be easier is you had the code saved/copied somewhere.

What function did you use?
100/(1 – (1/WIN%) ) ??

Is it the same as PROB2US() from Ganchars stuff?

EDIT.

Well, its not since it has 2 parameters, uses VIG as well as win%.

**uva3021** · 04-18-11, 01:54 PM

Originally posted by demens

It would be easier is you had the code saved/copied somewhere.

What function did you use?
100/(1 – (1/WIN%) ) ??

Is it the same as PROB2US() from Ganchars stuff?

EDIT.

Well, its not since it has 2 parameters, uses VIG as well as win%.

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 his

**uva3021** · 04-18-11, 01:55 PM

Originally posted by hoyas2007

UVA: Do you have any idea what "Runtime error 9: subscript out of range" might refer to? Is there anything else that I need to do in terms of defining the data in order to get this to work?
Thanks a lot

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

**uva3021** · 04-18-11, 02:02 PM

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 messy

Primarily the playoff matchup sheet is useful, the drop down box at the top labeled "l_pyth, e_ptyh...." represent the different metrics used to assess the series prices

You can select whichever teams you wish in the drop down boxes, and switch conference 2-2-2-1 format to finals 2-3-2 format

All the values on that sheet are attached to formulas

Attached Files

NBA_Playoffs_Scenario_SIM.zip (180.8 KB, 569 views)

**demens** · 04-18-11, 10:12 PM

Originally posted by uva3021

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 messy

Primarily the playoff matchup sheet is useful, the drop down box at the top labeled "l_pyth, e_ptyh...." represent the different metrics used to assess the series prices

You can select whichever teams you wish in the drop down boxes, and switch conference 2-2-2-1 format to finals 2-3-2 format

All the values on that sheet are attached to formulas

Its just a bunch of error and name? for me man. I'm using oo calc, you gotta post some of those formulas man.

pythex function returns an NAME?
most of the other stuff in the TEAM sheet returns error:502. Total, line ,etc/

per2line function still not sure what thats is exactly.

Basically the sheet doesn't work for me because most of the cells have errors in them.

**uva3021** · 04-18-11, 10:37 PM

Originally posted by demens

Its just a bunch of error and name? for me man. I'm using oo calc, you gotta post some of those formulas man.

pythex function returns an NAME?
most of the other stuff in the TEAM sheet returns error:502. Total, line ,etc/

per2line function still not sure what thats is exactly.

Basically the sheet doesn't work for me because most of the cells have errors in them.

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

**Aman_Dage** · 05-02-11, 04:13 AM

Most people and me are too lazy to do any things of this, I don't worry about losing any edge

**Aman_Dage** · 05-04-11, 04:16 AM

Nice information. I wonder how many people put this much thought and energy into their decisions. More power to those who can come up with an edge and win money.

**vyomguy** · 07-19-11, 12:35 AM

i use shell script and awk for most of the scraping....quick and efficient

**Ingram$** · 08-09-11, 01:37 PM

**Ethan** · 08-19-11, 01:08 PM

**ballparkbabe** · 09-11-11, 07:36 PM

hmm neat

**Inspirited** · 09-27-11, 02:27 AM

I'm slowly moving along here. I've learned perl for data scraping and manipulation and am looking to use R for statistics. Right now I'm using csv files and guess I should look into learning how to use mysql or something.

**357vegas** · 10-31-11, 05:09 PM

Anyone use usatoday - Sagarin rating for power rating and SOS?

Would love if someone would show me how to put in an excel sheet automatically?

Thanks

**theclutch7** · 11-08-11, 09:03 AM

theclutch7

chicago won, philly has problems

**theclutch7** · 11-08-11, 09:03 AM

ha haa ha

**theclutch7** · 11-08-11, 09:04 AM

time to change the ny logo?

**Hank63** · 11-08-11, 04:30 PM

Very helpful!

**Hank63** · 11-08-11, 04:31 PM

Great thread

**Dan Kelly** · 12-29-11, 10:29 AM

Would anyone in here do me a favor and look at my NBA excel spreadsheet from last year - of course, I am always looking to make improvements and I would appreciate any ideas - your eyes might see something no one else does. I am trying to get as much info out of it as possible, It has all the quarters and no OT's (they are luck) and what I'd really like to do with it is make it work visually - I do have that started with some coloring. Spend 2 minutes on it and throw it away if you want to - not to be trite, but time is money. Any input is welcome. Send me a message and I will attach it to the return.
Thanks
p.s. the reason I am making this request is that I recently sent it to an SBR poster and got some terrific feedback.

**dooncan** · 01-11-12, 06:30 PM

Hi i'm trying to track down the mlb_ex_1.csv file. Does anyone know where I can get it from now or could PM it?

**jonohull** · 02-01-12, 02:36 PM

I was doing some scraping today and accidentally made Yahoo temporarily block my ISP (my college). Sorry everyone else at my school...

**Inspirited** · 02-13-12, 05:30 PM

Here's a great class at an introductory level.

http://www.ml-class.org/

**Salmon Steak** · 02-13-12, 11:43 PM

Originally posted by Inspirited

Here's a great class at an introductory level.

http://www.ml-class.org/

Thanks man, I will likely participate in this. How great that these courses look to be free. What a great opportunity.

**Sportsguy_USA** · 02-17-12, 08:42 PM

Hmmmm....I'll save myself some time and hire this out to my team in india for $2/hr to put together. Good post.

On that note..."Kelly Criterion", wouldn't you need a) what source you using to obtain all the data sets, and b) application of machine learning....beyond my pea size brain...so I revert back to my first point....outsource to my little army of indians. Go guys go.

**Sportsguy_USA** · 02-17-12, 08:43 PM

Oh - so no one get their panties in a knot - I employ a variety of guys from all over the world - india, philipines, china, easter europe for technical dev. work as this...and secondly...my indian guys...well, they are small, or little...or well....I'm just bigger than them.

**uva3021** · 02-22-12, 02:29 PM

Originally posted by Salmon Steak

Thanks man, I will likely participate in this. How great that these courses look to be free. What a great opportunity.

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 watching yale lectures or searching iTunes U. I signed up for 3 more classes that were suppose to have started by now but now Stanford is facing legal issues in making these courses available.

**sportsbetjunkie** · 02-26-12, 01:42 AM

This is an excellent guide. You could create an e-book out of this.

Keep up the good work.

**jonohull** · 03-01-12, 05:05 PM

I was trying to use Excel and VB macros to scrape my data, but I've been using Python the last week or so and it is so much faster and just as easy. It took less than 200 lines of code to make a program to scrape the box scores and individual stats for every game of the year in the NBA and save each day into its own csv file.