Forum Discussion
Excel Get Data from Web Timeout
I posted the following message in the Microsoft Community forum and got routed here because of the Power-Query related problem. It was suggested that the connection timeout might be related to the we...
I don't think that video will help as it looks like it's about getting data from 'regular' websites i.e. those that don't implement anti-scraping technology or use JavaScript to load pages
Even using a scraping proxy like ScrapingBee doesn't work. Companies like this live off the data they provide so they don't want people scraping their web pages.
If you check their terms it's even explicitly stated that scraping is forbidden (under Prohibited Uses) Market Data Explanation and Disclaimer
use of any Web browsers (other than generally available third-party browsers), engines, scripts, software, spiders, robots, avatars, agents, tools or other devices or mechanisms (such as crawlers, browser plug-ins and add-ons, or other technology) to navigate, access, copy in bulk, retrieve, harvest, index, search or analyze any portion of the Website is strictly prohibited.
Regards
Phil