Helping You Build Wealth With Honest Research
Since 1996. Try Now

  • MyStocks

MEMBER'S LOGINX

     
Login Failure
   
     
   
     
 
 
 
(Please do not use this option on a public machine)
 
     
 
 
 
  Sign Up | Forgot Password?  

How to Import Schemes from Excel to an Existing Portfolio?

Import from Excel for Mutual Funds helps you import your Mutual Fund portfolio directly from ICICI direct, ValueResearchOnline or Moneycontrol.


Step 1

Go to the Homepage of Portfolio Tracker and click on <Import funds from excel>


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

You have two ways to Import portfolio from excel:

  • 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.

Select an existing portfolio:


Step 2

Click on Select an existing portfolio


Step 3

Select the Portfolio from the drop down list and click on <Go>. In this case, we have selected Mutual Fund Holdings as the portfolio for import.


Step 4

Here, select the service where you have your portfolio, from the drop down list.

Note: You can only import from Moneycontrol and Valueresearchonline. Also please ensure that the excel sheet is not edited. Because the import function does not function if the excel sheet is edited.


Step 5

Click on <Choose File>. to search for the excel file that you have imported from your account and saved in your computer. For example, in this case the name of the file is - mf_portfolio.


Step 6

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


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

  1. ENTRY: i.e. the schemes that have been imported from excel
  2. OUR SUGGESTION: When the name of the scheme does not correspond to the scheme matched by the system, you will find the closest matching scheme here. This could even be blank if the system does not find the matching scheme name.
  3. Change: In case the name of the scheme that you actually own does not correspond to the scheme matched by the system, or does not show any scheme against that name, click on Change link and select the correct scheme name.

Step 7

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

Note: The purpose of this additional step is 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:

  1. SCHEME: It enlists the schemes that have been imported from excel.
  2. TRANSACTION TYPE: It shows the status i.e whether the scheme is a BUY or a SELL.
  3. DATE: This shows the date, when the transaction took place.
  4. QUANTITY: Ensure that the quantity of is correct.
  5. PRICE: It shows the market price or the last purchase price at which the scheme was purchased.

Step 8

Once you have verified all your transactions and found no errors, click on <Save> to proceed.

You will now be directed back to the Consolidated Holdings report.


You will find that the schemes from excel have been added to your existing portfolio.



Related Links:
Get Started: