Job finished
Execution time 4 days
Feedback from employee
Nice client
Specification
There is one excel file. Within this file there are sheets where data from one broker are shown in one sheet, another broker in another sheet.
The goal is to get the totals of “Buy Lots”, “Sell Lots”, and “Profits” of all open pairs, from all sheets into one main "TOTALS" sheet. This "TOTALS" sheet is within the same Excel file.
“Buy Lots”, “Sell Lots”, and "Profits" columns in "TOTALS" sheet sum all respective pairs - see my attachments.
With Regards.
Files:
Oanda.jpg 342 kb
NordFx.jpg 264 kb
Broker3.jpg 345 kb
TOTALS_working.jpg 158 kb
TOTALS_final_look.jpg 150 kb
Responded
1
Rating
Projects
15
60%
Arbitration
2
0%
/
100%
Overdue
5
33%
Free
2
Rating
Projects
9
44%
Arbitration
0
Overdue
0
Free
3
Rating
Projects
210
40%
Arbitration
90
20%
/
43%
Overdue
85
40%
Free
4
Rating
Projects
367
56%
Arbitration
45
22%
/
56%
Overdue
188
51%
Free
Published: 1 article, 6 codes
5
Rating
Projects
1062
50%
Arbitration
39
28%
/
41%
Overdue
49
5%
Working
Published: 1 article, 8 codes
6
Rating
Projects
15
47%
Arbitration
6
33%
/
17%
Overdue
4
27%
Free
Project information
Budget
50 USD
Deadline
from 2 to 7 day(s)