Problems getting quotes for funds

[David Reiser]

Wheee. Yahoo is definitely messing with their quote system. If you go  
to any of the Yahoo European sites, get a quote by whichever naming  
convention will post something on the screen, then point your mouse at  
the "Download Data" link. You can inspect the url that it's pointing  
to, for example:

http://uk.old.finance.yahoo.com/d/quotes.csv?s=GB0003243465GBP&f=sl1t1c1ohgv&e=.csv
http://it.old.finance.yahoo.com/d/quotes.csv?s=IT0003110860ITA&f=sl1d1t1c1ohgv&e=.csv

and the results (two .csv files that shows up on my mac as Excel files):

GB0003243465GBP,87.31,12:00PM,02/11/2008,-2.13,N/A,N/A,N/A,N/A
IT0003110860ITA,3.70,12:00PM,02/08/2008,-0.01,N/A,N/A,N/A,N/A

You can also get the Italian fund quote from uk.old.finance.yahoo.com.

In finance::quote, the yahoo base .pm asks for everything it knows  
about via the &f field, including currency (&f=...c4, I think). The US  
Yahoo site still points with &f=sl1d1t1c1ohgv&e=.csv -- the key  
difference being that the US site asks for a date (d1) and a time  
(t1), whereas the European sites now only ask for a timespec (t1)  
which returns a comma separated time, date (2 fields responding to one  
field request, and in the opposite order from the one used in the old  
system!!!, and a US style date!!!!!!!).

So, I can get gnc-fq-dump to work with the hybrid isin+currency symbol  
by adding the "old" into the url spec in Europe.pm and by mucking with  
the base.pm to deal with the timespec problem. But that breaks  
retrieving quotes from Yahoo US because none of the US quotes have a  
date any more. It looks like finance::quote needs to split the Yahoo  
realm. Or we need to wait for Yahoo to change the US site to match the  
rest of the world. Of course, by that time the yy.old.finance.yahoo  
will likely have been renamed again.

Sorry if this is more tech than gnucash-user expects. This is where  
the thread was.

Dave


On Feb 12, 2008, at 5:59 PM, Richard Ullger wrote:

> This issue has just been raised in another thread.
>
> When you do a symbol lookup on yahoo now it returns a symbol made up  
> of
> the isin code and iso currency code, such as GB0003243465GBP, whereas
> before it returned a symbol such as MFEXPG.L. Even Yahoo's site
> complains, if you display the page for the fund, the area that  
> displayed
> the chart now displays the text 'Invalid Ticker'.
>
> Regards,
>
> Richard.
>
> 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
>>
>> Quoting Paul Stansell <ps at ph.ed.ac.uk>:
>>
>>> Hello everyone,
>>>
>>> I wondered if anyone could shed light on any recent changes which  
>>> may have
>>> stopped the "Tools: Price Editor: Get Quotes" for Funds from  
>>> working in
>>> gnucash-2.2.3.
>>>
>>> Shortly after 29th Jan 2008 the automatic price retrievals started  
>>> failing
>>> for all my funds.
>>>
>>> The error message is, for example,
>>>
>>>  Unable to retrieve quote for these items: FUND MFEXPG.L
>>>
>>> where MFEXPG.L is an example of a fund symbol that used to work  
>>> okay with
>>> "Tool: Security Editor: Fund: Type of quote source" set to "Single:
>>> Yahoo".  I've tried changing settings to other sources, but with  
>>> no luck.
>>> I've also tried changing the fund symbol, for example, using
>>> GB0003243465GBP, but that did help either.
>>>
>>> If I choose "Yahoo Europe" I get the error message "There was an  
>>> unknown
>>> error while retrieving the price quotes."
>>>
>>> In the days of gnucash-1.8.12-0.fc4 there used to be a perl script  
>>> called
>>> dump-finance-quote which could be run on the command line, eg,
>>>
>>>  dump-finance-quote yahoo MFEXPG.L
>>>
>>> I tried running this command on an old fedora4 system, but it no- 
>>> longer
>>> works either, or at least, not for this fund symbol for which it  
>>> used to
>>> work.
>>>
>>> Thanks for your help,
>>>
>>> Paul Stansell
>>> _______________________________________________
>>> 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.

--
David Reiser
dbreiser at earthlink.net