VBA for HTML Table Data Parsing

[VB2Learn]

Dear members - I'm need of your assistance in writing a vba macro to extract the below information from the referenced site. Your assistance will be much appreciated. My knowledge to Vb is very limited.

I need to pull the following information from the website to excel sheet. The URL is options education dot org.

[TABLE="width: 100%"]
<tbody>[TR="class: s1, bgcolor: #cccccc"]
[TD]Price[/TD]
[TD]Change (%)[/TD]
[TD]52 wk High[/TD]
[TD]52 wk Low[/TD]
[TD]Stock Volume

[/TD]
[TD]Avg. options volume

[/TD]
[TD]Avg. options open interest

[/TD]
[/TR]
</tbody>[/TABLE]

 

[mole999]

not sure of which page you are looking at but have you tried

fresh worksheet

Data Tab > From Web,import the web location, tick the boxes that have a table option for what you want, and import

from properties you can say how often you want it to refresh

 

[VB2Learn]

Thank you for your response. I'm looking for optionseducation dot org. I'm trying to retrieve the above referenced table. seeking to automate this with macro instead webquery. Any suggestion how can fetch this information from the web page.