Web query for stock data

I Need to Insert data from this web link.
Data Tab --> New Query --> From Other Sources --> From Web.

www investing com/equities/united-states

by default it selects ' Dow Jones Industrial Average ' but I need to get 'United States all stocks'

www youtube com/watch?v=qfsjSwEytFg

I create a video about this problem. please watch that video.

Hi sankeepan,

I tried to do this problem a few years ago and failed. You can't just put a different URL in your search and have that dropdown work as it is a Java Script that is extracting the stocks, not the URL. Thinking about it again I watched a Power Automate video that might help at: https://www.bing.com/videos/search?q...EA75&FORM=VIRE

The question is if Power Automate can select that dropdown and change it. I don't know..

The next chance is to view the HTML code using Edge and the "Inspect" window to see if you can change the script from the dropdown there.
https://learn.microsoft.com/en-us/mi...um/css/inspect

The last place I'd be looking is in a VBA code that might be described at:
https://chandoo.org/forum/threads/vb...n-index.37707/

I hope one of the smart gurus can come up with an easier answer.

Hi,

Another possibility would be to use Excel Data Types and have a list of symbols build in an Excel file already. See:
https://support.microsoft.com/en-us/....%20See%20More.

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...-from-web.html