Moneyline formula?

Search

0

New member
Joined
Jun 25, 2007
Messages
52
Tokens
0
I'm trying to create an excel spreadsheet to store line information.

I'm beating my head against the wall here, because i'm trying to figure out a single formula to calculate moneyline takebacks given the vig price.

In most cases, as long as the line is below the vig amount, it's easy. For example 20 cents vig:

-130 (invert) = +130 + 20 = +150 (or -130 - 20, invert +150)

This doesn't work when you get closer to flat though.

-110 (invert) = +110 + 20 = +130

I've tried adding 100. That doesn't work.

-110 + 100 = -10 + 20 = +10 - 100 = -90

There has to be a single formula for this. I don't want to have to have two formulas depending on the value of the line.

Can anyone help? Thanks.
 

0

New member
Joined
Jun 25, 2007
Messages
52
Tokens
0
Er.. I got that backwards, same point though that should be -20

-130 (invert) = +130 - 20 = +110 (or -130 + 20, invert +110)

Likewise it doesn't work closer to flat

-110 (invert) = +110 - 20 = +90

Adding 100 doesn't work

-110 + 100 = -10 - 20 = -30 - 100 = -130
 

0

New member
Joined
Mar 17, 2009
Messages
5
Tokens
0
If a line is -110 with 20 cent vig, the other line would also be -110.. however, you will never find 20 cent vig on a -110 line.. it would be 10 cents at most.. that is why your calculations won't work.

so -110 +10 = +100 (the correct odds)
 

0

New member
Joined
Jun 25, 2007
Messages
52
Tokens
0
uhhh.. what?

there's 20 cent vig all the time. almost all books have 20 cent baseball lines these days, for instance.
 

0

New member
Joined
Jun 25, 2007
Messages
52
Tokens
0
And yes, I know it's supposed to be -110. I just can't figure out the formula to make it that way.

In the case of 10 cent juice.

-105 + 10 = -95 (invert) +95. It doesn't work. See my point?
 

0

New member
Joined
Jun 25, 2007
Messages
52
Tokens
0
Nope, lotta good 10 cent books out there. Betjam to name 1.

:drink:

There are some 10 cent books out there, but the vast majority are now 20 cent. BTW, BetJam is now 20 cents according to my line service. A lot of books that were 10 cents last year are 20 cents this year.
 

0

New member
Joined
Jun 25, 2007
Messages
52
Tokens
0
Well, upon further digging, it looks like most books are 20 cent pre-season, and will be 10 cent reg season.

But my question still stands. Anyone know a formula?
 

0

New member
Joined
Jun 25, 2007
Messages
52
Tokens
0
This is the best I have so far:

-110 + 20 = -90 (invert) = + 90
If the value is less than 100 then
100 + (100 - 90) = 110 (invert) -110

For 10 cent lines

-105 + 10 = -95 (invert) = +95
If the value is less than 100 then
100 + (100 - 95) = 105 (invert) -105

I don't like the two step process, makes it harder to do in Excel, but this works. Anyone know a one-step method?
 

Forum statistics

Threads
1,123,984
Messages
13,640,589
Members
101,749
Latest member
drew6423
The RX is the sports betting industry's leading information portal for bonuses, picks, and sportsbook reviews. Find the best deals offered by a sportsbook in your state and browse our free picks section.FacebookTwitterInstagramContact Usforum@therx.com
TheRX uses cookies to help us provide, protect & improve our services. See our Privacy Policy for more details.
Accept & Close