Bubbledoms

Get the stock list from following link (all pages) : [login to view URL] Go to Yahoo finance and retrieve following info for each stock and show them on an Excel sheet and make it update every week or any other interval. Each item below will be a header and sortable per each column. Yahoo Finance: From Summary Page: ​​ ​1- ​52wk Range ​2- ​Current Price ​3- Beta​ From Key Statistics Page: 4- Total Cash (mrq): ​5- ​Total Debt (mrq): ​6- ​Shares Short ​7- ​Shares Short (prior month) From Income Statement page​: ​8- ​Annual Total Revenue​ ​for past three years​ (This will be three columns)​ ​9- ​Net Income Applicable To Common Shares​ ​for the past thee years​ (This will be three columns)​​ ​10- ​Interest Expense​ ​for the past three years​ (This will be three columns)​​ Analyst Opinion​ ​Page​: ​11- ​Mean Recommendation (this week): ​12- ​H​​igh Target: ​13- ​Low Target