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) [url removed, login to view] There is another list of companies with RSI below 30 (RSI is just an index, [url removed, login to view],exchange-50,pageno-1,sortby-volume,sortorder-desc,indexid-2365,company-true,[url removed, login to view]) 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 [url removed, login to view] etc to extract data from web.
Milestone2: After the common stocks are selected, the program will go to another website, [url removed, login to view] 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, [url removed, login to view], 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.
8 freelancers are bidding on average ₹11840 for this job
I am an expert in delivering custom scripts and softwares willing to discuss further details Relevant Skills and Experience proven track record on this site Proposed Milestones ₹12222 INR - milestone