mardi 5 novembre 2019

How to extract data from web page to excel using Power query where the website has a drop down list?

I would like to extract the data tables to excel from the below two sites, but need to change the time period from the default of hourly to Daily. I can extract the hourly fine with Power Query but the web address does not change with selection change.

https://au.investing.com/technical/moving-averages https://www.dailyfx.com/pivot-points

Any help is greatly appreciated!




Aucun commentaire:

Enregistrer un commentaire