View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Yield (ROI = Return Of Investment) issue

Ivica,

Actually, the formula is

(Winnings/Stakes -1 ) * 100 = ROI

No matter what the odds are, on average, you will break even, if the betting system is completely
fair. Usually, the system isn't fair, and you have less than a 50% chance at best (like in
roulette, if you bet black, the odds aren't 1 to 1, they are 1.111 to 1 against winning, which is
the house edge). So, there is no odds system that will give a positive rate of return over the long
run.... Games of skill, like poker, can allow some players to have a positive yield, but overall,
once the house takes its cut, the average yield is still negative. That is a hard lesson for many
gamblers....

HTH,
Bernie
MS Excel MVP


"Ivica TypeR" wrote in message ...
The Calculation of simple yield:

The Return*
(Winnings)
__________ X 100= ROI (%)

Investment*
(Stakes)


so for example: I have 1000 bets with odds 2,00
500 of them are winning and 500 losing. So i am on 0 and my ROI is zero

Would like to get right odds to have 15% yield,
How to calculate on what odds should i be to have ROI 15% ?
Because odds are not always 2,00 - they are different but i gave 2,00 as example...

So, i know what are odds to have 0% yield, but would like to get with some formula odds to have
15% yield (ROI)!?

Thanks very much for help!
Ivica