This project must be completed within 36 hours.
We need a tool which can gather Stock related data from Yahoo Finance and Nasdaq websites.
The tool should be standalone excel application.
Input will be Stock symbol. And accordingly tool should fetch data from the yahoo finanace website like Market Cap, Enterprise values, Dividend yield etc . And then a couple of data points from the Nasdaq website
1. Market Cap in $millions
2. Enterprise Value in $millions
3. After-Tax Profits Most Recent 4 Quarters 1 in $millions
4. After-Tax Profits Most Recent 4 Quarters 2 in $millions
5. After-Tax Profits Most Recent 4 Quarters 3 in $millions
6. After-Tax Profits Most Recent 4 Quarters 4 in $millions
7. Revenue Most Recent 3 Years 1 in $millions
8. Revenue Most Recent 3 Years 2 in $millions
9. Revenue Most Recent 3 Years 3 in $millions
10. Dividend Rate in percentage to one decimal point. For instance: 3.2%
11. Net Insider Sales Last Qtr in total shares - from Nasdaq
12. Net Insider Sales Last 4 Qtrs in total shares - from Nasdaq
The data will be character form – not graphically represented – so that they can be included in equations.
We will provide the initial spreadsheet with approximately 4300 stock symbols, and the system will work with up to 7000 stock symbols. We should be able to add or delete symbols to the spreadsheet.
In the event of blank or inaccurate data:
· If the stock symbol is bad or no longer exists (for example, the company has been sold), We should be able to update the spreadsheet.
· If a whole column of data is bad, you will address the data source or coding problem within one week.
· If a stock exists, but has difficulty with certain data points, you will allow notes by us in column C that alert the operator to manually update those data points. For instance: 5,8, 15 will mean that this stock manual updates for columns 5, 8 and 15.
All dollar values will be saved as millions. For instance: $300,000 = $ 0.3; $25 million = $ 25; $5.678 billion = $ 5678 A consistent format is important when applying our equations.
Hello Sr., how are you ?
Jorge is my name and I have wide experience doing scrapes using different tools.
Would be great to have the websites you need to collect the data from and explain me how to find that data in a simple flow detail. Then, I'll study if I'm able to build a Macro with Excel to get that working for you. Message me.
Several scrape jobs done, accessing different and easy, middle and complex websites. I use private proxies -not free!- to access some difficult webpages (if required).
You can visit my Portfolio to know my last jobs regarding these skills, the reviews received from clients and as you can see, a higher percentage of jobs completed.
i'm interested to help you on this particular project.
What I prefer is to discuss with you more in detail all your terms and I'll give you a better proposal.
No more Sr.; contact me if you'd like it.
Regards.
Jorge.
P.S.: I will not accept any award before to discuss with you all the details needed.