Problems getting quotes for funds
Paolo Di Giacomo
pistadj-gnucash at yahoo.it
Tue Apr 8 01:17:18 EDT 2008
Thanks for your support.
I tried to apply the patch using "patch" for windows, but it fails
with the following errors:
C:\usr\share\perl5\Finance\Quote\Yahoo>patch -p7 --binary <libfinance-quote-yaho
o-2.diff
patching file Base.pm
Hunk #1 FAILED at 56.
Hunk #2 FAILED at 142.
Hunk #3 FAILED at 189.
Hunk #4 FAILED at 254.
Hunk #5 FAILED at 276.
5 out of 5 hunks FAILED -- saving rejects to file Base.pm.rej
I then applied all the changes described in diff file by hand. Now the
Finance::Quote works from command line:
Retrieving updated value for Ducato Azionario Italia
Finance::Quote fields Gnucash uses:
symbol: IT0001036315ITA <=== required
date: 04/04/2008 <=== required
currency: EUR <=== required
last: 17.14 <=\
nav: <=== one of these
price: 17.14 <=/
timezone: <=== optional
Anyway I cannot update prices within GnuCash (I get no error or
feedback, prices are simply not being updated).
I already changed url in Europe.pm to
"http://uk.old.finance.yahoo.com/d/quotes.csv" following suggestions I
found in the mailing list.
What am I missing?
Your help is much appreciated
Paolo
On Tue, Apr 8, 2008 at 6:55 AM, David Reiser <dbreiser at earthlink.net> wrote:
> The patch from the finance-quote bug tracker is probably a better one to
> use:
>
> http://sourceforge.net/tracker/index.php?func=detail&aid=1910138&group_id=4232&atid=104232
>
> even after my second attempt, the British funds weren't right because Yahoo
> reports the funds' value in pence rather than pounds. The bug tracker patch
> handles that problem, too.
>
> Dave
>
>
> On Apr 7, 2008, at 3:04 AM, Paolo Di Giacomo wrote:
>
>
> > Hi Dave,
> >
> > It would be possible to have this patch? I am experiencing the problem
> > you describe, and I tried to apply the modifications you describe, but
> > I am probably missing something somewere... I am using GnuCash 2.2.4
> > for Windows
> >
> > Thanks a lot
> >
> > Paolo
> >
> > On Mar 12, 2008, at 7:16 PM, David Reiser wrote:
> >
> >
> > > Does two ugly hacks equal a fix?
> > >
> > > When I sent out the first hack, I assumed that success of gnc-fq-dump
> > > = success for Get Quotes inside gnucash. Oops. It turns out that
> > > gnucash wasn't totally silent, just mumbling in the background about
> > > no currency being assigned. When I accommodated yahoo_europe's new
> > > timespec field, I didn't bother matching the number of elements in
> > > @FIELDS and @FIELD_ENCODING lists. gnc-fq-dump didn't have a problem
> > > with that, but gnucash does. My second hack is just to add a second
> > > request for currency at the end of the encoding list. I have tested
> > > this inside gnucash, and it does work for European funds identified by
> > > isin.
> > >
> > > REMEMBER: this hack definitely breaks Yahoo US (and most likely Yahoo
> > > Asia and Australia too). But if you can get all the rest of your
> > > quotes from either Yahoo_Europe or non-Yahoo sources, then it can
> > > retrieve quotes for isin identified funds. Instead of MFEXPG.L, you'll
> > > have to enter GB0003243465GBP as the 'ticker'.
> > >
> > > This 'fix' is still ugly almost beyond belief, but it might be useful
> > > to some. There is a different patch in the Finance-Quote bug tracker,
> > > but it breaks non-European Yahoos as well.
> > >
> > > Dave
> > >
> > >
> > >
> > >
> > >
> > > On Mar 11, 2008, at 7:16 PM, David Reiser wrote:
> > >
> > >
> > > > I'll see if I can find a straightforward fix. Since gnc-fq-dump says
> > > > it can use one of 3 prices, maybe there is an easy way to branch the
> > > > gnucash code on the gnucash side of the fq fetch. If it isn't
> > > > relatively straightforward, it may be quite a while before someone
> > > > else can look for a fix.
> > > >
> > > > Dave
> > > > On Mar 10, 2008, at 4:39 PM, Paul Stansell wrote:
> > > >
> > > >
> > > > >
> > > > > Dear Derek,
> > > > >
> > > > > Recently, you helped me and others by providing a patch to deal with
> > > > > fixing gnc-fq-dump so that it could get quotes from yahoo_europe
> > > > > after
> > > > > they made changes to their stock and funds codes.
> > > > >
> > > > > Well, the patch does fix gnc-fq-dump so that I can get the price of
> > > > > a fund
> > > > > from the command line, eg "gnc-fq-dump yahoo_europe
> > > > > GB0003243465GBP", but
> > > > > I've just noticed that when I retrieve quotes for funds using
> > > > > gnucash's
> > > > > "Price Editor -> Get Quotes" the current quotes are not being stored
> > > > > or
> > > > > updated, and are not available to gnucash. Stock prices, however,
> > > > > are
> > > > > being updated and are available. Also, unlike the case before the
> > > > > patch
> > > > > was suppled, there are no error messages after the "Price Editor ->
> > > > > Get
> > > > > Quotes" attempt to indicate that getting the prices of any of the
> > > > > funds
> > > > > has failed.
> > > > >
> > > > > Regards,
> > > > >
> > > > > Paul Stansell
> > > > >
> > > > >
> > > > > On Tue, 12 Feb 2008, Derek Atkins wrote:
> > > > >
> > > > >
> > > > > > The command was renamed to gnc-fq-dump. Using your example:
> > > > > >
> > > > > > gnc-fq-dump yahoo MFEXPG.L
> > > > > > Finance::Quote fields Gnucash uses:
> > > > > > symbol: MFEXPG.L <=== required
> > > > > > date: ** missing ** <=== required
> > > > > > currency: ** missing ** <=== required
> > > > > > last: 0.00 <=\
> > > > > > nav: <=== one of these
> > > > > > price: <=/
> > > > > > timezone: <=== optional
> > > > > >
> > > > > > ** This stock quote cannot be used by gnucash!!
> > > > > >
> > > > > >
> > > > > > Maybe Yahoo changed their site and F::Q can't parse it?
> > > > > >
> > > > > > -derek
> > > > > >
> > > > > >
> > > > > _______________________________________________
> > > > > gnucash-user mailing list
> > > > > gnucash-user
> > > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > > > -----
> > > > > Please remember to CC this list on all your replies.
> > > > > You can do this by using Reply-To-List or Reply-All.
> > > > >
> > > >
> > > > --
> > > > David Reiser
> > > > dbreiser
> > > >
> > > >
> > > >
> > > >
> > > > _______________________________________________
> > > > gnucash-user mailing list
> > > > gnucash-user
> > > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > > -----
> > > > Please remember to CC this list on all your replies.
> > > > You can do this by using Reply-To-List or Reply-All.
> > > >
> > >
> > > --
> > > David Reiser
> > > dbreiser
> > >
> > >
> > >
> > >
> > >
> > >
> > > _______________________________________________
> > > gnucash-user mailing list
> > > gnucash-user
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > -----
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> > >
> >
>
> --
> David Reiser
> dbreiser at earthlink.net
>
>
>
>
>
More information about the gnucash-user
mailing list