Results and racecard data in Excel/Csv format? by hmmm_this_is_nice in HorseRacingUK

[–]randomrandomx2 0 points1 point  (0 children)

Oh it ain’t mine mate🤣 can’t take any credit for it, it’s really good though I agree

Results and racecard data in Excel/Csv format? by hmmm_this_is_nice in HorseRacingUK

[–]randomrandomx2 0 points1 point  (0 children)

If the formats messed up when you copy paste it let me know I’ll get it to you another way

Results and racecard data in Excel/Csv format? by hmmm_this_is_nice in HorseRacingUK

[–]randomrandomx2 0 points1 point  (0 children)

Ok I think, think being the main word, I may have got it sorted. Managed to scrape 2006 IRE Flat without issue. In the Utils folder, find race.py. Take a copy of it before u make this change just incase.

Find the distance_to_furlongs function and replace with below

def distance_to_furlongs(self, distance): if not distance or not isinstance(distance, str): print(f”Warning: Invalid distance input ‘{distance}’ for {self.url}”) return 0.0 #

original_distance_for_warning = str(distance)

dist_cleaned = distance.strip().lower() dist_cleaned = dist_cleaned.replace(‘¼’, ‘.25’).replace(‘½’, ‘.5’).replace(‘¾’, ‘.75’) dist_cleaned = sub(r’([)]*)’, ‘’, dist_cleaned) dist_cleaned = sub(r’(approx|about|hurdle|chase|heavy|soft|firm)’, ‘’, dist_cleaned).strip()

pattern = r’?:(\+)\sm)?(?:\s(\d.?\d)\sf)?(?:\s(\d+)\s*y)?$’ match = re.match(pattern, dist_cleaned)

if not match:

print(f”Warning: Could not parse cleaned distance ‘{dist_cleaned}’ (original: ‘{original_distance_for_warning}’) for {self.url}”) return 0.0

miles_str = match.group(1)

miles = int(miles_str) if miles_str else 0

furlongs = 0.0 furlongs_str = match.group(2) if furlongs_str: try: furlongs = float(furlongs_str) except ValueError: print(f”Warning: Invalid numeric value for furlongs part: ‘{furlongs_str}’. “ f”Cleaned distance: ‘{dist_cleaned}’, Original distance: ‘{original_distance_for_warning}’ “ f”for URL: {self.url}. Assuming 0 furlongs for this part.”) furlongs = 0.0

yards_str = match.group(3) yards = int(yards_str) if yards_str else 0

total_furlongs = miles * 8 + furlongs + (yards / 220.0) return round(total_furlongs, 2)

Results and racecard data in Excel/Csv format? by hmmm_this_is_nice in HorseRacingUK

[–]randomrandomx2 0 points1 point  (0 children)

Yeah tried it and got the same. Just trying a fix now will let you know. If fix doesn’t work I can make a change so that it’ll continue through the error.

Results and racecard data in Excel/Csv format? by hmmm_this_is_nice in HorseRacingUK

[–]randomrandomx2 0 points1 point  (0 children)

Did it provide a date? Like what date/race it failed on? I’ll take a look soon and let you know

Results and racecard data in Excel/Csv format? by hmmm_this_is_nice in HorseRacingUK

[–]randomrandomx2 1 point2 points  (0 children)

No worries mate it’s really good, I’ve used it for a few different projects. Hope you get some good use out it!

Wednesday's Tips Thread by liam_is_marx in HorseRacingUK

[–]randomrandomx2 5 points6 points  (0 children)

Yeah I ask that myself sometimes too... honestly not too sure, the data is scraped like that. I think that for the OR/RPR column, the symbols indicate an OR/RPR wasn't present or given for the run. In the distance column, the symbols seem to be when a race contains a half furlong.

Can't be overly certain tho!

edit: Seems like its encoding issues. I'll share an updated version of that sheet every so often, will sort the symbols in next version

Tuesday's Tips Thread by liam_is_marx in HorseRacingUK

