Moneyline formula?

[mystere]

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.

 

[mystere]

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

 

[Sharp.Vegas.Picks]

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)

 

[mystere]

uhhh.. what?

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

 

[downtown2222]

uhhh.. what?

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

Nope, lotta good 10 cent books out there. Betjam to name 1.

:drink:

 

[mystere]

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?

 

[mystere]

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.

 

[mystere]

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?

 

[mystere]

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?