thanks kalpesh,

i stand corrected, i tried fetching with BRK-B with Alphavantage and it worked. 
Also with ANZ i am able to fetch with multiple ->Australia (ASX)

so the issue is somewhere else




Saludos Cordiales


Murugan

________________________________
From: Kalpesh Patel <kalpesh.pa...@usa.net>
Sent: Wednesday, May 24, 2023 11:21 AM
To: 'Murugan Muruganandam' <m.muruganan...@hotmail.com>; 
thornefamilytr...@bigpond.com <thornefamilytr...@bigpond.com>; 'David H' 
<hell...@gmail.com>
Cc: gnucash-user@gnucash.org <gnucash-user@gnucash.org>
Subject: RE: [GNC] Gnucash 5.1 Online Quotes not working


Kevin –



In addition to below what Murugan has mentioned … two additional items to try:



1)      Check which perl is GNC using (this is to eliminate munged up path or 
GNC is looking at different Perl install base – unlikely but validation won’t 
hurt)

To do so, type in following in an clean CMD window:



                where Perl



This for me returns back ‘C:\Strawberry\Perl\bin\perl.exe’



2)      Start with a clean slate in GNC … also recommend that you fully turn 
off Norton mal-ware/anti-virus software for duration of this clean slate test.

a.       Open GNC

Select ‘File’ -> ‘New File’ (select default all the way through and save the 
file as ‘test’ or something like that at a known location in a separate folder. 
You’ll want to delete the folder once test is over)

b.       Define the ‘Berkshire Hathaway Inc Class B’ security as previously 
mentioned and only this one security precisely as detailed in prior email.

c.       Update prices

d.       Review if prices got retrieved



Few notes:



On ‘Change the symbol for Berkshire to BRK.B from BRK-B’, for me when the 
source is set to ‘Yahoo as JSON’, BRK-B (one with the dash) retrieves prices. 
There is likely a chance that different price sourcer might set the symbol 
format differently – this is the experimentation part which is to figure out 
what security works with which price source as mentioned earlier in the thread. 
If you want an alternate that does not have a complication of different classes 
of security then try the below simpler one:



Security Information:

Full Name: BANK OF NEW YORK MELLON CORP COM

Symbol/abbreviation: BK

Display symbol: BK

Namespace: NYSE

ISIN, CUSIP or other code: <blank>

Fraction traded 1/:1000



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



Prices pull for ‘BRK-B’ via ‘Yahoo as JSON’ source was working for me as of 
this writing but your mileage may very if Yahoo is in middle of shutdown of v6 
spigot (David H mentioned this).







From: Murugan Muruganandam <m.muruganan...@hotmail.com>
Sent: Wednesday, May 24, 2023 10:49 AM
To: thornefamilytr...@bigpond.com; 'David H' <hell...@gmail.com>
Cc: 'Kalpesh Patel' <kalpesh.pa...@usa.net>; gnucash-user@gnucash.org
Subject: Re: [GNC] Gnucash 5.1 Online Quotes not working





couple of things from your screen shots



  1.  Change the symbol for Berkshire to BRK.B from BRK-B
  2.  for ANZ choose single quote and exchange as Australian Stock Exchange, AU







Saludos Cordiales



Murugan

________________________________

From: gnucash-user 
<gnucash-user-bounces+m.muruganandam=hotmail....@gnucash.org<mailto:gnucash-user-bounces+m.muruganandam=hotmail....@gnucash.org>>
 on behalf of 
thornefamilytr...@bigpond.com<mailto:thornefamilytr...@bigpond.com> 
<thornefamilytr...@bigpond.com<mailto:thornefamilytr...@bigpond.com>>
Sent: Wednesday, May 24, 2023 3:43 AM
To: 'David H' <hell...@gmail.com<mailto:hell...@gmail.com>>
Cc: 'Kalpesh Patel' <kalpesh.pa...@usa.net<mailto:kalpesh.pa...@usa.net>>; 
gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> 
<gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] Gnucash 5.1 Online Quotes not working



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 <hell...@gmail.com<mailto:hell...@gmail.com>>
Sent: Wednesday, May 24, 2023 1:07 PM
To: thornefamilytr...@bigpond.com<mailto:thornefamilytr...@bigpond.com>
Cc: Kalpesh Patel <kalpesh.pa...@usa.net<mailto:kalpesh.pa...@usa.net>>; 
gnucash-user@gnucash.org<mailto:gnucash-user@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, <thornefamilytr...@bigpond.com 
<mailto:thornefamilytr...@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 <hell...@gmail.com <mailto:hell...@gmail.com> >
Sent: Wednesday, May 24, 2023 12:37 PM
To: thornefamilytr...@bigpond.com<mailto:thornefamilytr...@bigpond.com> 
<mailto:thornefamilytr...@bigpond.com>
Cc: Kalpesh Patel <kalpesh.pa...@usa.net <mailto:kalpesh.pa...@usa.net> >; 
gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> 
<mailto:gnucash-user@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, <thornefamilytr...@bigpond.com 
<mailto:thornefamilytr...@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: thornefamilytr...@bigpond.com<mailto:thornefamilytr...@bigpond.com> 
<mailto:thornefamilytr...@bigpond.com>  <thornefamilytr...@bigpond.com 
<mailto:thornefamilytr...@bigpond.com> >
Sent: Wednesday, May 24, 2023 8:42 AM
To: 'Kalpesh Patel' <kalpesh.pa...@usa.net <mailto:kalpesh.pa...@usa.net> >
Cc: 'gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> ' 
<gnucash-user@gnucash.org <mailto:gnucash-user@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.pa...@usa.net <mailto:kalpesh.pa...@usa.net> >
Sent: Tuesday, May 23, 2023 9:36 PM
To: thornefamilytr...@bigpond.com<mailto:thornefamilytr...@bigpond.com> 
<mailto:thornefamilytr...@bigpond.com>
Cc: gnucash-user@gnucash.org<mailto:gnucash-user@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: thornefamilytr...@bigpond.com<mailto:thornefamilytr...@bigpond.com> 
<mailto:thornefamilytr...@bigpond.com>  <thornefamilytr...@bigpond.com 
<mailto:thornefamilytr...@bigpond.com> >
Sent: Monday, May 22, 2023 9:22 PM
To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> 
<mailto:gnucash-user@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@gnucash.org<mailto:gnucash-user@gnucash.org> 
<mailto: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.
_______________________________________________
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