yahoo as json stock quotes pounds/pence

Dave H hellvee at gmail.com
Sat Jan 27 16:53:11 EST 2018


Also if you go to
https://lists.gnucash.org/pipermail/gnucash-user/2017-November/thread.html#72946
there's a lot more info re the issue of changing quotes from Yahoo to
Alphavantage.

If you want to search the mailing list you need to specify the site in
google e.g. "site:gnucash-user at gnucash.org alphavantage" or similar as the
Gnucash search function doesn't work.

The actual release announcement for this change is at
https://lists.gnucash.org/pipermail/gnucash-user/2017-November/072859.html

And states among other things...

Finance-Quote 1.45 released!*Erik Colson* eco at ecocode.net
<gnucash-user%40gnucash.org?Subject=Re:%20Re%3A%20Finance-Quote%201.45%20released%21&In-Reply-To=%3C20171108203651.33934E00DB1%40shangai.localdomain%3E>
*Wed Nov 8 15:36:51 EST 2017*


   - Previous message (by thread): Asian Stocks and Multiple Currencies Not
   Updated
   <https://lists.gnucash.org/pipermail/gnucash-user/2017-November/072877.html>
   - Next message (by thread): Finance-Quote 1.45 released!
   <https://lists.gnucash.org/pipermail/gnucash-user/2017-November/072871.html>
   - *Messages sorted by:* [ date ]
   <https://lists.gnucash.org/pipermail/gnucash-user/2017-November/date.html#72859>
    [ thread ]
   <https://lists.gnucash.org/pipermail/gnucash-user/2017-November/thread.html#72859>
    [ subject ]
   <https://lists.gnucash.org/pipermail/gnucash-user/2017-November/subject.html#72859>
    [ author ]
   <https://lists.gnucash.org/pipermail/gnucash-user/2017-November/author.html#72859>

------------------------------

New version 1.45 of Finance-Quote is available with the following changes:

        * alphavantage
          * more suffix - currency pairs added
          * GBP and GBX divided by 100


Cheers Dave H.


On 28 January 2018 at 07:02, Dave H <hellvee at gmail.com> wrote:

> This came about because of an issue reported in early November last year
> and is considered solved I believe ....
>
> What version of Finance Quote are you running as it all changed about then
> ???
>
> > On 06/11/17 22:43, Erik Colson wrote:
> >> New version 1.43 of Finance-Quote is available with the following
> changes:
> >
> > All prices from AlphaVantage are being returned 100 times too big as
> > pence rather than pounds. For example, a price of £7.329 is being
> > returned as £732.90. This is making stock values 100 times too big in
> > gnucash.
>
> division by 100 will be added in F::Q v1.45
>
> Cheers Dave H.
>
>
> On 28 January 2018 at 02:18, ml enquirer <ml.hnel.227484 at gmail.com> wrote:
>
>> OK, I guess this is not a solved problem, then? I don't see this on the
>> GnuCash FAQ page... and I figure these 2008/2009 threads are quite likely
>> to be outdated.
>>
>> I did the following:
>> - checkout financequote: "git clone
>> https://github.com/finance-quote/finance-quote.git
>> - edit lib/Finance/Quote/YahooJSON.pm to change:
>> <<
>>
>> $info{ $stocks, "last" }   = $json_price;
>> >>
>>
>> $info{ $stocks, "last" }   = $json_price/100.;
>> - edit the gnc-fq-helper script to add at the top the line:
>>
>> use lib '<path to my checked-out finance-quote>/lib';
>>
>>
>> This isn't a great/elegant solution. I'd be very interested to hear what
>> more experienced people have to say!
>>
>>
>> Thanks,
>>
>> Dan
>>
>>
>> On Thu, Jan 25, 2018 at 11:55 PM, ml enquirer <ml.hnel.227484 at gmail.com>
>> wrote:
>>
>> > Hi,
>> >
>> > I'm aware this is not a new question:
>> > - https://lists.gnucash.org/pipermail/gnucash-user/2008-
>> > November/027224.html
>> > - https://lists.gnucash.org/pipermail/gnucash-user/2008-April/
>> 024688.html
>> > - https://lists.gnucash.org/pipermail/gnucash-user/2009-
>> > February/028602.html
>> >
>> > but I recently found the "get quotes" feature stopped working with a
>> very
>> > generic error message (more or less the same time as the change of
>> currency
>> > quotes from yahoo to alphaVantage). So I switched my "Type of quote
>> source"
>> > in the "Securities Editor" to "Yahoo as JSON" instead of "Yahoo Europe".
>> >
>> > However, now I see the returned values are in GBP *pence* not *pounds*,
>> so
>> > 100 times larger than GnuCash expects.
>> >
>> > Most previous fixes discussed here (as far as I can see all >2 years
>> old)
>> > involve various hacks at different levels in the source. Is this a
>> solved
>> > problem, or do I need to follow their lead and dig around in the code?
>> >
>> > Thanks in advance!
>> >
>> _______________________________________________
>> 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