Create an Excel and a csv file, by extracting data from a web site.

Your task is to deliver an Excel file by extracting data from: [login to view URL] Your file will include the following columns: 1 Index Name 2 Asset Class 3 Theme 4 YTD Change (%) 5 Sub Asset Class 6 Developed / Emerging / Frontier 7 Geography 8 Sub Geography 9 Sector 10 Sub Sector 11 Size/Style 12 Sub Size/Style 13 Index Currency How to extract ============= 1. Go to that URL. 2. Select check boxes criteria on the left side. 3. Some data rows should appear on the right side. Note that on the bottom of the records list you need to select the number of views per page. Make sure it is always 100. Select all records by selecting the top checkbox - and press the 'Export' link on the top right to generate the exported Excel file. Note that if there are more than 100 records in the list, you will have to repeat the process as many times as needed. 4. The exported file only has the first four columns, (1-4). You will have to fill the rest columns manually, according to the selected criteria. 5. You are welcome to use any software - as long as I get my Excel correctly. 6. The same record (identified by 'Index Name') may appear on multiple searches. You must merge all appearances correctly. Example: ======== In section [Asset Class] select 'Fixed Income' -> 'Composite/Global' (don't select the other boxes under 'Fixed Income') In sction [Index Currency] select 'Canadian Dollar'. You will have 19 records. Select all and export. Copy the data into your Excel file and add 'Canadian Dollar' to the 'Index Currency' column. Also, if you select in the [Geography] section, you will remain with 18 records. For these records, add 'Americas' to the column 'Geography' and 'Canada' to the column 'Sub Geography'. If you select 'Global' in the [Geography] section, you will obtain the record: "S&P Global Developed Aggregate Ex-Collateralized Bond Index (CAD)" So for this record fill Geography = 'Global' and Sub Geography is blank (empty). Delivery: The delivery is the Excel file as described. Milestones: We'll have 2 milestones - to make sure we are on the same page. Since there are ~6000 records, we will have the first milestone for an Excel with 3000 records and a second milestone with the rest of the records. IMPORTANT: I WILL ONLY RELEASE A MILESTONE AFTER YOU SEND ME THE MILESTONE FILES AND I HAVE USED ENOUGH TIME TO TEST IT. I AM A MEMBER IN THIS WEBSITE SINCE 2008 AND I NEVER CHEAT ANY WORKER. If you do not like this condition then please do not apply for the project. HAPPY BIDDING!!!