Extracting Data: ICE Exchange Code from a 63 page table

BruceWillis

Hey Guys,

I am looking to try and extract all Exchange codes and details from: https://www.theice.com/products

This has 63 pages that I have to manually select through and copy and paste ... I like to extract the table compete (retaining the hyperlink for product description) does anyone know how to achieve this? 

Would be amazing if anyone can help ... my boss is chasing me 😉

Bruce

TrevorS

Hello @BruceWillis 

You can do this for sure in Alteryx. I would try using the link below as a starting point.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Web-scraping/td-p/505335

You will need to look through the data afterward to determine which columns you need to keep, then you should be able to clean it up and pull only whats necessary.

I hope this helps get you going in the right direction!

TrevorS