Horse racing : Today / Tomorrows Runner & Their BHB Ratings

Post Reply
nigelk
Posts: 461
Joined: Wed Apr 15, 2009 11:00 pm

Fri Feb 23, 2018 11:42 am

Create a folder on your c drive and call it BHB Ratings. Press the BHB button and two spreadsheets will be created, one weekly and one monthly.

Data taken from https://www.britishhorseracing.com/regu ... -database/

As the names suggest, they don't have to be updated on a daily basis.

Next, pressing the ABC button will get a list of all todays/tomorrows runners and will be shown with their BHB ratings.

Note. When you update the BHB ratings, you'll have to delete the existing ones first. I don't want to start deleting files on peoples C drives.

http://www.betangel.com/spreadsheets/BHB-Ratings.zip
.

jumbo
Posts: 4
Joined: Tue Feb 20, 2018 11:16 pm

Mon Mar 05, 2018 12:42 pm

Hi Nigel, this looks really good, but I am getting an error when pressing the button for refresh ABC ?

error at the selection listobject line..

.Range("A2").Select
Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False

mike..

nigelk
Posts: 461
Joined: Wed Apr 15, 2009 11:00 pm

Mon Mar 05, 2018 2:42 pm

Hi Jumbo

This will happen if you've deleted any of the columns/rows on any of the "Todays" / "Tomorrows" sheets. Download it agin and everything should work.

I've just downloaded it and everything is ok. Just as an aside, what version of excel (year) are you using?

jumbo
Posts: 4
Joined: Tue Feb 20, 2018 11:16 pm

Tue Mar 06, 2018 8:28 pm

Thanks Nigel, works a treat now.

mike

Post Reply

Return to “Horse racing”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest