Thanks Bruce and Kalpesh for your help. Sorry to hear of Bruce's health issues 
and I wish you a speedy recovery.

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. 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!

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.

Although my issues are now resolved I am still a bit puzzled with the results I 
got!

Thanks for your help and I am enjoying finding out a bit more about the inner 
workings of Perl but I fear it is too late for me to become even 
semi-proficient!

Adrian
________________________________
From: Kalpesh Patel <kalpesh.pa...@usa.net>
Sent: 03 March 2025 22:57
To: 'Bruce Schuck' <bsch...@asgard-systems.com>; 'GnuCash User' 
<gnucash-user@gnucash.org>
Cc: 'Adrian Holbrook' <megagru...@hotmail.com>
Subject: RE: [GNC] Problems getting prices from Yahoo as JSON

Hi Bruce:

Hopefully you are on your way to mending from the health issue.

Anyways, your suggestions are duly noted and will keep them in mind.

-----Original Message-----
From: Bruce Schuck <bsch...@asgard-systems.com>
Sent: Monday, March 03, 2025 4:40 PM
To: GnuCash User <gnucash-user@gnucash.org>
Cc: Kalpesh Patel <kalpesh.pa...@usa.net>; Adrian Holbrook 
<megagru...@hotmail.com>
Subject: Re: [GNC] Problems getting prices from Yahoo as JSON

Sorry for late response, I've been battling some health issues the last
month+.

On Mar 1, 2025 at 09:06:36 EST, Kalpesh Patel wrote:

 > If you have Unix/Linux then you can run following to get the official  > 
 > interim release (literally cut and paste each line when your prompt  > comes 
 > back after executing each one) as mentioned by another user  > on this 
 > distro:


     cd ~
     wget

https://gbr01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.cpan.org%2Fauthors%2Fid%2FB%2FBP%2FBPSCHUCK%2FFinance-Quote-1.64_03.tar.gz&data=05%7C02%7C%7Ca140570d4e1748c1cf3608dd5aa6d4d6%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638766394751254965%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=%2FR7upIWQ8%2Bg3WCiWkngaAKgVj%2FXor2NPKl6K43kNlp4%3D&reserved=0<https://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.64_03.tar.gz>
     tar -xvf ./Finance-Quote-1.64_03.tar.gz
     cd Finance-Quote-1.64_03/
     perl Makefile.PL
     make
     sudo make install

Kalpesh,

While this will work for this case (no extra dependencies added), please 
refrain from suggesting this method of installing Finance::Quote.
Especially to those with limited experience with Perl.

There is no reason that the cpan or cpanm utilities can not be used on Windows 
with Strawberry Perl, Mac OSX, and especially Linux/Unix/BSD.
For those who for some reason are having difficulties with cpan/cpanm, it would 
be much more beneficial in the long run to troubleshoot why the standard Perl 
module install tool is not working.

WRT the GBP/GBp issue, I would appreciate that the issue is duplicated and 
confirmed BEFORE suggesting a user make manual edits! In the case of NWG.L, 
Finance::Quote this morning returned Last:4.803 GBP (pounds). A lookup at 
https://gbr01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.londonstockexchange.com%2Fstock%2FNWG%2Fnatwest-group-plc%2Fcompany-page&data=05%7C02%7C%7Ca140570d4e1748c1cf3608dd5aa6d4d6%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638766394751271330%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=loJYGG0pad%2FMDVUB6lRNwCnqxOVu2fMhB1XfrZFPGWE%3D&reserved=0<https://www.londonstockexchange.com/stock/NWG/natwest-group-plc/company-page>
returned 480.30 GBX (pence). And finance.yahoo.com returned 480.30 GBp (pence). 
Perhaps asking Adrian what values he was seeing, and why he determined they 
were incorrect?

Thank you.

Bruce S.

_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Reply via email to