Fw: Downloading Stock Prices - Finance::Quote Problems

[Alan Jaye]

Attention Liz or Colin

Regardless of recent correspondence and despite having unsubscribed from the Gnucash Forum and mailing list, I am STILL receiving emails like the one below.

PLEASE remove me from all mailing list immediately.

Alan Jaye

-----Original Message----- 
From: Erik Colson 
Sent: Monday, June 23, 2014 9:34 PM 
To: Tim Johnson 
Cc: gnucash-user at gnucash.org 
Subject: Re: Downloading Stock Prices - Finance::Quote Problems 


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.