You can import your portfolio into Trendlyne in a few easy steps. Choose between two convenient methods: ‘Via Broker’ and ‘Excel Import’.


Broker import (import portfolio via brokers):

  1. Go to the Portfolio section, and click on Import Portfolio.

  2. Select the Via Broker option.

  3. Choose your broker from the options provided. This will redirect you to a page where you can enter your credentials to import your portfolio, as shown below.

To import portfolio via Excel:

  1. In the Portfolio section, click on Import Portfolio.

  2. Choose the Excel Import feature.

  1. Select the account you want to import into your portfolio and specify the type of transaction: current portfolio, buy transaction, or sell transaction.

  2. Download the provided Excel sheet template. The template includes three columns with predefined headings. It's essential not to modify these headings.

  3. In the first column as specified, either enter the stock name (as listed on the BSE or NSE websites) or its ISIN code. For mutual funds, use the MF scheme code.

  4. Enter the number of shares bought and the buy price, as shown in the screenshot below.

  1. After adding your portfolio details into the Excel sheet, save the file. 

  2. Upload the saved Excel sheet to the app. Once the Excel import is complete, you'll see the list of imported stocks in your portfolio.