If the script doesn't run you prob. need to install these modules
pip install pandas
pip install requests-html
pip install openpyxl
Just run the script and it will take all the data from http://www.wsj.com/mdc/public/page/2_3062-shtnyse_S-listing.html and add it to an excel file