[GNC] Problems getting prices from Yahoo as JSON
Bruce Schuck
bschuck at asgard-systems.com
Tue Mar 4 11:28:41 EST 2025
On 3/4/25 12:01 AM, Adrian Holbrook wrote:
> I think that the issue with the Perl module to download
> Finance::Quote is that it downloads the latest released version
> while I was trying to download the development issue.
Exactly what command were you using.
"cpan BPSCHUCK/Finance-Quote-1.64_03.tar.gz" would have installed the
interim version.
> In the end I just copied the relevant YahooJson.pm module and
> replaced the previous module. Unfortunately my programming
> experience was limited to Fortran, Basic and Logo (!) and I am a bit
> rusty!
I was a Fortran IV/77 developer a lifetime ago. Learned Basic as part of
an advanced Math curriculum in 8th grade (1974-1975).
> On the issue of the GBp to GBP conversion Things are now working
> but there is still a minor issue. When I checked this morning NXR
> was returning the correct price (I do not understand what has
> changed) but with NWG I realised that I was retrieving the price
> from Alphavantage not Yahoo and that was showing 480.5. When I
> changed the source to Yahoo as JSON it worked correctly and shows
> 4.803.
It's a known issue with AlphaVantage, noted in the Caveat section of the
Finance::Quote::AlphaVantage(3) man page. The AV API does not return the
currency, so all ".L" symbols are assumed to be GBP. If the user knows a
security is traded in GPp/GBX, and using AlphaVantage, add a ".X" to the
symbol. So NWG.L would be NWG.L.X.
Bruce S.
More information about the gnucash-user
mailing list