No price updates anymore

Michael Gordon michael.gerald.gordon at gmail.com
Fri Feb 14 22:27:20 EST 2014


/////////////////////////////////////////
1) Take a backup copy of C:\Perl64\site\lib\Finance\Quote\Yahoo\Australia.pm
2) Start, type 'wordpad' in Search programs and files, click on WordPad that
appears at top. (Wordpad is used because it copes with lines that end with
only newline, unlike notepad)
3) Open (Control-O)
4) Bottom right: select 'All Documents' from drop down
5) open C:\Perl64\site\lib\Finance\Quote\Yahoo\Australia.pm
6) Change
$YAHOO_AUSTRALIA_URL = ("http://au.finance.yahoo.com/d/quotes.csv");
to
$YAHOO_AUSTRALIA_URL = ("http://download.finance.yahoo.com/d/quotes.csv");
//////////////////////////////////////////////

Great! Works on Windows 8.1 64bit.

Mike Gordon.



On 15 February 2014 12:12, Chris Good <chris.good at ozemail.com.au> wrote:

> > Message: 9
> > Date: Fri, 14 Feb 2014 10:24:13 -0000
> > From: "Fred Bone" <Fred.Bone at dial.pipex.com>
> > To: Mike Alexander <mta at umich.edu>
> > Cc: gnucash-user at gnucash.org
> > Subject: Re: No price updates anymore
> > Message-ID: <52FDEECD.26425.1D30EEDC at Fred.Bone.dial.pipex.com>
> > Content-Type: text/plain; charset=US-ASCII
> >
> > On 13 February 2014 at 22:36, Mike Alexander said:
> >
> > > --On February 12, 2014 5:50:20 PM -0800 liberace
> > > <philsdutchie at gmail.com> wrote:
> > >
> > > > Hi,
> > > >
> > > > Since yesterday I cant update the prices anymore. The error message
> > > > is "*There was an unknown error while retrieving the price quotes*.
> > >
> > > Yahoo changed URL for their quote service, or more likely turned off
> > > the old one since the new one doesn't seem all that new.  The attached
> > > patch seem to fix the problem.
> >
> > ... for the USA source. Yahoo_Europe was already in that form (but the
> URL
> > starts uk.finance.yahoo.com).
> >
> > Some ferreting around on the uk.finance.yahoo.com website indicates that
> > (for the yahoo_europe quote-source) the URL should start
> > download.finance.yahoo.com - and that now works for me.
> >
>
> Thanks very much for the info Fred & Mike.
>
> Get Quotes is also failing from Yahoo Australia.
>
> For Windows 7, GnuCash 2.4.11 here is how to fix:
>
> 1) Take a backup copy of
> C:\Perl64\site\lib\Finance\Quote\Yahoo\Australia.pm
> 2) Start, type 'wordpad' in Search programs and files, click on WordPad
> that
> appears at top. (Wordpad is used because it copes with lines that end with
> only newline, unlike notepad)
> 3) Open (Control-O)
> 4) Bottom right: select 'All Documents' from drop down
> 5) open C:\Perl64\site\lib\Finance\Quote\Yahoo\Australia.pm
> 6) Change
> $YAHOO_AUSTRALIA_URL = ("http://au.finance.yahoo.com/d/quotes.csv");
> to
> $YAHOO_AUSTRALIA_URL = ("http://download.finance.yahoo.com/d/quotes.csv");
>
> 7) Save file (Control-S) . Ensure to save in text only format without .txt
> extension. Note that the original file is read-only, so I actually saved it
> as Australia.pm.txt, deleted Australia.pm, then renamed Australia.pm.txt to
> Australia.pm.
>
> I also had a problem because I previously had my securities set up with
> quote source 'Multiple' from ASX, then Yahoo Australia.
> As previously noted on this list, ASX only allows approx 10 securities in 1
> enquiry, so additional securities, which Finance::Quote  tries get from
> Yahoo Australia, were failing.
>
> I fixed that by changing all my securities to use only a single quote
> source
> of Yahoo Australia.
> Note that download.finance.yahoo.com/d/quotes.csv is the same URL that is
> needed now for Yahoo USA.
> I thought that I might be able to get prices for Aus securities from Yahoo
> USA, but this it seems is not possible from within GC.
>
> I tested using gnc-fq-dump
> ie for Windows
> In a command window:
>         cd \Program Files (x86)\gnucash\bin
>         perl gnc-fq-dump -v yahoo_australia BOQ (OK)
>         perl gnc-fq-dump -v yahoo BOQ.AX                (OK)
>         perl gnc-fq-dump -v yahoo BOQ           (Fails)
> so I guess Finance::Quote is not adding the .AX to the security code.
> I'll try to see if this, & the problem with more than 10 securities from
> the
> ASX can be fixed.
>
> If it came down to getting prices from the ASX one at a time, would anyone
> object to the few extra seconds that took?
>
> Regards, Chris Good
>
> _______________________________________________
> 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