Scrap data with PowerQuery with advanced options from INVESTING.COM

i am interested in stock markets and i guess investing.com web site is the most powerfull in its area. They have many well programmed and efficient tables in site and their coverage is whole worldwide markets. So, i want to use it more efficient. What i want to get help about here is:

For example:
1- when i get the current stock prices from UK, i can set a web data query with link: "..uk.investing.com/equities/united-kingdom". And it gives me FTSE-100 stocks from its default page. But if i want to see ALL stocks prices, i must choose "United Kingdom All Stocks" option on web page's Select Box object. Then i see all stocks without any change on web address.. but in PowerQuery, nothing changes, it still gets FTSE-100 stocks. Any idea how i can get all stocks prices to my query table in excel sheet?

2- İnvesting.com values are delayed 15 minutes. For example, I can see live data on my screen from my investing bank's web page which i contracted with. Is there a way to get those live values from actual html page on my desktop screen

I searched on web about these issues and i have found some usefull articles and i can share them. I know this kind of web scrapping (especially 2nd example) needs some programming skills (little html, more Power-bi and maybe Python as best). But if there are some experienced people here who knows about these kind of issues, maybe they can give me a starting point. Thanks.

Do you need something like this?

https://www.excel.web.tr/threads/bis...rileri.169875/

.

Thanks for reply, Haluk.. i don't see any detailed information about your excel file in that link.. i see an animated gif which shows your file gets BIST-100 stocks values only.. And i dont know if they are live values or not.. i have already got my own excel file including my personalised vba codes to get data from web.. But my point is different:

- main link: "tr.investing.com/equities/turkey". When i create a web query with this link, i can get BIST-100 stock values. But i want all shares not only 100..
- on web page, i must choose "all stocks" from SELECT BOX, then i can see all shares.. But i can not transfer those all shares to my excel sheet..

Anyway, i wish to be connected for inspecting your excel file..
Selamlar.. Regards..

Added sample file can get data from UK Stock Markets (FTSE-100, FTSE-250 or all stocks). Any other country is possible. Only need to change source link.
This code uses iexplorer object not power query. Its quite good but slow.
And i think when i create a special iexplorer object to login my investing bank account, then i can get live values by this way.