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, Excel, Format & Susun Atur

Lihat lagi: 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, spreadsheet net, quarterly comparison spreadsheet, spreadsheet fill

Tentang Majikan:
( 3 ulasan ) Houston, United States

ID Projek: #1540811

Dianugerahkan kepada:


Hi, I made my formal bidding in a private message with this. Regards, Mayeen

$120 USD dalam 4 hari
(4 Ulasan)

30 pekerja bebas membida secara purata $160 untuk pekerjaan ini


Excel expert at your service. Check your inbox for details.

$250 USD dalam 4 hari
(205 Ulasan)

lets start .. check pm .. thx

$150 USD dalam 7 hari
(179 Ulasan)

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$250 USD dalam 7 hari
(67 Ulasan)

Hello. We are experts in Word\Excel\Access based projects. Please check your PMB for examples.

$240 USD dalam 5 hari
(21 Ulasan)

Hi, Please have a glance at PMB.

$50 USD dalam 2 hari
(40 Ulasan)

Please see more details on PMB. Thanks

$225 USD dalam 6 hari
(28 Ulasan)

Expert here.. Please check PM..

$60 USD dalam 3 hari
(29 Ulasan)

Hi.... I am a Certified Professional(Equivalent to CPA).

$200 USD dalam 7 hari
(13 Ulasan)

Hello, I am an MS Excel expert. I will be able to do what you ask. I am a new freelancer but please consider me for the role. Thank you.

$75 USD dalam 2 hari
(1 Ulasan)

Hello Sir, I've read your requirements and ready to start.

$200 USD dalam 6 hari
(5 Ulasan)

Hi, I would like to bid on your project as I similar work experience before. Please check PM for further on the bid. Regards

$80 USD dalam 3 hari
(7 Ulasan)

Dear Sir Please see your personal message for my bid details

$100 USD dalam 3 hari
(4 Ulasan)

I have excellent knowledge of excel & access , sql server. I can do this job. just send some trial work.

$180 USD dalam 5 hari
(1 Ulasan)

Excel-VBA Experts are ready to start immediately. Please share the files/ sample files

$200 USD dalam sehari
(3 Ulasan)

Hello, Sir. How are you? I have over 10 years of Office vba programming and especially in excel vba programming. Also I have many experiences in plugin programming. I have developed many excel vba and plugin p Lagi

$150 USD dalam 3 hari
(1 Ulasan)

I am writing to express my interest in your current opening. Having over 10 years experience in data entry, I strongly believe I can make a significant contribution.

$150 USD dalam 7 hari
(0 Ulasan)

I'm ready to start and very collaborative. Your instructions seem thorough and clear. I value and deliver high standards. Thanks.

$110 USD dalam 2 hari
(0 Ulasan)

hey i am a new freelancer and would like to start my work with this project. i am a computer science engineering student and know excel so i can do it.

$172 USD dalam 7 hari
(0 Ulasan)

I will do this project to my employers satisfaction

$150 USD dalam 5 hari
(0 Ulasan)

I am a Business Data Analyst with ample experience in working with multi-file Parent-Child dashboards. I can deliver your results and give you the tools and/or information needed to complete this task in the future. Lagi

$250 USD dalam sehari
(0 Ulasan)