Use Gnucash to retrieve stock quotes from Bombay Stock Exchange India using MumbaiStock.pm

Gnucash retrieves Stock Quotes from Yahoo Finance for Indian stocks. Of late, Yahoo Asia Finance stock quote source does not work correctly. To overcome the issue, I added a new Finance::Quote module MumbaiStock.pm to help retrieve stock prices from the MUMBAISTOCK source. This is based on IndiaMutual.pm where mutual fund NAVs are retrieved from the amfiindia.com website.

MumbaiStock relies upon the Bombay Stock Exchange to provide stock quotes. It picks up the end of trading day stock quotes file like eq181013_csv.zip to read the last price of the stocks you have in your Gnucash portfolio. To use Mumbai Stock, you need to do the following:

  1. Download the file MumbaiStock.pm
  2. Download the Quote.pm
  3. Open a terminal window and copy the files as follows:

$ sudo cp MumbaiStock.pm /usr/share/perl5/Finance/Quote/MumbaiStock.pm <enter>
$ sudo cp Quote.pm /usr/share/perl5/Finance/Quote.pm <enter>

If you need to know the 6 digit symbol code in the Bombay Stock Exchange, visit this link http://www.bseindia.com/download/BhavCopy/Equity/eq181013_csv.zip. Open the file inside it EQ181013.CSV. The first 6 digits you see are the stock symbol. For example, in below record, 500002 is the stock symbol for ABB.
500002,ABB LTD.    ,A ,Q,543.00,559.00,540.00,554.50,554.50,541.40,1969,21123,11623881.00,

After that, start up Gnucash and set up the Stocks in the Security Editor as shown at this link http://www.askmeaboutlinux.com/?p=1726. Replace INDIAMUTUAL with MUMBAISTOCK and use the symbol code from the eq141013_csv.zip EQ141013.CSV file.

If you are looking for real-time quotes update into Gnucash like Yahoo Finance or Google Finance, look elsewhere.

Leave a Reply

  

  

  

Blue Captcha Image
Refresh

*

June 2019
M T W T F S S
« Feb    
 12
3456789
10111213141516
17181920212223
24252627282930