There are several 4 folders. Within each folder, there are Quarterly Reports for the last 10 years. I need certain data from each of these Quarterly reports combined in to one Master spreadsheet for each folder. I will go into more detail about the data that needs to be extracted and combined on to one Master spreadsheet with the winner of the bid as it may be confusing to describe here.
Once the data is combined, I need every other week highlighted. The date ranges are provides in a separate spreadsheet that is designed to be a side by side comparison.
A column titled "Total Net Profit" needs to be created which literally taken 30 seconds to do.
I also need to know run ups and drawdowns. If there are several profitable trades in a row, I need that added up in the "Runup" Column. If there are several losses in a row, I need that added up in the "Drawdown" column.
All the data described above will be used to fill in the blanks on the Comparison Spreadsheet.
For the Comparison Spreadsheet, a tab has been created for each month. Within each monthly tab, you will see the weekly date ranges for the last 10 years for that month.
For each of the 4 Master spreadsheets just created (the 5th one is already completed), I need a sum for the date ranges provided under the columns titled "Gross...". The amount used in this column is found in the spreadsheet you are creating titled "Profit/Loss." This spreadsheet can be formatted any way that makes the extracting the sums from the other spreadsheets easier as there may be an automated way of completing this.
I will take care of the rest of the spreadsheet.