Updating exchange rates in windows fails

Maf. King maf at chilwell.net
Fri Jun 8 05:12:46 EDT 2012


On Fri 8 June 12 10:50:24 Mark wrote:
> Hello,
> 
> I am running Windows XP home with the latest service packs and updates.
> My firewall is disabled.
> 
> I just installed the latest version of Gnucash,  Activestate Perl and
> the Perl Finance module yesterday.
> 
> I am not able to update currency exchange rates (I need USD/EUR). I get
> the error message "Unable to retrieve quotes for these items:
> CURRENCY:USD".
> 
> Calling gnc-fq-dump from the command line seems to work:
>          C:\Programme\gnucash\bin>perl gnc-fq-dump yahoo  USD
>          Finance::Quote fields Gnucash uses:
>              symbol: USD <=== required
>                date: 06/07/2012 <=== required
>            currency: USD <=== required
>                last: 33.72 <=\
>                 nav: <=== one of these
>               price: 33.72 <=/
>            timezone: <=== optional
> 
> Running "gnucash.exe --add-price-quotes <myfile>" opens the perl window
> briefly and then drops back to the command line. In the gnucash.trace


Hi Mark,

I have no idea why GC is barfing, nor do I use multi currency stuff, but I 
noticed the exchange rate you gave above, and thought it looked odd.

A bit of digging on the yahoo site suggests that for EUR/USD exchange rate you 
should use the symbol EURUSD=X (or USDEUR=X depending which way toy are 
exchanging)

gnc-fq-dump yahoo EURUSD=X
Finance::Quote fields Gnucash uses:
    symbol: EURUSD=X             <=== required
      date: 06/08/2012           <=== required
  currency: EUR                  <=== required
      last: 1.2458               <=\       
       nav:                      <=== one of these
     price: 1.2458               <=/        
  timezone:                      <=== optional

seems like a more sensible exchange rate!  
Maybe Yahoo! have made changes to their output again?

HTH,
Maf.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part.
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20120608/02533bfd/attachment.sig>


More information about the gnucash-user mailing list