Excel- Combining Reports & Formatting Comparison Spreadsheet

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. 

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel

Lihat lagi: bid comparison spreadsheet excel, excel spreadsheet formatting, quarterly comparison spreadsheet, master excel, row spreadsheet, reports in excel, fill in spreadsheets excel, excel reports, data formatting, excel row column, net spreadsheet, data fill excel, excel column row, drawdown, column row excel, excel fill, profit amp loss, FILL DATA SPREADSHEET, creating spreadsheets, entry trades excel, data entry folders, net reports, fill excel spreadsheet data, columns excel, profit spreadsheet

Tentang Majikan:
( 0 ulasan ) Colombo, Sri Lanka

ID Projek: #1541573

10 pekerja bebas membida secara purata $154 untuk pekerjaan ini


Ready to [url removed, login to view] on similar type of [url removed, login to view] it done perfectly on [url removed, login to view] check PMB

$250 USD dalam 5 hari
(17 Ulasan)

Hi, Check PMB

$200 USD dalam 15 hari
(2 Ulasan)

I know the excel macro. Think we can do it via the automation process.

$150 USD dalam 20 hari
(0 Ulasan)

Iam expert in excel and excel vba. I assure you that work will be done one time with professional look and 100% accuracy, Kevin

$30 USD dalam 5 hari
(0 Ulasan)

Please check PMB

$30 USD dalam sehari
(0 Ulasan)

Interested in your project

$50 USD dalam 5 hari
(0 Ulasan)

lets start

$200 USD dalam 20 hari
(0 Ulasan)

please check pm

$150 USD dalam 7 hari
(0 Ulasan)

expert in excel

$250 USD dalam 3 hari
(0 Ulasan)

proficient with excel. Can handle this project and in a position to start with an immediate effect. Moreover the requirement which you have posted is very confusing. We can have a detailed discussion on this once yo Lagi

$225 USD dalam 14 hari
(0 Ulasan)