[GNC] Gnucash 5.1 Online Quotes not working

Tue May 23 20:51:52 EDT 2023

Hi,

In addition to the below, when I try to run a PERL command it also fails,
previously with v4.xx this was possible?

See attached

-----Original Message-----
From: Thornefamilytrust at bigpond.com <Thornefamilytrust at bigpond.com> 
Sent: Wednesday, May 24, 2023 8:42 AM
To: 'Kalpesh Patel' <kalpesh.patel at usa.net>
Cc: 'gnucash-user at gnucash.org' <gnucash-user at gnucash.org>
Subject: RE: [GNC] Gnucash 5.1 Online Quotes not working

Hi,

I have those exact settings selected as below and it's not updating see
attached

Last update was with v4.xx in April 2023 see attached.

Previously with V4.xx was working fine, all I have done is upgrade to v5.1,
uninstall Perl and run the online price retrieval tool which has reinstalled
the latest Perl.

Nothing else on my PC has changed and still running Norton with the same
settings as previously.

-----Original Message-----
From: Kalpesh Patel <kalpesh.patel at usa.net> 
Sent: Tuesday, May 23, 2023 9:36 PM
To: Thornefamilytrust at bigpond.com
Cc: gnucash-user at gnucash.org
Subject: RE: [GNC] Gnucash 5.1 Online Quotes not working

If it is "seems to do something for a while 30-60 sec then the Perl wind
closes without any errors" then your quote retrieving facility is most
likely working correctly and retrieving prices. Re-running install script
and displaying the info you list is further concurrence that the quote
retrieving facility is working fine. Here most likely is case of security
definition having incorrect ticker symbol or the source you are selecting
does not carry prices for it. Try adding a known security with a known
source and see if it retrieves prices or not (see below known to work for
me). If it does not retrieve prices even after that then there is likely a
third party malware protection installed on your system which is blocking
networking connection to the source to retrieve prices.

Here is the security definition...

Security Information
	Full Name: Berkshire Hathaway Inc Class B
	Symbol/abbreviation: BRK-B
	Display symbol: BRK-B
	Namespace: NYSE (note: type in 'NYSE' if it is not found in the drop
down)
	ISIN,CUSIP or other code: (leave it blank)
	Fraction traded 1/:100000

Quote Source Information:
		--tick 'Get Online Quotes'
	Type of quote source:
		--click 'Single' and field next to it needs to read 'Yahoo
as JSON' (scroll down the drop down by clicking the arrow on the right side
and then select it from the list. )
		 Timezone: Use local time

Update the prices (Tools -> Price Database --> click 'Get Quotes' button)
and then review it in that window whether price was retrieved or not. Expand
the 'NYSE' namespace and underneath it you should see BRK-B. Click arrow to
the left of 'BRK-B' to see prices that GNC has collected so far. If nothing
is there  then most likely a third party malware protection (or a malware)
is restricting connection. If prices were retrieved then you need to
ascertain correct source and symbol by means of experimentation for the
security that is of interest for which prices retrieval has eluded you so
far. 

-----Original Message-----
From: Thornefamilytrust at bigpond.com <Thornefamilytrust at bigpond.com>
Sent: Monday, May 22, 2023 9:22 PM
To: gnucash-user at gnucash.org
Subject: [GNC] Gnucash 5.1 Online Quotes not working

Hi,

I have re-tried by installing Gnucash v5.1 on my Win 10 machine to get
online quotes to work. 

Upgraded from 4.XX to 5.1 uninstalled Strawberry and ran the "Install Online
Price retrieval" tool for Gnucash. This reinstalled Strawberry Perl , F:Q
etc

but all I get when clicking Get Quotes within Gnucash is the Perl window
opens and seems to do something for a while 30-60 sec then the Perl wind
closes without any errors - the quotes have not been updated. 

System:

Win 10

Gnucash 5.1

F:Q 1.55

Re-running "Install Online Price retrieval" tool for Gnucash produces the
following

*Check Perl

* Check Perl version

* Install required perl modules

Database was generated on Mon, 22 May 2023 03:35:21 GMT

Test2 is up to date (1.302195).

Finance::Quote is up to date (1.55).

JSON::Parse is up to date (0.62).

* Check environment variable ALPHAVANTAGE_API_KEY

  ***

  *** You need an API key (from https://www.alphavantage.co)

  ***   to run the Perl module Finance::Quote.

  ***

  *** Make it available to GnuCash by

  ***    - setting the environment variable ALPHAVANTAGE_API_KEY or

  ***    - starting GnuCash and adding the Alpha Vantage api key in

  ***        Edit->Preferences->Online Quotes

  ***

* Installation succeeded

Press any key to continue . . .

I have set the Alphavantage Key in Gnucash and can see it in preferences.

Not sure what to do to get this working - please assist.

Regards

Kevin

-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot PERL command not working.jpg
Type: image/jpeg
Size: 32111 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20230524/01d4e143/attachment.jpg>