Re: [GNC] gnucash-user Digest, Vol 231, Issue 73
Hi Kalpesh, So I found a solution which I detail here: https://lists.gnucash.org/pipermail/gnucash-user/2022-June/101721.html Basically, it was all to do with the fact that I was using a Flatpak version of Gnucash (on Linux) - so yes there technically are two versions of Perl, but the one used by Gnucash is the one bundled into the Flatpak app sandbox (i.e. only Gnucash uses it). The problems were then that: 1. The version of Perl on my computer (not in the Flatpak) was working with the Quotes feature for AU stocks straight out of the box - the packaged version didn't. 2. How to update the packaged version wasn't immediately obvious However, I found out how -to update it, though it didn't update perfectly - the bundled Perl version still can't get info from the ASX, but it now can from Yahoo (JSON). So ultimately it now does work. Cheers, Richard. On Fri, Jul 1, 2022 at 1:23 AM Kalpesh Patel wrote: > 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@my-desktop:~# find / -name perl -type f -executable -print > /usr/bin/perl > root@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 > To: Geoff > Cc: gnucash-user@gnucash.org > Subject: Re: [GNC] ASX Online quotes problem > Message-ID: > e9bdnpy1+u+-fh7zs4v9...@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 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:
Re: [GNC] ASX Online quotes problem
Ok, I found a solution, helped by Geoff, which I describe here in case it is of any use to others. Note: This solution is relevant to the Flatpak distribution of Gnucash on Linux. So, Geoff rightly pointed out that my command line quotes were working using my system version of Perl, not the sandbox Flatpak version, which is what Gnucash uses. My attempts to run the quote scripts/gnucash-cli from a terminal failed as they were trying to be run outside of the Flatpak sandbox so were not dynamically linking with the appropriate, bundled, dynamic libraries. To use them you need to enter the sandbox for the Gnucash app as a command line interface by typing flatpak run --command=sh org.gnucash.GnuCash This enters a shell in the Flatpak sandbox. In this environment you can then update the relevant perl modules using "gnc-fq-update". This was a lengthy procedure and it didn't completely succeed. For instance, within the sandbox shell after the update, the command "gnc-fq-dump asx vgs" still did not work, even though it worked using by system's version of Perl. However, using Yahoo as JSON as a source did work, i.e. "gnc-fq-dump yahoo_json VGS.AX". Consequently, reloading Gnucash, and setting the stock details in the security editor to: Symbol: VGS.AX Source: Yahoo as JSON allowed the ASX stocks to get online quotes. On Thu, Jun 30, 2022 at 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, 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@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.
Re: [GNC] ASX Online quotes problem
Apologies for the spam - just trying to make the necessary info visible. So I have found a separate perl executable bundled with the Flatpak installation. The issue now appears to be that I can't run the update script with it as these executables are designed to be run independently of Flatpak. I.e. in this bundled folder is "perl", "gnucash", "gnucash-cli", "gnc-fq-dump" etc. But I can't "run" any of them - I get a runtime linking error. I was able to run the gnc-fq-* scripts as I was invoking my system version of perl to do so. I open the gnucash GUI itself with the entry to the flatpak, "org.gnucash.GnuCash". I.e. there appear to be a few issues with distributing Gnucash as a flatpak here: These quite important scripts (gnc-fq-*, gnucash-cli) are: 1. Hidden away in some horrible hidden file structure e.g. "~/.local/share/flatpak/app/org.gnucash.GnuCash/x86_64/stable/de789f62d67a6ed3ae7fd898b9d1e05cf57cb26fc7f7743262608dfefc81bd0b/files/bin" 2. Even when you do find them, they can't simply be run - the only one that can be run is "gnucash" (i.e. the GUI), because that is the one that is hardlinked to in the Flapak run command "flatpak run org.gnucash.Gnucash" Thanks, R. On Thu, Jun 30, 2022 at 6:43 PM Geoff 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, > <mailto:cleanoutmys...@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 > >
Re: [GNC] ASX Online quotes problem
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 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, > <mailto:cleanoutmys...@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@gnucash.org <mailto:gnucash-user@gnucash.org> > >
Re: [GNC] ASX Online quotes problem
Hi Geoff, Yes, I see, that would explain the behaviour. I followed your advice and upgraded with that script to v 1.51. Unfortunately, that hasn't solved the issue, and the version reported in Help->About in Gnucash remains at 1.49, aligning with your suggestion that two versions are acting independently here. I think I might be waiting for someone who is familiar with how Gnucash plays in Linux to weigh in on how to manage the "GUI version". Thanks for your help, R. On Thu, Jun 30, 2022 at 6:43 PM Geoff 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, > <mailto:cleanoutmys...@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. > >
Re: [GNC] ASX Online quotes problem
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, 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, 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@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. > ___ gnucash-user mailing list gnucash-user@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.
[GNC] ASX Online quotes problem
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, 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@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.
