[GNC] Can anyone help with this issue please - GNC-FQ Not able to collect data
david.romano at davidjromano.com
david.romano at davidjromano.com
Mon Jul 19 08:04:11 EDT 2021
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 <cleanoutmyshed at gmail.com>
Sent: 19 July 2021 13:01
To: david.romano at davidjromano.com; gnucash-user at 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.romano at 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 <cleanoutmyshed at gmail.com>
> Sent: 19 July 2021 12:41
> To: david.romano at davidjromano.com; gnucash-user at 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.romano at davidjromano.com
> <mailto:david.romano at 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 <cleanoutmyshed at gmail.com
> <mailto:cleanoutmyshed at gmail.com>>
>
> > Sent: 18 July 2021 13:55
>
> > To: david.romano at davidjromano.com
> <mailto:david.romano at davidjromano.com>; gnucash-user at gnucash.org
> <mailto:gnucash-user at 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.romano at davidjromano.com
> <mailto:david.romano at 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 at gnucash.org <mailto:gnucash-user at gnucash.org>
>
> >> To update your subscription preferences or to unsubscribe:
>
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>
> >> If you are using Nabble or Gmane, please see
>
> > https://wiki.gnucash.org/wiki/Mailing_Lists
> <https://wiki.gnucash.org/wiki/Mailing_Lists> for more information.
>
> >> -----
>
> >> Please remember to CC this list on all your replies.
>
> >> You can do this by using Reply-To-List or Reply-All.
>
> >>
>
> >
>
More information about the gnucash-user
mailing list