risk/to win conversion formula

[bbyhill]

know this is beginner stuff however would like to have it if possible

What is the formula for price (-110 or whatever) to risk to win USD?

for a spread sheet and it can be any - # so it would auto calculate

[element1286]

Favorite:

moneyline = -150
amount risked = 200

(200/150)*100=133.33

Underdog:

moneyline = +350
amount risked = 150

150*(350/100) = 525

[bbyhill]

Thanks Mike and Element

[Ganchrow]

Since you're now using my VBA Sports Betting Functions Template for Excel:

Assuming the US odds were in cell A1 and the risk quantity were in cell A2, then you could use this equation to calculate the to win quantity:

=A2*(us2dec(A1)-1)

Assuming the US odds were in cell A1 and the to win quantity were in cell A3, then you could use this equation to calculate the risk quantity:

=A3/(us2dec(A1)-1)

[bbyhill]

Thanks Ganch that is what I was looking for.

[bbyhill]

have it set line=A1 price=b1 risk =h2 What would the formula look like now Gaunch?

[Ganchrow]

have it set line=A1 price=b1 risk =h2 What would the formula look like now Gaunch?

I'm not quite sure I understand what you're asking as the line is obviosuly immaterial when calculating the to win amount.

So your to win would would be exactly as before except you'd substitute B1 for A1 and H2 for A2:

=H2*(us2dec(B1)-1)

Or perhaps I've misunderstood your question.

[bbyhill]

I'm not quite sure I understand what you're asking as the line is obviosuly immaterial when calculating the to win amount.

So your to win would would be exactly as before except you'd substitute B1 for A1 and H2 for A2:

=H2*(us2dec(B1)-1)

Or perhaps I've misunderstood your question.

Thats exactly what I thought.Thank you again Ganch.