Today's racing - Excel spreadsheet

The sport of kings.
Bet Angel
Bet Angel
Bet Angel
Posts: 3999
Joined: Tue Apr 14, 2009 3:47 pm

Just a note, Ffos las doesn't seem to appear in todays racing?
xdg99667
Posts: 27
Joined: Thu May 14, 2009 11:00 pm

thanks for the heads up, I'll have a look into it.

Cheers, Gary
User avatar
firedave
Posts: 12
Joined: Mon Apr 20, 2009 6:18 pm

It is the same issue as before - just needs a translation table for the different spelled courses on the two different lookup sites.
:D
mazdaq100
Posts: 12
Joined: Sat Aug 01, 2009 9:37 am

Thanks for this, very useful. Just to let you know, Ayr isn't showing up in the list for today. Any idea why this is?
User avatar
TheTub
Posts: 267
Joined: Thu Mar 26, 2009 7:53 pm
Location: Nottinghamshire

Hi all - for anyone who uses this I had to update to get the courses coming through correctly. I think the source site keeps changing how the data is displayed.

Anyway, it works again. Am trying to see how to include an option to include the Irish and US cards if anyone is interested. Maybe the original author could help out with this?
Todays Racing.xls
You do not have the required permissions to view the files attached to this post.
mazdaq100
Posts: 12
Joined: Sat Aug 01, 2009 9:37 am

Thanks for this TheTub, seems to be include all the races this time. I found that often one meeting seemed to be excluded from the original spreadsheet.
lilgreenback
Posts: 211
Joined: Thu Apr 16, 2009 11:28 am

Hi,

Just a question does the spreadsheet update automatically or does each person that accesses it have to update it individually.

As I found it yeserday got it to work but today no joy just woundered if it was somthing I was doing wrong, it is certainly useful.

Regards

LilGB
BBB123
Posts: 62
Joined: Sat Jul 11, 2009 12:07 pm

Hi,

can soomeone check if this is working ok today.I've just downloaded excel 2010 & can't seem to get it working?

Cheers
Ben
User avatar
TheTub
Posts: 267
Joined: Thu Mar 26, 2009 7:53 pm
Location: Nottinghamshire

Seems to work ok for me in Excel 2010.

Although it needs a small fix.

Once updated, go to the 'Market' column and replace each 'Newton' with 'Newton Abbot'.

Please feel free to correct the code yourself and post up here.
BBB123
Posts: 62
Joined: Sat Jul 11, 2009 12:07 pm

Cheers Tub,

I'm still not able to get as far as that,I have taken debug after clicking update & this is what it says;
End If

If ActiveCell = "" Then ActiveCell.Offset(1, 0).Select


Loop While Mid(ActiveCell.Value, 1, 3) <> "Use"

Exit Sub


errorhandler: MsgBox "There was a problem getting the odds, please try again"

End Sub

Any help appreciated
Ben
jimbob04
Posts: 7
Joined: Thu Nov 04, 2010 9:05 am

thats for all your help ImageImage
maciek
Posts: 6
Joined: Sun Nov 21, 2010 3:16 pm

It works, but I have not all meetings (Wetherby and Naas missing today). Any problem with parsing data? Was layout changed or so?
Bet Angel
Bet Angel
Bet Angel
Posts: 3999
Joined: Tue Apr 14, 2009 3:47 pm

Don't think Irish racing is on here but the UK racing should be.
maciek
Posts: 6
Joined: Sun Nov 21, 2010 3:16 pm

How can I get first meeting data racing in this Excel spreadsheet without error? The data from http://horses.sportinglife.com/Meetings/ are inside spreadsheet 'RaceCard' (but cuted - first part named "Book" it is Wetherby without first race):
12:50 Book Raceday Hospitality On 01937 582035 Handicap Chase (4yo+, Class 4, 2m 6f 110y, 6 runners)
Book 13:20 Follow Wetherby Racecourse On Facebook 'national Hunt' Novices' Hurdle (4yo+, Class 4, 2m 110y, 18 runners) 13:20 4 18 2m 110y Hurdle
Book 13:50 Buy Tickets For Boxing Day at Wetherbyracing.co.uk Handicap Chase (4yo+, Class 3, 2m, 7 runners) 13:50 3 7 2m Chase
Book 14:25 Subscribe To Racing Uk Juvenile Maiden Hurdle (3yo, Class 5, 2m 110y, 9 runners) 14:25 5 9 2m 110y Hurdle
Book 15:00 Bramham Hall For Conferences & Banqueting Beginners' Chase (4yo+, Class 4, 3m 1f, 4 runners) 15:00 4 4 3m 1f Chase
Book 15:35 E.b.f./dbs Mares' Standard Open Nh Flat Race (qualifier) (4-6yo, Class 5, 2m 110y, 10 runners) 15:35 5 10 2m 110y NH Flat
image Chepstow Fast Cards
Chepstow 13:10 Betfair Racing Excellence Conditional Jockeys' Training Series Handicap Chase (4yo+, Class 5, 2m 3f 110y, 5 runners) 13:10 5 5 2m 3f 110y Chase
//
...
//
Naas 15:40 Become A Go Racing In Kildare Member (pro/am) Flat Race (5-7yo, 2m, 8 runners) 15:40 8


Parsing error maybe?
Last edited by maciek on Thu Nov 25, 2010 7:53 am, edited 1 time in total.
Post Reply

Return to “Trading Horse racing”