My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

need to copy historical data from this link |General Excel Questions & Answers|Excel Forum|My Online Training Hub

You are here: Home / need to copy historical data from this link |General Excel Questions & Answers|Excel Forum|My Online Training Hub

vba course banner

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
need to copy historical data from this link
Avatar
faha thamer

New Member
Members
Level 0
Forum Posts: 2
Member Since:
October 15, 2020
sp_UserOfflineSmall Offline
1
October 15, 2020 - 11:07 am
sp_Permalink sp_Print

How can I import the historical data as it is from this page  to excel automatically with this link:

https://www.tadawul.com.sa/wps.....UREAVqe_kw!!/#chart_tab2

 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 
sp_AnswersTopicSeeAnswer See Answer
Avatar
Philip Treacy
Admin
Level 10
Forum Posts: 1529
Member Since:
October 5, 2010
sp_UserOfflineSmall Offline
2
October 15, 2020 - 1:04 pm
sp_Permalink sp_Print

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 with VBA

Web scraping multiple pages

Web scraping - Filling in forms

Regards

Phil

sp_AnswersTopicAnswer
Answers Post
Avatar
faha thamer

New Member
Members
Level 0
Forum Posts: 2
Member Since:
October 15, 2020
sp_UserOfflineSmall Offline
3
October 15, 2020 - 11:10 pm
sp_Permalink sp_Print

Thanks a lot Philip. 

Avatar
Philip Treacy
Admin
Level 10
Forum Posts: 1529
Member Since:
October 5, 2010
sp_UserOfflineSmall Offline
4
October 20, 2020 - 11:10 pm
sp_Permalink sp_Print

You're welcome.

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Alain Balken
Guest(s) 12
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 216
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Melanie Ford
Isaac Felbah
Adele Glover
Hitesh Asrani
Rohan Abraham
Anthony van Riessen
Erlinda Eloriaga
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Forum Stats:
Groups: 3
Forums: 24
Topics: 6356
Posts: 27793

 

Member Stats:
Guest Posters: 49
Members: 32324
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen