FAQ

Qfinr has the most extensive range of portfolio analytical tools compared to any Wealth Management App across the world.

There are a few Fintech companies who provide WM analytical tools as a part of their overall offering, but none are as comprehensive and extensive as us. In addition, the extent of information and analysis presented in “Know Your Fund / ETF” module is significantly more than any other provider, including some of the popular household names.

We work for the investor. We specialise in providing portfolio analytics. We do not host ads, or provide access to trading engines nor do we monetise aggregated client data. So our app has been build ground up to provide best in class analytics. We continue to improve the range and breadth of coverage and analytics.

All of this has just one purpose : help you in your financial decisions.

Qfinr’s focus is portfolio analytics. Questions, other than those which can be addressed by our website acting as a portfolio analytics portal, are best answered by your wealth advisor. Qfinr does not provide recommendations or investment advice.

Qfinr offers quantitative and graphical tools to help an investor make better investment decisions. Qfinr exclusively focuses on financial analytics. Unlike other Apps, it does not offer a gateway to execute transactions or make purchase and sale recommendations.

Unlike robo-advisors or financial advisors who promise to manage your investments, Qfinr believes that investors need to be in the driver’s seat to manage their financial future. For this investors need the data and tools to make informed decisions. Once investors have data and analysis, they can ask advisors the questions that will lead to better financial outcomes.

Qfinr is an unbiased provider of data and analytical tools – and we are committed to remaining so. Enabling and improving your decision making process is our sole purpose.

Qfinr does not sell aggregated data, does not profit from data in any form. It has no ads, no product placements or marketing messages. As of now, Qfinr offers its platform for free though it might charge a subscription fee at some stage in the future. If it does charge a subscription fee, then that will be the sole source of revenue for Qfinr.

Qfinr has no ads, no product placements or marketing messages. Qfinr does not receive commissions or fees or payments from anyone. As of now, Qfinr offers its platform for free though it might charge a subscription fee at some stage in the future. If it does charge a subscription fee, then that will be the sole source of revenue for Qfinr.

Qfinr’s market data is sourced from the best financial data provider in the world, Refinitive.

No. We are a truly independent investment analytics platform. We have no alliances, no preferred product providers. We work alongside your current product providers and advisors as an independent provider of data, information and insights.

Qfinr is an Investment Analytics platform. Qfinr’s unique offering is the risk and return insights it offers to its subscribers. Qfinr does not offer price data for download.

Qfinr wishes to remain truly independent and offer a unique service to its subscribers. Qfinr believes that specialising in Investment Analytics i.e. offering risk and return insights about its subscriber’s portfolios is a service that its subscribers will value. It does not wish to offer transaction services.

Qfinr is a forward planning Investment Analytics App. The most important data point is the daily closing price of Assets. We do not store live prices as live prices are not relevant for our analysis nor do we provide trading access. We are also not in the real time price data distribution business.

The Qfinr platform is hosted on Amazon’s AWS. We use industry standard encryption tools and techniques to protect your data from external parties. In addition, your data is encrypted when you enter information in the Qfinr database, and again when it is retrieved from the database to reduce the risks of third party snooping.

Your data is not visible to our engineers too. We have a separate production environment which needs dual sign off from managers for an engineer to access.

Your financial information is yours. It cannot be seen by either our internal engineers or external parties. We do not use your financial information for anything else except to give you insights to your portfolio. It is secure in a production environment which is housed in Amazon’s AWS, the world’s foremost cloud storage environment.

Simply click on the “Forgot my password” link on the login page and we will send you an email with a temporary password that you can use to reset your password.

Hopefully you’ll never need to do this. In the unlikely event, send an email to care@qfinr.com with your account details, and we will close your account and delete all information for the account.

Please see our website https://app.Qfinr.com to access the desktop version of the platform. Alternatively, you can download the apps from the Android or Apple App Stores.

Once you have the App loaded and working, then open the App by tapping on the logo on your phone screen. You will be prompted to set up your 4 digit Login Passcode. You will be prompted for biometric identifiers such as your fingerprint too. Please allow this too as it will make your App experience better. Now you are all set to go.

After your login, you will see a screen with a personalised greeting and a button saying Add Investments. Click on the button which will take you to the “Add New Portfolio” screen. Here you have three choices of which only two are enabled now. To enter your portfolio in bulk using the “Import from Excel” option or the “Add Manually” option which helps you add assets manually.

If you press the “Import from Excel” button, you will receive an email in your registered mail box with an excel template. Fill in the Excel Template as indicated and reply back on the email with the filled in Excel File saved and attached. Please do note that the system identifies each asset – stock, etf or fund – with a RIC. The database of the RICs are in a separate sheet on the same excel file.

