Hi all
I hvae been trying to record some data on horse racing recently (mostly using Nigel's excellent IXL sheet).
I haven't gone through the sheet in detail yet to analyse but i have just thought about (as it happened to me manually) ..... how does one account for a withdrawal and therefore the subsequent changing of odds - ie when Betfair apply the reduction factor
As I say I havent gone back through my data to analyse the effect - but presumably there will be one. Because I'm recording the data "live", then tick by tick / line by line into a spreadsheet - but these odds might "change" when actually all thats happened is betfair applying reduction factor.
(1) Is there any way to see the "original odds"?
(2) Has anyone else come across this problem when collecting data / and then later using it for analysis etc?
I'd be grateful to hear any thoughts!!
Thanks
Jonny
Horse Racing - Data capturing - Dealing with Non Runners / Withdrawals
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
If you capture market status alongside the price history you could look for lines where it's 'suspended' and the countdown is still before the start time?
Not foolproof but it makes 'funnies' easier to spot.
Not foolproof but it makes 'funnies' easier to spot.
for analysis purposes i simply ignore any markets with nonrunners (although this is definitely not best practice though its definitely easy)
otherwise you could code something to go back and "fix" your data, ie adjust previous odds by the reduction factor (Shaun's suggestion is a good way to identify when a runner has been withdrawn)
otherwise you could code something to go back and "fix" your data, ie adjust previous odds by the reduction factor (Shaun's suggestion is a good way to identify when a runner has been withdrawn)
-
- Posts: 17
- Joined: Sat Aug 20, 2011 4:17 pm
Yup - thanks guys - its a bit of tricky one . Neither solution ideal really - very difficult (and time consuming!) to work back the reduction factors.
Hmm will have to keep thinking ...
Hmm will have to keep thinking ...