Today's racing - Excel spreadsheet

[maciek]

I know now where the problem is.

The spreadsheet get the data from http://horses.sportinglife.com/Meetings/.
It starts after 'image' (country flag). But unfortunately, sportinglife was adding another 'image' in the first row of data ('RACING UK'). And it is the reason of problem not getting first race meeting data.

Who can resolve it?

Thank you!

[Euler]

Seems to be ok from this end?

[TheTub]

The spreadsheet seems to work fine today. I must admit I do not use it everyday so there may be updates required for subtle changes on the data sources but I can't see a problem with it at the moment.

Maybe you are looking at the sheet too early in the day? I imagine the student who puts that page together at the sporting life is occasionally late for work. I would give it until 10am at least.

Cheers Tub,

I'm still not able to get as far as that...

Any help appreciated
Ben

Hi Ben - I've only just seen this post so apologies for not replying. I guess you have got it working now?

[Passman]

I hope I'm not treading on anyone's toes but here is a version which gives the option of including the Irish meetings.

I haven't tested it with every Irish track but if there are any errors in this area in the future post them up and I'll see if I can find a solution.

Cheers

[maciek]

It seems to be OK today.

Passman - thank you for your version too!

[maciek]

Isn't working now:-(
Was layout changed?

[misimiki]

Yes, I have noticed this too. It hasn't been working for a couple of days and I haven't a clue about VBA. can anyone help?

[maciek]

Repaired, I hope...

[misimiki]

Many thanks for the repaired sheet.

michael

[JohnBet]

Thank you very much, Maciek!!

[pdupre1961]

Is there any way of getting Betfair's Market ID for tomorrow's racing quickly. Without having to copy and paste from each market on their website.

Paul

[Bet Angel]

Load them up in Guardian and they are hidden on the leftmost columns in the Excel template.

[pdupre1961]

Load them up in Guardian and they are hidden on the leftmost columns in the Excel template.

That's only the Betfair Selection IDs in column A.

Paul

[pdupre1961]

Hi Guys,

I use a summary page on the front of BetAngel_Multi.xls, with the Betfair Market ID in column A, market name in column B, totals runners in column C etc etc. It usually takes a few minutes getting all the market IDs from the Betfair website. Anyway, after a weeks research I now have a solution using Visual Basic. So, if anyone's interested I created a VB project from here http://forum.bdp.betfair.com/showthread.php?t=112 - using Betfair API directly.

Paul

[TQO23]

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

Hi Gary.
Heard about this spreadsheet at Peter's course this week. Great work.

There appear to be lots of versions in this thread but can you confirm that the one in your original post is still the valid one please as I can't get it to work.

I receive the Run-time error 5 in the MVB screen and when I debug I get the highlighted error strMeeting = Mid(ActiveCell.Value, 1, (Len(ActiveCell.Value) - 13))

I don't know VBA so can't debug.

Any help appreciated.

Thanks


Nigel

Thanks

Nigel