Power Query - Greyhound Course Trap & Favourite Stats

Post Reply
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

This PQ document scrapes data from http://greyhoundstats.co.uk/index.php

It collates 8 years of Trap data for each course between 2013 - 2020.
(I then calculated the average figures and tabulated them)

It also collates 4 years of data for each Favourite by course and Trap number between 2017 - 2020.
(I then calculated the average figures and tabulated them)

Caveat; some data on the website was missing, so I have had to compensate where possible (possibly due to a course does not exist anymore).

The data updates daily on the website, so you can update the Tables too by going to your Data Tab and clicking on "Refresh".
You do not have the required permissions to view the files attached to this post.
ArticalBadboy
Posts: 106
Joined: Tue Feb 14, 2017 1:43 pm

Wish I'd have had this before Wimbledon shut!
mgrant
Posts: 9
Joined: Mon Jun 07, 2021 11:48 am

Hi,
I downloaded the SSheet and that works fine but when I refresh I get the following message:
'Initialisation of the data source failed
Check the database server or contact admin.Make sure external database is available,and then try the operation again.If you see this message again create a new data source to connect to the database.'
Any suggestions on how to fix this :D Or am I doing something wrong :o
thanks
granty
User avatar
paspuggie48
Posts: 611
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

Not having experienced this before Google says it could be to do with your version of Excel.
Post Reply

Return to “Excel Power Query”