Problems getting quotes for funds

Tue Apr 8 13:17:05 EDT 2008

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.
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Base.pm
Type: application/x-perl
Size: 11459 bytes
Desc: not available
Url : http://lists.gnucash.org/pipermail/gnucash-user/attachments/20080408/17e43deb/attachment.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Europe.pm
Type: application/x-perl
Size: 3977 bytes
Desc: not available
Url : http://lists.gnucash.org/pipermail/gnucash-user/attachments/20080408/17e43deb/attachment-0001.bin 