A PQ Excel version of the gg.co.uk Free Tips, NAP, Double, Treble, Lucky 15 & Outsider, should it be of help to anyone?
NOTE: To update each day go to your Data tab then click on "Refresh All"
Power of Power Query - Daily Tips
- paspuggie48
- Posts: 674
- 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.
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Power Query Daily Tips, comprising of the following: -
Tips for each race
NAP
Double
Treble
Lucky 15
Outsider
To update the data each day select: Data Tab > Refresh All
Tips for each race
NAP
Double
Treble
Lucky 15
Outsider
To update the data each day select: Data Tab > Refresh All
Not working for me - server returns a 503 error.
They appear to be hosted on Cloudflare and have anti-bot/scraper measures in place.
Can connect ok via Chrome but there's some sort of checking/handshaking going on which causes the server to reject the connection.
Any ideas welcome - I found the same problem arises trying to scrape directly with .net :/
They appear to be hosted on Cloudflare and have anti-bot/scraper measures in place.
Can connect ok via Chrome but there's some sort of checking/handshaking going on which causes the server to reject the connection.
Any ideas welcome - I found the same problem arises trying to scrape directly with .net :/
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
I see what you mean Foxwood. I too can get to the website with Chrome but get the same error with the PQ.
I'll try again later but it might be just that it has some sort of blocker for scraping. I know I came across this once with a Snooker site, which wasn't exactly top secret stuff but alas it blocked me at the time after 1 scrape...some sites have this employed obviously.
I'll try again later but it might be just that it has some sort of blocker for scraping. I know I came across this once with a Snooker site, which wasn't exactly top secret stuff but alas it blocked me at the time after 1 scrape...some sites have this employed obviously.
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Alas....I'm afraid, no
There is a blocker from accessing the data, which is kinda shit as it's a non-subscription site and the data is free to view.
You do not have the required permissions to view the files attached to this post.