[GNC] Gnucash 5.1 Online Quotes not working
David H
hellvee at gmail.com
Wed May 24 05:46:39 EDT 2023
Hmm that setup works for me using a source of Alphavantage US as opposed to
Yahoo as JSON that Kalpesh specified as you have typed above and returns a
price for BRK-B. Did you say you had you Alphavantage api key setup in
Gnucash preferences under Finance Quote tab ?
On another note it for anyone else reading this it seems Yahoo have turned
off access to the version 6 api as I am now getting a HTTP Response 404
(Not Found) error when trying to use it and have had to revert my
YahooJSON.pm module to use v7 which gives an unauthorised error.
Cheers David H.
On Wed, 24 May 2023 at 17:43, <Thornefamilytrust at bigpond.com> wrote:
> Thanks David that works – still no online quotes in Gnucash
>
>
>
> I can run gnucash-cli from the CMD and get the desired results for ASX and
> ALPHAVANTAGE as per attached, but no online quotes within Gnucash – see
> settings attached.
>
>
>
> Is there another step I need to do in Gnucash to get this to work?
>
>
>
>
>
>
>
> *From:* David H <hellvee at gmail.com>
> *Sent:* Wednesday, May 24, 2023 1:07 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
>
>
>
> 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