Bet Angel Automation - Shared files : Horse Racing - Data capturing - Dealing with Non Runners / Withdrawals

Share your automation file with other users.
Post Reply
jonedelman
Posts: 17
Joined: Sat Aug 20, 2011 4:17 pm

Thu Sep 13, 2018 4:10 pm

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

User avatar
ShaunWhite
Posts: 3426
Joined: Sat Sep 03, 2016 3:42 am

Thu Sep 13, 2018 6:53 pm

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.

sa7med
Posts: 156
Joined: Thu May 18, 2017 8:01 am

Fri Sep 14, 2018 1:58 pm

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)

jonedelman
Posts: 17
Joined: Sat Aug 20, 2011 4:17 pm

Fri Sep 14, 2018 4:02 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 ...

weemac
Posts: 316
Joined: Mon Sep 16, 2013 8:16 pm

Fri Sep 14, 2018 4:05 pm

I used to do it manually the morning after racing by comparing my records with betfair's records, and adjusting odds, field sizes etc. using Excel, but it was such a pain in the neck I gave up after a while.

Post Reply

Return to “Bet Angel Automation - Shared files”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest