Serving the Quantitative Finance Community

 
volunteer
Topic Author
Posts: 1
Joined: August 22nd, 2020, 10:16 pm

VBA + Selenium

August 7th, 2022, 5:17 am

OK, I admit defeat.
The answer must be easy, but is escaping me.

I want to obtain the price of the 'front' corn futures from www.cmegroup.com  main page.
This seems straightforward using SeleniumBasic and VBA.
However, I've tried searching "ID", "TAG", "CLASS", etc etc and cannot find the right combo.
It seems those items that look like tags, id's, classes, links, etc are not accessible - even though I can see them when inspecting the page.

Help?
 
 
User avatar
tags
Posts: 3162
Joined: February 21st, 2010, 12:58 pm

Re: VBA + Selenium

August 10th, 2022, 3:42 pm

hello Selenium seems overkill no?
i mean the data are refreshed/delivered via their API. it is all there, clean, behind the scene.
A note of warning maybe, if you read the Terms of Use you'll probably see CME doesn't like people to extract content from their website.

Image

BTW what is that ags project you're working on?
Best.