Stock Data Analysis in Excel
Budget: £250 – £750 GBP
I'm in need of your expertise in consolidating and analyzing stock market data within an Excel spreadsheet.
Subsequently, I have a monthly set of data in a spreadsheet. I need separate sheets build from this master set of data for groups in terms of sector and sub sector. Build a formula to look at sector and subsector averages, the highlight the stocks using green and red. Green for positive outliers and red for negative outliers,
The ideal freelancer for this project would have proven experience in financial data analysis and a strong command of Excel. Knowledge of the stock market or finance is a significant advantage. Ability to interpret data and present it in a clear, concise manner is a must.
Its a relatively straight forward to do. Once you build a sheet with the correct formula for 1 sector/subsector it can just be copied. I'm happy to walk through in more details whats required,
Subsequently, I have a monthly set of data in a spreadsheet. I need separate sheets build from this master set of data for groups in terms of sector and sub sector. Build a formula to look at sector and subsector averages, the highlight the stocks using green and red. Green for positive outliers and red for negative outliers,
The ideal freelancer for this project would have proven experience in financial data analysis and a strong command of Excel. Knowledge of the stock market or finance is a significant advantage. Ability to interpret data and present it in a clear, concise manner is a must.
Its a relatively straight forward to do. Once you build a sheet with the correct formula for 1 sector/subsector it can just be copied. I'm happy to walk through in more details whats required,