Dear Friends,
I wish to extract some data from stock market webpages. I have around 20 - 25 stocks listed in column A and their URLs in column B. I am trying to extract the trigger price, target and stop loss for both buy (green) and sell (red). Attached image of my excel sheet. I am able to connect to the page using below code but not sure how to workaround with those innertexts and html to get my output as I am encountering lot of issues inside the Do Until Loop.
Appreciate if I can get a start here so that later i can try to extract more values that I want.
Here are sample 3 urls
http://www.premarkettips.com/sector-...2=equitiesdata
http://www.premarkettips.com/sector-...2=equitiesdata
http://www.premarkettips.com/sector-...2=equitiesdata
Bookmarks