Ditutup

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 lebih lanjut: 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 freelancers are bidding on average $154 for this job

shanki161

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)
4.9
PG89

Hi, Check PMB

$200 USD dalam 15 hari
(2 Ulasan)
1.6
sathishhariharan

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

$150 USD dalam 20 hari
(0 Ulasan)
0.0
kevindelhi

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)
0.0
cstwitterffbfnsg

Please check PMB

$30 USD dalam sehari
(0 Ulasan)
0.0
mlpraveena

Interested in your project

$50 USD dalam 5 hari
(0 Ulasan)
0.0
engr321

lets start

$200 USD dalam 20 hari
(0 Ulasan)
0.0
ctguxp

please check pm

$150 USD dalam 7 hari
(0 Ulasan)
0.0
shafin132

expert in excel

$250 USD dalam 3 hari
(0 Ulasan)
0.0
suvam123

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)
0.0