Downloading Stock Prices - Finance::Quote Problems

David Carlson david.carlson.417 at gmail.com
Thu Jun 26 14:00:51 EDT 2014


On 6/25/2014 8:11 AM, Richard Lindgren wrote:
> Erik, it sounds like you're a programmer that you are able to proceed and
> have success. I am having GREAT difficulty in retrieving my stock prices
> like I was able to do before. Making a long story short, my computer
> crashed and window 7 was re-installed by my computer guy. Now I can no
> longer get my stock prices.
>
> I have downloaded the latest version of GnuCash and have installed it as
> the System Administrator. I then went into the GnuCash folder and ran the
> utility to download prices. When I request the stock price it comes back
> with "Unable to retrieve quotes for these items:" . I could sure use some
I always get that message for two particular items that Yahoo does not
recognize.  The others come through fine for me.  Are you now getting
some quotes?
David C

> help here. I am NOT a programmer and anything I do needs to be explained as
> simply as possible. Thanks.
>
> Richard
>
> On Mon, Jun 23, 2014 at 4:34 PM, Erik Colson <eco at ecocode.net> wrote:
>
>> On 23 Jun 2014, at 15:07, Tim Johnson <timnjane at hotmail.co.uk> wrote:
>>
>>> Hi Erik,
>>>
>>> Definitely getting there!
>> Hi Tim !
>>
>> Great to read you.
>>
>>> I installed using Synaptic "openssl" and "libopenssl-dev" (the other
>> options you gave were not in the package list - I hope that's OK).
>>
>> yep, you did the right thing
>>
>>> I then ran cpan Test::Inter, and finally gnc-fq-update.
>> Cool! you got it working then :)
>>
>>> The dialog box in GnuCash then showed that Finance::Quote appeared to be
>> installed properly, BUT I can't get quotes out yet.  I tries various
>> combinations of ISIN and SEDOL codes for the stocks (see below), with
>> variations of data sources, but still drew a blank (see below).  If I open
>> the Yahoo Finance webpage, and type in any of the four ISIN codes in the
>> search box at the top, it finds the correct stock with price and
>> performance data so some of this is correct.
>>
>> Auch :/ ISIN codes are _not_ supported with yahoo_europe. But!...
>> You can get them through the yahoo_json module! However I have no idea
>> which item you should choose in the Gnucash list. Maybe a Gnucash developer
>> should be able to give you a hint :)
>>
>> This is the info I get for the code you entered:
>> TIP: Don’t forget to add '.L' to the code
>>
>>> perl ./stockdump.pl yahoo_json GB0003878559.L
>> $VAR1 = {
>>           'GB0003878559.Lname' => 'GB0003878559.L (Fidelity MoneyBuilder
>> Balanced)',
>>           'GB0003878559.Lisodate' => '2014-06-20',
>>           'GB0003878559.Llast' => '49.000000',
>>           'GB0003878559.Ldate' => '06/20/2014',
>>           'GB0003878559.Lvolume' => '0',
>>           'GB0003878559.Lsuccess' => 1,
>>           'GB0003878559.Ltype' => 'mutualfund',
>>           'GB0003878559.Lsymbol' => 'GB0003878559.L',
>>           'GB0003878559.Lmethod' => 'yahoo_json',
>>           'GB0003878559.Lexchange' => 'Sourced from Yahoo Finance (as
>> JSON)'
>>         };
>>
>> best
>> --
>> erik colson
>>
>>
>> _______________________________________________
>> 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.



More information about the gnucash-user mailing list