TABLE OF CONTENTS

  • Import your historical HDFC Securities F&O transactions

    This is important for computing accurate Realised Profit/Loss.

  • Set up auto-import for your daily HDFC Securities contract note

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


1. Import your historical HDFC Securities F&O transactions


To get your historical fno transactions in one file from HDFC Securities, you can download a Trade Details Excel report from your HDFC Securities back-office login. You can directly import this report to MProfit.

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


1. Login to your HDFC Securities back-office - https://ntrade.hdfcsec.com/


2. Once you are logged in, click Reports / Statements (please refer to the screenshot below) 


From F&O and Currency Reports section click on Trade Details F&O. 




3. Next, select the options as per the screenshot below:  



  • Date: Request this file year-wise historical data you need to import.

  • Exchange: Select 'NSE-F&O'.

  • Scrip id: Keep it blank.

  • Stt. Type: Select All

  • Click on Export to Excel.


4. Once the file is downloaded, open it in excel and save it as "Excel 97-2003 Workbook" format. 


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


6. Once logged in, click Import (top-right) and search for the following template:

HDFC Securities - Trade Details

In the search results, click on the HDFC Securities - Trade Details (F&O) template, as displayed in the below screenshot:



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



8. Now that this template has been added, select the HDFC Securities - Trade Details (F&O) template under the My Templates section. 




You can now proceed to uploading & importing your HDFC Securities historical files: 
Step-wise MProfit import guide (start at step 5 in this guide)



2. Set up auto-import for your daily HDFC Securities contract note


The HDFC Securities daily email contract note contains your daily trades across NSE-EQ, NSE-FO and NSE-Currency.
 

Depending on whether you have already set up auto-forwarding for your Daily HDFC Securities Contract Note for Stocks, you can proceed as per the guidance below.


If you HAVE NOT set up auto-import for your daily HDFC Securities Stock transactions:

  1. Please follow the steps in this guide.
    (Section 2: Set up auto-import for your daily HDFC Securities contract note)

  2. Next, proceed with the steps below.

If you HAVE already set up auto-import for your daily HDFC Securities Stock transactions: 

Please follow the steps below:


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:

HDFC Securities - Daily CN (F&O)


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



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



4. Next, under My Templates, locate the HDFC Securities - Daily CN (EQ) template and click the Template Information button.

Please note this is the Stock Contract Note template for HDFC Securities.



5. In the Template Information box, click the Link button.



6. In the subsequent window, add HDFC Securities - Daily CN (F&O PDF) - Latest as the Linked Template. 


7. Finally, click Save, and now you are done.

MProfit will now start importing both Stocks and Equity F&O transactions from your HDFC Securities daily contract note file.



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.