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 <cleanoutmys...@gmail.com> 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 <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&fro > m> > > >> _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. > > >> > > > >
_______________________________________________ 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.