VBA: Changing Daily Data to Monthly Delta Data
Budget: $10 – $30 AUD
I need a developer to develop a Excel macro script using VBA. The following criterias are required for the function of the macro:
1. Able to read and extract data files similar to the one attached (XJO.csv)
2. Process and output the input data (XJO.csv) into a new tab called "Analysis Output_XXX" with XXX being the file name, i.e. Analysis_Output_XJO
3. The "Analysis Output" tab should contain the following data structure:
- "Month" Column that only shows each month of each year based on the input data
- "Close" Column after "Month" that shows the "Close" data of the last day of the month based on the
associated "Month"
- "Delta" Column that takes the differences between the "Close" Column data of each month and compare it
to that of the previous month
4. The macro shall be able to output multiple tabs (based on the above criterias) if multiple files are given as
an input
**The VBA code needs to be shown and shared as part of the final result.
1. Able to read and extract data files similar to the one attached (XJO.csv)
2. Process and output the input data (XJO.csv) into a new tab called "Analysis Output_XXX" with XXX being the file name, i.e. Analysis_Output_XJO
3. The "Analysis Output" tab should contain the following data structure:
- "Month" Column that only shows each month of each year based on the input data
- "Close" Column after "Month" that shows the "Close" data of the last day of the month based on the
associated "Month"
- "Delta" Column that takes the differences between the "Close" Column data of each month and compare it
to that of the previous month
4. The macro shall be able to output multiple tabs (based on the above criterias) if multiple files are given as
an input
**The VBA code needs to be shown and shared as part of the final result.