Prepare Excel Template for Evaluating Stocks Data
Budget: ₹600 – ₹750 INR
a) Structured Data will be provided in csv file. Could be modified to excel if suits better in further tasks.
b) Develop excel that uses csv files provided and compute (formulas will be provided) and provide multiple time-frame based cuts/view of the data. It needs to have predefined timeframes and also ability to select specific ‘from and to’ time period. For each csv file there would be corresponding excel sheet in the format stated above and summary of the page will be consolidated in to one excel as dashboard.
c) Prepare a dashboard/comparative table of the above data for analysis (as mentioned above)
d) All analytical reports should be page aligned for appropriate pdf printing.
e) Any other ideas the developer may have for better data analysis and presentation are appreciated
b) Develop excel that uses csv files provided and compute (formulas will be provided) and provide multiple time-frame based cuts/view of the data. It needs to have predefined timeframes and also ability to select specific ‘from and to’ time period. For each csv file there would be corresponding excel sheet in the format stated above and summary of the page will be consolidated in to one excel as dashboard.
c) Prepare a dashboard/comparative table of the above data for analysis (as mentioned above)
d) All analytical reports should be page aligned for appropriate pdf printing.
e) Any other ideas the developer may have for better data analysis and presentation are appreciated