Today's racing - Excel spreadsheet

[xdg99667]

Could be Ben, didn't think that was still around

I know it should work xl 2000 and upwards, If i get chance i'll try to get hold of a copy of 97 and test it on that.

[Tim]

Hi Gary

Hope you can help with this. I had seen your 'todays racing' spreadsheet last month and thought that it looked really useful, but was using open office at the time and it wouldn't run on it. I now have excel 2007 but the script is freezing when I try the update button. The debugger comes up with this highlighted in yellow

strMeeting = Mid(ActiveCell.Value, 1, (Len(ActiveCell.Value) - 13))

Now, this unfortunately means nothing to me (being the wrong side of 50 and with only a small number of brain cells I can bring to bear on the subject of IT).

Was hoping that you might point me in the right direction to get it working.


Thanks again

Tim

[Bet Angel]

This doesn't appear to be working any longer or is it just me?

[xdg99667]

Hi Tim sorry I missed your email, Peter sent me an email this morning pointing out the error

I wish the guys at oddschecker would not keep changing things!

Anyway I have attached a new version, please could you let me know if it is not working.

Thanks

Gary


(Ammeded not to show Abandoned meetings also)

[xdg99667]

Another day another problem lol.

[Bhut]

Hi,

Ok getting a debug error when running this.

Subscript out of range.

Its refering to a worksheet that it wants to see "odds2 and another one that I can't remember.

Any help?

Cheers

Ian

[xdg99667]

Hi Ian, I'll have a little look

[xdg99667]

Hi Ian

Its working okay for me apart from the 14:00 @ Taunton which has been given oddds yet?

I've attached todays

[xdg99667]

Todays is running okay, for me but I have attached the sheet with Todays info in

Thanks

Gary

[firedave]

Fantastic spreadsheet. I was just thinking about writing one that goes to gg.com to get the card as it would save me 20 minutes a day and stumbled across yours. Really good work.

Just out of interest - do you after update then add additional columns for how you expect the market to act - scalp, swing and record your p/l against the card? Just trying to think if there are any useful additions that could be made?

[Joao]

For me it's not appearing all the odds, just those that are integer numbers...

[firedave]

I'm having issues with the spreadsheet today - only bringing through prices and names for Lingfield.

[firedave]

It is working fine again today - which makes me think there was a problem with Ffos Las and Stratford-upon-Avon. Could it be that these UK courses are spelt differently on the oddschecker site and couldn't match these courses?

Like I say, working fine again today so will have to wait until next Monday for Stratford and next Sat for Ffos Las.

[whereistom]

Hi

Newbie here. Please could someone explain how to use the spreadsheet. Have got it downloaded but not sure how to update.

many thanks

[xdg99667]

Hi Folks

Sorry been hectic for the last while, as soon as we get 60 hour days the better!

Yes it needs a translation table added where the course names are different for the courses.

Its something that I had meant to do but... not been able to get around to it just yet

Thanks, Gary