If you click on the “Add Manually” button, the sequence of screens you will see are

=> Add New Portfolio > Add Securities > Search for the Security > Click on the Right Security > Add > Fill in Template > Save > Create > View Portfolio

Pro-Tips: Search for the security with the full name. For example, Reliance Industries is best searched under Reliance and not RIL.

This is a repeat of the point above. Careful.

There are a number of ways to upload your assets to the Qfinr Platform.

First, you can manually enter your investments to Qfinr. Please go to the “Manage” module on the App. Then click on

=>Add New Portfolio > Add Securities > Search for the Security > select Security > Add > Add Units > Save > Create > View Portfolio

[Pro Tip –

1. if you want to add multiple assets to the portfolio then keep on adding securities via the Add Security feature, then add units before you

=> Save > Create > View Portfolio

We have also got some easy ways for you to enter equal-weighted or equal-shares portfolios.

1. If you are simply interested in the forward analysis of your portfolio and are not really interested in the past, just enter the security and the number of units. We will automatically update price!]

Second, you can upload portfolios using the auto-load feature of the App. Qfinr supports multiple modes of loading securities. Please use the one that suits you best. Note: This feature works best on the desktop version of the App.

When you click on the Add New Portfolio button in the “Manage” module, you will see a screen with two banners – Import and Add Manually. Click on Import. You will see a page with a number of Options. The Options are Qfinr, Custodians, Brokers, Banks and Others. Let’s go through these one by one.

1. Qfinr. If you maintain an excel spreadsheet on your home computer to manage your portfolio, then you can simply export into Qfinr. Please click on the Download Sample tab on the right to get a copy of the Qfinr template, copy paste the appropriate columns, save the new file in your hard drive and upload the same using Qfinr as the source name. We have two sample files – one for securities and financial assets and the other for fixed, savings and other deposit/cash accounts. Do remember to choose the right one! PS: You can also send us the file via email if you are using your phone app. Just remember to have the right subject line in your email to care@qfinr.com.

2. Custodians: As of now, Qfinr supports uploads from CAMS / KARVY, NSDL and CDSL. For NSDL and CDSL, please go to your mailbox, download the latest statements, make a note of the password required to open the statement, and follow the steps mentioned on the page.

For Karvy and CAMS: Goto: https://new.camsonline.com

• Click “View More in Transactions” card. You’ll come to the transaction page.

• Click on Statements

• If you want to just upload your holdings as of the date : Click portfolio valuation statement

• Enter Email registered with any fund house
• In delivery option: choose from one of the two (delivery link or encrypted attachment)
• In Mutual Funds select All funds
• Choose Excel as Statement Format
• Enter a password which will be used to encrypt your file
• Click submit and you will see

• Await the email from CAMS and open the excel file.
• If you want a detailed transaction statement: click on Transaction Details

• Email registered with any fund house
• In Mutual Funds select All funds
• Choose period from and to
• Choose Excel as Statement Format
• Enter a password which will be used to encrypt your file
• Click submit and you will see the Success page as before
• CAMS will send you an email with a link to download the excel file as a zip folder. Double click on the zip file and enter your chosen password and the zip file will open as a folder with 2 excel files : the first is the current valuation and the second is the transaction file. Simply upload either excel after selecting Karvy / CAMS on the menu.

3. Brokers: Currently, Qfinr supports Zerodha. Others will be added as we go along. Please go to the Holdings page on Zerodha, click on Download (top right of the page). The downloaded CSV file can be uploaded from the Qfinr upload page.
4. Banks: HDFC Securities, ICICI Securities and Kotak Securities are supported. Please download your portfolio from your Bank Custodian. For HDFC Securities, please go to the main page, click on Equity Summary under the Portfolio Tab and then click on the Export button.

The sequence is:

=> Portfolio>Equity Summary>Export.

This downloads an excel file that can be uploaded to Qfinr.

If your broker is not listed on the upload page, please do let us know at care@qfinr.com. Please also send us the statement you wish to upload on this email address and we will help you upload the data. We will also create a template for uploading data from your broker, so you will be able to auto-upload data from your broker in the future.

There could be a few reasons for this. First, and the more likely case is that the reporting format that your broker or custodian uses has changed. Second, it could also be that the specific security that you have in your portfolio is not in our database or that the name used for the security is non-standard.

In any case, please do let us know at care@qfinr.com and we will sort out the problem. This does mean that you will have to separately enter this security in your portfolio with a lag of a day or two.

Most investors have accounts with multiple wealth managers / brokers. Every wealth manager / broker has their own unique statementing process making it very difficult to build an integrated view of a portfolio. At Qfinr, we have simplified the process of integrating all these myriad of 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. Simply log in to your Qfinr account on your desktop, 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

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 / 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 Date is left blank, Qfinr will put the portfolio inception date 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 to the upload page. If you would like us to add your wealth manager / 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.

