arb formula?

[34TheTruth34]

Could somebody repost the formula (or link) for calcuating arbs if you want to make the same profit no matter who wins?

I have the following written down, but think it's wrong:

for each $100 bet on the dog, bet

(dogline + 100)*favline/(favline-100)

on the favorite.

couldn't find it in the search function. thanks.

[wageringblog]

I'll copy/paste from my Excel sheet since I don't think I can upload an attachment. The formatting is a little screwy, but esentially the columns are A-E (Team, Odds, Wager, If Win, and PNL), with rows 1-3 (headings, and the two teams)...

A B C D E
1 Team Odds Wager If Win PNL
2 Ari 114 100.00 114.00 1.90
3 Phi -110 112.10 101.90 1.90

If you fill in your wager amount on Arizona, for example, in cell C2, then the formula in C3 for the corresponding bet on the opposite side is:

((((B2*C2)/100)+C2)/(1+(100/-B3)))

So, in this case, $100 on Arizona +114 and $112.10 on Philly -110 will net you $1.90 in profit, guaranteed.

Columns D and E are simply formulas calculating the winnings on each side and the net winnings after taking into account the loss on the other side, just as a check to make sure the P&L is the same for both sides.

I'm sure I made that way more confusing that it has to be, though...

[wageringblog]

[ QUOTE ]
I'll copy/paste from my Excel sheet since I don't think I can upload an attachment. The formatting is a little screwy, but esentially the columns are A-E (Team, Odds, Wager, If Win, and PNL), with rows 1-3 (headings, and the two teams)...

A B C D E
1 Team Odds Wager If Win PNL
2 Ari 114 100.00 114.00 1.90
3 Phi -110 112.10 101.90 1.90

If you fill in your wager amount on Arizona, for example, in cell C2, then the formula in C3 for the corresponding bet on the opposite side is:

((((B2*C2)/100)+C2)/(1+(100/-B3)))

So, in this case, $100 on Arizona +114 and $112.10 on Philly -110 will net you $1.90 in profit, guaranteed.

Columns D and E are simply formulas calculating the winnings on each side and the net winnings after taking into account the loss on the other side, just as a check to make sure the P&L is the same for both sides.

I'm sure I made that way more confusing that it has to be, though...

[/ QUOTE ]

Note that the 100 in the formula is not related to the $100 bet - the 100 in the formula is a constant.

[34TheTruth34]

[ QUOTE ]
I'm sure I made that way more confusing that it has to be, though...


[/ QUOTE ]

no, not at all. thanks, that's exactly what I was looking for.

I wish you had included the other 4 formulas, but since you didn't I guess I can compute them myself /images/graemlins/tongue.gif

[wageringblog]

here ya go:

formula in D2 ("Ari If Win") = IF(B2>0,C2*B2/100,C2/-B2*100)
formula in E2 ("Ari PNL") = D2-C3
formula in D3 ("Phi If Win") = IF(B3>0,C3*B3/100,C3/-B3*100)
formula in E3 ("Phi PNL") = D3-C2

again these formulas don't change - the 100's have nothing to do with the bet amount.

[34TheTruth34]

[ QUOTE ]
here ya go:

formula in D2 ("Ari If Win") = IF(B2>0,C2*B2/100,C2/-B2*100)
formula in E2 ("Ari PNL") = D2-C3
formula in D3 ("Phi If Win") = IF(B3>0,C3*B3/100,C3/-B3*100)
formula in E3 ("Phi PNL") = D3-C2

again these formulas don't change - the 100's have nothing to do with the bet amount.

[/ QUOTE ]

I did them myself before I checked back and came up with:

d2= (b2*c2)/100
d3= ABS((c3*100)/(b3))
e2= d2-c3
e3= d3-c2

this would work too, right?

[Recliner]

Here is an excel file based on the formulas in this thread that will calculate what you need to bet for a perfect scalp. It will calculate the bet based on an amount bet on a dog or favorite so if one book has a max or you only have so much money at one book you can do it with ease.

Download from here! (http://www.decipherwealth.com/calculator.xls)