Project requires coding to be written and only based in Excel, using VBA/Macros etc to complete the data entry project. The code is required to look up and enter data extracted from [login to view URL] and other sources into a spreadsheet. The spreadsheet is essentially a stock screener with a number of financial details. The code should allow the user to obtain all the financial data for the listed stocks quickly and easily and in a robust fashion (i.e. hard to break/easy to use). Where errors may occur in the future it would be appropriate for the user to be notified of an error, so that they can take action before proceeding with using the data.
An excel template is attached as well as a Word document describing how the data is extracted from the websites (in a manual way rather than automated), and what steps to follow. If any steps are unclear in the document the freelancer should communicate with me and I will advise how to proceed.