TABLE OF CONTENTS

  1. Import your historical ICICI F&O transaction data

    This is important for accurate Capital Gain and XIRR reporting.

  2. Set up auto-import for your Daily Contract Note for ICICIDirect

    This is will ensure your daily trades are auto-updated in MProfit.





1. Import your historical ICICI transaction data


To get your historical F&O transactions in one file, you can download a Trade Book in Excel from your ICICI Securities back-office login. You can directly import this report to MProfit.

Please follow the steps below to download the ICICI Securities Trade Book Excel report and import it to MProfit:

  1. Go to your ICICIDirect account: https://secure.icicidirect.com/customer/login

    Please note that this is the new ICICIDirect website, but you can also follow the same steps in the old ICICIDirect website.


  2. Login to your ICICIDirect account with your Username (Email), Password and DOB / PAN details.

     
  3. Once logged in, click F&O at the top left of the screen: 

     
  4. Under the F&O section, click the Trade Book option.

     
  5. Under Trade Book, select your desired Time Period and then click View.

     
  6. All your transactions for the selected period will now load on the screen.

    Click the Download dropdown and click Excel in the dropdown options. Your Trade Book file will now be downloaded in Excel format. 

     
  7. The F&O trade book file does not contain personal information like name or code. Hence you need to add your unique name/code in this file before importing it, to enable portfolio mapping in MProfit .

    Open the Excel file and add the client code in the cell "Trade Date-Your Name".


    For example, if your name is "Mahendra Mehta", change the value of the cell to "Trade Date-Mahendra Mehta" as shown in the screenshot below.

    Example:
  8. Now, login to your MProfit account at https://cloud.mprofit.in

  9. Once logged in, click Import (top-right) and search for the following template: ICICIdirect - Trade Book

    In the search results, click on the ICICIdirect - Trade Book (F&O) template for Stocks, as displayed in the below screenshot:

     
  10. Review the template information. Next, click the Add to My Templates button and then click Continue.

     
  11. Now that this template has been added, select the ICICIdirect - Trade Book (F&O) template under the My Templates section.

     

You can now proceed to importing your ICICI trade book:
Step-wise MProfit import guide (start at Step 5) 



2. Set up auto-import for your Daily Contract Note for ICICIDirect


MProfit lets you set up an auto-forwarding rule in your email for the daily F&O digital contract note file that you receive from ICICIDirect.


Please follow the steps below to set up auto-import for your contract note:


  1. Login to your MProfit account at https://cloud.mprofit.in

  2. Once logged in, click Import (top-right) and search for the following template: ICICI Securities - Daily CN

    In the search results, click on the ICICI Securities - Daily CN (F&O) template for Stocks, as displayed in the below screenshot below:


     
  3. Review the template information. Next, click the Add to My Templates button and then click Continue.


    You can now proceed to creating a forwarding rule for your contract note file in your email account.

    If you don't want to set up auto-import right now, you can upload your file directly in the MProfit application: Step-wise MProfit import guide (start at Step 4)


    To set up auto-import for your daily contract note:

  4. First, go to Import and locate the ICICI Securities - Daily CN (F&O) template under My Templates.

  5. Once you have located this template, click the Auto-Import button under the template name (screenshot below).

     
  6. The auto-import window will now appear on the screen (screenshot below). Follow the steps as directed. Start by selecting your email client.

     
  7. By following the subsequent auto-import steps as directed on the screen, you will be able to successfully set up auto-import for this contract note.


Once complete, your ICICIDirect transactions will now automatically be updated in MProfit on a daily basis.



Disclaimer: Any company names and logos used in this document are the property of their respective owners and may be trademarks. MProfit Software Private Limited does not claim proprietary interest in the marks, names & property of others.