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.
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
I can create the desired stock screener. Infact I have done several similar projects here on freelancer itself as you would see in my work history.
Relevant Skills and Experience
Excel/VBA
Proposed Milestones
₹27777 INR - Creation of Desired Screener
Please send a message to me and we may discuss the next steps.
Best Regards,
Rishi
Hi!
My name is Tomasz Kustra, and I am from Poland.
I am interested in this project.
I have plenty experience with gatherning data from web:
http://www.freelancer.com/u/tomkusvw.html
Relevant Skills and Experience
As you can see I have successfully completed few similar projects.
I am sure, that you will be glad of my work if you choose me.
With Best Regards
Tomasz Kustra
Proposed Milestones
₹6500 INR - milestone1
₹6000 INR - milestone2