Power Query - Example Spreadsheets

Example spreadsheets and comments on example spreadsheets.
Post Reply
foxwood
Posts: 287
Joined: Mon Jul 23, 2012 2:54 pm

Shaung89 wrote:
Thu Sep 23, 2021 9:33 am
I tried Nigels 'Daily Runner' document but ran into an error immediately when trying to 'refresh all' the data from his 2018 file.

Does anyone have a working version? Im looking for a PQ solution something like the following for every runner:
- Meeting
- Time
- Horse 1

Thanks in advance
Have a look at https://www.sportinglife.com/racing/abc-guide

Might be useful and an easy scrape - you could also just copy/paste the list into Excel and work from that
User avatar
ODPaul82
Posts: 471
Joined: Sun May 08, 2011 6:32 am
Location: Digswell Herts

Shaung89 wrote:
Thu Sep 23, 2021 9:33 am
I tried Nigels 'Daily Runner' document but ran into an error immediately when trying to 'refresh all' the data from his 2018 file.

Does anyone have a working version? Im looking for a PQ solution something like the following for every runner:
- Meeting
- Time
- Horse 1

Thanks in advance
This is one I had before for something (was looking at racing post ratings hence the name).
It points at skybet if I remember correctly, should just need to refresh the query on a daily basis
You do not have the required permissions to view the files attached to this post.
User avatar
Shaung89
Posts: 157
Joined: Wed Aug 08, 2018 5:39 pm

Thanks all,

Now have this up and running. PQ off of sky sports abc runners and a couple fo VLookups against a list of tracked horses to let me know which runners are racing each day.
stever78
Posts: 63
Joined: Wed May 24, 2017 7:43 pm

Does anyone get the RACING POST SIGNPOSTS page ( its a daily pdf document full of stats, subscribers only ) and download into excel for analysis in a power query ???

i have a excel master sheet of runners and some extracted BA STUFF. in my excel is power queries from other sources.

just wondering if anyone has extracted the Racing Post PDF and got it into power query succsesfully.

obviosly i can cut and paste the info into excel but i would rather it automated.

just that the PQ doesnt get on with the PDF when importing it ( even as a PDF )

Id be interested if the clever folk on here can help me out at all , if theyve done it that is ??

cheers, steve
User avatar
MemphisFlash
Posts: 1847
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

i might be able to convert using Parsehub for the scraping part but i am not a subscriber to the document you need.
Post Reply

Return to “Bet Angel - Example spreadsheets”