Re: [GNC] Unable to retrieve currency quotes

[ml enquirer]

Hi John,

Thanks. Executing that command gives:

ALPHAVANTAGE_API_KEY=
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump currency "CHF"
"USD"

1 CHF = 1.00156244 USD
so all looks good on the alphavantage side.

Thanks for the bug-link. Indeed, I have a number of securities (but no
other currencies, I think) set up. I'll try debugging by disabling one by
one and let you know how I get on.

All the best,


On Sat, May 19, 2018 at 7:39 PM, John Ralls  wrote:

>
>
> On May 19, 2018, at 9:10 AM, ml enquirer  wrote:
>
> Hi all,
>
> @shaq32: thanks for the idea, but no, this is not the problem, I already
> have a valid API key (that's a very old FAQ...)
>
> Any luck debugging, John? Anything I can do to provide more useful info?
>
>
> Well, I just tried again and it failed, so I checked the Alphavantage key
> setting in Preferences>Online Banking and found it not set. After setting
> it with my key retrieving CHF->USD and EUR->USD quotes worked. I’m afraid
> that’s not much help.
>
> If you run from the command line (ALPHAVANAGE_API_KEY=xxx
> /Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump currency
> “CHF” “USD”) do you get a valid result?
>
> It occurs to me that your problem might be similar to
> https://bugzilla.gnome.org/show_bug.cgi?id=795564. Try disabling quote
> retrieval on all securities and see if that changes anything. Are there any
> currencies in your book besides CHF, EUR, and USD?
>
> Regards,
> John Ralls
>
>
___
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] Unable to retrieve currency quotes

[John Ralls]

> On May 19, 2018, at 9:10 AM, ml enquirer  wrote:
> 
> Hi all,
> 
> @shaq32: thanks for the idea, but no, this is not the problem, I already
> have a valid API key (that's a very old FAQ...)
> 
> Any luck debugging, John? Anything I can do to provide more useful info?

Well, I just tried again and it failed, so I checked the Alphavantage key 
setting in Preferences>Online Banking and found it not set. After setting it 
with my key retrieving CHF->USD and EUR->USD quotes worked. I’m afraid that’s 
not much help.

If you run from the command line (ALPHAVANAGE_API_KEY=xxx 
/Applications/Gnucash.app/Contents/Resources/bin/gnc-fq-dump currency “CHF” 
“USD”) do you get a valid result?

It occurs to me that your problem might be similar to 
https://bugzilla.gnome.org/show_bug.cgi?id=795564 
. Try disabling quote 
retrieval on all securities and see if that changes anything. Are there any 
currencies in your book besides CHF, EUR, and USD?

Regards,
John Ralls

___
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] Unable to retrieve currency quotes

[ml enquirer]

Hi all,

@shaq32: thanks for the idea, but no, this is not the problem, I already
have a valid API key (that's a very old FAQ...)

Any luck debugging, John? Anything I can do to provide more useful info?

Best regards,

On Tue, May 8, 2018 at 7:31 PM, shaq32  wrote:

> Hi,
>
> I had the same problem and fund the solution for it.
>
> 1) go this website https://www.alphavantage.co
>
> chose "Get your free API Key today"
>
> register and get an Alpha Vantage API Key.
>
> Copy the key and go to step no. 2
>
>
>
> 2) In Gnucash menu go to Preferences -> Online Quotes
>
> paste the API key there
>
> you are all set to go !
>
> Regards
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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] Unable to retrieve currency quotes

[shaq32]

Hi,

I had the same problem and fund the solution for it.

1) go this website https://www.alphavantage.co 

chose "Get your free API Key today"

register and get an Alpha Vantage API Key.

Copy the key and go to step no. 2



2) In Gnucash menu go to Preferences -> Online Quotes

paste the API key there

you are all set to go !

Regards



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] Unable to retrieve currency quotes

[David Carlson]

I have too many VMs.  It was a different VM that has Ubuntu 16.04 and
GnuCash release 2.6.12 with Finance::Quote 1.47 that is currently the only
instance here that can download security prices for US stocks through
AlpaVantage.  That instance cannot retrieve any of the 5 currencies that I
like to follow.

David C
​
___
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] Unable to retrieve currency quotes

[David Carlson]

