Ever wondered what are the constituent stocks in an MF? This public disclosure is available in individual mutual fund websites. This disclosure also gives information about how many shares of each stocks they hold in a scheme, the market value and weight of each stock in the scheme based on the market value (all, as at the end of previous month). Money control and Morningstar collates for various schemes across mutual funds. For example, to see the detailed portfolio of Kotak Select Focus Regular Growth in
Morningstar
Moneycontrol
Let us say, you own 5 different mutual funds - may be one ELSS, one balanced, one mid cap, one liquid fund and one multi cap fund. Now, you have different quantum of amounts invested in each of these schemes. But for you, all these 5 schemes with appropriate weight put together is your portfolio. You want to have a consolidated view of stock and debt investments happened through these 5 schemes. This portfolio scanner tool helps in getting information from across different schemes, collate the similar stocks and debt instruments and presents an overall view.
For example let us say there is a sample portfolio of Rs 1 Lakh each in HDFC Tax Saver and UTI Mid Cap Fund. Here is how the consolidated stocks stack up.
This is a snapshot of the sectors
And here, are the instruments in the Rs 2 Lakh portfolio (of 1 Lakh each in HDFC Tax Saver and UTI Mid Cap Fund)
And this view helps searching for a particular stock and how the total value in the stock is split up across the MF schemes invested in.
The online MF portfolio scanner is published here. You need to upload the portfolio of various MF schemes in an excel file (.xlsx). The excel sheet has to have a single sheet named "Portfolio" and have 3 columns to be populated as depicted in the below template. The file name column is just an identifier for the MF and the application saves the portfolio of the scheme in the said name - it might save in the server, you will not be able to see that.
Morningstar
Moneycontrol
Let us say, you own 5 different mutual funds - may be one ELSS, one balanced, one mid cap, one liquid fund and one multi cap fund. Now, you have different quantum of amounts invested in each of these schemes. But for you, all these 5 schemes with appropriate weight put together is your portfolio. You want to have a consolidated view of stock and debt investments happened through these 5 schemes. This portfolio scanner tool helps in getting information from across different schemes, collate the similar stocks and debt instruments and presents an overall view.
For example let us say there is a sample portfolio of Rs 1 Lakh each in HDFC Tax Saver and UTI Mid Cap Fund. Here is how the consolidated stocks stack up.
This is a snapshot of the sectors
And here, are the instruments in the Rs 2 Lakh portfolio (of 1 Lakh each in HDFC Tax Saver and UTI Mid Cap Fund)
And this view helps searching for a particular stock and how the total value in the stock is split up across the MF schemes invested in.
The online MF portfolio scanner is published here. You need to upload the portfolio of various MF schemes in an excel file (.xlsx). The excel sheet has to have a single sheet named "Portfolio" and have 3 columns to be populated as depicted in the below template. The file name column is just an identifier for the MF and the application saves the portfolio of the scheme in the said name - it might save in the server, you will not be able to see that.
No comments:
Post a Comment