1. Login to your ICICIdirect back-office: http://www.icicidirect.com


Click image for larger version  Name:	1final.png Views:	1 Size:	98.4 KB ID:	1049



2. Go to Mutual Fund Category - > History - > Order Book and select Order Book from summary screen.


Click image for larger version  Name:	2final.png Views:	1 Size:	210.5 KB ID:	1050


3. Select Time Period, click on View and then click on the Excel icon to export the file.


Click image for larger version  Name:	3final.png Views:	1 Size:	201.6 KB ID:	1051


4. You need to open the Excel file and save as "Excel 97-2003 Workbook".

5. From MProfit, select the "ICICI Mutual Fund Order Book - Excel" template to import it.


Click image for larger version  Name:	import.PNG Views:	1 Size:	8.6 KB ID:	1062


6. Here is the image of the sample back-office file from ICICIdirect.


Click image for larger version  Name:	sample-icici-mf.png Views:	1 Size:	5.6 KB ID:	1063