This Power Query scrapes data from a certain website.
If you want to know the data source go to Data Tab > Get data > Data Source Settings
Each worksheet has a different set of stats
To refresh the data each morning go to Data Tab > Refresh All > Refresh All
Note: the way the data is hosted and imported with Power Query, it creates an anomaly by combining the headgear to the horses name. Oops !
Power Query - Combos, Last 14 Days, Going etc
-
paspuggie48
- Posts: 659
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
You do not have the required permissions to view the files attached to this post.
-
paspuggie48
- Posts: 659
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Some people get an error when running queries.
This is usually down to their privacy settings.
To resolve this go to the Data Tab > Get Data > Query Options > Privacy
Ensure 'Always ignore Privacy level settings' is selected.
This is usually down to their privacy settings.
To resolve this go to the Data Tab > Get Data > Query Options > Privacy
Ensure 'Always ignore Privacy level settings' is selected.
You do not have the required permissions to view the files attached to this post.
-
MemphisFlash
- Posts: 2185
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
The sith Lord has returned, 
-
paspuggie48
- Posts: 659
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
ha Ha...bless you my child
-
MemphisFlash
- Posts: 2185
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
are you still my father!