Power Query - Example Spreadsheets

Example spreadsheets and comments on example spreadsheets.
Post Reply
JMoney
Posts: 9
Joined: Fri Mar 04, 2016 11:37 am

Is there a US Sports section at all?

Covering - MLB, NBA, NFL, NCAAB, NCAAF, and NHL
User avatar
Realrocknrolla
Posts: 1191
Joined: Fri Jun 05, 2020 7:15 pm

JMoney wrote:
Thu Sep 09, 2021 4:05 pm
Is there a US Sports section at all?

Covering - MLB, NBA, NFL, NCAAB, NCAAF, and NHL
+1

Especially NBA
paspuggie48
Posts: 421
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

makkad wrote:
Sun Sep 05, 2021 3:33 pm
MemphisFlash wrote:
Sun Jun 06, 2021 12:03 am
Capture.JPG
Now that internationals are back has anyone (except memphis) got a clue how to PQ this web site?

https://www.eloratings.net/fixtures

I've tried basic PQ'ing but I'm unsuccessful (I'm using an up to date version excel)
Only Memphis has the spreadsheet with eloratings. As it was not shared we don't know if it is a PQ solution or not.
User avatar
Shaung89
Posts: 123
Joined: Wed Aug 08, 2018 5:39 pm

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
paspuggie48
Posts: 421
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

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
You can right click on the Guardian list of horse races and export all details to a CSV. Dependent on what custom columns you have obviously.
foxwood
Posts: 242
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: 363
Joined: Sun May 08, 2011 6:32 am
Location: Sutton

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: 123
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.
Post Reply

Return to “Bet Angel - Example spreadsheets”