Any other odds (other than BF) and import to Excel

[stever78]

Hi All,
i have been searching, but cannot get any (easier) ways to do this.

does anyone know how i could get bookmakers ( say, skybet, PP, VICTOR, willhill) odds on the horses, and import them into Excel.

i have heard people can do it via xml and programming (python), etc. But i was wondering if it could be done easier. ( at a few clicks if poss !! )

no doubt it would come at a price.

very interested to know if anyone's got any info on it ??

alternatively, even a grab of the individual oddschecker race pages. would want it automated though ( to grab the screens, etc )

appreciated any info you may have.
thanks, steve.

[paspuggie48]

You could use the attached Steve.

ATR ABC & Odds.xlsx

I was using it myself but then didn't have any use for the info (what with some database websites offering much much more)

As a local copy though it worked fine and scrapes the Timeform A-Z of runners and prices they post. Sometimes these prices can be blank though as they have not published any prices. I believe the prices are the same as SkyBet.

You need to ensure you have Power Query as part of your Excel package (if not, google how to install it)

Simply select any cell in the 'green' table and go to Data Tab > Refresh All > Refresh.

It will update the 'green' table but as you can see I have a second table to the right in 'blue'. This is the historic data.

So, if you want to keep a historic record, simply copy 'n paste from the green table to the blue table. Should be self-explanatory.

Screenshot 2021-06-26 143237.png

[stever78]

hi PasPuggie,

thanks very much for this. i have downloaded and i have power pivot.

do you know how would i get the data. ( i.e when i click REFRESH ) it says
"initialization of the data source failed"
and then
"check the database server" make sure the external database is available.

do you know how i can tell where to look for the data ?

thanks very much for your help on this. very much appreciated.

ps
what are the database websites you mention?? do they have odds feeds?.

cheers, interesting stuff

[stever78]

further to my message above.

i have checked connections

it does have a !Query - ABC , workbook connection , when i open it the connection string is
"Provider=Microsoft.Mashup.OleDb.1;Data Source=$Workbook$;Location=ABC;Extended Properties="

and when i TEST CONNECTION it says test connection failed because the provider could not be initialized

i've not used power pivot before , let alone connecting to outside sources, so wouldnt know how to find out where it should look for the data

appreciate any help u could give, no rush though obv.

[paspuggie48]

It's not Power Pivot Steve, it's Power Query you need.

Screenshot 2021-06-26 154017.png

It's part of the Get & Transform function in Excel. It could be you have an older version of Excel that is causing the issue. (I have Office 2016). You don't need to connect to anything, Power Query is set up in the workbook to do that.

Go to the Power Query thread for other examples viewtopic.php?f=31&t=22492

As for the websites, there are a plethora. I'm sure the Forum members will have a list but you would be looking at Inform, Racing-Bet-Data and more.

Depends on how much you wanna spend but by all means search for Eyesnack on here, he has a really great database of information he's sharing.

[stever78]

ok. wow.
im like a kid in a sweetshop at the moment.

you got tips, naps, all sorts.

looks like i need to upgrade my 2013 excel and get POWER QUERY !!!

my big fear is that my macros that i spent ages on will not work ( just the type of thing that happens when i change anything !!) . it should be ok though.

thanks for your help

[paspuggie48]

No need to upgrade, Power Query can be used with as old as Office 2010. Just Google how to download to Office 2010, it will show you how ( I did this 2 years back when i had an older laptop and Office version)

All macros work with any version of Office too, however there may be issues with References or Object Libraries. I've been developing and using macros for over 10 years and never had problems with my VBA when upgrading my versions.

[Realrocknrolla]

ok. wow.
im like a kid in a sweetshop at the moment.

you got tips, naps, all sorts.

looks like i need to upgrade my 2013 excel and get POWER QUERY !!!

my big fear is that my macros that i spent ages on will not work ( just the type of thing that happens when i change anything !!) . it should be ok though.

thanks for your help

https://youtu.be/Afh1nloLrOE

May help you

[paspuggie48]

ok. wow.
im like a kid in a sweetshop at the moment.

you got tips, naps, all sorts.

looks like i need to upgrade my 2013 excel and get POWER QUERY !!!

my big fear is that my macros that i spent ages on will not work ( just the type of thing that happens when i change anything !!) . it should be ok though.

thanks for your help

https://youtu.be/Afh1nloLrOE

May help you

[stever78]

Ok,

Im on a roll here,

everything seems to be working !!, installed power query , much easier interface to connect to websites !!.

PugsPar, on your original file ATR ABC & ODDS.

is there any way i can get that for TOMORROWS runners.

or would i need to refresh it later, perhaps tonight ??

thanks, steve

thanks for the link rocknroller, installed, no probs

[paspuggie48]

Ok,

Im on a roll here,

everything seems to be working !!, installed power query , much easier interface to connect to websites !!.

PugsPar, on your original file ATR ABC & ODDS.

is there any way i can get that for TOMORROWS runners.

or would i need to refresh it later, perhaps tonight ??

thanks, steve

thanks for the link rocknroller, installed, no probs

It will only populate with whatever is on Timeform's or SkyBet's websites. Some prices may be there the night before but I would assume there will be lots missing.

So, in effect it will only update the prices on the morning of racing. (I used to refresh it around 7am on the day)