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)
Betfair model % difference calc
- ilovepizza82
- Posts: 494
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
You do not have the required permissions to view the files attached to this post.
Last edited by ilovepizza82 on Thu Jan 05, 2023 4:36 am, edited 1 time in total.
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 wrote: ↑Thu Jan 05, 2023 4:09 amHi
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%
- ilovepizza82
- Posts: 494
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
Rated odds = 5.79Derek27 wrote: ↑Thu Jan 05, 2023 4:18 amIf 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 wrote: ↑Thu Jan 05, 2023 4:09 amHi
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%
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 wrote: ↑Thu Jan 05, 2023 4:34 amRated odds = 5.79Derek27 wrote: ↑Thu Jan 05, 2023 4:18 amIf 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 wrote: ↑Thu Jan 05, 2023 4:09 amHi
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%
Back odds = 3.04
Lay odds = 3.04
Value = 15.6 %
TAken from here:
https://www.betfair.com.au/hub/models/g ... ons-model/
- ilovepizza82
- Posts: 494
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
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
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