This is a very simple Power Query solution to get the results of PGA tournaments and combine them all into one Table.
It works by using the URL on the Tournaments worksheet to get a list of all the Golfers who played in the event and then a function is applied to get their scores.
I have included the classics and some other events but one can add as many as they want from the website.
Power Query - PGA Tournament Results
-
paspuggie48
- Posts: 737
- Joined: Thu Jun 20, 2013 9:22 am
You do not have the required permissions to view the files attached to this post.
Last edited by paspuggie48 on Wed Apr 17, 2024 12:51 pm, edited 1 time in total.
-
paspuggie48
- Posts: 737
- Joined: Thu Jun 20, 2013 9:22 am
If one wants to add more events, then from the website select a Year and Tournament from the drop down menus.
Copy the URL from the address bar and paste it into the Table in the Tournaments worksheet.
It is self-explanatory but also include the other information to complete the Table. The Column called "Course" is just for information but can be copied from the webpage if required.
After you've added more Tournaments go to the 'TournamentsResults' worksheet, select a cell on the Table and right-click "Refresh". After a couple of minutes it will update.
Note: it takes a few minutes to update so even if your Excel says "not responding" just leave it alone and it will work fine.
Copy the URL from the address bar and paste it into the Table in the Tournaments worksheet.
It is self-explanatory but also include the other information to complete the Table. The Column called "Course" is just for information but can be copied from the webpage if required.
After you've added more Tournaments go to the 'TournamentsResults' worksheet, select a cell on the Table and right-click "Refresh". After a couple of minutes it will update.
Note: it takes a few minutes to update so even if your Excel says "not responding" just leave it alone and it will work fine.
You do not have the required permissions to view the files attached to this post.
-
MemphisFlash
- Posts: 2335
- Joined: Fri May 16, 2014 10:12 pm
nice work, the force is strong with you!!!
-
paspuggie48
- Posts: 737
- Joined: Thu Jun 20, 2013 9:22 am
You do not have the required permissions to view the files attached to this post.
Brilliant work again Paspuggie.
Only problem i have is i get the error below every time I try to refresh. Do i have to login to the website or something?
[Permission Error] Credentials are required to connect to the Web source. You'll need to refresh and provide credentials to continue. (Source at Https://espn.co.uk.....etc.)
Only problem i have is i get the error below every time I try to refresh. Do i have to login to the website or something?
[Permission Error] Credentials are required to connect to the Web source. You'll need to refresh and provide credentials to continue. (Source at Https://espn.co.uk.....etc.)
-
paspuggie48
- Posts: 737
- Joined: Thu Jun 20, 2013 9:22 am
Try the errors thread budMorrid4 wrote: ↑Wed Jul 17, 2024 10:11 amBrilliant work again Paspuggie.
Only problem i have is i get the error below every time I try to refresh. Do i have to login to the website or something?
[Permission Error] Credentials are required to connect to the Web source. You'll need to refresh and provide credentials to continue. (Source at Https://espn.co.uk.....etc.)
viewtopic.php?t=29223