Pull Data from Dynamically Created Table on the Web

[studious]

Hi all,

First time poster, so excuse me if I've made a mistake anywhere.

I would like to pull house price data from imot.bg. The normal Excel web query doesn't work because the table is created dynamically (javascript). I would like to automate the process if possible because each table contains weekly data and I need to pull them for the last couple of years.

The closest I came to an answer was this thread. However, the suggested VBA code didn't work or more likely I don't understand it well enough to adapt it to my case.

Would appreciate it if someone has a suggestion.

I am running Excel 2013 on Windows 10.

To generate the table that I need follow the screens.

 

[HolyExcel]

try with power query...query from web

should work fine here
BR

 

[studious]

Thanks. I tried it, but it shows only the tables on the home page, not the one I need to access. Maybe because there is no direct path to it?