Downloading European share prices

David Hampton hampton-gnucash at rainbolthampton.net
Tue May 3 12:39:58 EDT 2005


On Tue, 2005-05-03 at 23:59 +0800, Benjamin So wrote:
> Hello,
> 
> I suspect this has already been covered, but I wasn't able to find any 
> relevant posts in the archive. I have finance-quote up and running for 
> US shares, but haven't been able to find the magic codes to enable 
> GnuCash to download prices for Swiss-listed shares. What I've tried is 
> appending .VX or .SWX to the four-letter code, but this results in an 
> error message. According to the Yahoo! UK site, this should work, as 
> for example UBS has a code of UBSN.VX.

What version of Finance::Quote are you using?  IIRC, all versions of
F::Q simply pass the full symbol on to yahoo for resolution.  Older
versions mapped the suffix to a currency, but there is no mapping for
the "Virtual Exchange (VX)" case.  I'm not sure what F::Q does in this
case (whether it returns a bare number, or returns a default of GBP),
but either way it would screw up your results.  The very latest CVS
version of F::Q knows how to ask yahoo for the currency symbol as part
of the quote request.

You should have a program called dump-finance-quote installed with
gnucash.  What does it say?  Below is a quote when running the very
latest F::Q from CVS.  These results look correct to me.

    david$ dump-finance-quote yahoo UBSN.VX
    Finance::Quote fields Gnucash uses:
        symbol: UBSN.VX              <=== required
          date: 05/03/2005           <=== required
      currency: CHF                  <=== required
          last: 94.85                <=\       
           nav:                      <=== one of these
         price: 94.85                <=/        
      timezone:                      <=== optional

David







More information about the gnucash-user mailing list