Webversion:
Go to the Manage Module, identify the portfolio you want to duplicate, click on the Detail button, scroll down to the More button to see the drop down menu and then click on the Duplicate Portfolio button. Give the new portfolio a name and then click Next. The portfolio has been duplicated with the new name.

The specific keystrokes are

=> Manage > identify the correct portfolio > Detail > scroll down > More > Duplicate Portfolio > Type new Name > Next.

Phone App:

The specific keystrokes are

=> My Portfolio > Manage > identify the correct portfolio > Click > Click on the Hamburger buttons on the top right > Duplicate Portfolio > Type new Name > Next.

On the desk top:

=> Manage Portfolio > Manage > identify the correct portfolio > Click > Add Investments > Search (if you know which investments to add) or Sort and Filter (if you want to use the screener to identify the investment),

For both the desk top and the phone App:

=> Manage Portfolio > Manage > identify the correct portfolio > Click > Identify the correct investment > Click > Edit > Amend the necessary fields > Save

For both the desk top and the phone App:

=> Manage Portfolio > Manage > identify the correct portfolio > Click > Identify the correct investment > Delete

You need to amend the stock holding in the case of a stock split. Please follow the same steps as described in “How do I amend investments in my portfolio” and change the number of stocks held as per the instructions from your custodian. Qfinr will reflect the “cum bonus” share value on the same day as the exchange.

As many as you require. We recommend that your investments be recorded in separate portfolio’s to facilitate disaggregated analysis of your portfolio.

Investors usually like to see their investments in a home or base currency. This is usually the currency of their home country or the currency in which most expenses are incurred. Qfinr has made it very easy to change the base currency – it can be changed on the fly from both the Dashboard and the My Portfolio module. Please click on the currency tab in the top right of the screen to change the base currency. Please note that changing the base currency changes the currency of record of all the portfolios.

Please go to the Blog Post on How To: Sort and Filter Investments for a full description of the topic

We update our ratings every month end.

We use a quantitative approach in rating funds relying on actual performance over the last 3 years. We calculate ratings for returns based on the quality of the returns within the category using indicators like Information Ratio, Success Ratio. We calculate ratings for expenses by comparing the funds expense ratio against that of similar funds. We look for statistical evidence of alpha generation by the fund against its benchmark or equivalent market exposures. Finally, we compute the risk rating based on the actual volatility of returns over the past 3 years and use the same matrix to create the Synthetic Risk return Indicator for all instruments on our database.

The fund rating is a key statistic and should be an important input into the fund selection process. But what instruments to buy or to sell should be driven by its overall impact on the portfolio. The final purchase decision should always be driven by a combination of overall portfolio risk, return, stress test and personal comfort and advice of your personal investment advisor. Please consult with your advisor before investing.

Please note that the Qfinr platform provides analysis based on your inputs. It does not provide investment recommendations.

The Alerts page can be accessed via the Dashboard module of the Qfinr Desktop. As of now, you can either switch the Notifications On or Off. Notifications are sent only for the Live portfolios.

If you wish to have a further level of customisation, please let us know at care@qfinr.com and we will build it out for you.

Create a portfolio using the Portfolio > Add New buttons. After the View Portfolio button is pressed at the end of the process and the portfolio comes into view, click on the More button on the top right of the page and click on Mark as WatchList to create a Watchlist Portfolio.

The previous day’s closing FX price is used as a static data in calculating portfolio values.

The Qfinr App starts with the Investor at the centre. Once you have registered and logged in, the App asks you to fill in your risk profile questionnaire. This is the only place where we need some effort from you. Please do spend the 3 or 4  minutes necessary to read and tick the correct answers. It sets up to take full advantage of the powerful features in the App.  Without understanding your risk profile and loss tolerance, you will not be able to use key features of the Analysis module in our App.

We recommend that the risk profile be updated regularly. The frequency depends on the changes to market conditions or a change in the investor’s own financial condition. Do note that higher market volatility usually makes investors nervous. An inflow of cash or an unplanned large expense usually changes the investor’s risk taking capacity and loss tolerance.

Please do note that, as of now, we are only adding those assets whose End of Day prices are available in a public database. So, to take an example, AIFs are currently not added to the database.

Having said this, we will be very happy to add your assets to our database. Please send us an email at care@qfinr.com with the name of the asset and any other detail that you think appropriate.

No. As of now, we have not set up Qfinr to be a Market Data provider. We specialise in providing tools for Analysis, so we are focused in becoming the best in the world in Analytics.

