Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Yield (ROI = Return Of Investment) issue

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Yield (ROI = Return Of Investment) issue

Hi Bernie,
don't worry about breaking even and house cuts.. That's why i am mostly
on betting exchanges (places where people bet against each other so
there are some values..)
I'm too long in betting and earn some nice amount of money in past,
and believe me, you can't line sports betting with roulette where
mathematically there is no chance of success and odds are always in
house favor! In sports betting house can mistake with their odds while
on roulette everything is always same..

Anyway, i received one answer on some forum with some solution which
should get into excel formula, but don't understand it all, so maybe
someone could explain it easier:


Let p = 1/odds be the probability of success, and R = 2 be the amount
you win on a success (as a multiple of the amount you put down). Suppose
you play n games, where n is large (in your case n = 1000, but it
doesn't really matter).

Expected winnings are npR, and expected cost is n. ROI is (npR - n)/n =
pR - 1.

If you want ROI to be 0.15, just solve pR - 1 = 0.15. If R is fixed at
2.00, solve 2p - 1 = 0.15.




Bernie Deitrick wrote:
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I calculate Return on Investment in Excel Jay_very_cool Excel Worksheet Functions 4 April 25th 23 09:03 AM
Annual percentage return on investment. jjb Excel Worksheet Functions 2 September 21st 06 01:34 PM
rate of return on investment per annum Ram Excel Discussion (Misc queries) 3 June 25th 06 09:26 AM
WHAT IS THE RATE BY MONTHS on A return of investment PAYBACK ON ONVESTMENT Excel Discussion (Misc queries) 0 March 28th 05 08:27 PM
Financial Calculation: Return on Investment Mark Schreiber Excel Programming 2 February 21st 05 03:27 PM


All times are GMT +1. The time now is 03:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"