Extract data from web page

[sabha]

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

Sub Test()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
With IE
.Visible = False
.navigate "http://www.premarkettips.com/sector-wise-info.php?cname=AXISBANK&tablename=equities&tabledata=data&table2=equitiesdata"
Do Until .readyState = 4: DoEvents: Loop
    ...
    ...
    ...
    ...
    .Quit
End With
End Sub