Betfair model % difference calc

[ilovepizza82]

Hi

Take a look at the screenshot and if you could tell me how it is 15.6% when according to my calcs using this formula:
=100*(K201-J201)/J201
it is 47.5% (difference between the 2 odds)

[Derek27]

Hi

Take a look at the screenshot and if you could tell me how it is 15.6% when according to my calcs using this formula:
=100*(K201-J201)/J201
it is 47.5%

If that graphic is an Excel spreadsheet, the rows and columns aren't identifiable so it's not possible to make an independent calculation. The forumla's not visible either.

[ilovepizza82]

Hi

Take a look at the screenshot and if you could tell me how it is 15.6% when according to my calcs using this formula:
=100*(K201-J201)/J201
it is 47.5%

If that graphic is an Excel spreadsheet, the rows and columns aren't identifiable so it's not possible to make an independent calculation. The forumla's not visible either.

Rated odds = 5.79
Back odds = 3.04
Lay odds = 3.04
Value = 15.6 %

TAken from here:
https://www.betfair.com.au/hub/models/g ... ons-model/

[Derek27]

Hi

Take a look at the screenshot and if you could tell me how it is 15.6% when according to my calcs using this formula:
=100*(K201-J201)/J201
it is 47.5%

If that graphic is an Excel spreadsheet, the rows and columns aren't identifiable so it's not possible to make an independent calculation. The forumla's not visible either.

Rated odds = 5.79
Back odds = 3.04
Lay odds = 3.04
Value = 15.6 %

TAken from here:
https://www.betfair.com.au/hub/models/g ... ons-model/

Sorry, I didn't realise I was on the greyhound thread.

[ilovepizza82]

No worries.
Ive just figured out how to do it. LOL its just dec odds converted to % and then the diference betweent them.
My first mistake was to calc percentage of the odds difference and not the % probabilities. lol
Never create formulas early in the morning. Lesson learned