The Power of Power Query

[Cardano]

Could you please send me a copy of the spreadsheet.

[paspuggie48]

Could you please send me a copy of the spreadsheet.

Might need to do some screenshots and instructions as I use this downloader daily. I have modified it for my purposes and will have to explain how/why.

DM your email cardano

[murdok]

already sent my email by mp

and thx

[paspuggie48]

already sent my email by mp

and thx

To be honest, it may be easier if you download NigelK's original file as I have doctored my copy to suit me

viewtopic.php?f=54&t=14395

I'll work on my version and get some instructions drafted as it differs quite a lot

[paspuggie48]

Could you please send me a copy of the spreadsheet.

As above Cardano

[mgrant]

Hi
I think I have got the hang of PQ but how does the web scraping aspect work.In particular the scrape for greyhound stats
Thanks
granty

[paspuggie48]

Hi
I think I have got the hang of PQ but how does the web scraping aspect work.In particular the scrape for greyhound stats
Thanks
granty

As everything with Microsoft there are many ways of scraping website data with their internal tools, some very basic but it can get advanced.

With PQ one would use the option below: -

Screenshot 2021-06-14 172603.png

One then needs to go into the Editor and drill down into the Tables. It's almost impossible to explain on a thread but a typical advanced example would be here: -


viewtopic.php?f=31&t=22493