How To: Uploading Your Portfolio

Most investors have accounts with multiple wealth managers and brokers. Every wealth manager or broker has their own unique statement format making it very difficult to build an integrated view of a portfolio. 

At Qfinr, we have simplified the process of integrating the different statement formats so that you, the investor, can focus on the most important issue – your portfolio.

Qfinr reads NSDL and CDSL pdf statements and extracts holdings directly from the statement. First, download the NSDL or CDSL statement from your email and save it on your desktop. Next, simply log in to your Qfinr account, click ‘Add New’ under the ‘My Portfolio’ tab and click ‘Import’.

Enter the name of the portfolio in the ‘Portfolio Name’ box, select NSDL (if it is an NSDL Statement, or any of the formats we have already built) from the ‘Source Name’ dropdown, choose the file from your local drive.

You will be asked to enter the password. You can skip this step if you do not have a password.

Click ‘Upload File’ and after a short while you’ll see a screen showing that Qfinr has processed the file. That’s it! It is as simple as a few clicks and complete in a few seconds. And the process is fully secured: we don’t store your file or your password anywhere on our servers.

Check your portfolio against the statement of holdings. If we don’t have a particular instrument on our database, the holding will not get uploaded. Just drop us a line at care@qfinr.com with the holding (just the name and the ISIN Number shown on the NSDL statement) and we will look at adding the holding to the ever-growing Qfinr database..

What if you happen to have investments with a wealth manager or a broker who is not on our list? Don’t worry – it is almost as easy. Click the ‘Download Security’ button on the right hand box. Open the excel file that is downloaded. It has 4 tabs – ‘portfolio’, ‘sample’, ‘GL’ and ‘IN’. All you need to do to upload your holdings is to enter 3 pieces of information. First, the instrument details – we recommend ISIN Numbers as these are unique numbers identifying each security. ISIN Numbers are particularly important for mutual funds and bonds. ISIN Numbers are found in fact sheets or online from the mutual funds website. Bonds are usually referred to by their ISIN Numbers. For stocks, you can simply enter the Exchange Ticker Symbol. Then enter the number of units you hold. If you simply want to record your portfolio holdings, enter ‘Buy’ for each security. If you want Qfinr to keep track of your portfolio transactions, you will need to enter the amount in ‘Holding’, the ‘buy’ or ‘sell’ in ‘Type’, the price and date of transaction.

Say we want to upload our holdings which consist of 100 HDFC Bank, 100 Hindustan Unilever, 100 TCS, 10 Amazon, 1000 SBI ETF Nifty 50 and 1000 Kotak Bluechip Regular Growth Mutual Fund. Our spreadsheet will look like the one on the left. When the If the Date and Price column is left blank, Qfinr will automatically put the portfolio inception date and the price of 3 years ago (or if the instrument started after, the first date we have a price) and create the portfolio for you. As you will note, for stocks and the ETF, the example uses the Exchange Ticker and for the mutual fund, the ISIN Number. Enter the Portfolio Name, choose Qfinr from the ‘Source Name’ drop-down, choose the file from your local drive and click ‘Upload File’ and your portfolio is imported to Qfinr.

Qfinr’s portfolio upload features have been designed by investors for investors. We will keep adding wealth managers, brokers, custodians  to the upload page. If you would like us to add your wealth manager or broker, drop us an email at care@qfinr.com with the name of the wealth manager / broker.

And if you want one of our specialists to upload your portfolio, let us know at care@qfinr.com with your contact number and we will schedule a call with you.

Uploading your portfolio – easy, simple and convenient.

Qfinr powering intelligent investment decisions.