Gnucash / Finance::Quote cannot retrieve Spanish stocks and funds

Jose Gómez adler at dreamcoder.org
Thu Dec 17 22:05:53 EST 2015


I am trying to get the current value of a Spanish fund (INGDIRECTFNE.BC)
from Gnucash, and it is not working.

Trying with Finance::Quote directly I get:

    $ gnc-fq-dump -v yahoo_europe INGDIRECTFNE.BC
    Finance::Quote fields Gnucash uses:
        symbol: INGDIRECTFNE.BC      <=== required
          date: ** missing **        <=== required
      currency: ** missing **        <=== required
          last:                      <=\
           nav:                      <=== one of these
         price:                      <=/
      timezone:                      <=== optional

    ** This stock quote cannot be used by gnucash!!


    All fields returned by Finance::Quote for stock INGDIRECTFNE.BC

    stock           field  value
    -----           -----  -----
    INGDIRECTFNE.BC        ask:
    INGDIRECTFNE.BC    avg_vol:
    INGDIRECTFNE.BC        bid:
    INGDIRECTFNE.BC        cap:
    INGDIRECTFNE.BC      close:
    INGDIRECTFNE.BC   currency:
    INGDIRECTFNE.BC       date:
    INGDIRECTFNE.BC  day_range:
    INGDIRECTFNE.BC        div:
    INGDIRECTFNE.BC   div_date:
    INGDIRECTFNE.BC  div_yield:
    INGDIRECTFNE.BC        eps:
    INGDIRECTFNE.BC   errormsg: Stock lookup failed
    INGDIRECTFNE.BC     ex_div:
    INGDIRECTFNE.BC       last: **missing**
    INGDIRECTFNE.BC       name:
    INGDIRECTFNE.BC        nav: **missing**
    INGDIRECTFNE.BC        net:
    INGDIRECTFNE.BC       open:
    INGDIRECTFNE.BC   p_change:
    INGDIRECTFNE.BC         pe:
    INGDIRECTFNE.BC      price: **missing**
    INGDIRECTFNE.BC    success: 0
    INGDIRECTFNE.BC     symbol: INGDIRECTFNE.BC
    INGDIRECTFNE.BC       time:
    INGDIRECTFNE.BC     volume:
    INGDIRECTFNE.BC year_range:

The same happens with other Spanish funds:

    gnc-fq-dump -v yahoo_europe ^IBEX
    Finance::Quote fields Gnucash uses:
        symbol: ^IBEX                <=== required
          date: ** missing **        <=== required
      currency: ** missing **        <=== required
          last:                      <=\
           nav:                      <=== one of these
         price:                      <=/
      timezone:                      <=== optional

    ** This stock quote cannot be used by gnucash!!


    All fields returned by Finance::Quote for stock ^IBEX

    stock           field  value
    -----           -----  -----
    ^IBEX             ask:
    ^IBEX         avg_vol:
    ^IBEX             bid:
    ^IBEX             cap:
    ^IBEX           close:
    ^IBEX        currency:
    ^IBEX            date:
    ^IBEX       day_range:
    ^IBEX             div:
    ^IBEX        div_date:
    ^IBEX       div_yield:
    ^IBEX             eps:
    ^IBEX        errormsg: Stock lookup failed
    ^IBEX          ex_div:
    ^IBEX            last: **missing**
    ^IBEX            name:
    ^IBEX             nav: **missing**
    ^IBEX             net:
    ^IBEX            open:
    ^IBEX        p_change:
    ^IBEX              pe:
    ^IBEX           price: **missing**
    ^IBEX         success: 0
    ^IBEX          symbol: ^IBEX
    ^IBEX            time:
    ^IBEX          volume:
    ^IBEX      year_range:

And other Spanish stocks:

    gnc-fq-dump -v yahoo_europe AENA
    Finance::Quote fields Gnucash uses:
        symbol: AENA                 <=== required
          date: ** missing **        <=== required
      currency: ** missing **        <=== required
          last:                      <=\
           nav:                      <=== one of these
         price:                      <=/
      timezone:                      <=== optional

    ** This stock quote cannot be used by gnucash!!


    All fields returned by Finance::Quote for stock AENA

    stock           field  value
    -----           -----  -----
    AENA              ask:
    AENA          avg_vol:
    AENA              bid:
    AENA              cap:
    AENA            close:
    AENA         currency:
    AENA             date:
    AENA        day_range:
    AENA              div:
    AENA         div_date:
    AENA        div_yield:
    AENA              eps: -12.07
    AENA         errormsg: Stock lookup failed
    AENA           ex_div:
    AENA             last: **missing**
    AENA             name:
    AENA              nav: **missing**
    AENA              net:
    AENA             open:
    AENA         p_change:
    AENA               pe:
    AENA            price: **missing**
    AENA          success: 0
    AENA           symbol: AENA
    AENA             time:
    AENA           volume:
    AENA       year_range:

These funds and stocks can be found perfectly in the finance.yahoo.com
website, but they don't work from Finance:Quote. Note that other stocks
work perfectly.

Is there anything I can try, or is it just an incompatibility whith Spanish
funds and stocks?

Thanks.


More information about the gnucash-user mailing list