If you are a user of Gnucash http://www.gnucash.org, you have options to enable it to retrieve online mutual fund quotes. Here we will see how to retrieve the Indian Mutual Fund Schemes quotes. Gnucash is an open source, cross-platform, operating system independent, personal finance manager. It works on Linux, Windows and Mac. Explained below is an example of how you can enable it to retrieve mutual fund quotes from on line sources and view the latest value of your mutual funds using it’s Advanced Portfolio report. If you want to install Gnucash on a Windows computer, see this post.
Listed below is an example to demonstrate to you how the setup is done.
This should be INDIAMUTUAL. If you do not see a type for INDIAMUTUAL in the drop down, you can directly type it in here, also.
ISIN, CUSIP or other code:
You can leave this blank.
This will be 1/1000 for Reliance Natural Resources Fund. Sometimes, you can trade fractional amounts, and you should enter 1/<fraction> depending up to how many decimals you want for fractions. Normally, fractions default to 1/1000.
Quote Source Information:
Tick the box Get Online Quotes.
Type of Quote Source:
This for Reliance Natural Resources Fund that we entered. Select “Multiple” and choose India Mutual (AMFI…. If you have mutual funds in India, you should choose IndiaMutual as the source.
Now click the OK button to add the entry.
In the previous step, we set up the Security in the Security Editor. Now we have to add Edit the Stock (Mutual Fund) Account and point to it.
Go the the main account display of Gnucash and select the Reliance Natural Resources Mutual Fund. Select Edit and then Edit Account from the Gnucash main menu. You will see a screen similar to Illustration 3 below:
Illustration 3: Edit Account
Enter the following information for the fields as shown in Illustration 3 above.
Click on the Select… button next to the Security/Currency: field. Upon clicking select, you can choose Type as INDIAMUTUAL and choose 107636 from the list that it shows. This field actually picks up all the values from the Securities dialog that we entered in Steps a. and b. above.
Now, click the OK button to save the changes. Move to step d. to test your settings.
This step shows you how to retrieve the latest online prices for the mutual funds you entered.
Select Tools and then Price Editor from the Gnucash main menu. This will show a dialog as in Illustration 4 below:
Illustration 4: Price Editor – get Online Quotes
Click on the Get Quotes button to fetch the online quote for the Reliance Natural Resources Fund. Once this step is done, click the Close button and from the Gnucash main menu select Reports then Advanced Portfolio to see your mutual fund’s value.