Tweet
To get your historical stock transactions in one file from Zerodha, you can download a multi-day contract note report from your Zerodha back-office login. You can directly import this report to MProfit.
1. Login to your Zerodha Console.
2. Once you are logged in, click Reports > Download (please refer to the screenshot below)
3. Next, select the options as per the screenshot below:
Statement: Contract note
Category: Equity (this includes NSE-EQ, NSE-FO and BSE-EQ)
Date: Request this file year-wise for every year of historical data you need to import (you are able to download contract notes for an entire year in a single file!)
Report type: XLSX
Trade type: Don't select anything here, as you would need to include all trade types
4. Next, click the Download button and save the file to your computer.
5. Start MProfit application and click on Import.
From Equity list add " Zerodha Securities Multi Sheet - Excel (v1) "
1. Login to your Zerodha Console.
2. Once you are logged in, click Reports > Download (please refer to the screenshot below)
3. Next, select the options as per the screenshot below:
Statement: Contract note
Category: Equity (this includes NSE-EQ, NSE-FO and BSE-EQ)
Date: Request this file year-wise for every year of historical data you need to import (you are able to download contract notes for an entire year in a single file!)
Report type: XLSX
Trade type: Don't select anything here, as you would need to include all trade types
4. Next, click the Download button and save the file to your computer.
5. Start MProfit application and click on Import.
From Equity list add " Zerodha Securities Multi Sheet - Excel (v1) "