Re: [GNC] Alpha Vantage problems
Hi Robert I have bad news! It looks like Alpha Vantage has been distributing data without the exchange's license all along. A few days ago, TSX data stop working on Alphavantage. That explains why data keeps disappearing on Alpha vantage in recent weeks including real-time US market, LSE, Europe exchanges and now TSX. Check this links: https://www.elitetrader.com/etalpha-vantage-dead https://preview.redd.it/ucr35j For the moment until we find another provider or until Alpha Vantage returns to make the data available I suggest using yahoo_json instead of Alpha Vantage for the markets Toronto (.TO) Toronto Venture (.V) London (.L) London in USD (.IL) Milan (.MI) Oslo (.OL) Copenhagen (.CO) Paris (.PA). This is working for me. Best regards Adriano Baldi Il giorno mar 7 lug 2020 alle ore 14:08 Robert Dean < b...@bobandgilldean.me.uk> ha scritto: > Hi, > > I have also lost access to Alphavantage stocks on LSE. It last worked on > 24 June, but failed on the 25th. I have checked both my stocks with > gnc-fq-dump and neither work, so I have changed to Yahoo-json. > > I'm using Gnucash 3.10 on Fedora 32. > > Regards > Bob Dean > > On 07/07/2020 12:01, Chris Good wrote: > > Hi Adrian, how are you getting quotes from excel? Have you got your > > alphavantage API key specified in GnuCash preferences? > > > > I suggest the next stage would be to test each of the stocks you want to > > use Alphavantage for, with gnc-fq-dump. > > > > Regards, Chris Good > > > > On Tue., 7 Jul. 2020, 7:39 pm Adrian Holbrook, < > adrian.holbr...@gmail.com> > > wrote: > > > >> Thanks Chris, I think my installation of Finance;;Quote is working fine > as > >> I get quotes from other sources such as Morningstar and Yahoo JSON > without > >> any problem. I think it must be an Alphavantage problem and the next > stage > >> is to try and get quotes using excel and see if that works. In the > short > >> term I have changed my source to Yahoo JSON and that is working. I would > >> just like to be able to get Alphavantage working as well so that if one > >> fails I have a backup source. > >> > >> Regards > >> > >> Adrian > >> > >> > >> > >> On Tue, Jul 7, 2020 at 9:10 AM Chris Good > wrote: > >> > >>> Message: 3 > >>> Date: Tue, 7 Jul 2020 07:58:33 +0100 > >>> From: Adrian Holbrook > >>> To: gnucash-user@gnucash.org > >>> Subject: [GNC] Alpha Vantage problems > >>> Message-ID: > >>> >>> a...@mail.gmail.com> > >>> Content-Type: text/plain; charset="UTF-8" > >>> > >>> I have been using Alphvantage for about a year now to get quotes > without > >>> any > >>> problems - I had to add in the 15 second delay that was suggested to > stop > >>> it > >>> failing - but since then it has been 100% reliable. I normally download > >>> around 50 prices at a time about once a week. The last successful > download > >>> was on June 12th and since then all attempts have failed. > >>> > >>> All my shares are on the LSE. I have not checked trying to get quotes > from > >>> NYSE but that would be my next test. > >>> I am using Gnucash 4.0 and Finance::Quote 1.49 > >>> > >>> Regards > >>> > >>> Adrian > >>> > >>> Hi Adrian, > >>> > >>> Please follow instructions at > >>> https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting > >>> > >>> Regards, Chris Good > >>> > >>> > > ___ > > 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. > ___ 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] Alpha Vantage problems
Hi, to all I have bad news! It looks like Alphavantage has been distributing data without the exchange's license all along. A few days ago, TSX data stop working on Alphavantage. That explains why data keeps disappearing on Alpha vantage in recent weeks including real-time US market, LSE, Europe exchanges and now TSX. Check this links: https://www.elitetrader.com/etalpha-vantage-dead <https://www.elitetrader.com/et/threads/is-alpha-vantage-dead.347236/#post-5150781> https://preview.redd.it/ucr35j <https://preview.redd.it/ucr35jx3sr951.png?width=1194=png=webp=ec28ce816b00a6740ec14a5219a196f85b497aef> Best regards Adriano Baldi Il giorno mer 8 lug 2020 alle ore 10:15 Chris Good ha scritto: > Hi Bob, > > Good to know. Can you give an example of a stock and the symbol you used > that used to work please? > > Regards, Chris Good > > Message: 9 > Date: Tue, 7 Jul 2020 13:06:11 +0100 > From: Robert Dean > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Alpha Vantage problems > Message-ID: > > Content-Type: text/plain; charset=utf-8; format=flowed > > Hi, > > I have also lost access to Alphavantage stocks on LSE. It last worked on > 24 June, but failed on the 25th. I have checked both my stocks with > gnc-fq-dump and neither work, so I have changed to Yahoo-json. > > I'm using Gnucash 3.10 on Fedora 32. > > Regards > Bob Dean > > On 07/07/2020 12:01, Chris Good wrote: > > Hi Adrian, how are you getting quotes from excel? Have you got your > > alphavantage API key specified in GnuCash preferences? > > > > I suggest the next stage would be to test each of the stocks you want > > to use Alphavantage for, with gnc-fq-dump. > > > > Regards, Chris Good > > > > On Tue., 7 Jul. 2020, 7:39 pm Adrian Holbrook, > > > > wrote: > > > >> Thanks Chris, I think my installation of Finance;;Quote is working > >> fine as I get quotes from other sources such as Morningstar and Yahoo > >> JSON without any problem. I think it must be an Alphavantage problem > >> and the next stage is to try and get quotes using excel and see if > >> that works. In the short term I have changed my source to Yahoo JSON > >> and that is working. I would just like to be able to get Alphavantage > >> working as well so that if one fails I have a backup source. > >> > >> Regards > >> > >> Adrian > >> > >> > >> > >> On Tue, Jul 7, 2020 at 9:10 AM Chris Good > wrote: > >> > >>> Message: 3 > >>> Date: Tue, 7 Jul 2020 07:58:33 +0100 > >>> From: Adrian Holbrook > >>> To: gnucash-user@gnucash.org > >>> Subject: [GNC] Alpha Vantage problems > >>> Message-ID: > >>> >>> a...@mail.gmail.com> > >>> Content-Type: text/plain; charset="UTF-8" > >>> > >>> I have been using Alphvantage for about a year now to get quotes > >>> without any problems - I had to add in the 15 second delay that was > >>> suggested to stop it failing - but since then it has been 100% > >>> reliable. I normally download around 50 prices at a time about once > >>> a week. The last successful download was on June 12th and since then > >>> all attempts have failed. > >>> > >>> All my shares are on the LSE. I have not checked trying to get > >>> quotes from NYSE but that would be my next test. > >>> I am using Gnucash 4.0 and Finance::Quote 1.49 > >>> > >>> Regards > >>> > >>> Adrian > >>> > >>> Hi Adrian, > >>> > >>> Please follow instructions at > >>> https://wiki.gnucash.org/wiki/Online_Quotes#Trouble_Shooting > >>> > >>> Regards, Chris Good > > ___ > 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: Finance-Quote 1.47 Unable to retrieve Currency quotes
Hello to all
After some test I finally ad a delay of 30s delay between two subsequent
downloads.
With this delay the error disappear.
- Quote.pm --
...
# Don't know if these have to be in upper case, but it's
# better to be safe than sorry.
$to = uc($to);
$from = uc($from);
return $amount if ($from eq $to); # Trivial case.
my $ua = $this->user_agent;
my $ALPHAVANTAGE_API_KEY = $ENV{'ALPHAVANTAGE_API_KEY'};
return undef unless ( defined $ALPHAVANTAGE_API_KEY );
sleep 30; <= ADD THIS
my $reply = $ua->request(GET "${ALPHAVANTAGE_CURRENCY_URL}"
. "_currency=" . ${from}
. "_currency=" . ${to}
. "=" . ${ALPHAVANTAGE_API_KEY} );
---
We are far, from having found the solution but at least I have found a
temporary solution to the problem.
With the hope that the "Maestro" (Italian term) Erik Colson will intervene
for the benefit of everyone with one of his magic codes.
Best regards
Adriano
2018-02-23 2:09 GMT+01:00 Les <lellio...@gmail.com>:
> Thanks for the explanation Larry. Now I understand. I just don't know
> why I am unable to update currency quotes since 02/13/2018. Perhaps
> Alphavantage is just not robust enough to support all the users of GC plus
> what they were supporting before Yahoo went south last year.
>
> I appreciate what Erik Colson was able to put together in such a very
> short time. And Alphavantage seems to be the only game in town for the time
> being. All of the developers of GC need a big round of applause for keeping
> GC moving forward and answering all of the questions from users.
>
> Les
>
>
> On 02/22/2018 05:29 PM, ln.mailingli...@iinet.net.au wrote:
>
>> If you take a look in the Quote.pm perl module, the currency
>> conversion method calls the alpha vantage CURRENCY_EXCHANGE_RATE
>> function. As far as I can see this is the *only* source of exchange
>> rate data available in Finance::Quote (at least assuming you are using
>> version 1.47). Given this, any setting in gnucash is unlikely to
>> change anything (and is probably why gnucash reverts to currency no
>> matter what you do - it's the one data source that binds them all when
>> it comes to currency).
>> Also see the following post from Erik Colson (FQ developer)
>> https://sourceforge.net/p/finance-quote/mailman/message/36112625/
>> And finally, if you want to prove it for yourself, run currency
>> conversion with and without the alpha vantage key set.
>> Cheers,
>> Larry
>>
>> Maybe I am missing something but when I go to Security Editor,
>> click
>> on
>>
>> currencies and then select unknown and then alphavantage and save
>> it
>>
>> reverts back to single, currency. So how is the quote (when I get
>> one)
>>
>> coming from alphavantage?
>>
>> Confused,
>>
>> Les
>>
>> On 02/22/2018 03:09 AM, ln.mailinglists at iinet.net.au [1]
>> wrote:
>>
>> >_ Hi Richard, _
>>
>> >_ It's definitely alphavantage for currency - you can check the
>> data
>> URL _
>>
>> >_ early in the Quote.pm module. _
>>
>> >_ I'd agree with Adriano's assessment that the problem is server
>> side. _
>>
>> >_ I did a test this morning where I repeatedly requested quotes
>> from
>> _
>>
>> >_ gnucash - the first four attempts sucessfully grabbed all of my
>> stock _
>>
>> >_ values but failed on USD/AUD exchange rates, while the fifth
>> test
>> got _
>>
>> >_ everything. _
>>
>> >
>>
>> >_ Cheers, _
>>
>> >_ Larry _
>>
>> >
>>
>> >_ Date: Wed, 21 Feb 2018 11:24:25 + _
>>
>> >_ From: Richard Morris _
>>
>> >_ To: Adriano Baldi _
>>
>> >_ Cc: gnucash-user _
>>
>> >_ Subject: Re: Finance-Quote 1.47 Unable to retrieve Currency
>> quotes
>> _
>>
>> >_ Message-ID: _
>>
>> >
>>
>> >_ Content-Type: text/plain; charset="UTF-8" _
>>
>> >_ But I wonder - does GNUCash use alphavantage for currencies? _
>>
>> >_ I see this: _
>>
>> >_ "There are 3 types of sources of which the first - currency -
>> is _
>>
>> >_ ha
Re: Finance-Quote 1.47 Unable to retrieve Currency quotes
Hello Richard
You can't introduce a delay in Gnucash but you can modify the
Finance::Quote module that Gnucash use.
For the currency is Quote.pm (for me is in
/usr/local/share/perl/5.22.1/Finance/ ) and I try tho chance it :
# ===
# currency (public object method)
#
# currency allows the conversion of one currency to another.
#
# Usage: $quoter->currency("USD","AUD");
# $quoter->currency("15.95 USD","AUD");
#
# undef is returned upon error.
sub currency {
my $this = shift if (ref($_[0]));
$this ||= _dummy();
my ($from, $to) = @_;
return undef unless ($from and $to);
$from =~ s/^\s*(\d*\.?\d*)\s*//;
my $amount = $1 || 1;
# Don't know if these have to be in upper case, but it's
# better to be safe than sorry.
$to = uc($to);
$from = uc($from);
return $amount if ($from eq $to); # Trivial case.
my $ua = $this->user_agent;
my $ALPHAVANTAGE_API_KEY = $ENV{'ALPHAVANTAGE_API_KEY'};
return undef unless ( defined $ALPHAVANTAGE_API_KEY );
# change start --
*my $key_n=0; sleep 1; # This introduce a 1s delay $key_n =
int(rand(10)); # Select randomly one of the following API key (change the
keys with your keys)*
* if($key_n == 0) {$ALPHAVANTAGE_API_KEY="xx_KEY_00_xx"};
if($key_n == 1) {$ALPHAVANTAGE_API_KEY="xx_KEY_01_xx"};
if($key_n == 2) {$ALPHAVANTAGE_API_KEY="xx_KEY_02_xx"};
if($key_n == 3) {$ALPHAVANTAGE_API_KEY="xx_KEY_03_xx"};
if($key_n == 4) {$ALPHAVANTAGE_API_KEY="xx_KEY_04_xx"};
if($key_n == 5) {$ALPHAVANTAGE_API_KEY="xx_KEY_05_xx"};
if($key_n == 6) {$ALPHAVANTAGE_API_KEY="xx_KEY_06_xx"};
if($key_n == 7) {$ALPHAVANTAGE_API_KEY="xx_KEY_07_xx"};
if($key_n == 8) {$ALPHAVANTAGE_API_KEY="xx_KEY_08_xx"};
if($key_n == 9) {$ALPHAVANTAGE_API_KEY="xx_KEY_09_xx"};
if($key_n == 10) {$ALPHAVANTAGE_API_KEY="xx_KEY_10_xx"};* my
$reply = $ua->request(GET "${ALPHAVANTAGE_CURRENCY_URL}"
. "_currency=" . ${from}
. "_currency=" . ${to}
. "=" . ${ALPHAVANTAGE_API_KEY} );
*# This print the request, and you can see the key used*
* print "${ALPHAVANTAGE_CURRENCY_URL}". "_currency=" . ${from}
. "_currency=" . ${to}. "=" . ${ALPHAVANTAGE_API_KEY}."\n";
print $reply;# change end
--*
if you run *gnc-fq-dump currency usd eur *you are able to test it outside
Gnucash.
This apply a request every 0,1s but the delay inside the module (*sleep 1;
*) decide the real frequency and you can change it.
root@ASUS-N56VZ:/usr/local/share/perl/5.22.1/Finance# *watch -n 0
gnc-fq-dump currency usd eur*
https://www.alphavantage.co/query?function=CURRENCY_EXCHANGE_RATE_currency=USD_currency=EUR=xxx
HTTP::Response=HASH(0x42eb5a0)1 usd = 0.812089 eur
The problem it's than after two polling, same time the download fail.
Best regard
Adriano
2018-02-22 9:47 GMT+01:00 Richard Morris <sgtze...@gmail.com>:
> Sorry I couldn't reply to this before Adriano - I've been finding using
> this list a bit too difficult for me! (A confusion between my @gmail and
> @googlemail email domain identities)
>
> I think you are probably on to something in trying to throttle your
> requests. But may I ask - how are you adding the delay? Where is the
> setting in GNUCash for that?
>
> I have about 35 stocks to check, of which about 7 or 8 are in USD etc. I
> run "gnucash --add-price-quotes" on the hour as a cron job. I wouldn't have
> thought that was too demanding on Alphavantage. But then - how many of us
> are making requests to them via GNUCash?
>
> Best
>
> Richard
>
> On 20 February 2018 at 11:47, Adriano Baldi <adriano.ba...@gmail.com>
> wrote:
>
>> Hello Richard
>>
>> After doing countless tests I think that the problem is related to the
>> management of the demands of Alphavantage.
>> But I can not figure out where we are wrong.
>> These are the declared performances:
>>
>> *>> What is the expected server-side performance (e.g., throughput time)
>> for the API service?*
>>
>> *>> Based on the latest instrumentation, the throughput time for our API
>> endpoint is under 500 milliseconds per request at 25% to 75% percentile. *
>>
>> *>> While we are proud to provide free API service with no
>> daily/weekly/monthly call limits, we recommend that API call frequency does
>> not extend far beyond ~1 call per second *
>
Re: Finance-Quote 1.47 Unable to retrieve Currency quotes
Hello
Maybe I found something
https://www.alpha-vantage.community/post/unable-to-get-the-response-when-using-currencyexchangerate-api-9654331
we are not alone...
Best regards
Adriano
2018-02-20 12:47 GMT+01:00 Adriano Baldi <adriano.ba...@gmail.com>:
> Hello Richard
>
> After doing countless tests I think that the problem is related to the
> management of the demands of Alphavantage.
> But I can not figure out where we are wrong.
> These are the declared performances:
>
> *>> What is the expected server-side performance (e.g., throughput time)
> for the API service?*
>
> *>> Based on the latest instrumentation, the throughput time for our API
> endpoint is under 500 milliseconds per request at 25% to 75% percentile. *
>
> *>> While we are proud to provide free API service with no
> daily/weekly/monthly call limits, we recommend that API call frequency does
> not extend far beyond ~1 call per second *
>
> *>> so that we can continue to deliver the optimal server-side
> performance.*
>
> So I tried to put a delay between one request and another of 1 or more
> seconds, with no result.
> In addition I tried to ensure that for each request was used a different
> key, randomly chosen among 10 keys, even here without result.
>
> I need new idea to test.
>
> Best regards
>
> Adriano
>
>
> 2018-02-20 9:28 GMT+01:00 Richard Morris <sgtze...@googlemail.com>:
>
>> I have this problem too (starting yesterday). I was going to do a post -
>> then, late in the day, the problem went away! But now it's back again.
>>
>> I wonder if this is a connectivity issue with whatever GNUCash uses for
>> currency sources? (This is hard-wired I think, and I'm not sure what that
>> is).
>>
>> I'm on Ubuntu too: GnuCash 2.6.17 + Ubuntu 17.10 + Finance::Quote 1.47
>>
>>
>> On Tue, Feb 20, 2018 at 6:09 AM, Adriano Baldi <adriano.ba...@gmail.com>
>> wrote:
>>
>>> Hello
>>>
>>> I apologize for my poor English.
>>>
>>> I use GnuCash since 2011 and usually I am able to solve this kind of
>>> problem by myself if necessary modifing the perl files of Finance::Quote.
>>> But now I'm going crazy with this problem.
>>>
>>> I've got this error since february 14 on two different PC with Ubuntu
>>> 14.04
>>> and 16.04 with GnuCash 2.6.12 and Finance::Quote 1.47.
>>>
>>> Unable to retrieve quotes for these items:
>>> CURRENCY:XAU
>>> CURRENCY:XPT
>>> CURRENCY:XAG
>>> CURRENCY:NZD
>>> CURRENCY:CAD
>>> CURRENCY:AUD
>>> CURRENCY:CHF
>>> CURRENCY:CNY
>>> CURRENCY:RUB
>>> CURRENCY:DKK
>>> CURRENCY:NOK
>>> CURRENCY:GBP
>>> CURRENCY:USD
>>> CURRENCY:JPY
>>> Continue using only the good quotes?
>>>
>>> If I try from the consolle Finance::Quote work fine
>>>
>>> $ gnc-fq-dump currency USD EUR
>>> 1 USD = 0.805969 EUR
>>>
>>> $ gnc-fq-dump currency XAU EUR
>>> 1 XAU = 1085.3924262 EUR
>>>
>>> $ gnc-fq-check
>>> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia"
>>> "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil"
>>> "bse"
>>> "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka"
>>> "dutch"
>>> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct"
>>> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france"
>>> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney"
>>> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual"
>>> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp"
>>> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds"
>>> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse"
>>> "tiaacref" "tnet
Re: Finance-Quote 1.47 Unable to retrieve Currency quotes
Hello Richard
After doing countless tests I think that the problem is related to the
management of the demands of Alphavantage.
But I can not figure out where we are wrong.
These are the declared performances:
*>> What is the expected server-side performance (e.g., throughput time)
for the API service?*
*>> Based on the latest instrumentation, the throughput time for our API
endpoint is under 500 milliseconds per request at 25% to 75% percentile. *
*>> While we are proud to provide free API service with no
daily/weekly/monthly call limits, we recommend that API call frequency does
not extend far beyond ~1 call per second *
*>> so that we can continue to deliver the optimal server-side performance.*
So I tried to put a delay between one request and another of 1 or more
seconds, with no result.
In addition I tried to ensure that for each request was used a different
key, randomly chosen among 10 keys, even here without result.
I need new idea to test.
Best regards
Adriano
2018-02-20 9:28 GMT+01:00 Richard Morris <sgtze...@googlemail.com>:
> I have this problem too (starting yesterday). I was going to do a post -
> then, late in the day, the problem went away! But now it's back again.
>
> I wonder if this is a connectivity issue with whatever GNUCash uses for
> currency sources? (This is hard-wired I think, and I'm not sure what that
> is).
>
> I'm on Ubuntu too: GnuCash 2.6.17 + Ubuntu 17.10 + Finance::Quote 1.47
>
>
> On Tue, Feb 20, 2018 at 6:09 AM, Adriano Baldi <adriano.ba...@gmail.com>
> wrote:
>
>> Hello
>>
>> I apologize for my poor English.
>>
>> I use GnuCash since 2011 and usually I am able to solve this kind of
>> problem by myself if necessary modifing the perl files of Finance::Quote.
>> But now I'm going crazy with this problem.
>>
>> I've got this error since february 14 on two different PC with Ubuntu
>> 14.04
>> and 16.04 with GnuCash 2.6.12 and Finance::Quote 1.47.
>>
>> Unable to retrieve quotes for these items:
>> CURRENCY:XAU
>> CURRENCY:XPT
>> CURRENCY:XAG
>> CURRENCY:NZD
>> CURRENCY:CAD
>> CURRENCY:AUD
>> CURRENCY:CHF
>> CURRENCY:CNY
>> CURRENCY:RUB
>> CURRENCY:DKK
>> CURRENCY:NOK
>> CURRENCY:GBP
>> CURRENCY:USD
>> CURRENCY:JPY
>> Continue using only the good quotes?
>>
>> If I try from the consolle Finance::Quote work fine
>>
>> $ gnc-fq-dump currency USD EUR
>> 1 USD = 0.805969 EUR
>>
>> $ gnc-fq-dump currency XAU EUR
>> 1 XAU = 1085.3924262 EUR
>>
>> $ gnc-fq-check
>> ("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia"
>> "asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse"
>> "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka"
>> "dutch"
>> "dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct"
>> "fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france"
>> "ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney"
>> "greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual"
>> "known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp"
>> "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds"
>> "sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse"
>> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp"
>> "tsx"
>> "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard"
>> "vwd"
>> "yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe"
>> "yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts")
>>
>> I don't know if this problem afflict only me (I hope so) or if others have
>> the same problem.
>> The problem afflicts only the currency with continuity, on some stocks I
>> can have the problem occasionally, but generally a second download work
>> fine.
>> I retreive more of 40 stocks from 6 excange with no problem using
>> Alphavantage.
>> Does anyone have an idea from what can be determined?
>> Does anyone have a suggestion to give me to solve this problem?
>> Thanks in advance to anyone who can help me.
>>
>> Best regards
>>
>> Adriano
>> ___
>> 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.
Finance-Quote 1.47 Unable to retrieve Currency quotes
Hello
I apologize for my poor English.
I use GnuCash since 2011 and usually I am able to solve this kind of
problem by myself if necessary modifing the perl files of Finance::Quote.
But now I'm going crazy with this problem.
I've got this error since february 14 on two different PC with Ubuntu 14.04
and 16.04 with GnuCash 2.6.12 and Finance::Quote 1.47.
Unable to retrieve quotes for these items:
CURRENCY:XAU
CURRENCY:XPT
CURRENCY:XAG
CURRENCY:NZD
CURRENCY:CAD
CURRENCY:AUD
CURRENCY:CHF
CURRENCY:CNY
CURRENCY:RUB
CURRENCY:DKK
CURRENCY:NOK
CURRENCY:GBP
CURRENCY:USD
CURRENCY:JPY
Continue using only the good quotes?
If I try from the consolle Finance::Quote work fine
$ gnc-fq-dump currency USD EUR
1 USD = 0.805969 EUR
$ gnc-fq-dump currency XAU EUR
1 XAU = 1085.3924262 EUR
$ gnc-fq-check
("1.47" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asia"
"asx" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "brasil" "bse"
"bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka" "dutch"
"dwsfunds" "europe" "fetch_live_currencies" "fidelity" "fidelity_direct"
"fidelityfixed" "financecanada" "finanzpartner" "finland" "fool" "france"
"ftfunds" "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney"
"greece" "hex" "hu" "hufund" "hungary" "hustock" "indiamutual"
"known_currencies" "lerevenu" "maninv" "morningstar" "morningstarjp"
"mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum" "romania" "seb_funds"
"sixfunds" "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse"
"tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp" "tsx"
"uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds" "vanguard" "vwd"
"yahoo" "yahoo_asia" "yahoo_australia" "yahoo_brasil" "yahoo_europe"
"yahoo_json" "yahoo_nz" "yahoo_yql" "za" "za_unittrusts")
I don't know if this problem afflict only me (I hope so) or if others have
the same problem.
The problem afflicts only the currency with continuity, on some stocks I
can have the problem occasionally, but generally a second download work
fine.
I retreive more of 40 stocks from 6 excange with no problem using
Alphavantage.
Does anyone have an idea from what can be determined?
Does anyone have a suggestion to give me to solve this problem?
Thanks in advance to anyone who can help me.
Best regards
Adriano
___
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: Finance-Quote 1.45 released!
Hi Erik Some example symbol for the suffix .IL https://finance.yahoo.com/quote/OGZD.IL?p=OGZD.IL https://finance.yahoo.com/quote/LKOD.IL?p=LKOD.IL https://finance.yahoo.com/quote/MNOD.IL?p=MNOD.IL https://finance.yahoo.com/quote/VTBR.IL?p=VTBR.IL Thanks again. Best regards Adriano Baldi -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
