I am looking for someone with access to Capital IQ. If you do not have access to Capital IQ, please do not apply for this job.
I have developed some spreadsheets that store historical stock information for many stocks on the Italian stock exchange. I have some of the functions already built and need the rest of the spreadsheet populated for the entire Italian stock exchange.
See attached for an example of what I am after:
- "List" tab: I need this entire list to be updated for all stocks on the Borsa Italiana as at 31 Dec 2017.
- "CapIQ Formulas" tab: I need this entire sheet to refreshed for all stocks listed on the Borsa Italiana. All the formulas have already been input and don't need to be recreated. Anyone with basic excel skills will be able to copy/paste and repeat the formulas very quickly.
- "CapIQ Formulas - Value pasted" tab: Copy and paste values of all the data in the previous tab - "CapIQ Formulas"
More work will be available if you do a good job on this.