GnuCash for Personal Finance: Online Quotes

This is third in the series of posts describing how I use GnuCash to manage my finances. In previous posts, I had discussed how I organize my accounts, record transactions and handle taxation in GnuCash. In this post I’ll show how GnuCash can be configured to fetch the current NAV of mutual funds from the Internet.

GnuCash allows you to manually enter the current NAV of mutual funds by using Price Editor under the Tools menu. If you hold a small number of mutual funds and don’t care about having the latest NAV always (both of which are good), entering manually will work just fine. However if you want to track NAVs closely or hold a lot of different funds, entering them manually can get boring very fast.

Configuring Online Source

Before GnuCash can fetch NAVs from the Internet, we need to specify the source from which it needs to fetch them. For Indian mutual funds, AMFI (Association of Mutual Funds in India) publishes NAVs every day in a format that is easy to parse. To use this as source of NAVs in GnuCash,

Repeat this for all your funds and then if you visit the Price Editor, you can click on Get Quotes to fetch the latest NAV of all your funds.

Quote Source

Note: For this to work, the symbol for all your funds should be their AMFI scheme code as shown in the first post.

Fixing Finance::Quote

GnuCash internally uses a Perl module called Finance::Quote to fetch NAVs. AMFI recently changed the format of the NAVs file and hence the default version of Finance::Quote that ships with Ubuntu 18.04 is broken. However, the issue has been fixed in the original repository now.

If you face any error upon clicking Get Quotes, try downloading the latest version of IndiaMutual module and replace the existing file named IndiaMutual.pm on your system. On my laptop running Ubuntu 18.04, this file is located at /usr/share/perl5/Finance/Quote. If you’re on a different OS, you should be able to search for a file named IndiaMutual.pm in the entire system to locate it.

28 Jul, 2018 gnucash / personal-finance / mutual-fund