[GNC] gnucash-user Digest, Vol 231, Issue 73

Kalpesh Patel kalpesh.patel at usa.net
Thu Jun 30 11:23:40 EDT 2022


Richard, can you do some digging around to see if you have multiple version
of Perl or not. Assuming you are NOT on a Windows OS (will work ok within
WSL service in Windows - ignore if you do not know what that is), execute
following command in a shell prompt:


find / -name perl -type f -executable -print


When above command finishes, it will have returned full path to all Perl
that are available on that system. The number of lines returned back is
number of locations where Perl is installed on that system. If it returns
back only one line than you only have one Perl installed on that system --
that is good. If it is more than one then now you need to decide whether up
to upgrade the Finance::Quote on all of them or you have to find where it is
not working correctly, which will be more complex undertaking. You can
install/upgrade Finance::Quote in all Perl as follows: 

Take first full line from the above command and append following to it:
-MCPAN -e 'install Finance::Quote'

For example, when I run the 'find" command, my output looks like this (one
line returned which means I have only one Perl installed on my system):


root at my-desktop:~# find / -name perl -type f -executable -print
/usr/bin/perl
root at my-desktop:~#


Now I take the first entry (/usr/bin/perl) and append second part (-MCPAN -e
'install Finance::Quote') to get following full command to run in a shell:


/usr/bin/perl -MCPAN -e 'install Finance::Quote'


If you are running it for first time then it may ask few question for
initial configuration - feel free to accept default answers for all
questions as they are sane enough to work properly. Now you can do same
thing for the next entry until all different entries has the module
installed. I hope that it doesn't have more than two or three printed
entries as that would be the norm on the extreme case.

Now BIG DISCLAIMER: this will install or upgrade Finance::Quote module for
all the different locations where Perl is installed. Alternative is for you
to pick and choose in which Perl location to install but that seems to be
more vexing question which is probably out of scope of GNC needs. Make sure
you take backup of the system as if something else get broken then you can
recover back by restoring back from backup should it be necessary.

Hope this helps.


------------------------------

Message: 4
Date: Thu, 30 Jun 2022 19:40:45 +1000
From: Richard Spinney <rspinney20 at gmail.com>
To: Geoff <cleanoutmyshed at gmail.com>
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] ASX Online quotes problem
Message-ID:
	<CACyLq=5gF+hykYQ5Egs=LdUOto=e9BdNpy1+U+-Fh7Zs4v9xUg at mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"

As a note, it might be relevant that I am using a Flatpak distribution of
Gnucash, possibly explaining the "two versions" situation. Running the
Flatpak from the command line confirms that it is detecting Finance::Quotes
v1.49 even though the command line version I am using is v1.51.

On Thu, Jun 30, 2022 at 6:43 PM Geoff <cleanoutmyshed at gmail.com> wrote:

> Hi Richard
>
> Yes, that is confusing.  It is possible that this discrepancy in 
> behaviour may be due to you having two instances of Perl installed - 
> the later one is seen by your command line scripts and the earlier 
> (out of
> date) one is seen by your GnuCash GUI.  I make this suggestion as I 
> recall seeing other GnuCash problems being reported due to this.  I am 
> mainly a Windows user so I can't really help you to trouble shoot.
>
> Anyway, to upgrade, you can try the "gnc-fq-update" Perl script, which 
> should get the latest version (1.51) from CPAN:
> https://metacpan.org/pod/Finance::Quote
>
> Finally, I have attached a screenshot of my setup to retrieve prices 
> for ASX securities.
>
> Hope this helps.
>
> Regards
>
> Geoff
> =====
>
> On 30/06/2022 6:26 pm, Richard Spinney wrote:
> > Hi Geoff,
> >
> > Thanks for this.
> >
> > I am little bit confused though, the command line perl scripts I am 
> > using with the ASX as a source work fine. But moreover, they work 
> > when I use *different* sources (e.g. yahoo as JSON), but then they 
> > don't work in gnucash itself - I.e. the issue is there when I 
> > specifically avoid the ASX as a source. Or have I missed something?
> >
> > If I do have to update that module do you have any links or similar 
> > you could point me to?
> >
> > Thanks,
> >
> > R.
> >
> > On Thu, 30 June 2022, 18:21 Geoff, <cleanoutmyshed at gmail.com 
> > <mailto:cleanoutmyshed at gmail.com>> wrote:
> >
> >     Hi Richard
> >
> >     The ASX did a major web upgrade back in 2020 that broke Version 
> > 1.49
> of
> >     Finance::Quote.  If you want to use the ASX as your data source for
> >     Australian listed securities then you will need to upgrade that Perl
> >     module.
> >
> >
> >     Regards
> >
> >     Geoff
> >     =====
> >
> >     On 30/06/2022 5:44 pm, Richard Spinney wrote:
> >      > Hi All,
> >      >
> >      > I'm having some trouble fetching online quotes for Australian
> >     stocks in
> >      > Gnucash.
> >      >
> >      > My versions are:
> >      >
> >      > Gnucash Version: 4.11
> >      > Build ID: Flathub 4.11
> >      > Finance::Quote: 1.49
> >      >
> >      > running on Linux.
> >      >
> >      > Every other security price fetch seems to work fine. For
> >     instance, this
> >      > works for US stocks when input into the security editor:
> >      >
> >      > Symbol: AAPL
> >      > Source: alphavantage
> >      >
> >      > as do currency quotes.
> >      >
> >      > However, I get the following error message:
> >      >
> >      > "Unable to retrieve quotes for these items ASX:VGS ..."
> >      >
> >      > where ASX is just my "type" categorisation", if I try any ASX
> >     stock/etf
> >      > (here using VGS as an example) with any permutation of
> >      >
> >      > Symbol: VGS, VGS.AX <http://VGS.AX>, ASX:VGS, ASX.VGS
> >      > Source: Alphavantage US, Australian Stock Exchange AU,Yahoo 
> > as
> JSON
> >      >
> >      > For reference, I have got the underlying command line scripts
> >     working and I
> >      > *can* get Australian quotes using them (in addition to currency
> >     and US
> >      > stock quotes that *do* work in Gnucash). For instance the
> following
> >      > commands all return sensible quotes
> >      >
> >      >
> >      > perl gnc-fq-dump -v asx vgs
> >      > perl gnc-fq-dump -v yahoo_json VGS.ax
> >      > perl gnc-fq-dump -v australia vgs
> >      >
> >      > I'm unclear if this is because of something I am doing wrong 
> > with
> the
> >      > details in the security editor or if there is something else I'm
> >     missing.
> >      >
> >      > Thanks in advance,
> >      >
> >      > R.
> >      > _______________________________________________
> >      > gnucash-user mailing list
> >      > gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> >      > To update your subscription preferences or to unsubscribe:
> >      > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >     <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> >      > If you are using Nabble or Gmane, please see
> >     https://wiki.gnucash.org/wiki/Mailing_Lists
> >     <https://wiki.gnucash.org/wiki/Mailing_Lists> for more information.
> >      > -----
> >      > Please remember to CC this list on all your replies.
> >      > You can do this by using Reply-To-List or Reply-All.
> >


------------------------------

Subject: Digest Footer

_______________________________________________

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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


------------------------------

End of gnucash-user Digest, Vol 231, Issue 73
*********************************************



More information about the gnucash-user mailing list