Notifications
Clear all
General Excel Questions & Answers
4
Posts
2
Users
0
Reactions
92
Views
Topic starter
How can I import the historical data as it is from this page to excel automatically with this link:
I tried a lot using by using:
Data >>New Query>>from other source >> from web page
But the historical data for 30 days does not appear
please any support.
thanks
Posted : 15/10/2020 9:07 pm
Hi Faha,
PQ won't be able to get that data because the data is generated by JavaScript and isn't stored in a <table> element on the page.
You'd need to use VBA to scrape the page for what you want. These articles explain the process.
Web scraping - Filling in forms
Regards
Phil
Posted : 15/10/2020 11:04 pm
Topic starter
Thanks a lot Philip.
Posted : 16/10/2020 9:10 am
You're welcome.
Posted : 21/10/2020 9:10 am
