Problems getting quotes for funds
Paolo Di Giacomo
pistadj-gnucash at yahoo.it
Wed Apr 9 23:01:52 EDT 2008
Thank you for your answer, I solved the problem!
I put your files on Quote\Yahoo directory instead of my old files and
now when I update quotes prices within Gnucash their values results
updated!
Thanks to all for your support
On Tue, Apr 8, 2008 at 11:17 PM, Richard Ullger <rullger at ntlworld.com> wrote:
> Hi,
>
> The changes referred to in that mail can be found in the attached files,
> Base.pm and Europe.pm. Save the files and do your own diffs before
> copying them over. The files live in
> /usr/share/perl5/Finance/Quote/Yahoo on Linux (Ubuntu) or
> C:\Perl\site\lib\Finance\Quote\Yahoo on Windows.
>
> Hope that helps.
>
> Richard.
>
>
>
> David Reiser wrote:
> > There was one additional message on using this patch:
> > https://lists.gnucash.org/pipermail/gnucash-user/2008-March/024211.html
> >
> > Does that help?
> >
> > Dave
> > On Apr 8, 2008, at 1:17 AM, Paolo Di Giacomo wrote:
> >
> >> 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
> >>>>>>>>
> >>>>>>>>
> >
> > --
> > David Reiser
> > dbreiser at earthlink.net
> >
> >
> >
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
>
>
> > 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.
> >
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> 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.
>
More information about the gnucash-user
mailing list