Extracting greyhound runner names into Excel

Please post any questions regarding the program here.

Moderator: 2020vision

Extracting greyhound runner names into Excel

Postby hughsiepops » Fri Apr 11, 2008 10:06 am

Morning

Is it possible to extract all selections of a day's race meeting into Excel.? Specifically I am interested in extracting a list of the full day's runners in the greyhound markets

How the information is displayed in Excel is important and has to be in a particular order.

Time (: 24hrs), Course (Betfair short name), Trap Number, Runner's name

The greyhounds would need to look like this
13:51, Hgrn, 1, Watch The Talent

This would save me an awful lot of time making my selections. Does anyone know if it is possible.?

I am only interested in the UK races - (But I would happy to filter out the AUS racing). Example from the 11th April would look like this ..

13:51, HGrn, 1, Watch The Talent
13:51, HGrn, 2, Merritts Chloe
13:51, HGrn, 3, Turville Bonny
13:51, HGrn, 4, Stouke Ciara
13:51, HGrn, 5, Free Doso
13:51, HGrn, 6, Sizzling Rose
14:03, Wstow, 1, Shortfall
14:03, Wstow, 2, Bunlougher Star
14:03, Wstow, 3, Deans Lu
14:03, Wstow, 4, Queens Opinion
14:03, Wstow, 5, Canary Tide
14:03, Wstow, 6, Comeonthreedog
14:08, Swin, 1, Teresas Jewel
14:08, Swin, 2, Barraduff Sandie
14:08, Swin, 3, Horseshoe Tara
14:08, Swin, 4, Nikkynoo
14:08, Swin, 5, Bet Fred
14:08, Swin, 6, Cill Dubh Lassie

Thanks
Hughsiepops
hughsiepops
 
Posts: 32
Joined: Mon Dec 17, 2007 3:26 pm
Location: Manchester

Postby phrenetic » Fri Apr 11, 2008 7:24 pm

Hughsiepops

It might be possible through a bit of trickery and a bit of Excel macroing!

Load all the greyhound markets into the quick pick list and link to Excel. Manually select the first race in the quick pick list, then the Excel macro can detect a new race and copy the details to a separate tab in the spreadsheet.

The spreadsheet can then auto-advance the market to the next one in the quick pick list.

Rinse and repeat!

Alistair
phrenetic
 
Posts: 142
Joined: Tue Oct 16, 2007 8:44 pm

Postby phrenetic » Sat Apr 12, 2008 5:39 pm

Hughsiepops

I've created a spreadsheet that will do what you want and will mail it to you shortly.

Alistair
phrenetic
 
Posts: 142
Joined: Tue Oct 16, 2007 8:44 pm

Postby bobomini » Wed Aug 31, 2011 12:56 pm

Dear Alistair,
Please help me with the same excel wookbook you sent to hughsiepops
Thanks.
Bobo



phrenetic wrote:Hughsiepops

I've created a spreadsheet that will do what you want and will mail it to you shortly.

Alistair
bobomini
 
Posts: 3
Joined: Mon May 30, 2011 12:28 pm

Postby hughsiepops » Wed Aug 31, 2011 2:02 pm

Hi bobomini

If you can PM me your email address I will email it over to you

Thanks
Hughsiepops
hughsiepops
 
Posts: 32
Joined: Mon Dec 17, 2007 3:26 pm
Location: Manchester

Postby bobomini » Wed Aug 31, 2011 4:26 pm

Message received but no attachment. Please resend with the file attached.
Cheers.
Bobo.

hughsiepops wrote:Hi bobomini

If you can PM me your email address I will email it over to you

Thanks
Hughsiepops
bobomini
 
Posts: 3
Joined: Mon May 30, 2011 12:28 pm

Postby tgsteveo » Sat Sep 24, 2011 4:10 pm

I would also be interested in getting hold of this spreadsheet if possible.

Many thanks in advance.
tgsteveo
 
Posts: 1
Joined: Sat Sep 24, 2011 4:06 pm


Return to Help

Who is online

Users browsing this forum: No registered users and 39 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.