Thank you!

Last Wednesday I finally released the automated mutual fund and financial goal tracker. It took close to 4 months, 17 version changes, and 3 rounds of beta testing to bring it to a reasonably respectable shape.

This is the first time I sought help from readers to test a calculator before posting it.  What a difference it made! Several readers took the trouble of not only extensively testing it with their own mutual fund holdings, they tested the file under different limits to check for errors and if suitable error messages were in place.

They sent me detailed descriptions of the issues involved with screenshots for me to understand. They feedback was so incisive that I nearly scuttled the project! But for them, I would have lost face and reputation if I had released the tracker on my own.

The least I can do to acknowledge their efforts and thank them is to list their contributions. So here goes. I have compiled this from memory and from my email records. Apologies if I have left out any name, it is inadvertent.

  1. Bharat Shah tested the tracker with several of his own holdings and pointed out errors in listing of returns when trying to create fund records. He probably spent the most time playing with the tracker!
  2. Syamanatak Pati spotted Excel VBA bugs, corrected them himself and found new ways to use the sheet. He also suggested several crucial improvements to the user interface. I had to restructure the entire summary page thanks to him! He was instrumental in insisting that the facility to add transactions to SIP holdings is a MUST. He is also behind the ‘consolidate’ sheet in the file.
  3. A Krishna Kishore tested the tracker for suitable error messages. A step as important as checking for correctness in fund value and units.
  4. Mohammad Idris Khilji tested the lump sum entry sheet and a ‘manual entry’ sheet (now removed). Implementing his feedback made a big difference to the way lump sum entries are currently structured.
  5. Pushkar Sapre tested the sheet with his dividend reinvestment holdings and pointed out other issues in the interface. He was kind enough to share with me details of his holdings so that I could check them later. His feedback also made a telling difference in the way the sheet handles dividends.
  6. Raghav Nagarajan a CFP, and founder Rupeevest noted errors in the SIP entry sheet. Thanks to him I was able to include a host of error messages.
  7. Vandhana Rajendran was quite forthright in her analysis calling the tool ‘cumbersome’ :(. I agree … to an extent! She also made useful observations about the summary page.
  8. Gururaj Rudagi, perhaps the first to start using the final version. He located a bug after I posted the final version (now corrected). Earlier he had sent detailed notes on his findings that gave me confidence about the tracker.
  9. Anand Gadiyar, suggested I include closed-ended funds and ability to handle NFOs in the SIP and lump sum entry sheets
  10. Dr.G.M.Ajit was instrumental in getting the capital gains calculator in shape insisting that I include LTCG with indexation.
  11. Raj Singh gave me confidence that things were in order.
  12. Sundaram Anathankrishanan  could not test the file as he did not have the requisite Excel version (2007). However, I must acknowledge his eagerness and kind words of motivation.
  13.  Thanks to the many others who took the file from me. Testing such a file requires time. I entirely understand if you could not find it for providing your feedback. It is never too late to let me know how you feel about the sheet!

Thank you very much.

Download the automated mutual fund and financial goal tracker

Install Financial Freedom App! (Google Play Store)

Install Freefincal Retirement Planner App! (Google Play Store)

book-footer

Buy our New Book!

You Can Be Rich With Goal-based Investing A book by  P V Subramanyam (subramoney.com) & M Pattabiraman. Hard bound. Price: Rs. 399/- and Kindle Rs. 349/-. Read more about the book and pre-order now!
Practical advice + calculators for you to develop personalised investment solutions

Thank you for reading. You may also like

About Freefincal

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete  the entire comment or remove the links before approving them.

30 thoughts on “Thank you!

  1. ashal jauhari

    And I thank you dear Pattu for creating this piece. Similar to dear Sundaram, I'm having basic office 2010 suite and it does not support Macros as well as XLSB files. That's why I could not check this tool. But i'm glad that finally we do have an important offline tracker. so I thank you dear friend.

    Thanks

    Ashal

    Reply
  2. ashal jauhari

    And I thank you dear Pattu for creating this piece. Similar to dear Sundaram, I'm having basic office 2010 suite and it does not support Macros as well as XLSB files. That's why I could not check this tool. But i'm glad that finally we do have an important offline tracker. so I thank you dear friend.

    Thanks

    Ashal

    Reply
  3. NATARAJAN

    Great Job pattu. honestly i didnt realize you put this much time and efforts in setting this automated calc for MF. Hats off to you. I also like the way you have expressed your gratitude who those helped behind the scenes whose work / supports ensures that the it will be a huge success after all it is huge benefits to all. God Bless.

    Reply
    1. pattu

      Thank you very much. Initially I thought I will finish this in a couple of weeks. But it just kept becoming bigger, and I could not have done it without the help of above mentioned people.

      Reply
  4. NATARAJAN

    Great Job pattu. honestly i didnt realize you put this much time and efforts in setting this automated calc for MF. Hats off to you. I also like the way you have expressed your gratitude who those helped behind the scenes whose work / supports ensures that the it will be a huge success after all it is huge benefits to all. God Bless.

    Reply
    1. pattu

      Thank you very much. Initially I thought I will finish this in a couple of weeks. But it just kept becoming bigger, and I could not have done it without the help of above mentioned people.

      Reply
  5. Sundaram

    The remarkable thing is that Pattu has acknowledged even my inability to test as a positive feedback and has gone even further by acknowledging my contribution.I don't think any other blogger with equal-or far lesser- credentials would have even bothered to read my comment.Brilliance combined with a noble heart-that's Pattu for you.I am reminded of the dialogue from the film Munnabhai M.B.B.S. "Bas kar pagle, ab Rulayega kya?". Thank you,Pattu.

    Reply
    1. pattu

      ha ha! Thank you very dear Sundaramji. Kind and timely words of support and motivation are as important as specific feedback. I can never express satisfactorily what it means to me in words.

      Reply
  6. Sundaram

    The remarkable thing is that Pattu has acknowledged even my inability to test as a positive feedback and has gone even further by acknowledging my contribution.I don't think any other blogger with equal-or far lesser- credentials would have even bothered to read my comment.Brilliance combined with a noble heart-that's Pattu for you.I am reminded of the dialogue from the film Munnabhai M.B.B.S. "Bas kar pagle, ab Rulayega kya?". Thank you,Pattu.

    Reply
    1. pattu

      ha ha! Thank you very dear Sundaramji. Kind and timely words of support and motivation are as important as specific feedback. I can never express satisfactorily what it means to me in words.

      Reply
  7. bharat shah

    thank you for the template you made with great efforts. though i could not take its full advantage due to problem with the software i have, i enjoyed working with old and new versions as far as possible , and got the compilation of all my activities with the mutual funds thoroughly since 1st july,2009 , with these templates , and then used your XIRR calculator for getting combined CGAR of whole portfolio, and got some idea what i achieved by doing all this KHETI all this time !(i.e. any meaningful outcome from all this efforts!). though i like to do this from long time, i could do it with your templates and calculators. big thank you.

    Reply
    1. pattu

      Thank you very much Bhratji. In fact you have different XIRR sheets for different folios and update them from time to time. That is more than enough tracking!

      Reply
  8. bharat shah

    thank you for the template you made with great efforts. though i could not take its full advantage due to problem with the software i have, i enjoyed working with old and new versions as far as possible , and got the compilation of all my activities with the mutual funds thoroughly since 1st july,2009 , with these templates , and then used your XIRR calculator for getting combined CGAR of whole portfolio, and got some idea what i achieved by doing all this KHETI all this time !(i.e. any meaningful outcome from all this efforts!). though i like to do this from long time, i could do it with your templates and calculators. big thank you.

    Reply
    1. pattu

      Thank you very much Bhratji. In fact you have different XIRR sheets for different folios and update them from time to time. That is more than enough tracking!

      Reply
  9. Guru

    Dear Sh. Pattu,

    never realised few of my confusions on mails could get a mention on your blog.. 🙂

    At the cost of repetition... only individuals willing to teach others can spend time and energy to respond to each and every question, no matter how good or bad they are.. ..

    Thanks..

    Reply
  10. Guru

    Dear Sh. Pattu,

    never realised few of my confusions on mails could get a mention on your blog.. 🙂

    At the cost of repetition... only individuals willing to teach others can spend time and energy to respond to each and every question, no matter how good or bad they are.. ..

    Thanks..

    Reply
  11. dilip

    hi sir
    I used fundsindia for investing in MF before direct option came.
    With funds india,even though SIP date is 10th,transaction used to take place after a day or two.In that case,I think this cal. may not able to show real picture.

    here SIP date means,Second SIP date??? bcoz first one is sip registration date.

    Reply
    1. pattu

      The first entry is the date in which the SIP is registered. The second entry is SIP date. Sometimes if the date falls on a non-business day the next day will be used. As far as you are concerned you will need to use the actual SIP date you requested.
      If the SIP does not occur on specified days then you cannot use the SIP inputs sheet. You can still track with the lump sum entry sheet.

      Reply
  12. dilip

    hi sir
    I used fundsindia for investing in MF before direct option came.
    With funds india,even though SIP date is 10th,transaction used to take place after a day or two.In that case,I think this cal. may not able to show real picture.

    here SIP date means,Second SIP date??? bcoz first one is sip registration date.

    Reply
    1. pattu

      The first entry is the date in which the SIP is registered. The second entry is SIP date. Sometimes if the date falls on a non-business day the next day will be used. As far as you are concerned you will need to use the actual SIP date you requested.
      If the SIP does not occur on specified days then you cannot use the SIP inputs sheet. You can still track with the lump sum entry sheet.

      Reply

Do let us know what you think about the article