Problems getting quotes for funds
Peter Jones
jonesypeter at hotmail.com
Thu Feb 19 04:54:39 EST 2009
Hi
Does anyone know if these work with finance quote 1.15?
Kind regards
Paolo Di Giacomo wrote:
>
> 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.
>>
> _______________________________________________
> 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.
>
>
--
View this message in context: http://www.nabble.com/Re%3A-Problems-getting-quotes-for-funds-tp16567083p22097120.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
More information about the gnucash-user
mailing list