Welcome to the Bet Angel Professional Community

Today's racing - Excel spreadsheet

The sport of kings.

Postby xdg99667 » Thu Oct 01, 2009 3:56 pm

Hi all,

blimy my first post on here ;)

I had put together an excel sheet that i use to give me a bit more info. essentilly click the button and it will go out onto the big bad and get a list of races, distance, type, classs, number of runners and odds of the first two runners

I find it saves me a bit of legwork each day - so if it will be of use to you....

comments / feedback would be very useful to me also

i've found that its best to log on to oddschecker with IE and set odds to decimal just for my preference.

I have uploaded it in a rarfile (2003 version) but please shout if it doesn't work for you

Thanks, Gary

Todays Racing (2003).xls

Todays Racing (2003).rar

You do not have the required permissions to view the files attached to this post.
User avatar
xdg99667
 
Posts: 27
Joined: Thu May 14, 2009 11:00 pm
  

Postby mtrend » Fri Oct 09, 2009 10:58 am

This looks useful, is there a way you can modify it to get the going for each race aswell ??

User avatar
mtrend
 
Posts: 58
Joined: Sun Sep 06, 2009 6:46 pm
  

Postby Bet Angel » Fri Oct 09, 2009 2:17 pm

We have edited the title of this thread and attached an uncompressed version of this useful spreadsheet. Hopefully that should get it the attention it deserves.

User avatar
Bet Angel
Bet Angel
Bet Angel
 
Posts: 3141
Joined: Tue Apr 14, 2009 3:47 pm
  

Postby PeterLe » Fri Oct 09, 2009 5:25 pm

Gary
Nice piece of work; thanks for sharing it...
regards
Peter

User avatar
PeterLe
Archangel Professional
Archangel Professional
 
Posts: 1549
Joined: Wed Apr 15, 2009 3:19 pm
  

Postby xdg99667 » Fri Dec 04, 2009 1:15 am

Hi again

oddschecker have changed the layout to their site, therefore i have updated mine, also there is a conversion to get theo dds from fractional to decimal.

let me know if you have any troubles with it!

You do not have the required permissions to view the files attached to this post.
User avatar
xdg99667
 
Posts: 27
Joined: Thu May 14, 2009 11:00 pm
  

Postby xdg99667 » Fri Dec 04, 2009 2:13 am

mtrend, just seen that - in theory :) - in practise i cant get at the html source from sporting life - winhttprequest just isnt working on that one so its on the drawing board!

User avatar
xdg99667
 
Posts: 27
Joined: Thu May 14, 2009 11:00 pm
  

Postby chris_ri » Fri Dec 04, 2009 10:35 am

Gary,

Thanks for posting update, I use your spreadsheet each day and it had started locking up Excel (I presume since the oddschecker change), all works well now.

Cheers,

Chris

User avatar
chris_ri
 
Posts: 31
Joined: Wed Apr 15, 2009 1:57 pm
  

Postby Frosy » Fri Dec 04, 2009 10:56 am

OK, I'm editing this post as I see how it works.

I originally uploaded it online and the update button didn't work.

The info look great, thanks!!
Dave

Last edited by Frosy on Fri Dec 04, 2009 12:02 pm, edited 1 time in total.
User avatar
Frosy
 
Posts: 24
Joined: Fri Nov 20, 2009 9:11 pm
  

Postby fox13wfd » Fri Dec 04, 2009 11:24 am

Hi,

This spreadsheet looks great!

When I load it up in Excel it only shows yesterdays fields. I have enabled Macros and clicked update but then Excel just freezes?

Any ideas?

Thanks

Greg

User avatar
fox13wfd
 
Posts: 3
Joined: Sat Oct 31, 2009 8:20 pm
  

Postby xdg99667 » Fri Dec 04, 2009 8:22 pm

fox13wfd wrote:When I load it up in Excel it only shows yesterdays fields. I have enabled Macros and clicked update but then Excel just freezes?



Hi Greg,

Can I ask you do do the following

when you have open the sheet, clicked update and it appears to freeze, can you hold down "Ctrl" and then press "Break" on the keyboard, a message box will appear asking if you want to debug, if you select "debug" it will pop open another screen and a line will be highlighted in yellow.

Can you tell me what that line says please? - we can have a look where its falling over and hopefully diagnose whats hapeening for you.

Cheers mate, Gary

User avatar
xdg99667
 
Posts: 27
Joined: Thu May 14, 2009 11:00 pm
  

Next

Return to Horse racing

Who is online

Users browsing this forum: Wainwright and 1 guest

Login Form