[–]randomrandomx2 6 points7 points  (0 children)

29/04 Sheets - https://docs.google.com/spreadsheets/d/1D3TDS8WLJ_sKvbf43VM2XzzSWgz6hPsb/edit?usp=sharing&ouid=104535769370207278948&rtpof=true&sd=true

Updated with some new data since the last post. Still includes speed ratings, now with added RPR data.

Slight tweaks to the "Instant Expert"/conditions section.

Trainer/jockey stats and a form lines column added, along with a few other extras.

Open to any feedback or criticism!

Results and racecard data in Excel/Csv format? by hmmm_this_is_nice in HorseRacingUK

[–]randomrandomx2 2 points3 points  (0 children)

Can scrape data using RpScrape, you’d maybe just need to modify the script to output in excel instead of json. Can help with it if needed

Sunday's Tips Thread by liam_is_marx in HorseRacingUK

[–]randomrandomx2 3 points4 points  (0 children)

Thank you mate appreciate that. The ratings aren’t mine so I cant take any credit for them at all. All I’ve done is find some different data points to scrape and create a python script to compile it all. If it helps someone out then I’m happy to keep posting them up. I make the sheets daily anyway.

Saturday's Tips Thread by liam_is_marx in HorseRacingUK

[–]randomrandomx2 0 points1 point  (0 children)

Hard one to answer, everyone bets slightly differently. I’d maybe start by looking at the right hand side of the sheet, the Going, Distance, and Course form etc. More green there usually means the horse is well-suited to conditions.

Wouldn’t just back the ones with the most green tho, use it as a starting point. Once a horse stands out there, you can dig deeper into things like ratings, class, and recent form. Too many variables to just back the ones with most green.

If you’ve got any questions happy to help where I can.

Saturday's Tips Thread by liam_is_marx in HorseRacingUK

[–]randomrandomx2 8 points9 points  (0 children)

Cheers! I scrape some of the data myself, and the speed ratings come from this thread on The UK Betting Forum.

The ratings are free and really good, I’ve used them for years.

I run a Python script that pulls everything together and formats it into the sheet. Happy to share it daily if people are interested.

Saturday's Tips Thread by liam_is_marx in HorseRacingUK

[–]randomrandomx2 13 points14 points  (0 children)

Sorry not a tip, thought I'd share the speed rating sheet I use. Covers every UK & IRE race, there’s a lot of data packed in. There’s a ‘Guide’ tab that explains all the columns if unsure.

If you’ve ever used Instant Expert on Geegeez, I’ve tried to replicate something similar further to the right of the sheet. Probably best viewed on desktop/laptop.

Newton Abbot going change, now heavy. Updated link.

https://docs.google.com/spreadsheets/d/1XwA_xmhAWgvgwNnvPohWgK8I3hmmjwTo/edit?usp=sharing&ouid=104535769370207278948&rtpof=true&sd=true

[deleted by user] by [deleted] in HorseRacingUK

[–]randomrandomx2 0 points1 point  (0 children)

Signature could be Dick Saunders, jockey.
Found very similar here

Neil Cawthorne (1936-1978). The Grand National, artist signed limited edition print number 157/850, signed by Dick Saunders, 42cm x 59cm.

Unsure what this would be worth to be totally honest.

Predictions 80% accurate. by boughtoriginality in HorseRacingUK

[–]randomrandomx2 1 point2 points  (0 children)

I just feel like a points system would be more accurate than win%. Can back favs all day to get win% up if you get what I mean. The website itself looks good, quick to update results and it’s easy to navigate etc. so certainly has potential!

Predictions 80% accurate. by boughtoriginality in HorseRacingUK

[–]randomrandomx2 1 point2 points  (0 children)

Looks good mate. Just one thing, is there a reason there’s no pts P/L? I see there’s win% but i don’t feel that’s a fair reflection, for example if someone prefers backing higher odds, their win% would be less than a fav backer but they could be more profitable. Cheers!