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 is broken. However, the issue has been fixed in the upstream 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 on your system. On my laptop running Ubuntu, 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 in the entire system to locate it.

If you liked what you read, consider subscribing to the RSS feed in your favourite feed reader.

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