Here is the task:
1. Go to [url removed, login to view]
2. Select month and year (Start at March 2013 stop at March 2017)
3. Select Representative Rates for Selected Currencies
4. Click on Get report at the bottom
5. Download the data by clicking on TSV
6. Delete unnecessary information and manipulate the data so that the excel spreadsheet is exactly like the example attached.
7. Save the file as an xls (excel 97-2004) file and name it 'MMYYYY' (eg. March 2013 = '032013'.
20 freelancers are bidding on average $28 for this job
Hello, I have sound knowledge of finance and accounting. I've downloaded such data many times. I can provide you aligned excel sheet as per requirements in short time. Thanks.