[µo°Ý] How to scrape this website dynamic data from Javascript with VBA? VBA, data scraping, javascript

DanielWONG

Website: https://www.hangseng.com/en-hk/personal/insurance-mpf/e-mpf/fund-price-performance/

Targets of automate data scraping: fund price as highlighted in the below figure

¤U¸ü (111.61 KB)
target data

2022-11-19 16:41

Tools: VBA(Excel), Chrome driven by Selenium

The code started as below:

1. Chrome.ExecuteScript "window.open('https://www.hangseng.com/en-hk/e-services/e-mpf/fund-price- performance/price/','_blank');"
   
2. 
   
3. Chrome.SwitchToNextWindow
   
4. 
   
5. Chrome.FindElementByXPath("//a[text()='Acknowledge']").Click

½Æ»s¥N½X

Then I have no further idea to retrieve those specified data. Please provide help. Thanks a lot!

DanielWONG

¦^´_ 2# singo1232001


  The code is very simple , but very productive!
There are also two questions:
1)

1. Set A_s = chrome.FindElementsBytag("a")
   
2.     For i = 1100 To A_s.Count

½Æ»s¥N½X

Only 139 "<a" tag can be searched in the website source code, what is the meaning of 1100 here?

2)  for another website http://www.aastocks.com/tc/stocks/quote/detailchart.aspx?symbol=110000
It is possible to extract the highlighted RSI data ?

¤U¸ü (69.87 KB)

2022-11-20 10:45

Thank you very much!

DanielWONG

Thanks a lot! I found if  I  switch to this OCR site https://ocr.space/
The code should works well.
Respect for your nice work!

¦^´_ 6# singo1232001