Macro to retrieve value in columns from a website (ASP.NET)

[confusedpiper]

This is the website: mwatch.boursakuwait.com.kw

I uploaded my Excel spreadsheet here: https://ufile.io/gokit

it's a stock market portfolio (I'm getting destroyed). I'd like to update the "curr. price" column automatically.

The macro should look up each "Code" (Col J:J), retrieve it's corresponding "Current price" from the website, and update the value in (Col M:M).

I'm not a programmer and I don't know where to start. Can anyone help me?

Thank you.


EDIT: I'd like to add that you have to click "All Shares" on that website to see the details.

 

[confusedpiper]

Bump

 

[John_w]

Cross-posted. Please post links to your cross-posts on other forums.

 

[confusedpiper]

X-Post to "Excelforum.com"

https://www.excelforum.com/excel-pr...-data-from-a-website-asp-net.html#post5033497

 

[confusedpiper]

Help