Qfinr has a unique approach to stress test portfolios. It models the behaviour of the test  portfolio(s) assuming that it was a live portfolio during past episodes of market breakdown such as the Global Financial Crisis or the 2020 Covid driven sell off. Each such episode has a start data and an end date. The Qfinr Stress Test module values each instrument and the portfolio at the values prevailing on the start date and on each subsequent date until the end date and compares the values against an index. The results are presented on a chart for easy reading and the portfolio statistics are also shown for a deeper understanding.

If a particular stock was not listed or did not exist during a past episode of market breakdown, say during the Global Financial Crisis, then no price data for that period would be available. In that case, the stock will be ignored for Stress Test calculations.

The Desired Zone in the Analyse Module of our Platform is calculated through a simulation process. We start with expectations of returns and risk over the long term for 5 asset classes : Cash / Cash Equivalents, Bonds, Mixed Assets, Equities and Commodities. We generate over 3 million portfolios of varying allocations to the 5 asset classes which we group into 5 for each of our 5 risk profiles. The median metrics for the appropriate Risk Profile i.e. return, volatility and the standard deviation of the population appropriate for that risk profile is then used to generate the Desired Zone.

The Desired Zone reflects the risk/return characteristics of an asset allocation derived from this analysis for the user’s specific risk profile. The time period assumed is medium term investment time horizon (3-5 years).

The Desired Zone is based upon your risk profile – and reflects the risk return characteristics appropriate for your risk tolerance.  As Qfinr is currently available for investors in India, we have used the asset classes available to investors in India to derive the Desired Zone. We will be adding Desired Zones for investors based in other countries shortly.

It is very likely that there would be a gap between the Desired Risk Return Zone and a test portfolio(s) Risk Return chart point. Do remember that the Desired Zone is a subset of the projected risk return profile from 3 million simulated Portfolios. These simulated portfolios comprise of 5 assets, namely Cash & Cash Equivalents, Bonds, Mixed Assets, Equities and Commodities. So the first point of departure is the test portfolio might not have the same level of diversification as the simulated portfolios.

The gap between the test portfolio’s Risk Return chart point and the Desired Zone should be the start of a discussion with your Wealth Provider or Advisor about portfolio diversification, asset selection, their respective weights and so on. Each recommendation by your wealth provider or advisor can be tested using Qfinr’s What If capabilities to see how the proposed portfolio behaves with respect to the Desired Zone and the existing portfolio. A movement towards a lower volatility without much compromise on the return is always a good outcome.

The stock dividends are forecast from the past dividend awards. Qfinr also looks at Analyst forecast consensus if such a consensus exists. But it is always possible for the company management to surprise the market with a different dividend award.

Please write to us at care@qfinr.com and we will look at including the stock or mutual fund in our next upgrade of the App.

The current version of the Qfinr App provides market data. It does not do fundamental analysis – so it does not generate or display corporate information.

Not as yet. We have instead written up this extensive FAQ to help investors. We will also have video tutorials available in a few weeks.

The Qfinr Intelli-Screener module is a sophisticated “sorting and screening” tool. It works on the same principles as the Excel sorting tool, except it cuts the selection depending on cut-off criteria selected by you. This selection can be saved as a watch-list.

Users outside India can only access the Desktop version. The phone App is limited to Indian users.

If your portfolio is marked 1 star, then a deeper level of analysis is necessary to find the root cause. All the pages under the Analysis module would show critical bits of information to explain why the portfolio is so poorly rated.

Depending on the advice your advisors, you may consider iteratively testing various combinations of shares, funds and ETFs to create a portfolio as per your risk profile. This What If analysis can be done by duplicating this portfolio, removing and adding instruments in this portfolio and running the Analytics just for this portfolio to understand its behaviour.

Let’s look at it in more detail.

First, please have a look at the disaggregated rating i.e the Return Rating, Alpha Rating, Portfolio Suitability and Risk Rating. More than one of these ratings would have to be very poor for the portfolio to fetch a 1 Star rating.

Once signals from these disaggregated ratings are known, further investigation would clarify as to the exact source of the poor rating. The risk rating is 7, i.e. the portfolio has the highest risk, meaning that the portfolio volatility is at the highest bracket. Ask your wealth advisors and iteratively test their recommendations. Use various combinations of shares, funds and ETFs to create a portfolio as per your risk profile.  Please look at the Key Statistics page and note the volatility numbers and look for instruments with a lower volatility reading. Usually, ETFs on widely diversified indices are the best instrument to reduce portfolio volatility. If the return on the portfolio is very poor, then the Discover module can be used to identify assets with a better return profile.

Once the alternative investments are identified, then they should be tested the same way as explained in the What If analysis question. Please scroll down to see that section.