Excel formula help

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
parbynat
Posts: 65
Joined: Thu May 10, 2018 5:25 pm

Merry Christmas to the forum
I thought this would be easy to work out but I'm struggling to do it.
What is the formula that turns the decimal odds into standard odds, eg:- 3.50 in one cell, then the formula to show 5/2 in another?
Hope someone can help.
Parbynat
sa7med
Posts: 800
Joined: Thu May 18, 2017 8:01 am

Probably is best to have an index to call from, ie https://www.spreadex.com/sports/get-sta ... imal-odds/

then you can just index/match it or vlookup.
User avatar
Euler
Posts: 24701
Joined: Wed Nov 10, 2010 1:39 pm
Location: Bet Angel HQ

parbynat wrote:
Tue Dec 25, 2018 8:53 am
Merry Christmas to the forum
I thought this would be easy to work out but I'm struggling to do it.
What is the formula that turns the decimal odds into standard odds, eg:- 3.50 in one cell, then the formula to show 5/2 in another?
Hope someone can help.
Parbynat
It is easier to do a lookup so you get an exact match with bookie odds, but 5/2 is a ratio of 3.50: -

3.50-1=2.50 = 5/2

QED
User avatar
Derek27
Posts: 23477
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

It's impossible to replicate them using formulas because 3/2 is quoted as 6/4, 10-3 as 100-30, 17/8 as 85/40 etc.

Just had a quick look in as I'm bored of American In Paris. :)
parbynat
Posts: 65
Joined: Thu May 10, 2018 5:25 pm

I'll do the lookup thing, thanks chaps.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”