Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
On 7/23/21 1:41 AM, david.rom...@davidjromano.com wrote: Hi Bruce, the headline news is that your suggestion fixed the issue - see gnu.png - very many thanks to you (and Chris and Geoff) for your help, expertise and patience. Not a problem, glad I could be of assistance. If you previously sent other screen shots that showed the errors just trying to use cpan, I'm sorry I missed them. Here's the detail: a) Running cpan> force install IO::Handle made no difference. I realize I should not have even suggested this, using cpan to reinstall IO::Handle would require the IO::Handle module which was at least part of your issue. As HJS would say, "D'Oh!". b) Reinstalling Strawberry Perl appeared to make no difference As you found out later, since you found artifacts of an older install, then you didn't completely remove Strawberry Perl as I suggested. But as long as you worked it out, cool beans! BUT: 1) A residual directory C: Strawberry with a date of 2016 remained. I deleted this. *This* was likely the key that caused all your headaches. Again very many thanks for all your help - I couldn't have done it without you. Again, not a problem. - Bruce S. ___ 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] Can anyone help with this issue please - GNC-FQ Not able to collect data
Hi Bruce, the headline news is that your suggestion fixed the issue - see gnu.png - very many thanks to you (and Chris and Geoff) for your help, expertise and patience. Here's the detail: a) Running cpan> force install IO::Handle made no difference. b) Reinstalling Strawberry Perl appeared to make no difference BUT: 1) A residual directory C: Strawberry with a date of 2016 remained. I deleted this. 2) I re-ran the Cpan upgrade utility cpan> upgrade This process took considerably longer than previously (about 5-10 minutes (I went to get a coffee so I'm not sure) - on a 64gb Xeon SSD machine!) and appeared, from the cmd prompt window trace, to have been a much more comprehensive build than the earlier one. On opening GNC the currencies list was fully instantiated and Get Quotes button returned and loaded the current value of EUR against GBP apparently in real time because the rate changes on re-clicking. Again very many thanks for all your help - I couldn't have done it without you. Best regards, Davide -Original Message- From: Bruce Schuck Sent: 22 July 2021 17:26 To: david.rom...@davidjromano.com; gnucash-user@gnucash.org Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data David, While that was worth a check, it is concerning that CPAN itself on your system appears to be having issues. The repeated error "syswrite() on unopened filehandle GEN3 at C:\Strawberry\perl\lib/IO/Handle.pm line 459. LWP failed with code[500] message[write failed: Bad file descriptor]" is likely an indication that there is an issue with your installation of Strweberry Perl. I would guess that whatever issue it may be, it is the cause of your issues with Finance::Quote. I would try: 1: Reinstall IO::Handle cpan> force install IO::Handle 2: *Completely* remove Strawberry Perl and reinstall from scratch. Somewhere in this thread I think you may have done this, but try once again please. - Bruce S. On 7/22/21 2:48 AM, david.rom...@davidjromano.com wrote: > Hi Bruce, > > I just checked this and it did not fix the issue - see attached > > > Best regards, > > David Romano, > > UK Direct line: +44 (0) 23 9234 1647 > UK Mobile & WhatsApp: +44 (0) 79 4830 8868 Skype Video Call: > David.J.Romano > > -Original Message- > From: Bruce Schuck > Sent: 21 July 2021 22:37 > To: gnucash-user@gnucash.org > Cc: david.rom...@davidjromano.com > Subject: ***SPAM*** Re: [GNC] Can anyone help with this issue please - > GNC-FQ Not able to collect data > > David, > > I've been testing installs of F::Q on different operating systems. > > An install of F::Q 1.51 on a MacBook running OSX Catalina (10.15.7) and Perl > 5.34.0 installed via HomeBrew uncovered an issue where the DistZilla tool > used to build the package for uploading to CPAN did not automatically the > dependency on LWP::Protocol::https. > > Please ensure that you have LWP::Protocol::https installed and test again. > > Thank you. > > - Bruce S. > ___ 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] Can anyone help with this issue please - GNC-FQ Not able to collect data
David, x64 is fine. I agree with Bruce - completely uninstall and reinstall. Regards Geoff = On 23/07/2021 4:46 am, david.rom...@davidjromano.com wrote: Bruce, I'll give this a try in the morning---but just a thought. I've been using the x64 Strawberry install because the system is x64 but could it be that CBC-FQ requires the 32 bit install? Sent from my iPhone On 22 Jul 2021, at 17:25, Bruce Schuck wrote: David, While that was worth a check, it is concerning that CPAN itself on your system appears to be having issues. The repeated error "syswrite() on unopened filehandle GEN3 at C:\Strawberry\perl\lib/IO/Handle.pm line 459. LWP failed with code[500] message[write failed: Bad file descriptor]" is likely an indication that there is an issue with your installation of Strweberry Perl. I would guess that whatever issue it may be, it is the cause of your issues with Finance::Quote. I would try: 1: Reinstall IO::Handle cpan> force install IO::Handle 2: *Completely* remove Strawberry Perl and reinstall from scratch. Somewhere in this thread I think you may have done this, but try once again please. - Bruce S. On 7/22/21 2:48 AM, david.rom...@davidjromano.com wrote: Hi Bruce, I just checked this and it did not fix the issue - see attached Best regards, David Romano, UK Direct line: +44 (0) 23 9234 1647 UK Mobile & WhatsApp: +44 (0) 79 4830 8868 Skype Video Call: David.J.Romano -Original Message- From: Bruce Schuck Sent: 21 July 2021 22:37 To: gnucash-user@gnucash.org Cc: david.rom...@davidjromano.com Subject: ***SPAM*** Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data David, I've been testing installs of F::Q on different operating systems. An install of F::Q 1.51 on a MacBook running OSX Catalina (10.15.7) and Perl 5.34.0 installed via HomeBrew uncovered an issue where the DistZilla tool used to build the package for uploading to CPAN did not automatically the dependency on LWP::Protocol::https. Please ensure that you have LWP::Protocol::https installed and test again. Thank you. - Bruce S. ___ 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.
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
David, While that was worth a check, it is concerning that CPAN itself on your system appears to be having issues. The repeated error "syswrite() on unopened filehandle GEN3 at C:\Strawberry\perl\lib/IO/Handle.pm line 459. LWP failed with code[500] message[write failed: Bad file descriptor]" is likely an indication that there is an issue with your installation of Strweberry Perl. I would guess that whatever issue it may be, it is the cause of your issues with Finance::Quote. I would try: 1: Reinstall IO::Handle cpan> force install IO::Handle 2: *Completely* remove Strawberry Perl and reinstall from scratch. Somewhere in this thread I think you may have done this, but try once again please. - Bruce S. On 7/22/21 2:48 AM, david.rom...@davidjromano.com wrote: Hi Bruce, I just checked this and it did not fix the issue - see attached Best regards, David Romano, UK Direct line: +44 (0) 23 9234 1647 UK Mobile & WhatsApp: +44 (0) 79 4830 8868 Skype Video Call: David.J.Romano -Original Message- From: Bruce Schuck Sent: 21 July 2021 22:37 To: gnucash-user@gnucash.org Cc: david.rom...@davidjromano.com Subject: ***SPAM*** Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data David, I've been testing installs of F::Q on different operating systems. An install of F::Q 1.51 on a MacBook running OSX Catalina (10.15.7) and Perl 5.34.0 installed via HomeBrew uncovered an issue where the DistZilla tool used to build the package for uploading to CPAN did not automatically the dependency on LWP::Protocol::https. Please ensure that you have LWP::Protocol::https installed and test again. Thank you. - Bruce S. ___ 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] Can anyone help with this issue please - GNC-FQ Not able to collect data
David, I've been testing installs of F::Q on different operating systems. An install of F::Q 1.51 on a MacBook running OSX Catalina (10.15.7) and Perl 5.34.0 installed via HomeBrew uncovered an issue where the DistZilla tool used to build the package for uploading to CPAN did not automatically the dependency on LWP::Protocol::https. Please ensure that you have LWP::Protocol::https installed and test again. Thank you. - Bruce S. ___ 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] Can anyone help with this issue please - GNC-FQ Not able to collect data
Bruce, I'll give this a try in the morning---but just a thought. I've been using the x64 Strawberry install because the system is x64 but could it be that CBC-FQ requires the 32 bit install? Sent from my iPhone > On 22 Jul 2021, at 17:25, Bruce Schuck wrote: > > David, > > While that was worth a check, it is concerning that CPAN itself on your > system appears to be having issues. > > The repeated error > > "syswrite() on unopened filehandle GEN3 at > C:\Strawberry\perl\lib/IO/Handle.pm line 459. > LWP failed with code[500] message[write failed: Bad file descriptor]" > > is likely an indication that there is an issue with your installation of > Strweberry Perl. I would guess that whatever issue it may be, it is the cause > of your issues with Finance::Quote. > > I would try: > > 1: Reinstall IO::Handle > cpan> force install IO::Handle > > 2: *Completely* remove Strawberry Perl and reinstall from scratch. Somewhere > in this thread I think you may have done this, but try once again please. > > - Bruce S. > >> On 7/22/21 2:48 AM, david.rom...@davidjromano.com wrote: >> Hi Bruce, >> I just checked this and it did not fix the issue - see attached >> Best regards, >> David Romano, >> UK Direct line: +44 (0) 23 9234 1647 >> UK Mobile & WhatsApp: +44 (0) 79 4830 8868 >> Skype Video Call: David.J.Romano >> -Original Message- >> From: Bruce Schuck >> Sent: 21 July 2021 22:37 >> To: gnucash-user@gnucash.org >> Cc: david.rom...@davidjromano.com >> Subject: ***SPAM*** Re: [GNC] Can anyone help with this issue please - >> GNC-FQ Not able to collect data >> David, >> I've been testing installs of F::Q on different operating systems. >> An install of F::Q 1.51 on a MacBook running OSX Catalina (10.15.7) and Perl >> 5.34.0 installed via HomeBrew uncovered an issue where the DistZilla tool >> used to build the package for uploading to CPAN did not automatically the >> dependency on LWP::Protocol::https. >> Please ensure that you have LWP::Protocol::https installed and test again. >> Thank you. >> - Bruce S. > ___ 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] Can anyone help with this issue please - GNC-FQ Not able to collect data
Hi D,
Yes I did – I even removed PERL / Strawberry Perl and allowed GNC to install
everything, but still it does not work.
I’m beginning to wonder if its an F::Q 1.51 issue.
Best regards,
David Romano,
UK Direct line: +44 (0) 23 9234 1647
UK Mobile & WhatsApp: +44 (0) 79 4830 8868
Skype Video Call: David.J.Romano
From: D.
Sent: 19 July 2021 18:36
To: david.rom...@davidjromano.com
Cc: Geoff ; Dong Lin via gnucash-user
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to
collect data
Out of curiosity, have you tried reinstalling Finance::Quote from the menu
option? I recently resumed use of F::Q, but found it non functional. I
reinstalled from the menu, and things started working again...
_
From: david.rom...@davidjromano.com <mailto:david.rom...@davidjromano.com>
Sent: Mon Jul 19 08:04:11 EDT 2021
To: 'Geoff' , gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to
collect data
I think your right - does not look good - no output at all
C:\Program Files (x86)\gnucash\bin>perl -MFinance::Quote -e "my $q =
Finance::Quote->new(); print $q->currency(q/USD/,q/GBP/);"
C:\Program Files (x86)\gnucash\bin>
Best regards,
David Romano,
UK Direct line: +44 (0) 23 9234 1647
UK Mobile & WhatsApp: +44 (0) 79 4830 8868
Skype Video Call: David.J.Romano
-Original Message-
From: Geoff mailto:cleanoutmys...@gmail.com> >
Sent: 19 July 2021 13:01
To: david.rom...@davidjromano.com <mailto:david.rom...@davidjromano.com> ;
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to
collect data
Hmmm, something is definitely broken there.
Let me know what you get with my second email.
Geoff
=
On 19/07/2021 9:57 pm, david.rom...@davidjromano.com
<mailto:david.rom...@davidjromano.com> wrote:
Sorry Geoff, I was pasting from my troubleshooting notes not what I typed.
I’ve attached the screenshot
Best regards,
David Romano,
UK Direct line: +44 (0) 23 9234 1647
UK Mobile & WhatsApp: +44 (0) 79 4830 8868
Skype Video Call: David.J.Romano
-Original Message-
From: Geoff mailto:cleanoutmys...@gmail.com> >
Sent: 19 July 2021 12:41
To: david.rom...@davidjromano.com <mailto:david.rom...@davidjromano.com> ;
gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not
able to collect data
Hi David
This problem is because you are pasting not just the command itself,
but also its expected output.
This is the command:
echo (currency "USD" "GBP") | perl gnc-fq-helper
And this is the expected output:
(("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 21:27:37")
(last . #e0.72922) (currency . "GBP")))
See attached screenshot.
Hope this helps.
Regards
Geoff
=
On 19/07/2021 7:08 pm, david.rom...@davidjromano.com
<mailto:david.rom...@davidjromano.com>
<mailto:david.rom...@davidjromano.com> wrote:
Good morning Geoff - I'm now back in the office and have run
through your
suggestions with the following result:
a) C:\Program Files (x86)\gnucash\bin>set
ALPHAVANTAGE_API_KEY=[MYKEY]
LOOKS OK
b) C:\Program Files (x86)\gnucash\bin>echo
%ALPHAVANTAGE_API_KEY%
[MYKEY]
RETURNS KEY CORRECTLY
c) C:\Program Files (x86)\gnucash\bin>echo (currency
"USD" "GBP") |
perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
"2021-03-10
08:40:01") (last . #e0.72002) (currency . "GBP")))
RETURNS ERROR STRING:
C:\Program Files (x86)\gnucash\bin>echo
(currency "USD"
"GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
"2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
Can't open ((USD: No
such file or directory at
gnc-fq-helper line 331.
Can't open (symbol: No
such file or directory at
gnc-fq-helper line 331.
Can't do inplace edit: .
is not a regular file at
gnc-fq-helper line 331.
Can't open USD): No
such file or directory at
gnc-fq-helper line 331.
Can't open
(gnc:time-no-zone: No such file or
directory at gnc-fq-helper
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Hello all,
Chris G,
1.51 is not broken. We missed a bug in the F::Q 1.50 release that caused
testing of at least one module to fail for some. 1.51 was pushed to CPAN
a week later. F::Q v1.52 is likely at least a few months out.
David R (and Geoff),
The Windows system I used for testing F::Q 1.51 before pushing it to
CPAN was deleted a few days ago, so under VirtualBox running on OSX
Catalina I created a new Windows 10 Pro (64-bit) virtual machine as to
install GnuCash and F::Q on a completely clean OS.
Windows 10 Pro
Version 21H1
OS Build 19043.928
64-bit operating system, x64-based processor
Installed Strawberry Perl 5.32.1 MSWin32-64-multi-thread
Installed GnuCash 4.6
Installed F::Q 1.51 using cpanm.
C:\Users\bschuck> cpanm Finance::Quote
C:\Program Files (x86)\gnucash\bin>perl -MFinance::Quote -e "print
$Finance::Quote::VERSION"
1.51
Set my ALPHAVANTAGE_API_KEY.
Tested using gnc-fq-helper:
C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl
gnc-fq-helper
(("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 13:24:43")
(last . #e0.73157) (currency . "GBP")))
Tested using the one-liner Geoff suggested:
C:\Program Files (x86)\gnucash\bin>perl -MFinance::Quote -e "my $q =
Finance::Quote->new(); print $q->currency(q/USD/,q/GBP/);"
0.73132
- Bruce S.
___
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] Can anyone help with this issue please - GNC-FQ Not able to collect data
Out of curiosity, have you tried reinstalling Finance::Quote from the menu
option? I recently resumed use of F::Q, but found it non functional. I
reinstalled from the menu, and things started working again...
Original Message
From: david.rom...@davidjromano.com
Sent: Mon Jul 19 08:04:11 EDT 2021
To: 'Geoff' , gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to
collect data
I think your right - does not look good - no output at all
C:\Program Files (x86)\gnucash\bin>perl -MFinance::Quote -e "my $q =
Finance::Quote->new(); print $q->currency(q/USD/,q/GBP/);"
C:\Program Files (x86)\gnucash\bin>
Best regards,
David Romano,
UK Direct line: +44 (0) 23 9234 1647
UK Mobile & WhatsApp: +44 (0) 79 4830 8868
Skype Video Call: David.J.Romano
-Original Message-
From: Geoff
Sent: 19 July 2021 13:01
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to
collect data
Hmmm, something is definitely broken there.
Let me know what you get with my second email.
Geoff
=
On 19/07/2021 9:57 pm, david.rom...@davidjromano.com wrote:
> Sorry Geoff, I was pasting from my troubleshooting notes not what I typed.
>
> I’ve attached the screenshot
>
> Best regards,
>
> David Romano,
>
> UK Direct line: +44 (0) 23 9234 1647
>
> UK Mobile & WhatsApp: +44 (0) 79 4830 8868
>
> Skype Video Call: David.J.Romano
>
> -Original Message-
> From: Geoff
> Sent: 19 July 2021 12:41
> To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
> Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not
> able to collect data
>
> Hi David
>
> This problem is because you are pasting not just the command itself,
> but also its expected output.
>
> This is the command:
>
> echo (currency "USD" "GBP") | perl gnc-fq-helper
>
> And this is the expected output:
>
> (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 21:27:37")
> (last . #e0.72922) (currency . "GBP")))
>
> See attached screenshot.
>
> Hope this helps.
>
> Regards
>
> Geoff
>
> =
>
> On 19/07/2021 7:08 pm, david.rom...@davidjromano.com
> <mailto:david.rom...@davidjromano.com> wrote:
>
> > Good morning Geoff - I'm now back in the office and have run
> through your
>
> > suggestions with the following result:
>
> >
>
> >
>
> > a) C:\Program Files (x86)\gnucash\bin>set
>
> > ALPHAVANTAGE_API_KEY=[MYKEY]
>
> >
>
> > > LOOKS OK
>
> >
>
> > b) C:\Program Files (x86)\gnucash\bin>echo
> %ALPHAVANTAGE_API_KEY%
>
> > [MYKEY]
>
> >
>
> > > RETURNS KEY CORRECTLY
>
> >
>
> > c) C:\Program Files (x86)\gnucash\bin>echo (currency
> "USD" "GBP") |
>
> > perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
> "2021-03-10
>
> > 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> >
>
> > > RETURNS ERROR STRING:
>
> >
>
> > C:\Program Files (x86)\gnucash\bin>echo
> (currency "USD"
>
> > "GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
>
> > "2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> >
>
> > Can't open ((USD: No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't open (symbol: No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> > Can't open USD): No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't open
> (gnc:time-no-zone: No such file or
>
> > directory at gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> >
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Thanks Geoff - I thought you were west of me (London time) not east!
I'll try to work out how to downgrade.
-Original Message-
From: Geoff
Sent: 19 July 2021 13:12
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to
collect data
OK, I have been testing using Finance::Quote version 1.49. As a
*workaround* you could try downgrading to that version?
It is getting late here, I'll try and upgrade to a later version of
Finance::Quote and see if I can reproduce your problem later this week.
Meantime someone else may have a suggestion.
Regards
Geoff
=
On 19/07/2021 10:04 pm, david.rom...@davidjromano.com wrote:
> I think your right - does not look good - no output at all
>
> C:\Program Files (x86)\gnucash\bin>perl -MFinance::Quote -e "my $q =
> Finance::Quote->new(); print $q->currency(q/USD/,q/GBP/);"
>
> C:\Program Files (x86)\gnucash\bin>
>
> Best regards,
>
> David Romano,
>
> UK Direct line: +44 (0) 23 9234 1647
> UK Mobile & WhatsApp: +44 (0) 79 4830 8868 Skype Video Call:
> David.J.Romano
>
> -Original Message-
> From: Geoff
> Sent: 19 July 2021 13:01
> To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
> Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not
> able to collect data
>
> Hmmm, something is definitely broken there.
>
> Let me know what you get with my second email.
>
> Geoff
> =
>
> On 19/07/2021 9:57 pm, david.rom...@davidjromano.com wrote:
>> Sorry Geoff, I was pasting from my troubleshooting notes not what I typed.
>>
>> I’ve attached the screenshot
>>
>> Best regards,
>>
>> David Romano,
>>
>> UK Direct line: +44 (0) 23 9234 1647
>>
>> UK Mobile & WhatsApp: +44 (0) 79 4830 8868
>>
>> Skype Video Call: David.J.Romano
>>
>> -Original Message-
>> From: Geoff
>> Sent: 19 July 2021 12:41
>> To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
>> Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ
>> Not able to collect data
>>
>> Hi David
>>
>> This problem is because you are pasting not just the command itself,
>> but also its expected output.
>>
>> This is the command:
>>
>> echo (currency "USD" "GBP") | perl gnc-fq-helper
>>
>> And this is the expected output:
>>
>> (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 21:27:37")
>> (last . #e0.72922) (currency . "GBP")))
>>
>> See attached screenshot.
>>
>> Hope this helps.
>>
>> Regards
>>
>> Geoff
>>
>> =
>>
>> On 19/07/2021 7:08 pm, david.rom...@davidjromano.com
>> <mailto:david.rom...@davidjromano.com> wrote:
>>
>> > Good morning Geoff - I'm now back in the office and have run
>> through your
>>
>> > suggestions with the following result:
>>
>> >
>>
>> >
>>
>> > a) C:\Program Files (x86)\gnucash\bin>set
>>
>> > ALPHAVANTAGE_API_KEY=[MYKEY]
>>
>> >
>>
>> > > LOOKS OK
>>
>> >
>>
>> > b) C:\Program Files (x86)\gnucash\bin>echo
>> %ALPHAVANTAGE_API_KEY%
>>
>> > [MYKEY]
>>
>> >
>>
>> > > RETURNS KEY CORRECTLY
>>
>> >
>>
>> > c) C:\Program Files (x86)\gnucash\bin>echo (currency
>> "USD" "GBP") |
>>
>> > perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
>> "2021-03-10
>>
>> > 08:40:01") (last . #e0.72002) (currency . "GBP")))
>>
>> >
>>
>> > > RETURNS ERROR STRING:
>>
>> >
>>
>> > C:\Program Files (x86)\gnucash\bin>echo
>> (currency "USD"
>>
>> > "GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
>>
>> > "2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
>>
>> >
>>
>> > Can't open ((USD: No
>> such file or directory at
>>
>> > gnc-fq-helper line 331.
>>
>> >
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
OK, I have been testing using Finance::Quote version 1.49. As a
*workaround* you could try downgrading to that version?
It is getting late here, I'll try and upgrade to a later version of
Finance::Quote and see if I can reproduce your problem later this week.
Meantime someone else may have a suggestion.
Regards
Geoff
=
On 19/07/2021 10:04 pm, david.rom...@davidjromano.com wrote:
I think your right - does not look good - no output at all
C:\Program Files (x86)\gnucash\bin>perl -MFinance::Quote -e "my $q =
Finance::Quote->new(); print $q->currency(q/USD/,q/GBP/);"
C:\Program Files (x86)\gnucash\bin>
Best regards,
David Romano,
UK Direct line: +44 (0) 23 9234 1647
UK Mobile & WhatsApp: +44 (0) 79 4830 8868
Skype Video Call: David.J.Romano
-Original Message-
From: Geoff
Sent: 19 July 2021 13:01
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to
collect data
Hmmm, something is definitely broken there.
Let me know what you get with my second email.
Geoff
=
On 19/07/2021 9:57 pm, david.rom...@davidjromano.com wrote:
Sorry Geoff, I was pasting from my troubleshooting notes not what I typed.
I’ve attached the screenshot
Best regards,
David Romano,
UK Direct line: +44 (0) 23 9234 1647
UK Mobile & WhatsApp: +44 (0) 79 4830 8868
Skype Video Call: David.J.Romano
-Original Message-
From: Geoff
Sent: 19 July 2021 12:41
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not
able to collect data
Hi David
This problem is because you are pasting not just the command itself,
but also its expected output.
This is the command:
echo (currency "USD" "GBP") | perl gnc-fq-helper
And this is the expected output:
(("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 21:27:37")
(last . #e0.72922) (currency . "GBP")))
See attached screenshot.
Hope this helps.
Regards
Geoff
=
On 19/07/2021 7:08 pm, david.rom...@davidjromano.com
<mailto:david.rom...@davidjromano.com> wrote:
> Good morning Geoff - I'm now back in the office and have run
through your
> suggestions with the following result:
>
>
> a) C:\Program Files (x86)\gnucash\bin>set
> ALPHAVANTAGE_API_KEY=[MYKEY]
>
> > LOOKS OK
>
> b) C:\Program Files (x86)\gnucash\bin>echo
%ALPHAVANTAGE_API_KEY%
> [MYKEY]
>
> > RETURNS KEY CORRECTLY
>
> c) C:\Program Files (x86)\gnucash\bin>echo (currency
"USD" "GBP") |
> perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
"2021-03-10
> 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> > RETURNS ERROR STRING:
>
> C:\Program Files (x86)\gnucash\bin>echo
(currency "USD"
> "GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
> "2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> Can't open ((USD: No
such file or directory at
> gnc-fq-helper line 331.
> Can't open (symbol: No
such file or directory at
> gnc-fq-helper line 331.
> Can't do inplace edit: .
is not a regular file at
> gnc-fq-helper line 331.
> Can't open USD): No
such file or directory at
> gnc-fq-helper line 331.
> Can't open
(gnc:time-no-zone: No such file or
> directory at gnc-fq-helper line 331.
> Can't do inplace edit: .
is not a regular file at
> gnc-fq-helper line 331.
> Can't open 2021-03-10
08:40:01): Invalid argument at
> gnc-fq-helper line 331.
> Can't open (last: No
such file or directory at
> gnc-fq-helper line 331.
> Can't do inplace edit: .
is not a regular file at
> gnc-fq-helper line 331.
> Can't open #e0.72002):
No such file or directory at
> gnc-fq-helper line 331.
> Can't open (currency:
No such file or directory at
> gnc-fq-helper line 331.
>
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Geoff,
I forgot to add the screenshot.
After hitting enter there is a short pause and the CMD window reverts to it's
state prior to the command
Best regards,
David Romano,
UK Direct line: +44 (0) 23 9234 1647
UK Mobile & WhatsApp: +44 (0) 79 4830 8868
Skype Video Call: David.J.Romano
-Original Message-
From: Geoff
Sent: 19 July 2021 13:01
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to
collect data
Hmmm, something is definitely broken there.
Let me know what you get with my second email.
Geoff
=
On 19/07/2021 9:57 pm, david.rom...@davidjromano.com wrote:
> Sorry Geoff, I was pasting from my troubleshooting notes not what I typed.
>
> I’ve attached the screenshot
>
> Best regards,
>
> David Romano,
>
> UK Direct line: +44 (0) 23 9234 1647
>
> UK Mobile & WhatsApp: +44 (0) 79 4830 8868
>
> Skype Video Call: David.J.Romano
>
> -Original Message-
> From: Geoff
> Sent: 19 July 2021 12:41
> To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
> Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not
> able to collect data
>
> Hi David
>
> This problem is because you are pasting not just the command itself,
> but also its expected output.
>
> This is the command:
>
> echo (currency "USD" "GBP") | perl gnc-fq-helper
>
> And this is the expected output:
>
> (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 21:27:37")
> (last . #e0.72922) (currency . "GBP")))
>
> See attached screenshot.
>
> Hope this helps.
>
> Regards
>
> Geoff
>
> =
>
> On 19/07/2021 7:08 pm, david.rom...@davidjromano.com
> <mailto:david.rom...@davidjromano.com> wrote:
>
> > Good morning Geoff - I'm now back in the office and have run
> through your
>
> > suggestions with the following result:
>
> >
>
> >
>
> > a) C:\Program Files (x86)\gnucash\bin>set
>
> > ALPHAVANTAGE_API_KEY=[MYKEY]
>
> >
>
> > > LOOKS OK
>
> >
>
> > b) C:\Program Files (x86)\gnucash\bin>echo
> %ALPHAVANTAGE_API_KEY%
>
> > [MYKEY]
>
> >
>
> > > RETURNS KEY CORRECTLY
>
> >
>
> > c) C:\Program Files (x86)\gnucash\bin>echo (currency
> "USD" "GBP") |
>
> > perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
> "2021-03-10
>
> > 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> >
>
> > > RETURNS ERROR STRING:
>
> >
>
> > C:\Program Files (x86)\gnucash\bin>echo
> (currency "USD"
>
> > "GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
>
> > "2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> >
>
> > Can't open ((USD: No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't open (symbol: No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> > Can't open USD): No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't open
> (gnc:time-no-zone: No such file or
>
> > directory at gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> > Can't open 2021-03-10
> 08:40:01): Invalid argument at
>
> > gnc-fq-helper line 331.
>
> > Can't open (last: No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> > Can't open #e0.72002):
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
I think your right - does not look good - no output at all
C:\Program Files (x86)\gnucash\bin>perl -MFinance::Quote -e "my $q =
Finance::Quote->new(); print $q->currency(q/USD/,q/GBP/);"
C:\Program Files (x86)\gnucash\bin>
Best regards,
David Romano,
UK Direct line: +44 (0) 23 9234 1647
UK Mobile & WhatsApp: +44 (0) 79 4830 8868
Skype Video Call: David.J.Romano
-Original Message-
From: Geoff
Sent: 19 July 2021 13:01
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to
collect data
Hmmm, something is definitely broken there.
Let me know what you get with my second email.
Geoff
=
On 19/07/2021 9:57 pm, david.rom...@davidjromano.com wrote:
> Sorry Geoff, I was pasting from my troubleshooting notes not what I typed.
>
> I’ve attached the screenshot
>
> Best regards,
>
> David Romano,
>
> UK Direct line: +44 (0) 23 9234 1647
>
> UK Mobile & WhatsApp: +44 (0) 79 4830 8868
>
> Skype Video Call: David.J.Romano
>
> -Original Message-
> From: Geoff
> Sent: 19 July 2021 12:41
> To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
> Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not
> able to collect data
>
> Hi David
>
> This problem is because you are pasting not just the command itself,
> but also its expected output.
>
> This is the command:
>
> echo (currency "USD" "GBP") | perl gnc-fq-helper
>
> And this is the expected output:
>
> (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 21:27:37")
> (last . #e0.72922) (currency . "GBP")))
>
> See attached screenshot.
>
> Hope this helps.
>
> Regards
>
> Geoff
>
> =
>
> On 19/07/2021 7:08 pm, david.rom...@davidjromano.com
> <mailto:david.rom...@davidjromano.com> wrote:
>
> > Good morning Geoff - I'm now back in the office and have run
> through your
>
> > suggestions with the following result:
>
> >
>
> >
>
> > a) C:\Program Files (x86)\gnucash\bin>set
>
> > ALPHAVANTAGE_API_KEY=[MYKEY]
>
> >
>
> > > LOOKS OK
>
> >
>
> > b) C:\Program Files (x86)\gnucash\bin>echo
> %ALPHAVANTAGE_API_KEY%
>
> > [MYKEY]
>
> >
>
> > > RETURNS KEY CORRECTLY
>
> >
>
> > c) C:\Program Files (x86)\gnucash\bin>echo (currency
> "USD" "GBP") |
>
> > perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
> "2021-03-10
>
> > 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> >
>
> > > RETURNS ERROR STRING:
>
> >
>
> > C:\Program Files (x86)\gnucash\bin>echo
> (currency "USD"
>
> > "GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
>
> > "2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> >
>
> > Can't open ((USD: No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't open (symbol: No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> > Can't open USD): No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't open
> (gnc:time-no-zone: No such file or
>
> > directory at gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> > Can't open 2021-03-10
> 08:40:01): Invalid argument at
>
> > gnc-fq-helper line 331.
>
> > Can't open (last: No
> such file or directory at
>
> > gnc-fq-helper line 331.
>
> > Can't do inplace edit: .
> is not a regular file at
>
> > gnc-fq-helper line 331.
>
> >
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Hmmm, something is definitely broken there.
Let me know what you get with my second email.
Geoff
=
On 19/07/2021 9:57 pm, david.rom...@davidjromano.com wrote:
Sorry Geoff, I was pasting from my troubleshooting notes not what I typed.
I’ve attached the screenshot
Best regards,
David Romano,
UK Direct line: +44 (0) 23 9234 1647
UK Mobile & WhatsApp: +44 (0) 79 4830 8868
Skype Video Call: David.J.Romano
-Original Message-
From: Geoff
Sent: 19 July 2021 12:41
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not
able to collect data
Hi David
This problem is because you are pasting not just the command itself, but
also its expected output.
This is the command:
echo (currency "USD" "GBP") | perl gnc-fq-helper
And this is the expected output:
(("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 21:27:37")
(last . #e0.72922) (currency . "GBP")))
See attached screenshot.
Hope this helps.
Regards
Geoff
=
On 19/07/2021 7:08 pm, david.rom...@davidjromano.com
<mailto:david.rom...@davidjromano.com> wrote:
> Good morning Geoff - I'm now back in the office and have run through your
> suggestions with the following result:
>
>
> a) C:\Program Files (x86)\gnucash\bin>set
> ALPHAVANTAGE_API_KEY=[MYKEY]
>
> > LOOKS OK
>
> b) C:\Program Files (x86)\gnucash\bin>echo
%ALPHAVANTAGE_API_KEY%
> [MYKEY]
>
> > RETURNS KEY CORRECTLY
>
> c) C:\Program Files (x86)\gnucash\bin>echo (currency
"USD" "GBP") |
> perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
"2021-03-10
> 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> > RETURNS ERROR STRING:
>
> C:\Program Files (x86)\gnucash\bin>echo
(currency "USD"
> "GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
> "2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> Can't open ((USD: No such
file or directory at
> gnc-fq-helper line 331.
> Can't open (symbol: No
such file or directory at
> gnc-fq-helper line 331.
> Can't do inplace edit: .
is not a regular file at
> gnc-fq-helper line 331.
> Can't open USD): No such
file or directory at
> gnc-fq-helper line 331.
> Can't open
(gnc:time-no-zone: No such file or
> directory at gnc-fq-helper line 331.
> Can't do inplace edit: .
is not a regular file at
> gnc-fq-helper line 331.
> Can't open 2021-03-10
08:40:01): Invalid argument at
> gnc-fq-helper line 331.
> Can't open (last: No such
file or directory at
> gnc-fq-helper line 331.
> Can't do inplace edit: .
is not a regular file at
> gnc-fq-helper line 331.
> Can't open #e0.72002): No
such file or directory at
> gnc-fq-helper line 331.
> Can't open (currency: No
such file or directory at
> gnc-fq-helper line 331.
> Can't do inplace edit: .
is not a regular file at
> gnc-fq-helper line 331.
> Can't open GBP))): No
such file or directory at
> gnc-fq-helper line 331.
>
> Unfortunately I'm not a PERL coder but the code block starting at
line 331
> is the following:
>
> while(<>) {
>
> my $result = parse_input_line($_);
>
> if(!$result) {
> print STDERR "$prgnam: bad input line ($_)\n";
> exit 1;
> }
>
>
> -Original Message-
> From: Geoff mailto:cleanoutmys...@gmail.com>>
> Sent: 18 July 2021 13:55
> To: david.rom...@davidjromano.com
<mailto:david.rom...@davidjromano.com>; gnucash-user@gnucash.org
<mailto:gnucash-user@gnucash.org>
> Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ
Not able
> to collect data
&g
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Hi again David
Here is an easy way to determine if Perl and Finance::Quote are working
correctly, independently of GnuCash itself.
Set your Alphavantage key as before, and type in this one liner:
perl -MFinance::Quote -e "my $q = Finance::Quote->new(); print
$q->currency(q/USD/,q/GBP/);"
Expected result:
0.72953
[Note to other readers - the above is the syntax for Windows]
See attached screenshot.
Hope this helps.
Regards
Geoff
=
On 19/07/2021 9:04 pm, david.rom...@davidjromano.com wrote:
Good Morning Chris,
Many thanks for this, which I've just worked through with the results as
below - I've also worked through Geoff's suggestions.
The results are not encouraging though!
You are right that I'm running FC 1.51
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-update
Database was generated on Mon, 19 Jul 2021 09:43:47 GMT
Date::Manip is up to date (6.85).
Finance::Quote is up to date (1.51).
C:\>perl -v
This is perl 5, version 32, subversion 1 (v5.32.1) built for
MSWin32-x86-multi-thread-64int (I think this is the latest version.)
1. cpan upgrade DONE
cpan> upgrade
Database was generated on Mon, 19 Jul 2021 09:43:47 GMT
C:\>cpan -v
Loading internal logger. Log::Log4perl recommended
for better logging
>(info): C:\Strawberry\perl\bin/cpan script version
1.676, CPAN.pm version 2.28
2. gnc-fq-dump
After setting the alphavantage key (and confirming with echo) this fails as
follows:
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump currency USD EUR
> RETURNS ERROR STRING:
syswrite() on unopened filehandle GEN0 at
C:/Strawberry/perl/lib/IO/Handle.pm line 459.
syswrite() on unopened filehandle GEN1 at
C:/Strawberry/perl/lib/IO/Handle.pm line 459.
1 USD = EUR
However, gnc-fq is still not working so maybe it's an issue with FC 1.51 or
maybe I have some issue with Perl that I don't understand.
-Original Message-
From: Chris Good
Sent: 19 July 2021 01:48
To: gnucash-user@gnucash.org
Cc: david.rom...@davidjromano.com
Subject: RE: [GNC] Can anyone help with this issue please - GNC-FQ Not able
to collect data
Hi David,
From memory Finance::Quote 1.51 is broken and the nice maintainer is working
on 1.52.
The problems were to do with missing dependencies for some cpan modules.
In the meantime you might try, from a cmd.exe window:
cpan upgrade
to upgrades all modules.
Note that the correct syntax to use gnc-fq-dump to get an exchange rate is:
cd C:\Program Files (x86)\gnucash\bin
set ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
perl gnc-fq-dump currency USD EUR
See https://wiki.gnucash.org/wiki/Online_Quotes#Helper_Scripts
Another thing to check is your version of Strawberry perl. Use perl -v to
check the version.
Maybe you need to upgrade to the latest Strawberry perl.
You can uninstall your current Strawberry perl from Start, Settings, Apps.
Regards, Chris Good
Message: 2
Date: Sun, 18 Jul 2021 15:30:43 +0100
From: "david.rom...@davidjromano.com"
To: Geoff
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not
able to collect data
Message-ID: <12969517-6727-42c5-a202-04b3b75f8...@davidjromano.com>
Content-Type: text/plain; charset=us-ascii
Thanks Geoff, yes I think I did though I will recheck this.
I've also tried this with an alternative key in case the first was the
problem.
David
Sent from my iPhone
On 18 Jul 2021, at 13:55, Geoff wrote:
Hi David
Did you remember to set your alphavantage key as an environment
variable
when testing with Perl from the command line?
Can you try this:
C:\Program Files (x86)\gnucash\bin>set
ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
__Your_Actual_Key__
C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl
gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10
08:40:01") (last . #e0.72002) (currency . "GBP")))
C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl
gnc-fq-helper (("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10
08:45:05") (last . #e4.8841) (currency . "RON")))
Also, it is normal to get the blank command window when doing Get
Quotes
on Windows.
Regards
Geoff
=
On 18/07/2021 8:04 pm, david.rom...@davidjromano.com wrote:
I'm having a problem with GNC-FQ not being able to retrieve currency
data for the GBP / EUR currency pair.
I had previously used FQ back when the data source was Yahoo, but
when the Yahoo died I stopped using it
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Sorry Geoff, I was pasting from my troubleshooting notes not what I typed.
I’ve attached the screenshot
Best regards,
David Romano,
UK Direct line: +44 (0) 23 9234 1647
UK Mobile & WhatsApp: +44 (0) 79 4830 8868
Skype Video Call: David.J.Romano
-Original Message-
From: Geoff
Sent: 19 July 2021 12:41
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to
collect data
Hi David
This problem is because you are pasting not just the command itself, but also
its expected output.
This is the command:
echo (currency "USD" "GBP") | perl gnc-fq-helper
And this is the expected output:
(("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 21:27:37") (last .
#e0.72922) (currency . "GBP")))
See attached screenshot.
Hope this helps.
Regards
Geoff
=
On 19/07/2021 7:08 pm, <mailto:david.rom...@davidjromano.com>
david.rom...@davidjromano.com wrote:
> Good morning Geoff - I'm now back in the office and have run through your
> suggestions with the following result:
>
>
> a) C:\Program Files (x86)\gnucash\bin>set
> ALPHAVANTAGE_API_KEY=[MYKEY]
>
> > LOOKS OK
>
> b) C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
> [MYKEY]
>
> > RETURNS KEY CORRECTLY
>
> c) C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP")
> |
> perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10
> 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> > RETURNS ERROR STRING:
>
> C:\Program Files (x86)\gnucash\bin>echo (currency
> "USD"
> "GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
> "2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> Can't open ((USD: No such file or
> directory at
> gnc-fq-helper line 331.
> Can't open (symbol: No such file
> or directory at
> gnc-fq-helper line 331.
> Can't do inplace edit: . is not a
> regular file at
> gnc-fq-helper line 331.
> Can't open USD): No such file or
> directory at
> gnc-fq-helper line 331.
> Can't open (gnc:time-no-zone: No
> such file or
> directory at gnc-fq-helper line 331.
> Can't do inplace edit: . is not a
> regular file at
> gnc-fq-helper line 331.
> Can't open 2021-03-10 08:40:01):
> Invalid argument at
> gnc-fq-helper line 331.
> Can't open (last: No such file or
> directory at
> gnc-fq-helper line 331.
> Can't do inplace edit: . is not a
> regular file at
> gnc-fq-helper line 331.
> Can't open #e0.72002): No such
> file or directory at
> gnc-fq-helper line 331.
> Can't open (currency: No such
> file or directory at
> gnc-fq-helper line 331.
> Can't do inplace edit: . is not a
> regular file at
> gnc-fq-helper line 331.
> Can't open GBP))): No such file
> or directory at
> gnc-fq-helper line 331.
>
> Unfortunately I'm not a PERL coder but the code block starting at line 331
> is the following:
>
> while(<>) {
>
> my $result = parse_input_line($_);
>
> if(!$result) {
>print STDERR "$prgnam: bad input line ($_)\n";
> exit 1;
>}
>
>
> -Original Message-
> From: Geoff < <mailto:cleanoutmys...@gmail.com> cleanoutmys...@gmail.com>
> Sent: 18 July 2021 13:55
> To: <mailto:david.rom...@davidjromano.com> david.rom...@davidjromano.com;
> <mailto:gnucash-user@gnucash.org> gnucash-user@gnucash.org
> Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able
> to collect data
>
> Hi David
>
> Did you remember to set your alphavantage key as an env
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Hi David
This problem is because you are pasting not just the command itself, but
also its expected output.
This is the command:
echo (currency "USD" "GBP") | perl gnc-fq-helper
And this is the expected output:
(("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 21:27:37")
(last . #e0.72922) (currency . "GBP")))
See attached screenshot.
Hope this helps.
Regards
Geoff
=
On 19/07/2021 7:08 pm, david.rom...@davidjromano.com wrote:
Good morning Geoff - I'm now back in the office and have run through your
suggestions with the following result:
a) C:\Program Files (x86)\gnucash\bin>set
ALPHAVANTAGE_API_KEY=[MYKEY]
> LOOKS OK
b) C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
[MYKEY]
> RETURNS KEY CORRECTLY
c) C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") |
perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10
08:40:01") (last . #e0.72002) (currency . "GBP")))
> RETURNS ERROR STRING:
C:\Program Files (x86)\gnucash\bin>echo (currency "USD"
"GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
"2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
Can't open ((USD: No such file or directory at
gnc-fq-helper line 331.
Can't open (symbol: No such file or directory at
gnc-fq-helper line 331.
Can't do inplace edit: . is not a regular file at
gnc-fq-helper line 331.
Can't open USD): No such file or directory at
gnc-fq-helper line 331.
Can't open (gnc:time-no-zone: No such file or
directory at gnc-fq-helper line 331.
Can't do inplace edit: . is not a regular file at
gnc-fq-helper line 331.
Can't open 2021-03-10 08:40:01): Invalid argument at
gnc-fq-helper line 331.
Can't open (last: No such file or directory at
gnc-fq-helper line 331.
Can't do inplace edit: . is not a regular file at
gnc-fq-helper line 331.
Can't open #e0.72002): No such file or directory at
gnc-fq-helper line 331.
Can't open (currency: No such file or directory at
gnc-fq-helper line 331.
Can't do inplace edit: . is not a regular file at
gnc-fq-helper line 331.
Can't open GBP))): No such file or directory at
gnc-fq-helper line 331.
Unfortunately I'm not a PERL coder but the code block starting at line 331
is the following:
while(<>) {
my $result = parse_input_line($_);
if(!$result) {
print STDERR "$prgnam: bad input line ($_)\n";
exit 1;
}
-Original Message-
From: Geoff
Sent: 18 July 2021 13:55
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able
to collect data
Hi David
Did you remember to set your alphavantage key as an environment variable
when testing with Perl from the command line?
Can you try this:
C:\Program Files (x86)\gnucash\bin>set
ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
__Your_Actual_Key__
C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl
gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10
08:40:01") (last . #e0.72002) (currency . "GBP")))
C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl
gnc-fq-helper (("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10
08:45:05") (last . #e4.8841) (currency . "RON")))
Also, it is normal to get the blank command window when doing Get Quotes on
Windows.
Regards
Geoff
=
On 18/07/2021 8:04 pm, david.rom...@davidjromano.com wrote:
I'm having a problem with GNC-FQ not being able to retrieve currency
data for the GBP / EUR currency pair.
I had previously used FQ back when the data source was Yahoo, but when
the Yahoo died I stopped using it.
I now need to pick up GBP and EUR rates so I've installed the
components required to get the Alphavantage feed to work - or so I hoped!
Here's where I've got to so far:
1. I updated GNU Cash to current 4.6.
2. I installed Strawberry Perl version 5.32.1.1
3. I'm Running Windows 10 Professional 21H1 build 19043.110
4. I added my aphhavantage key in Preferences \ Online Quotes
5. I ra
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Good Morning Chris,
Many thanks for this, which I've just worked through with the results as
below - I've also worked through Geoff's suggestions.
The results are not encouraging though!
You are right that I'm running FC 1.51
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-update
Database was generated on Mon, 19 Jul 2021 09:43:47 GMT
Date::Manip is up to date (6.85).
Finance::Quote is up to date (1.51).
C:\>perl -v
This is perl 5, version 32, subversion 1 (v5.32.1) built for
MSWin32-x86-multi-thread-64int (I think this is the latest version.)
1. cpan upgrade DONE
cpan> upgrade
Database was generated on Mon, 19 Jul 2021 09:43:47 GMT
C:\>cpan -v
Loading internal logger. Log::Log4perl recommended
for better logging
>(info): C:\Strawberry\perl\bin/cpan script version
1.676, CPAN.pm version 2.28
2. gnc-fq-dump
After setting the alphavantage key (and confirming with echo) this fails as
follows:
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump currency USD EUR
> RETURNS ERROR STRING:
syswrite() on unopened filehandle GEN0 at
C:/Strawberry/perl/lib/IO/Handle.pm line 459.
syswrite() on unopened filehandle GEN1 at
C:/Strawberry/perl/lib/IO/Handle.pm line 459.
1 USD = EUR
However, gnc-fq is still not working so maybe it's an issue with FC 1.51 or
maybe I have some issue with Perl that I don't understand.
-Original Message-
From: Chris Good
Sent: 19 July 2021 01:48
To: gnucash-user@gnucash.org
Cc: david.rom...@davidjromano.com
Subject: RE: [GNC] Can anyone help with this issue please - GNC-FQ Not able
to collect data
Hi David,
>From memory Finance::Quote 1.51 is broken and the nice maintainer is working
on 1.52.
The problems were to do with missing dependencies for some cpan modules.
In the meantime you might try, from a cmd.exe window:
cpan upgrade
to upgrades all modules.
Note that the correct syntax to use gnc-fq-dump to get an exchange rate is:
cd C:\Program Files (x86)\gnucash\bin
set ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
perl gnc-fq-dump currency USD EUR
See https://wiki.gnucash.org/wiki/Online_Quotes#Helper_Scripts
Another thing to check is your version of Strawberry perl. Use perl -v to
check the version.
Maybe you need to upgrade to the latest Strawberry perl.
You can uninstall your current Strawberry perl from Start, Settings, Apps.
Regards, Chris Good
Message: 2
Date: Sun, 18 Jul 2021 15:30:43 +0100
From: "david.rom...@davidjromano.com"
To: Geoff
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not
able to collect data
Message-ID: <12969517-6727-42c5-a202-04b3b75f8...@davidjromano.com>
Content-Type: text/plain; charset=us-ascii
Thanks Geoff, yes I think I did though I will recheck this.
I've also tried this with an alternative key in case the first was the
problem.
David
Sent from my iPhone
> On 18 Jul 2021, at 13:55, Geoff wrote:
>
> Hi David
>
> Did you remember to set your alphavantage key as an environment
> variable
when testing with Perl from the command line?
>
> Can you try this:
>
> C:\Program Files (x86)\gnucash\bin>set
> ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
>
> C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
> __Your_Actual_Key__
>
> C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl
> gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10
> 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl
> gnc-fq-helper (("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10
> 08:45:05") (last . #e4.8841) (currency . "RON")))
>
>
> Also, it is normal to get the blank command window when doing Get
> Quotes
on Windows.
>
> Regards
>
> Geoff
> =
>
>> On 18/07/2021 8:04 pm, david.rom...@davidjromano.com wrote:
>> I'm having a problem with GNC-FQ not being able to retrieve currency
>> data for the GBP / EUR currency pair.
>> I had previously used FQ back when the data source was Yahoo, but
>> when the Yahoo died I stopped using it.
>> I now need to pick up GBP and EUR rates so I've installed the
>> components required to get the Alphavantage feed to work - or so I hoped!
>> Here's where I've got to so far:
>> 1.I updated GNU Cash to current 4.6.
>> 2.I installed Strawberry Perl version 5.32.
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Good morning Geoff - I'm now back in the office and have run through your
suggestions with the following result:
a) C:\Program Files (x86)\gnucash\bin>set
ALPHAVANTAGE_API_KEY=[MYKEY]
> LOOKS OK
b) C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
[MYKEY]
> RETURNS KEY CORRECTLY
c) C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") |
perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10
08:40:01") (last . #e0.72002) (currency . "GBP")))
> RETURNS ERROR STRING:
C:\Program Files (x86)\gnucash\bin>echo (currency "USD"
"GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
"2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
Can't open ((USD: No such file or directory at
gnc-fq-helper line 331.
Can't open (symbol: No such file or directory at
gnc-fq-helper line 331.
Can't do inplace edit: . is not a regular file at
gnc-fq-helper line 331.
Can't open USD): No such file or directory at
gnc-fq-helper line 331.
Can't open (gnc:time-no-zone: No such file or
directory at gnc-fq-helper line 331.
Can't do inplace edit: . is not a regular file at
gnc-fq-helper line 331.
Can't open 2021-03-10 08:40:01): Invalid argument at
gnc-fq-helper line 331.
Can't open (last: No such file or directory at
gnc-fq-helper line 331.
Can't do inplace edit: . is not a regular file at
gnc-fq-helper line 331.
Can't open #e0.72002): No such file or directory at
gnc-fq-helper line 331.
Can't open (currency: No such file or directory at
gnc-fq-helper line 331.
Can't do inplace edit: . is not a regular file at
gnc-fq-helper line 331.
Can't open GBP))): No such file or directory at
gnc-fq-helper line 331.
Unfortunately I'm not a PERL coder but the code block starting at line 331
is the following:
while(<>) {
my $result = parse_input_line($_);
if(!$result) {
print STDERR "$prgnam: bad input line ($_)\n";
exit 1;
}
-Original Message-
From: Geoff
Sent: 18 July 2021 13:55
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able
to collect data
Hi David
Did you remember to set your alphavantage key as an environment variable
when testing with Perl from the command line?
Can you try this:
C:\Program Files (x86)\gnucash\bin>set
ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
__Your_Actual_Key__
C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl
gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10
08:40:01") (last . #e0.72002) (currency . "GBP")))
C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl
gnc-fq-helper (("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10
08:45:05") (last . #e4.8841) (currency . "RON")))
Also, it is normal to get the blank command window when doing Get Quotes on
Windows.
Regards
Geoff
=
On 18/07/2021 8:04 pm, david.rom...@davidjromano.com wrote:
> I'm having a problem with GNC-FQ not being able to retrieve currency
> data for the GBP / EUR currency pair.
>
>
>
> I had previously used FQ back when the data source was Yahoo, but when
> the Yahoo died I stopped using it.
>
>
>
> I now need to pick up GBP and EUR rates so I've installed the
> components required to get the Alphavantage feed to work - or so I hoped!
>
>
>
> Here's where I've got to so far:
>
>
>
> 1.I updated GNU Cash to current 4.6.
> 2.I installed Strawberry Perl version 5.32.1.1
> 3.I'm Running Windows 10 Professional 21H1 build 19043.110
> 4.I added my aphhavantage key in Preferences \ Online Quotes
> 5.I ran perl gnc-fq-check and got the following result:
>
>
>
> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check
>
>
>
> ("1.51" "aex" "alphavantage" "amfiindia" "asegr" "asx" "aufunds"
"australia"
> "bamosz" "bet" "bloomberg" "bourso" "bse" "bs
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Hi David,
>From memory Finance::Quote 1.51 is broken and the nice maintainer is working
on 1.52.
The problems were to do with missing dependencies for some cpan modules.
In the meantime you might try, from a cmd.exe window:
cpan upgrade
to upgrades all modules.
Note that the correct syntax to use gnc-fq-dump to get an exchange rate is:
cd C:\Program Files (x86)\gnucash\bin
set ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
perl gnc-fq-dump currency USD EUR
See https://wiki.gnucash.org/wiki/Online_Quotes#Helper_Scripts
Another thing to check is your version of Strawberry perl. Use
perl -v
to check the version.
Maybe you need to upgrade to the latest Strawberry perl.
You can uninstall your current Strawberry perl from Start, Settings, Apps.
Regards, Chris Good
Message: 2
Date: Sun, 18 Jul 2021 15:30:43 +0100
From: "david.rom...@davidjromano.com"
To: Geoff
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not
able to collect data
Message-ID: <12969517-6727-42c5-a202-04b3b75f8...@davidjromano.com>
Content-Type: text/plain; charset=us-ascii
Thanks Geoff, yes I think I did though I will recheck this.
I've also tried this with an alternative key in case the first was the
problem.
David
Sent from my iPhone
> On 18 Jul 2021, at 13:55, Geoff wrote:
>
> Hi David
>
> Did you remember to set your alphavantage key as an environment variable
when testing with Perl from the command line?
>
> Can you try this:
>
> C:\Program Files (x86)\gnucash\bin>set
> ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
>
> C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
> __Your_Actual_Key__
>
> C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl
> gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10
> 08:40:01") (last . #e0.72002) (currency . "GBP")))
>
> C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl
> gnc-fq-helper (("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10
> 08:45:05") (last . #e4.8841) (currency . "RON")))
>
>
> Also, it is normal to get the blank command window when doing Get Quotes
on Windows.
>
> Regards
>
> Geoff
> =
>
>> On 18/07/2021 8:04 pm, david.rom...@davidjromano.com wrote:
>> I'm having a problem with GNC-FQ not being able to retrieve currency
>> data for the GBP / EUR currency pair.
>> I had previously used FQ back when the data source was Yahoo, but
>> when the Yahoo died I stopped using it.
>> I now need to pick up GBP and EUR rates so I've installed the
>> components required to get the Alphavantage feed to work - or so I hoped!
>> Here's where I've got to so far:
>> 1.I updated GNU Cash to current 4.6.
>> 2.I installed Strawberry Perl version 5.32.1.1
>> 3.I'm Running Windows 10 Professional 21H1 build 19043.110
>> 4.I added my aphhavantage key in Preferences \ Online Quotes
>> 5.I ran perl gnc-fq-check and got the following result:
>> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check ("1.51" "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" "ftfunds"
>> "fundata" "fundlibrary" "goldmoney" "greece" "hu" "hufund" "hungary"
>> "hustock" "iexcloud" "india" "indiamutual" "known_currencies"
>> "morningstarau" "morningstarjp" "mstaruk" "nasdaq" "nseindia" "nyse"
"nzx"
>> "onvista" "oslobors" "romania" "seb_funds" "six" "tiaacref" "tmx"
>> "tradeville" "troweprice" "troweprice_direct" "tsp" "ukfunds"
"unionfunds"
>> "usa" "usfedbonds" "yahoo_json" "za")
>> 6.I ran perl gnc-fq-update and got the following result:
>> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-update Database was
>> generated on Sat, 17
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Currency quotes work differently from stock quotes because forex markets
operate differently from stock exchanges. A particular stock symbol on any one
price source is unique and quoted in a single currency so only the symbol is
needed to retrieve the quote. Forex markets quote exchange rates between pairs
of currencies, e.g. GBP to USD or JPY to EUR. Simply asking for the current
quote for EUR isn't meaningful.
In F::Q to retrieve currency quotes you must use `currency` for the source and
you need two symbols as shown in Geoff's examples. Enabling online quotes for a
currency in the security editor won't work because that will try to retrieve a
price for a stock with the currency symbol from the selected source and odds
are there is no such stock.
To easily test that F::Q is working for currencies find a two-currency
transaction and right-click on it, then select "edit exchange rate" in the
context menu. The transfer dialog will appear. Click the Fetch Rate button and
if everything is behaving itself the current rate will fill in the exchange
rate box.
Regards,
John Ralls
> On Jul 18, 2021, at 7:30 AM, david.rom...@davidjromano.com
> wrote:
>
> Thanks Geoff, yes I think I did though I will recheck this.
>
> I've also tried this with an alternative key in case the first was the
> problem.
>
> David
> Sent from my iPhone
>
>> On 18 Jul 2021, at 13:55, Geoff wrote:
>>
>> Hi David
>>
>> Did you remember to set your alphavantage key as an environment variable
>> when testing with Perl from the command line?
>>
>> Can you try this:
>>
>> C:\Program Files (x86)\gnucash\bin>set
>> ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
>>
>> C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
>> __Your_Actual_Key__
>>
>> C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl
>> gnc-fq-helper
>> (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10 08:40:01") (last .
>> #e0.72002) (currency . "GBP")))
>>
>> C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl
>> gnc-fq-helper
>> (("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10 08:45:05") (last .
>> #e4.8841) (currency . "RON")))
>>
>>
>> Also, it is normal to get the blank command window when doing Get Quotes on
>> Windows.
>>
>> Regards
>>
>> Geoff
>> =
>>
>>> On 18/07/2021 8:04 pm, david.rom...@davidjromano.com wrote:
>>> I'm having a problem with GNC-FQ not being able to retrieve currency data
>>> for the GBP / EUR currency pair.
>>> I had previously used FQ back when the data source was Yahoo, but when the
>>> Yahoo died I stopped using it.
>>> I now need to pick up GBP and EUR rates so I've installed the components
>>> required to get the Alphavantage feed to work - or so I hoped!
>>> Here's where I've got to so far:
>>> 1.I updated GNU Cash to current 4.6.
>>> 2.I installed Strawberry Perl version 5.32.1.1
>>> 3.I'm Running Windows 10 Professional 21H1 build 19043.110
>>> 4.I added my aphhavantage key in Preferences \ Online Quotes
>>> 5.I ran perl gnc-fq-check and got the following result:
>>> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check
>>> ("1.51" "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" "ftfunds"
>>> "fundata" "fundlibrary" "goldmoney" "greece" "hu" "hufund" "hungary"
>>> "hustock" "iexcloud" "india" "indiamutual" "known_currencies"
>>> "morningstarau" "morningstarjp" "mstaruk" "nasdaq" "nseindia" "nyse" "nzx"
>>> "onvista" "oslobors" "romania" "seb_funds" "six" "tiaacref" "tmx"
>>> "tradeville" "troweprice" "troweprice_direct" "tsp" "ukfunds" "unionfunds"
>>> "usa" "usfedbonds" "yahoo_json" "za")
>>> 6.I ran perl gnc-fq-update and got the following result:
>>> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-update
>>> Database was generated on Sat, 17 Jul 2021 11:42:13 GMT
>>> Date::Manip is up to date (6.85).
>>> Finance::Quote is up to date (1.51).
>>> 7.I tested the alphavantage data feed using this URL string and got
>>> the following result:
>>> https://www.alphavantage.co/query?function=CURRENCY_EXCHANGE_RATE&from_curre
>>> ncy=GBP&to_currency=EUR&apikey=[MYKEY}
>>> Realtime Currency Exchange Rate
>>> 1. From_Currency Code "GBP"
>>> 2. From_Currency Name "British Pound Sterling"
>>> 3. To_Currency Code "EUR"
>>> 4. To_Currency Name "Euro"
>>> 5. Exchange Rate "1.1655"
>>> 6. Last Refreshed "2021-07-18 09:00:04"
>>> 7. Time Zone"UTC"
>>> 8. Bid Price "1.16544000"
>>> 9. Ask Price "1.16555000"
>>> All looked good so I set the two currencies GBP and EUR to get online quotes
>>> in the Security Editor.
>>> I then switched to the Price Database and clicked Get Quotes only to get the
>>> following failure message:
>>> Interestingly, wh
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Thanks Geoff, yes I think I did though I will recheck this.
I've also tried this with an alternative key in case the first was the problem.
David
Sent from my iPhone
> On 18 Jul 2021, at 13:55, Geoff wrote:
>
> Hi David
>
> Did you remember to set your alphavantage key as an environment variable when
> testing with Perl from the command line?
>
> Can you try this:
>
> C:\Program Files (x86)\gnucash\bin>set
> ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
>
> C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
> __Your_Actual_Key__
>
> C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl
> gnc-fq-helper
> (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10 08:40:01") (last .
> #e0.72002) (currency . "GBP")))
>
> C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl
> gnc-fq-helper
> (("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10 08:45:05") (last .
> #e4.8841) (currency . "RON")))
>
>
> Also, it is normal to get the blank command window when doing Get Quotes on
> Windows.
>
> Regards
>
> Geoff
> =
>
>> On 18/07/2021 8:04 pm, david.rom...@davidjromano.com wrote:
>> I'm having a problem with GNC-FQ not being able to retrieve currency data
>> for the GBP / EUR currency pair.
>> I had previously used FQ back when the data source was Yahoo, but when the
>> Yahoo died I stopped using it.
>> I now need to pick up GBP and EUR rates so I've installed the components
>> required to get the Alphavantage feed to work - or so I hoped!
>> Here's where I've got to so far:
>> 1.I updated GNU Cash to current 4.6.
>> 2.I installed Strawberry Perl version 5.32.1.1
>> 3.I'm Running Windows 10 Professional 21H1 build 19043.110
>> 4.I added my aphhavantage key in Preferences \ Online Quotes
>> 5.I ran perl gnc-fq-check and got the following result:
>> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check
>> ("1.51" "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" "ftfunds"
>> "fundata" "fundlibrary" "goldmoney" "greece" "hu" "hufund" "hungary"
>> "hustock" "iexcloud" "india" "indiamutual" "known_currencies"
>> "morningstarau" "morningstarjp" "mstaruk" "nasdaq" "nseindia" "nyse" "nzx"
>> "onvista" "oslobors" "romania" "seb_funds" "six" "tiaacref" "tmx"
>> "tradeville" "troweprice" "troweprice_direct" "tsp" "ukfunds" "unionfunds"
>> "usa" "usfedbonds" "yahoo_json" "za")
>> 6.I ran perl gnc-fq-update and got the following result:
>> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-update
>> Database was generated on Sat, 17 Jul 2021 11:42:13 GMT
>> Date::Manip is up to date (6.85).
>> Finance::Quote is up to date (1.51).
>> 7.I tested the alphavantage data feed using this URL string and got
>> the following result:
>> https://www.alphavantage.co/query?function=CURRENCY_EXCHANGE_RATE&from_curre
>> ncy=GBP&to_currency=EUR&apikey=[MYKEY}
>> Realtime Currency Exchange Rate
>> 1. From_Currency Code "GBP"
>> 2. From_Currency Name "British Pound Sterling"
>> 3. To_Currency Code "EUR"
>> 4. To_Currency Name "Euro"
>> 5. Exchange Rate "1.1655"
>> 6. Last Refreshed "2021-07-18 09:00:04"
>> 7. Time Zone"UTC"
>> 8. Bid Price "1.16544000"
>> 9. Ask Price "1.16555000"
>> All looked good so I set the two currencies GBP and EUR to get online quotes
>> in the Security Editor.
>> I then switched to the Price Database and clicked Get Quotes only to get the
>> following failure message:
>>Interestingly, when I click the Get Quotes button (and when I open GNU
>> Cash)
>> Perl pops a blank CMD window (C:Strawbery\perl\bin\perl.exe) and the window
>> closes without being populated.
>> I then created a new alphavantage key which I updated in GNC preferences,
>> but I got the same result when I ran Get Quotes.
>> I next tried the following code example:
>> cd \Program Files (x86)\gnucash\bin
>> set ALPHAVANTAGE_API_KEY=[MYKEY]
>> perl gnc-fq-dump alphavantage CSCO
>> Which generated the following output:
>> C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump alphavantage EUR
>> syswrite() on unopened filehandle GEN0 at
>> C:/Strawberry/perl/lib/IO/Handle.pm line 459.
>> Finance::Quote fields Gnucash uses:
>> symbol: EUR (deduced)<=== required
>> date: ** missing **<=== recommended
>>currency: ** missing **<=== required
>> last: **missing** <=\
>> nav: **missing** <=== one of these
>> price: **missing** <=/
>>timezone: <=== optional
>> My immediate thought was that either GNC or PERL were being blocked by Win
>> 10 security so I explicitly added both Perl Interpreter and GNC to the apps
>> allowed through Windows Firewall - both private and publi
Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
Hi David
Did you remember to set your alphavantage key as an environment variable
when testing with Perl from the command line?
Can you try this:
C:\Program Files (x86)\gnucash\bin>set
ALPHAVANTAGE_API_KEY=__Your_Actual_Key__
C:\Program Files (x86)\gnucash\bin>echo %ALPHAVANTAGE_API_KEY%
__Your_Actual_Key__
C:\Program Files (x86)\gnucash\bin>echo (currency "USD" "GBP") | perl
gnc-fq-helper
(("USD" (symbol . "USD") (gnc:time-no-zone . "2021-03-10 08:40:01")
(last . #e0.72002) (currency . "GBP")))
C:\Program Files (x86)\gnucash\bin>echo (currency "EUR" "RON") | perl
gnc-fq-helper
(("EUR" (symbol . "EUR") (gnc:time-no-zone . "2021-03-10 08:45:05")
(last . #e4.8841) (currency . "RON")))
Also, it is normal to get the blank command window when doing Get Quotes
on Windows.
Regards
Geoff
=
On 18/07/2021 8:04 pm, david.rom...@davidjromano.com wrote:
I'm having a problem with GNC-FQ not being able to retrieve currency data
for the GBP / EUR currency pair.
I had previously used FQ back when the data source was Yahoo, but when the
Yahoo died I stopped using it.
I now need to pick up GBP and EUR rates so I've installed the components
required to get the Alphavantage feed to work - or so I hoped!
Here's where I've got to so far:
1. I updated GNU Cash to current 4.6.
2. I installed Strawberry Perl version 5.32.1.1
3. I'm Running Windows 10 Professional 21H1 build 19043.110
4. I added my aphhavantage key in Preferences \ Online Quotes
5. I ran perl gnc-fq-check and got the following result:
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check
("1.51" "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" "ftfunds"
"fundata" "fundlibrary" "goldmoney" "greece" "hu" "hufund" "hungary"
"hustock" "iexcloud" "india" "indiamutual" "known_currencies"
"morningstarau" "morningstarjp" "mstaruk" "nasdaq" "nseindia" "nyse" "nzx"
"onvista" "oslobors" "romania" "seb_funds" "six" "tiaacref" "tmx"
"tradeville" "troweprice" "troweprice_direct" "tsp" "ukfunds" "unionfunds"
"usa" "usfedbonds" "yahoo_json" "za")
6. I ran perl gnc-fq-update and got the following result:
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-update
Database was generated on Sat, 17 Jul 2021 11:42:13 GMT
Date::Manip is up to date (6.85).
Finance::Quote is up to date (1.51).
7. I tested the alphavantage data feed using this URL string and got
the following result:
https://www.alphavantage.co/query?function=CURRENCY_EXCHANGE_RATE&from_curre
ncy=GBP&to_currency=EUR&apikey=[MYKEY}
Realtime Currency Exchange Rate
1. From_Currency Code "GBP"
2. From_Currency Name "British Pound Sterling"
3. To_Currency Code "EUR"
4. To_Currency Name "Euro"
5. Exchange Rate "1.1655"
6. Last Refreshed "2021-07-18 09:00:04"
7. Time Zone"UTC"
8. Bid Price "1.16544000"
9. Ask Price "1.16555000"
All looked good so I set the two currencies GBP and EUR to get online quotes
in the Security Editor.
I then switched to the Price Database and clicked Get Quotes only to get the
following failure message:
Interestingly, when I click the Get Quotes button (and when I open GNU Cash)
Perl pops a blank CMD window (C:Strawbery\perl\bin\perl.exe) and the window
closes without being populated.
I then created a new alphavantage key which I updated in GNC preferences,
but I got the same result when I ran Get Quotes.
I next tried the following code example:
cd \Program Files (x86)\gnucash\bin
set ALPHAVANTAGE_API_KEY=[MYKEY]
perl gnc-fq-dump alphavantage CSCO
Which generated the following output:
C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump alphavantage EUR
syswrite() on unopened filehandle GEN0 at
C:/Strawberry/perl/lib/IO/Handle.pm line 459.
Finance::Quote fields Gnucash uses:
symbol: EUR (deduced)<=== required
date: ** missing **<=== recommended
currency: ** missing **<=== required
last: **missing** <=\
nav: **missing** <=== one of these
price: **missing** <=/
timezone: <=== optional
My immediate thought was that either GNC or PERL were being blocked by Win
10 security so I explicitly added both Perl Interpreter and GNC to the apps
allowed through Windows Firewall - both private and public. This made no
difference.
I then wondered if the problem was IP blocking so tried again over a VPN,
thus a different IP. This made no difference.
I'm not a Perl programmer so I'm now pretty much stuck. Possibly I've missed
something very obvious or else there is something strange going on here
which I don't understan
