This simple Power Query solution extracts the Racing Post Summary it has for every horse racing in UK & IRE on the day.
Basically it extracts all the URLs for each race
Once it has the URL for every race, it looks for each Racing Post comment for every horse, adds the relevant other columns of data and then combines accordingly.
To update select any cell on the Table and right-click "Refresh"
Note: it does take 2-3 minutes to refresh.
Note: if a horse has no comment it is more than likely a NR
Power Query - Racing Post Summary
- paspuggie48
- Posts: 649
- 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.