Go Back   Sports Handicapping Forum > Welcome Forums > Main Street > Capping

Capping All handicapping, betting systems, spreadsheets, mathematics & quantitative technicapping.

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-10-2011, 05:26 PM
Registered User
 
Join Date: Jul 2010
Posts: 7
Rewards: 77
Spread to Moneyline for the NFL or NBA?

Does anyone have any REAL averages? It would be so helpful for me personally (and many other people I am sure).

Spread ML Converter

This calculator seems to be pretty spot on at low spread numbers, but become pretty inaccurate by just around -7 or so.
Reply With Quote
  #2  
Old 01-10-2011, 07:26 PM
Hall of Fame
 
Join Date: Oct 2005
Location: Salem, VA
Posts: 22,450
Rewards: 1,800
could just do a regression for a full slate of games one day, regressing ML onto spread and total, to come up with the formula

sample size would be immaterial in that case because I doubt the bookies would drastically change their ML formula from one day to another, just make sure you grab a sufficient range of prices (double digit favs, mid to high favs, low favs, etc...)

A typical NBA saturday should do the trick

or when in doubt use Pythagorean (though keep in mind one game pythagorean calculations are not conditions the formula assumes, rather its a season expectation of winning percentage)


Total / 2 - Line/2 = Points scored/against

Points scored ^ a / (Points scored ^ a + Points against ^ a)

NFL a = 2.37
NBA a = 14

Total / 2 - Line / 2
__________________
"Nobody goes there anymore, its too crowded." --Yogi Berra

"Always tell the truth, that way you won't have to remember what you said." --Mark Twain


*=$50,000
Reply With Quote
  #3  
Old 01-10-2011, 08:15 PM
Registered User
 
Join Date: Jul 2010
Posts: 7
Rewards: 77
I only half understand what you mean with the pythagorean stuff (which team's points scored? where do you determine a line, just halfway?), but I have no idea how to do a regression. Lines also do vary a lot, especially in the NFL at lower levels. That is why I would like real averages if anyone knows a place to find them. Thanks for the response though.
Reply With Quote
  #4  
Old 01-10-2011, 11:34 PM
Hall of Fame
 
Join Date: Oct 2005
Location: Salem, VA
Posts: 22,450
Rewards: 1,800
Quote:
Originally Posted by Poli View Post
I only half understand what you mean with the pythagorean stuff (which team's points scored? where do you determine a line, just halfway?), but I have no idea how to do a regression. Lines also do vary a lot, especially in the NFL at lower levels. That is why I would like real averages if anyone knows a place to find them. Thanks for the response though.
well yeah what I'm saying is find a day with range of similar prices and highly variable prices

a line of -3 with a total of 45 for game A will have basically the same ML as game b with the same parameters. There will be a central tendency with movement contingent on money.

I figured the line was implied since you are looking for a spread to ML converter. For example:

Total 40
Line -3

Points scored = 40/2 - (-3)/2 = 21.5
Points against = 40/2 - (+3)/2 = 18.5

Exponent = 2.37

21.5^2.37/(21.5^2.37 + 18.5^2.37) = 58.81% = -143

ML = -143

But like I said before Pythagorean is a measure of aggregate win expectation, not typically used for one game scenario. So my suggestion was to gather an adequate sample size, plug the Total and Line parameters into the Pythagorean formula, and find the exponent that best fits the actual respective MLs. Then for future single game calculations you have your exponent
__________________
"Nobody goes there anymore, its too crowded." --Yogi Berra

"Always tell the truth, that way you won't have to remember what you said." --Mark Twain


*=$50,000
Reply With Quote
  #5  
Old 01-11-2011, 01:43 AM
Registered User
 
Join Date: Oct 2010
Posts: 39
Rewards: 190
I ran a regression for NFL that shows

-35.7 + 51.86*point spread = $ line

R^2 = .92
very low p value
standard error 104

it puts one in the ball park

home field appears to be a factor that is not included in the above

good luck
Reply With Quote
  #6  
Old 01-11-2011, 02:36 PM
Hall of Fame
 
Join Date: Oct 2005
Location: Salem, VA
Posts: 22,450
Rewards: 1,800
thanks jarhead, did you not include total in the regression?
__________________
"Nobody goes there anymore, its too crowded." --Yogi Berra

"Always tell the truth, that way you won't have to remember what you said." --Mark Twain


*=$50,000
Reply With Quote
  #7  
Old 01-11-2011, 06:22 PM
Registered User
 
Join Date: Jul 2010
Posts: 7
Rewards: 77
uva, thanks for the further explanation, I get it now. You are saying that I should solve for the exponent myself, do you mean for each spread number or is the goal still to get one catch all exponent?

Quote:
Originally Posted by jarhead60 View Post
I ran a regression for NFL that shows

-35.7 + 51.86*point spread = $ line

R^2 = .92
very low p value
standard error 104

it puts one in the ball park

home field appears to be a factor that is not included in the above

good luck
Pretty far off at low numbers, but pretty accurate at higher levels. Home field is already kind of factored into spread numbers, so not really an issue right?

Anyway, thanks you guys, this helps. I still wish I could get real numbers though, I just wanted something that could be used to correlate to real money values since sportsdatabase only tracks $$ numbers on the MLB moneyline. I saw in another topic here where someone just pasted the bodog supposed line stuff, but those are really vague/bad lines (not that the user was not trying their best).
Reply With Quote
  #8  
Old 01-11-2011, 07:44 PM
Hall of Fame
 
Join Date: Oct 2005
Location: Salem, VA
Posts: 22,450
Rewards: 1,800
one exponent for all lines using the pythagorean formula

I highly suggest using a regression though, find as many years of spread and totals in the NFL/NBA as you can and run a regression using Stata or Excel
__________________
"Nobody goes there anymore, its too crowded." --Yogi Berra

"Always tell the truth, that way you won't have to remember what you said." --Mark Twain


*=$50,000
Reply With Quote
  #9  
Old 01-12-2011, 01:20 PM
Registered User
 
Join Date: Jul 2010
Posts: 7
Rewards: 77
Right but if I had data, then I could just sum up moneylines for myself assuming those were included...I do not really understand excel well enough to do anything like your getting data from statfox.
Reply With Quote
  #10  
Old 01-13-2011, 09:19 PM
Registered User
 
Join Date: Oct 2010
Posts: 39
Rewards: 190
poli,

free data can be found at this site

FootballLOCKS.com: NFL picks, weekly pro football lines, odds & point spreads. Expert NFL betting predictions.
Reply With Quote
  #11  
Old 01-22-2011, 09:30 PM
Registered User
 
Join Date: Jul 2010
Posts: 7
Rewards: 77
Sorry to "bump", but I forgot to look at this thread until recently. Thanks a lot jarhead60, I will do something with all that when I have the time (NFL season is already over after all :P)
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 05:58 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.