EXCEL VBA to scrape HTML Code

[Gill Bates]

Hello all,

I have a list of stocks with each assigned a 9 digit code, and I go to a website to pull their prices.

Below is the HTML code for a particular stock's evaluation where

I need to:
1. locate "td>QB<t/d>" (which represents the Bid price)
2. Pull the price, which appears to be the next line after the QB line
3. Pull the date

Is there a way to extract that 99.92 price + the dates under QB? I will need to do this process for over thousands of securities, and if I do this manually will definitely kill me.... thank you all for the help!!!

<
td><b>Bid Price</b></td>
<
td>QB</td>
<
td >99.92</td>
<
td > </td>
<
td nowrap> </td>
<
td nowrap>7 Nov 2017</td>
<
td >BAML Bid Evaluation</td>
<

td >J</td>

 

[Gill Bates]

just checking for an update, thank you for the help