Not sure what is happening at my house(wrt GnuCash).  Release 2.6.19 with
finance-quote 1.47  in Windows was able to retrieve the US securities in my
portfolio via AlphaVantage earlier this year but now it cannot retrieve
anything.  Release 2.6.17 (backport?) in Ubuntu 16.04 with finance::quote
1.38 in a VM can still retrieve Securities but it cannot retrieve
currencies.  In Ubuntu 16.04 Gnome on a Toshiba laptop GnuCash 2.6.17
(backport?) used to work (I think) a month or two ago but now it does not
indicate that it is failing to download security prices but new prices do
not appear in the database.  That machine also has Finance::Quote version
1.38 which seemingly does not explain that failure.

Lastly, my Debian8 machine which used to be my go-to machine for Gnucash
suddenly cannot even boot far enough to get an IP address or operate a
display.

David C

On Mon, Apr 30, 2018 at 3:34 PM, ml enquirer 
wrote:

> Thanks - it's reassuring to know it's not just me...
>
> all the best,
>
> On Mon, Apr 30, 2018 at 10:18 PM, John Ralls  wrote:
>
> >
> >
> > > On Apr 30, 2018, at 1:05 PM, ml enquirer 
> > wrote:
> > >
> > > Sorry, that should have read GnuCash 3.1...
> > >
> > > D
> > >
> > > On Mon, Apr 30, 2018 at 9:59 PM, ml enquirer  >
> > > wrote:
> > >
> > >> Hi,
> > >>
> > >> I have GnuCash 2.6.21 for Mac (running 10.13.4). I have set up
> > >> Finance::Quote properly, with my alphavantage key. When I press "Get
> > >> quotes" in the Price Editor, I expect updates for CHF, EUR and several
> > >> stock quotes. The stock quotes come back fine each time, but the two
> > >> currency updates fail every time:
> > >>
> > >> Unable to retrieve quotes for these items:
> > >>  CURRENCY:CHF
> > >>  CURRENCY:EUR
> > >> Continue using only the good quotes?
> > >>
> > >> Why are the currency updates failing, when the stock quotes succeed?
> How
> > >> can I debug? (I already tried looking at the gnucash.trace file, but
> > >> there's nothing obvious appearing there. ./gnc-fq-dump works fine...
> > >>
> > >> Please help! :(
> >
> > Hmm. Oddly, it works fine in Windows but fails on MacOS. Unfortunately
> I'm
> > traveling for the rest of the week and won't be able to investigate
> further
> > until I return.
> >
> > Regards,
> > John Ralls
> >
> >
> ___
> 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] Unable to retrieve currency quotes

[ml enquirer]

Thanks - it's reassuring to know it's not just me...

all the best,

On Mon, Apr 30, 2018 at 10:18 PM, John Ralls  wrote:

>
>
> > On Apr 30, 2018, at 1:05 PM, ml enquirer 
> wrote:
> >
> > Sorry, that should have read GnuCash 3.1...
> >
> > D
> >
> > On Mon, Apr 30, 2018 at 9:59 PM, ml enquirer 
> > wrote:
> >
> >> Hi,
> >>
> >> I have GnuCash 2.6.21 for Mac (running 10.13.4). I have set up
> >> Finance::Quote properly, with my alphavantage key. When I press "Get
> >> quotes" in the Price Editor, I expect updates for CHF, EUR and several
> >> stock quotes. The stock quotes come back fine each time, but the two
> >> currency updates fail every time:
> >>
> >> Unable to retrieve quotes for these items:
> >>  CURRENCY:CHF
> >>  CURRENCY:EUR
> >> Continue using only the good quotes?
> >>
> >> Why are the currency updates failing, when the stock quotes succeed? How
> >> can I debug? (I already tried looking at the gnucash.trace file, but
> >> there's nothing obvious appearing there. ./gnc-fq-dump works fine...
> >>
> >> Please help! :(
>
> Hmm. Oddly, it works fine in Windows but fails on MacOS. Unfortunately I'm
> traveling for the rest of the week and won't be able to investigate further
> until I return.
>
> Regards,
> John Ralls
>
>
___
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] Unable to retrieve currency quotes

[John Ralls]

> On Apr 30, 2018, at 1:05 PM, ml enquirer  wrote:
> 
> Sorry, that should have read GnuCash 3.1...
> 
> D
> 
> On Mon, Apr 30, 2018 at 9:59 PM, ml enquirer 
> wrote:
> 
>> Hi,
>> 
>> I have GnuCash 2.6.21 for Mac (running 10.13.4). I have set up
>> Finance::Quote properly, with my alphavantage key. When I press "Get
>> quotes" in the Price Editor, I expect updates for CHF, EUR and several
>> stock quotes. The stock quotes come back fine each time, but the two
>> currency updates fail every time:
>> 
>> Unable to retrieve quotes for these items:
>>  CURRENCY:CHF
>>  CURRENCY:EUR
>> Continue using only the good quotes?
>> 
>> Why are the currency updates failing, when the stock quotes succeed? How
>> can I debug? (I already tried looking at the gnucash.trace file, but
>> there's nothing obvious appearing there. ./gnc-fq-dump works fine...
>> 
>> Please help! :(

Hmm. Oddly, it works fine in Windows but fails on MacOS. Unfortunately I'm 
traveling for the rest of the week and won't be able to investigate further 
until I return.

Regards,
John Ralls

___
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] Unable to retrieve currency quotes

[ml enquirer]

I've tried making a copy of the account and deleting hundreds (or
thousands) of transactions. This didn't make much difference (though just
now one of the two currency requests seemed to succeed). Immediately
afterwards, though, the same "Get Quotes" reverted to its standard error
message.

Is AlphaVantage really very unstable? I tried with a new API key but with
no luck.

On Mon, Apr 30, 2018 at 10:05 PM, ml enquirer 
wrote:

> Sorry, that should have read GnuCash 3.1...
>
> D
>
>
> On Mon, Apr 30, 2018 at 9:59 PM, ml enquirer 
> wrote:
>
>> Hi,
>>
>> I have GnuCash 2.6.21 for Mac (running 10.13.4). I have set up
>> Finance::Quote properly, with my alphavantage key. When I press "Get
>> quotes" in the Price Editor, I expect updates for CHF, EUR and several
>> stock quotes. The stock quotes come back fine each time, but the two
>> currency updates fail every time:
>>
>> Unable to retrieve quotes for these items:
>>   CURRENCY:CHF
>>   CURRENCY:EUR
>> Continue using only the good quotes?
>>
>> Why are the currency updates failing, when the stock quotes succeed? How
>> can I debug? (I already tried looking at the gnucash.trace file, but
>> there's nothing obvious appearing there. ./gnc-fq-dump works fine...
>>
>> Please help! :(
>>
>> D
>>
>>
>
___
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] Unable to retrieve currency quotes

[ml enquirer]

Sorry, that should have read GnuCash 3.1...

D

On Mon, Apr 30, 2018 at 9:59 PM, ml enquirer 
wrote:

> Hi,
>
> I have GnuCash 2.6.21 for Mac (running 10.13.4). I have set up
> Finance::Quote properly, with my alphavantage key. When I press "Get
> quotes" in the Price Editor, I expect updates for CHF, EUR and several
> stock quotes. The stock quotes come back fine each time, but the two
> currency updates fail every time:
>
> Unable to retrieve quotes for these items:
>   CURRENCY:CHF
>   CURRENCY:EUR
> Continue using only the good quotes?
>
> Why are the currency updates failing, when the stock quotes succeed? How
> can I debug? (I already tried looking at the gnucash.trace file, but
> there's nothing obvious appearing there. ./gnc-fq-dump works fine...
>
> Please help! :(
>
> D
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Unable to retrieve currency quotes

[ml enquirer]

Hi,

I have GnuCash 2.6.21 for Mac (running 10.13.4). I have set up
Finance::Quote properly, with my alphavantage key. When I press "Get
quotes" in the Price Editor, I expect updates for CHF, EUR and several
stock quotes. The stock quotes come back fine each time, but the two
currency updates fail every time:

Unable to retrieve quotes for these items:
  CURRENCY:CHF
  CURRENCY:EUR
Continue using only the good quotes?

Why are the currency updates failing, when the stock quotes succeed? How
can I debug? (I already tried looking at the gnucash.trace file, but
there's nothing obvious appearing there. ./gnc-fq-dump works fine...

Please help! :(

D
___
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.