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 <cleanoutmys...@gmail.com>
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 <cleanoutmys...@gmail.com <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
>
> 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
<mailto: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
<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.16550000"
>>
>> 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 understand.
>>
>>
>>
>> If anyone can suggest how to diagnose the issue from here, or better
>> still fix the issue, I'd very much appreciate the help.
>>
>>
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org>
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists
<https://wiki.gnucash.org/wiki/Mailing_Lists> for more information.
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>