[Finance] Statistics/Data Calculation problem

[neilbard]

Can someone help with this please, a colleague and myself are getting differing answers.

What are the net gains and yields for each season?

The net gains represent the net profit (or loss) in terms of units on the basis of a 1 unit bet per match. So if you have a winning bet at odds 1.9, your net gains are 1.9-1 = 0.9.

Alternatively, had you bet 100 pounds instead of 1 unit, you would have won 100*(1.9-1)=90 pounds.

 

[The Optimist]

If I understand I think:
net gains = games won x (odd-1) - games lost
So for 12/13 net gains = 212 x 0.88 - 168 = 18.56
Yield = (gains / stake) x100
So for 12/13 yield = (18.56 / 380) x100 = 4.88%

The only question I have is it says max odds. Presumably the odds changed per game and then it matters what the odds were on the games won and lost.

 

[neilbard]

If I understand I think:
net gains = games won x (odd-1) - games lost
So for 12/13 net gains = 212 x 0.88 - 168 = 18.56
Yield = (gains / stake) x100
So for 12/13 yield = (18.56 / 380) x100 = 4.88%

The only question I have is it says max odds. Presumably the odds changed per game and then it matters what the odds were on the games won and lost.

The odds are the average odds taken over each season.

 

[schmunk]

If I understand I think:
net gains = games won x (odd-1) - games lost
So for 12/13 net gains = 212 x 0.88 - 168 = 18.56
Yield = (gains / stake) x100
So for 12/13 yield = (18.56 / 380) x100 = 4.88%

The only question I have is it says max odds. Presumably the odds changed per game and then it matters what the odds were on the games won and lost.

I have the same understanding (although I would have done net gains = (games won x odd) - total games, but this gives the same answer!)

 

[The Optimist]

I have the same understanding (although I would have done net gains = (games won x odd) - total games, but this gives the same answer!)

If you tidy up the equation on mine it becomes what you have written. You win for neatness!

 

[The Optimist]

The odds are the average odds taken over each season.

In which case you'll only ever get an estimate of the net gains and yield. The estimate is also likely to be an overestimate as presumably you were more likely to win on games with shorter odds and less likely to win on games with longer odds. You need the average odds for just the games won.

 

[neilbard]

I have the same understanding (although I would have done net gains = (games won x odd) - total games, but this gives the same answer!)

In which case you'll only ever get an estimate of the net gains and yield. The estimate is also likely to be an overestimate as presumably you were more likely to win on games with shorter odds and less likely to win on games with longer odds. You need the average odds for just the games won.

Thanks guys for your help, Table 1. Shows the calculations using Max. Average Odds which I used, whereas Table 2. Shows calculations using actual odds per game, which my colleague used.

This shows a big difference.

 

[dsr-burnley]

Thanks guys for your help, Table 1. Shows the calculations using Max. Average Odds which I used, whereas Table 2. Shows calculations using actual odds per game, which my colleague used.

This shows a big difference.

At risk of stating the obvious, if you've been doing different sums, you're bound to get different answers.

 

[neilbard]

At risk of stating the obvious, if you've been doing different sums, you're bound to get different answers.

Yes I know, but my dick colleague was pulling a fast one by not giving giving me all the data that he had.