Display Fractional Odds in Excel

[yursaduian]

Gary

I use your code to collect the liveshows from Sporting life on each horse race.

Is there anyway I can display the odds as fractional (7/4, 15/8 etc) in excel?

Thanks
Ian

[GaryRussell]

Unfortunately I don't know. It's not something I would want to do personally. There are decimal equivalents for every fraction, but not the other way round so even if you use a look up table there will be some missing. Has anyone else got any ideas?

[GaryRussell]

I've just reviewed my code. The odds are converted from fractional to decimal by my code so it's just a case of providing a function to return the fractional odds instead of decimal. I will add a function named getLiveShowFractional(). I'll let you know when it's ready.

[GaryRussell]

I've updated the example spreadsheet.

Download it from http://www.gruss-software.co.uk/Excel/S ... _Shows.xls

You can use the function getLiveShowFractional() instead of getLiveShow()

I haven't tested it yet because obviously it's too early for live shows. I'll test it later and let you know if I have to amend it.

[yursaduian]

Bloody hell - quick work Gary!

Obviously I still need the decimal figures for my excel calculations but it would help me read whats going on in the betting market if I could see the fractional odds on my worksheet as well

Without being a pain, is there any way we could have both?

Thanks again

[GaryRussell]

You've still got the getLiveShow() function so you can use that in addition to the getLiveShowFractional() function.

[yursaduian]

Gary - it works perfect - your a genius!!

Cheers!