View Single Post
  #74  
Old 12th June 2014, 01:44 PM
Chrome Prince Chrome Prince is offline
Member
 
Join Date: Jan 1970
Posts: 4,365
Default

Quote:
Originally Posted by DR RON
Hey Chrome, would the same principal be able to be applied to say the first 2 favourites, that is lay them early then back late? with the assumption that if 1 firms the other will probably drift at the same time. Also I have downloade some betfair data to excel to do some research and was wondering if you could explain the easiest way for me to eliminate or hide the harness races as well as the place markets for the gallops and perhaps the inplay prices as well as this would make my research a lot less time consuming having to scroll through data that I dont really need.
Thanks Chrome.


Hi Dr, yes it could IF there is early liquidity.
Be very wary of Betfair data, there are numerous errors in both the SP and other data, such as non runners included, prices recorded as $1.00 when in fact it was $5.00 etc etc. I use a crosschecking system, but I'm sure I've missed one or two errors. If you're talking about the general data and not the SP data, then, you can filter it out in excel using the autofilter facility.
To eliminate harness for example, you search for contains Trot or Pace, this will bring them all up and you can delete them.
It's a matter of seeing which data is contained in each field and then eliminating what you don't want, such as "IP" for in play.

I think a couple of the people on the forum actually grab their own data via webscraping, because the Betfair data has a lot of errors.
__________________
RaceCensus - powerful system testing software.
Now with over 399,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 31/03/2024
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg
Reply With Quote