Bug Fixes: Automated Mutual Fund and Financial Goal Tracker

Bug Fixes: Automated Mutual Fund and Financial Goal Tracker
Photo Credit: Smotography (Flickr)

Update: April 10th 2014: Errors pointed out by Mr. Deepak Rao in CAGR calculation of dividends have been rectified. Read the related post: How to calculate returns from Dividend Mutual Funds?

Existing users with dividend funds will need to download the new version The inconvenience is regretted.

Current users of the automated tracker will need to make the following changes to their sheets to correct potential errors in the consolidate and goal tracker sheets.

I thank Mr. Vikas Bansal for bring this error to my attention.

I apologize for the inconvenience. New users can ignore this post. The current version of the tracker is up-to-date.

Goal Tracker Sheet

While we can assign multiple funds to a single financial goal, Vikas pointed out that we cannot assign multiple goals to a single fund.

So, there is no point in Step 3: Set % of fund value corresponding to this goal

Therefore all the entries under Step 3  should always be 100%!

I am sorry for this goof up. This aspect did not occur to me. I cannot implement assigning multiple goals to a single fund as of now. Will try to do this in the future.

The following steps appear daunting to read. It will take less than 2 minutes to implements the same.

Bug Fix 1

a) Right click on the sheet names at the bottom.

b) choose unhide

c) from the list, choose lsnet

d) go to lsnet

e) Navigate to cell Y6001

f) Select cells, Y6001 to AB6016 (the ones with numbers in them)

g) press delete

Bug Fix 2

a) Go to sheet goal tracker

b) Right click on the calculate net portfolio return  macro button

c) Select Assign Macro

d) In the screen that appears, click on Edit

e) You will be taken to the Visual Basic Console

f) A few lines from the top, locate the line,

Range(Cells(5, 25), Cells(6000, 28)).Select

g) Replace this line with

Range(Cells(5, 25), Cells(10000, 28)).Select

h) Scroll down to the bottom of the page

i) Just 4 lines from the bottom you will see

'Range(Cells(5, 25), Cells(6000, 28)).Select
'Selection.Clear

j) Change this to

Range(Cells(5, 25), Cells(10000, 28)).Select
Selection.Clear

(remember that the  ' at the start of the line should be removed)

k) Close the visual basic window

l) Save the file

Bug Fix 3

a) Go to sheet consolidate

b) Right click on the consolidate!  Macro button

c) Select Assign Macro

d) In the screen that appears, click on Edit

e) You will be taken to the Visual Basic Console

f) A few lines from the top, locate the line,

Range(Cells(5, 25), Cells(6000, 27)).Select

g) Replace this with

Range(Cells(5, 25), Cells(10000, 27)).Select

h) Scroll down to the bottom of the page

i) Just 4 lines from the bottom you will see

Range(Cells(5, 25), Cells(6000, 27)).Select

j) Replace this with

Range(Cells(5, 25), Cells(10000, 27)).Select

k) Close the visual basic window

l) Save the file

I apologize for the inconvenience caused. Owing to the scale of the project it is difficult for me to weed  off all bugs before publication.

Download the current version of the tracker from the main page.

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.

Do let us know what you think about the article