Step 1

Select an existing portfolio: You can either import the excel sheet to your existing portfolio

-OR-

Create a new portfolio: Create a new, separate portfolio to import the excel file.

CREATE A NEW PORTFOLIO:

Step 2

Click on Create a new portfolio radio button.

Step 3

Enter a unique name for the portfolio. This unique name will help you identify each portfolio distinctly. For example, here we have named the Portfolio as Import from Moneycontrol.

Step 4

Select the Portfolio Status from the drop down list. The status of the portfolio identifies you as a Resident Indian, Non Resident Indian, Corporate Body or Overseas Corporate Body.

Step 5

Select the Exchange in which you are trading and click on <Go>

You will now be directed to the Import from Excel page.

Step 6

Here, select the service where you have been currently tracking your stock and mutual fund investments, from the drop down list.

Note: You can import from ICICI Direct, Moneycontrol and Valueresearchonline. Also please ensure that the excel sheet is not edited. Because the import function does not function on editing the excel sheet.

Step 7

Click on <Choose File> and then select the excel file that you have downloaded from your respective portfolio tracker.

Step 8

Now, click on <Upload> after selecting the file.

Post uploading, you will be directed to the preview screen, wherein the stocks from the excel sheet get uploaded in the system. Now, you need to check if the following are correct before adding the stocks to the portfolio:

ENTRY: i.e. the stocks that have been imported from excel

OUR SUGGESTION: When the name of the stock does not correspond to the stock in the system, you will find the closest matching name of the stock here. This could even be blank if the system does not find the matching stock name.

Change: In case the name of the stock that you actually own does not correspond to the name in the system, click on Change link and select the correct stock name.

Step 9

After checking and changing the required entries, click on <Proceed> to add them to the new portfolio.

Note: On clicking on <Proceed>, you will be directed to this page, wherein, you need to ensure that everything is correct, because once you <Save> the transactions, you will not be able to undo them and this could in turn show you wrong returns calculation

So in this particular step, you need to confirm all the following details:

SCRIP: It enlists the stocks that have been imported from excel.

TRANSACTION TYPE: It shows the status i.e whether the stock is a BUY or a SELL.

DATE: This shows the date, when the transaction took place.

QUANTITY: It shows the quantity of the scrip.

PRICE: It shows the price at which the transaction took place.

Step 10

Once you have confirmed all your transactions, click on <Save> to proceed.

Get Started:

ABOUT EQUITYMASTER

Since 1996, Equitymaster has been the source for honest and credible opinions on investing in India. With solid research and in-depth analysis Equitymaster is dedicated towards making its readers- smarter, more confident and richer every day. Here's why hundreds of thousands of readers spread across more than 70 countries Trust Equitymaster.

All rights reserved. Any act of copying, reproducing or distributing this newsletter whether wholly or in part, for any purpose without the permission of Equitymaster is strictly prohibited and shall be deemed to be copyright infringement.

LEGAL DISCLAIMER: Equitymaster Agora Research Private Limited (Research Analyst) bearing Registration No. INH000000537 (hereinafter referred as 'Equitymaster') is an independent equity research Company. Equitymaster is not an Investment Adviser. Information herein should be regarded as a resource only and should be used at one's own risk. This is not an offer to sell or solicitation to buy any securities and Equitymaster will not be liable for any losses incurred or investment(s) made or decisions taken/or not taken based on the information provided herein. Information contained herein does not constitute investment advice or a personal recommendation or take into account the particular investment objectives, financial situations, or needs of individual subscribers. Before acting on any recommendation, subscribers should consider whether it is suitable for their particular circumstances and, if necessary, seek an independent professional advice. This is not directed for access or use by anyone in a country, especially, USA, Canada or the European Union countries, where such use or access is unlawful or which may subject Equitymaster or its affiliates to any registration or licensing requirement. All content and information is provided on an 'As Is' basis by Equitymaster. Information herein is believed to be reliable but Equitymaster does not warrant its completeness or accuracy and expressly disclaims all warranties and conditions of any kind, whether express or implied. Equitymaster may hold shares in the company/ies discussed herein. As a condition to accessing Equitymaster content and website, you agree to our Terms and Conditions of Use, available here. The performance data quoted represents past performance and does not guarantee future results.