Problems getting quotes for funds

Tue Apr 8 01:46:51 EDT 2008

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