NH or Flat, which is best for Laying The Field?

Post Reply
Dasmith21
Posts: 16
Joined: Sat Dec 24, 2016 9:49 am

Hi guys, go easy on me on my first post please. I've recently got into Laying the field after going through and logging all results for the last 2 months. I was pleasantly surprised and have found some edges to benefit me. Obviously the majority of the races have been NH, and the regular All Weather meetings.
Can I expect the forth coming Flat season to be as good as the current NH Season or is there generally no difference?
I have learnt that some courses are definitely better than others over the jumps and that it's better to leave the All Weather Flat races well alone.
I continue to log all results (thanks to Timeform) and will do this until I complete a full year.
Any advice on the above Q would be gratefully received.

Dave.
LinusP
Posts: 1770
Joined: Mon Jul 02, 2012 10:45 pm
Contact:

Laying the field is very easy to backtest, download betfair's SP data and have a play. I can give you a dump of everything from 2012ish tomorrow morning.
LinusP
Posts: 1770
Joined: Mon Jul 02, 2012 10:45 pm
Contact:

A few have asked for this now:

Contains 2009-2016 in one csv.
https://www.dropbox.com/s/zp3a9r5vlg9eh ... v.zip?dl=0

Contains 2009-2016 in separate csv's.
https://www.dropbox.com/s/ls8d5sdih5hkx ... R.zip?dl=0

Both 46.2mb but excel will struggle with the top one.

COUNT(*): 962425
MAX(EVENT_DT): 2016-12-30 16:20:00.0
MIN(EVENT_DT): 2008-12-31 12:00:00.0

With a few if statements you can easily backtest, although I recommend chucking the data in a database, I plan on doing a short tutorial on how to do this soon.

More data can be found here, viewtopic.php?f=5&t=11883
User avatar
eddy4005
Posts: 20
Joined: Thu Apr 16, 2009 12:51 pm

Timeform will give you all the running stats you need , every course as its own high and lows
https://www.timeform.com/horse-racing/form-and-results i wish you luck.
jupiter_man
Posts: 29
Joined: Fri Feb 19, 2016 9:03 pm

LinusP wrote:A few have asked for this now:

Contains 2009-2016 in one csv.
https://www.dropbox.com/s/zp3a9r5vlg9eh ... v.zip?dl=0

Contains 2009-2016 in separate csv's.
https://www.dropbox.com/s/ls8d5sdih5hkx ... R.zip?dl=0

Both 46.2mb but excel will struggle with the top one.

COUNT(*): 962425
MAX(EVENT_DT): 2016-12-30 16:20:00.0
MIN(EVENT_DT): 2008-12-31 12:00:00.0

With a few if statements you can easily backtest, although I recommend chucking the data in a database, I plan on doing a short tutorial on how to do this soon.

More data can be found here, viewtopic.php?f=5&t=11883

I have been studying BF data for a while, just wondering how come there are so many races with 0 volume traded pre race / inplay, and both min/max odds are wrong as well?

What I usually do is to ignore all these races, but I am not sure how much will it affect the result in long term. What do you do with these data?
Iron
Posts: 6793
Joined: Fri Dec 11, 2009 10:51 pm

Hi LinusP

Would there be any chance you could post the same data for 2017 please?

Thanks

Jeff
LinusP wrote:
Sat Dec 31, 2016 9:52 am
A few have asked for this now:

Contains 2009-2016 in one csv.
https://www.dropbox.com/s/zp3a9r5vlg9eh ... v.zip?dl=0

Contains 2009-2016 in separate csv's.
https://www.dropbox.com/s/ls8d5sdih5hkx ... R.zip?dl=0

Both 46.2mb but excel will struggle with the top one.

COUNT(*): 962425
MAX(EVENT_DT): 2016-12-30 16:20:00.0
MIN(EVENT_DT): 2008-12-31 12:00:00.0

With a few if statements you can easily backtest, although I recommend chucking the data in a database, I plan on doing a short tutorial on how to do this soon.

More data can be found here, http://www.betangel.com/forum/viewtopic.php?f=5&t=11883
jjrrjj
Posts: 197
Joined: Wed Dec 09, 2015 8:21 pm

I was going to ask the other day if anyone had that data. Thanks very much for posting LinusP

:D
User avatar
Dallas
Posts: 16057
Joined: Sun Aug 09, 2015 10:57 pm
Contact:

NigelK has kindly uploaded a excellent spreadsheet to download a whole years worth of SP data in a few clicks
viewtopic.php?f=54&t=14395
User avatar
ShaunWhite
Posts: 6227
Joined: Sat Sep 03, 2016 3:42 am

Linus, I know this is going back a bit but the data in most of those dropbox files is incorrect. All of the races after 21/4/2013 only show a few runners, not the whole field.

Do you have a source for the correct data in the same format?

Edit...fixed.
I just used nigelk's brilliant utility that Dallas mentioned above and then a quick "Copy /b *.csv alldata.csv" from dos to join them all together. Bit of sorting to remove duplicate headers and ...bingo.

Further edit..the data is wrong on the individual files BF site too. damn.
Has anyone else noticed this ?

...from a file taken at random....most races have lots of runners missing.
Untitled.png
Final edit :oops: Sort the file by Event ID and all the data is there i think. I'd assumed it was sorted already.
That turned into a bit of a stream of consciousness but i'll leave it incase anyone else is as easily fooled as I seem to have been.
You do not have the required permissions to view the files attached to this post.
User avatar
Dallas
Posts: 16057
Joined: Sun Aug 09, 2015 10:57 pm
Contact:

ShaunWhite wrote:
Tue Jan 02, 2018 2:08 am
Linus, I know this is going back a bit but the data in most of those dropbox files is incorrect. All of the races after 21/4/2013 only show a few runners, not the whole field.

Do you have a source for the correct data in the same format?

Edit...fixed.
I just used nigelk's brilliant utility that Dallas mentioned above and then a quick "Copy /b *.csv alldata.csv" from dos to join them all together. Bit of sorting to remove duplicate headers and ...bingo.

Further edit..the data is wrong on the individual files BF site too. damn.
Has anyone else noticed this ?

...from a file taken at random....most races have lots of runners missing.
Untitled.png

Final edit :oops: Sort the file by Event ID and all the data is there i think. I'd assumed it was sorted already.
That turned into a bit of a stream of consciousness but i'll leave it incase anyone else is as easily fooled as I seem to have been.
Betfair seemed to haved cocked loads up this years SP data, from what i can see quiet a bit of 2017 looks to be missing and in parts its very messy compared to other years

As Liam said on another thread he couldn't get his Volume data this year either, I assume these are both related and possibly to do with there new data site launched last year
Post Reply

Return to “Betfair Data”