Power of Power Query - Daily Tips

[paspuggie48]

A PQ Excel version of the gg.co.uk Free Tips, NAP, Double, Treble, Lucky 15 & Outsider, should it be of help to anyone?

Daily Tips.png

Daily Tips.xlsx

NOTE: To update each day go to your Data tab then click on "Refresh All"

[paspuggie48]

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

[foxwood]

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 :/

[paspuggie48]

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.

[stever78]

Hello PasPuggs and all.

Is there any chance of this one being brought back from the dead !!!.

I have just downloaded but i think source is still blocking. Any quick work around known ?????

cheers

[paspuggie48]

Hello PasPuggs and all.

Is there any chance of this one being brought back from the dead !!!.

I have just downloaded but i think source is still blocking. Any quick work around known ?????

cheers

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.

Capture.PNG

[stever78]

agreed, weird really, as you say its a free site. but there you go thanks for checking.