ROI Excel Help

[boomboomjr]

Can anyone help me with a formula in excel that would compare "my line" versus the "vegas line" and then spit out what the roi would be? I.E. I have the line at -180 and Vegas has -120 so if betting $100 roi would be 17.86%.

Right now I go to a website and plug it in...just thought it would be easier to have available in same program where my handicapping is done. Thanks in advance.

[SunOfBeach]

Hi,

I'd convert the lines into probabilities of winning, which then makes the edge (ROI) calculation simple. To convert a line to a probability of winning, use P(win) = IF(B2<0,B2/(B2-100),100/B2), assuming the line from the book is in cell B2 (I have the labels in column A and the calcs in column B.). Then, do the same for your own line. The edge is then B6/B7-1.

Here's a cut/paste of how it looks in my sheet, using your numbers:

my line -180
book line -120
P(win) me 0.642857143
P(win) book 0.545454545
edge 0.178571429

If it's tricky or if my post just sux, send me a PM with your email address and I'd be happy to send you the sheet.

PC

[SunOfBeach]

Quick edit to typo above: the (if > 0) part of the P(win) calc should be

=IF(line<0,line/(line-100),100/(line+100)), where
"line" is the cell that you have your line in.

P