[curious]

Ganch,
I use the log5 formula to calculate win probability for NCAAB. This formula is very accurate at predicting straight up winner/loser.

I want to convert the probability to a moneyline and spread.

I'm not sure how to do that. Any suggestions?

Here is a game to use as an example.

For today, Tuesday, Dec 9 I for the San Fransisco / Pacific game I have a win probability for San Fransicso of 68.35%
and for Pacific the win probability is 31.65%.

How would I convert these into moneyline and spread?

[donjuan]

Spread depends on the total. Moneyline should be obvious.

[dcbt]

ML would be +/- 216

If SF 68.35% is in cell A1, here's you ML calc in B1: IF(A1>0.5,-(A1/(1-A1))*100,-(-((1-A1)/(A1))*100))

Or, similarly, If Pacific 31.65% is in A2, here's your ML calc in B2: IF(A2>0.5,-(A2/(1-A2))*100,-(-((1-A2)/(A2))*100))

[Arilou]

curious, I would simply go through a series of games on a Saturday or a few other days and look at the ML, spread and total for each game. That should give you enough examples to get a guide to translate MLs into spreads, or vice versa.

[smitch124]

There is also a spread to ML converter in the betting tools section of MySBR

[curious]

Thanks everyone.

[Ganchrow]

You've gotten some fine advice here.

For converting win probabilities to MLs check out the Odds Converter. You can also use the PROB2US() Excel function from my Simple VBA Sports Betting Functions Template for Excel.

As far as the spread to ML converter I can tell you as it's author I'd put little if any stock in its conclusions for all but the smallest of spreads. I'll also point that it completely ignores the impact of totals.

[raiders72002]

You've gotten some fine advice here.

For converting win probabilities to MLs check out the Odds Converter. You can also use the PROB2US() Excel function from my Simple VBA Sports Betting Functions Template for Excel.

As far as the spread to ML converter I can tell you as it's author I'd put little if any stock in its conclusions for all but the smallest of spreads. I'll also point that it completely ignores the impact of totals.

It's still a great tool and can be used by all. I check it out all the time for comparisons.

[shearer]

How we can use log5 formula in soccer?

[Dfjay9]

Curious, do you think you could post a copy of your spreadsheet?

[curious]

Curious, do you think you could post a copy of your spreadsheet?

Let me figure out how I can put it on my mySBR page. I didn't forget you I am just VERY busy.

[Astig5150]

Even DistributionA50.00%Probability of Home Team WinningB58.22%True Average Margin of VictoryC2.43722

Is this confirm? Please let me know. Thanks.

[uva3021]

I made a PHP US Odds Convertor

its buggy but works, i'll clean it up later

[cptbigsack]

You've gotten some fine advice here.

For converting win probabilities to MLs check out the Odds Converter. You can also use the PROB2US() Excel function from my Simple VBA Sports Betting Functions Template for Excel.

As far as the spread to ML converter I can tell you as it's author I'd put little if any stock in its conclusions for all but the smallest of spreads. I'll also point that it completely ignores the impact of totals.

I noticed you have some excel functions but was wondering if you had the spread moneyline converter for CBB in excel? I am trying to test a formula and my game results have the spread and my formula produces probability. If I had an excel function to convert it would really help. I want to test it against 8 years of data so manually isn't really an option. Any help is appreciated.

Thanks,
Dan

[ManBearPig]

As far as I've seen there isn't a clear cut way to achieve this, but I've used this for this type of thing. It may not give you exactly what you want, but it's all I've come across as I've seen no direct formula. I suppose that if one had all ML and spreads for x games they could attempt to create their own by looking at frequencies and relating them that way.

Point Spread Money Line

-2 -130/+110
-2.5 -140/+120
-3 -155/+135
-3.5 -175/+155
-4 -200/+170
-4.5 -220/+180
-5/-5.5 -240/+190
-6 -270/+210
-6.5 -300/+220
-7 -330/+250
-7.5/-8/-8.5 -360/+280
-9/-9.5 -400/+300
-10 -450/+325

[subs]

curious, I would simply go through a series of games on a Saturday or a few other days and look at the ML, spread and total for each game. That should give you enough examples to get a guide to translate MLs into spreads, or vice versa.

...