[GNC] Gnucash 5.1 Online Quotes not working
David H
hellvee at gmail.com
Wed May 24 01:06:53 EDT 2023
It's a windows exe and you'll need double quotes around the path name
because of the embedded spaces - see Geert's email -
https://lists.gnucash.org/pipermail/gnucash-user/2023-May/106961.html
Try the following in a windows command prompt, you should see
similar results....
Cheers David H.
C:\Users\David>"c:\Program Files (x86)\gnucash\bin\gnucash-cli" --quotes
info
Found Finance::Quote version 1.55.
Finance::Quote sources:
aex alphavantage amfiindia asegr asx
aufunds australia bamosz bet bloomberg bourso
bse bseindia canada canadamutual comdirect
cse deka dutch dwsfunds europe
fetch_live_currencies fidelity fidelity_direct
finanzpartner fondsweb fool france ftfunds
fundata fundlibrary goldmoney greece hu hufund
hungary hustock iexcloud india indiamutual
known_currencies morningstarau morningstarch
morningstarjp mstaruk nasdaq nseindia nyse
nzx onvista oslobors romania seb_funds sinvestor
six tesouro_direto tiaacref tmx tradegate
tradeville treasurydirect troweprice troweprice_direct
tsp tsx ukfunds unionfunds usa xetra
yahoo_json za
On Wed, 24 May 2023 at 14:48, <Thornefamilytrust at bigpond.com> wrote:
> Hi David,
>
>
>
> Thanks that makes sense and yes gnc-fq-check no longer exists
>
>
>
> Am I able to run gnucash-cli?
>
>
>
> I cant get it to work manually? See attached
>
>
>
>
>
>
>
> *From:* David H <hellvee at gmail.com>
> *Sent:* Wednesday, May 24, 2023 12:37 PM
> *To:* Thornefamilytrust at bigpond.com
> *Cc:* Kalpesh Patel <kalpesh.patel at usa.net>; gnucash-user at gnucash.org
> *Subject:* Re: [GNC] Gnucash 5.1 Online Quotes not working
>
>
>
> Hi Kevin,
>
>
>
> Note that Gnucash Get Quotes has been completely rewritten so there is no
> longer a gnc-fq-check script in gnucash version 5 that's why you are
> getting the error, check your C:\Program Files (x86)\gnucash\bin folder -
> this was mentioned in the release notes :-) There's only gnc-fq-update
> and gnc-path-check (which you can't run manually apparently) now so
> probably nothing wrong with your Perl install.
>
>
>
> Cheers David H.
>
>
>
> On Wed, 24 May 2023 at 10:53, <Thornefamilytrust at bigpond.com> wrote:
>
> 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
>
>
>
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
>
>
More information about the gnucash-user
mailing list