Set up Gnucash to fetch or retrieve Online Stock Quotes

If you are a user of Gnucash http://www.gnucash.org, you have options to enable it to retrieve online stock quotes. It can even be set up to retrieve online mutual fund quotes for Indian Mutual funds. 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 stock quotes from on line sources and view the latest value of your stocks using it’s Advanced Portfolio report. If you want to install Gnucash on a Windows computer, see this post.

  1. My stock’s name is HDIL and it is listed on the National Stock Exchange (NSE) in India. The quotes for it are available for retrieval on Yahoo Asia. The stock is also listed on the Bombay Stock Exchange (BSE) in India, but I will only fetch it from the NSE.
  2. Start Gnucash and click on the menu options: Tools -> Security Editor.

a.

You will now see the Security Editor window as in Ilustration 1.
Illustration 1: SecuritiesClick on the Add button to add your Security to the Securities List.

b.

Upon clicking the Add button in Illustration 1, you will see the dialog as in Illustration 2.
Illustration 2: Security InformationIn the dialog box as shown in Illustration 2, you should enter the following information:Full Name:

This is the full name of the company whose stock you own.

Symbol/abbreviation:

Enter the code of the stock. You can find out this code from the Yahoo Finance web site at this link http://in.finance.yahoo.com/. I got the code for the HDIL stock on the NSE from here http://in.finance.yahoo.com/q?s=HDIL.NS. The symbol for HDIL is HDIL.NS. Enter that in this box.

Type:

This should be NSE or NS. I kept it as NS. If you do not see a type for NSE in the drop down, you can directly type it in here, also.

ISIN, CUSIP or other code:

You can leave this blank.

Fraction traded:

This will be 1/1 for HDIL. 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 HDIL will be Multiple and within that Asia (Yaoo, …). If you have mutual funds in India, you can choose IndiaMutual as the source.

Now click the OK button to add the entry.

c.

In the previous step, we set up the Security in the Security Editor. Now we have to add Edit the Stock Account and point to it.Go the the main account display of Gnucash and select the HDIL Stock. Select Edit and then Edit Account from the Gnucash main menu. You will see a screen similar to Illustration 3 below:
Select Security
Illustration 3: Edit AccountEnter the following information for the fields as shown in Illustration 3 above.Security/Currency:

Click on the Select… button next to the Security/Currency: field. Upon clicking select, you can choose HDIL.NS 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.

d. This step shows you how to retrieve the latest online prices for the stock.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 Stock QuotesClick on the Get Quotes button to fetch the online quote for the HDIL stock. Once this step is done, click the Close button and from the Gnucash main menu select Reports, Advanced Portfolio to see your current stock value.

Leave a Reply

  

  

  

Blue Captcha Image
Refresh

*

April 2019
M T W T F S S
« Feb    
1234567
891011121314
15161718192021
22232425262728
2930