naveegator.in

Click here to view all the categories on naveegator.in

Category: Mutual Funds

  • 3 years with DSP Tax Saver Fund and L&T Tax Advantage Fund

    3 years ago I decided to start investing in an ELSS fund, apart from PPF, to save taxes. After a thorough research (eeny, meeny, miny, moe), I decided to go with DSP Tax Saver Fund and L&T Tax Advantage Fund. I went via the SIP route. My first couple of instalments were in Regular plan before realising that there is something called as Direct plan which has lower expense ratio (thank you Economic Times). Below are the key steps that I did over last three years.

    1. Started SIP in April 2018
    2. SIP frequency was monthly
    3. Increased SIP every year
      • DSP Tax Saver
        • Apr 2019: + 60%
        • Apr 2020: + 87.5%
      • L&T Tax Advantage
        • Apr 2019: + 20%
        • Apr 2020: + 16.7 %
    4. If I had surplus funds in a month, then I used to invest them in the fund as lumpsum. Being one of the lucky folks who did not lose his job due to pandemic (no increments though), I was able to invest surplus amount during the blood bath in stock markets of Mar-Jun 2020.

    I have plotted the SIP Return, Profit and XIRR of both these funds from April 2018 to Mar 2021.

    DSP Tax Saver Fund

    SIP Return Chart

    From Mar to Jul 2020, I was able to invest additional fund as lumpsum, that’s why the steps are not uniform as they were in previous two years. I continued investing lumpsum after wards also, albeit less frequent, as the market seemed to be very expensive.

    Profit Chart

    During the market crash from Mar to Jun 2020, two years worth of my investments went down by ~28%. But as of Mar 2021, I am looking at a profit of ~35%.

    XIRR Chart

    The market crash of Mar-Jun 2020 was so bad that the XIRR calculations went bonkers and resulted in 0% values for sometime during Mar-Jun 2020. From Mar 2020 to Mar 2021 the XIRR has gone from ~-30% to ~+30%.

    L&T Tax Advantage Fund

    SIP Return Chart

    Similar to DSP Tax Saver, from Mar to Jul 2020, I invested additional fund as lumpsum. But the returns in L&T Tax Advantage were always inferior to DSP Tax Saver. That resulted in me pouring more money in DSP Tax Saver.

    Profit Chart

    During the market crash of Mar-Jun 2020, two years worth of my investments went down by ~35%. But as of Mar 2021, I am looking at a profit of ~30%.

    XIRR Chart

    Similar to DSP Tax Saver, the market crash from Mar to Jun 2020 caused the XIRR calculations to go bonkers and resulted in 0% values for sometime. From Mar 2020 to Mar 2021 the XIRR has gone from ~-30% to ~+20%.

  • Get MUTF_IN codes for mutual fund to use in GOOGLEFINANCE function in Google Sheets

    Update 30-Jul-2023

    I am not sure if this was already there, but when I wrote this blog I couldn’t find this option. The below post becomes excessive in light of this new information.

    Go to https://www.google.com/finance/ and start searching for the mutual fund. The search results in the dropdown and page shows the MUTF_IN code. And that’s it!

    I have been searching for a long time on how to get the MUTF_IN code for Indian mutual funds. It has been a hit-and-miss for me trying to search on Google. Finally, I think, I figured out a sure shot way to get the MUTF_IN code.

    Go to Morning Star India. Search for your mutual fund in the search box and go to the search result page.

    Get the name of the mutual fund as it appears in the Morning Star page. For some reason Morning Star does not allow you to copy text from its site so you will have to type it. For those who are aware about Inspect Element I don’t think I need to say anything else.

    Type this name in Google search and you should get MUTF_IN code. You can then use the MUTF_IN code in the GOOGLEFINANCE in Google Sheets.

    Additional points to note

    1. This seems to work only for equity funds. Not debt or arbitrage funds (honestly, I don’t even know what an arbitrage fund is).
    2. If there is an hyphen (-) in the name of mutual fund as per Morning Star India, add space before and after it when searching it on Google.