Power Query - Example Spreadsheets

Example spreadsheets and comments on example spreadsheets.
Post Reply
stever78
Posts: 53
Joined: Wed May 24, 2017 7:43 pm

thanks pas,
your suggestion of changing names has led me to just replacing them on PQ.
this fuzzy matching could provide too many undesired results
thanks for your help
mgrant
Posts: 9
Joined: Mon Jun 07, 2021 11:48 am

Hi folks
Dogs related,could power query be used to download the daily cards for the greyhounds???
Thanks
Granty
User avatar
Realrocknrolla
Posts: 1191
Joined: Fri Jun 05, 2020 7:15 pm

mgrant wrote:
Wed Jul 07, 2021 11:23 am
Hi folks
Dogs related,could power query be used to download the daily cards for the greyhounds???
Thanks
Granty
Yea
mgrant
Posts: 9
Joined: Mon Jun 07, 2021 11:48 am

Good I will have a go then. :)
Office 2010(my usual office) doesn't seem to have the capabilities so I am using 2019
Ive done a bit with pivot tables,and a lot with VBA and excel.I am not too convinced yet of PQ's ability to scrape effectively but then I dont know too much about it.I have done a lot with Python and a little web scraping,but at the moment teaching myself HTML,Java Script etc.
But by what I have seen so far it looks like PQ could be just what I want.
My first project will to be downloading the dog cards,and I will put my feeble attempts up here :) :) :)
Granty.
User avatar
MemphisFlash
Posts: 1696
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

will compare with what i hav already done once you have posted. :D
mgrant
Posts: 9
Joined: Mon Jun 07, 2021 11:48 am

Hi Memphis,
Why have I a sneaking suspicion that yours will be better than mine :) :) :)
Granty. :lol:
paspuggie48
Posts: 421
Joined: Thu Jun 20, 2013 9:22 am
Location: South-West

mgrant wrote:
Wed Jul 07, 2021 11:23 am
Hi folks
Dogs related,could power query be used to download the daily cards for the greyhounds???
Thanks
Granty
Depends on which website you are trying to get data from Granty.

As an example, PQ can scrape Racing Post data but it will require an exceptional multi function programme and expert level with PQ to do it for a days set of racecards.

Other sites like Timeform are easily possible but the risk is you may get blocked

I know there are a few on here who are Python gurus and may offer an alternative solution.
ged1200
Posts: 39
Joined: Sun Oct 30, 2016 2:40 pm

I'm looking to create a WTA server stats workbook, modelled on the very useful one produced by paspuggie48 for ATP, but I've hit a snag right at the start. Does anyone know if power query can be made to scrape a "load more" web page table? PQ appears to only "see" 20 rows of just one WTA server stats table on the page.
Research suggests that I would probably need to use Python? Can anyone confirm this?
Many thanks
User avatar
MemphisFlash
Posts: 1696
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Top 9 Leagues - Power Query
Capture.JPG
Capture2.JPG
Top 9 Leagues - Power Query.xlsx
[attachment=0]
You do not have the required permissions to view the files attached to this post.
makkad
Posts: 73
Joined: Thu Sep 22, 2016 10:38 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)
Post Reply

Return to “Bet Angel - Example spreadsheets”