Stock selection with progrmming

This is a program to select few stocks from the market with the help of an Algorithm. Time period of the project will be 1 week. Milestone1 (initiation): There is a list of NSE 500 (this is a list of top 500 companies listed in NSE) [login to view URL] There is another list of companies with RSI below 30 (RSI is just an index, [login to view URL],exchange-50,pageno-1,sortby-volume,sortorder-desc,indexid-2365,company-true,[login to view URL]) on the website etmarket. Program will feed NSE500 through excel which user have on his computer (or can download from the link given above) and it will go online to etmarket and will take list of RSI below 30 and will show companies common in both the list by compiling results in another excel. I dont mind if you use web tools like [login to view URL] etc to extract data from web. Milestone2: After the common stocks are selected, the program will go to another website, [login to view URL] and will enter those common company names one by one and will check Market Cap, Current Price, Book Value and Return on Equity for 10,5,3 years. Then there will be a calculation: Today’s Value= Market Cap*Book Value/Current Value This value will be shown as a result along with return on equity for 10,5,3 years from the website. All these results will be compiled in excel sheet. Milestone3: After previous job, the program will go to another website, [login to view URL], and will enter company name one by one. There in the financials and key ratio tab, it will check free cash flow of the final year and will do the following calculation: Total Value=Free cash flow*10+Today’s Value Ratio= Market cap/total value These values will be shown in the same excel. With these there will be few other values which will be directly taken from the same website and will be shown in the excel, like Free cash flow of 10 years, Free Cash Flow/Sales %, Free Cash Flow/Net Income, Debt/Equity which are available on the same page in different tabs.