Re: [GNC] Unable to retrieve quotes for these items:, CURRENCY:EUR

2018-11-03 Thread Christian Kluge
Am 02.11.2018 um 17:42 schrieb Wm via gnucash-user:

> 
> I am known for saying that gnc should not be used for trading as it
> isn't suitable. For starters it records a price per day, think about the
> significance of that for an intra day trader.  Duh!
> 

I don’t use GNC for trading either and since the prices are recorded for
the day only, I’d like to have an option to get the reference rate from
central banks via Finance-Quote instead of dynamic price source that can
change all the time. You can’t really get consistent results, if you
update your quotes from AlphaVantage at a slightly different time. The
reference rates are fixed once per day, no chance of getting them wrong.

Currency trading and keeping accounting records should kept separate and
not done with one price source. One’s time unit is seconds and fractions
of them the other is done in days.

So I’d really like to see the ECB reference rates[1] for the eurozone
getting added to finance-quote, which should be doable, since they give
some information on how to retrieve with a bit of scripting.
Unfortunately I’m not that fond in programming in Perl.


Kind regards

Christian Kluge

[1]
https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.en.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 quotes for these items:, CURRENCY:EUR

2018-11-02 Thread Wm via gnucash-user

On 21/10/2018 10:32, rsbrux via gnucash-user wrote:

Dear John,

Thanks for the tip!  After a bit of experimentation, it seems that the 
problem has to do with the number of currency exchange rates requested. 
If I reduce the number to five or fewer, the price update works.  I 
guess this has to do with the limitations of AlphaVantage, which I have 
seen discussed elsewhere.  Thanks again for your support!


I'm not seeing an obvious solution to this other than allowing some time 
between requests which raises other issues, like, the currency trader 
jockey pressing "get my price now" every minute. [1]


I have an odd currency pair that only works in the early hours in 
european time.  That is sort of OK for me because I know when it works 
and it is when that market is open.


I sort of feel sorry for anyone providing free prices these days.

So many tiny people wanting so much for free.

[1] I am known for saying that gnc should not be used for trading as it 
isn't suitable. For starters it records a price per day, think about the 
significance of that for an intra day trader.  Duh!


--
Wm



___
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 quotes for these items:, CURRENCY:EUR

2018-10-21 Thread rsbrux via gnucash-user

Dear John,

Thanks for the tip!  After a bit of experimentation, it seems that the 
problem has to do with the number of currency exchange rates requested.  
If I reduce the number to five or fewer, the price update works.  I 
guess this has to do with the limitations of AlphaVantage, which I have 
seen discussed elsewhere.  Thanks again for your support!


On 20.10.18 19:20, John Ralls wrote:

--log gnc.scm=debug

___
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 quotes for these items:, CURRENCY:EUR

2018-10-20 Thread John Ralls
Ah, sorry, that wasn’t obvious to me.

Try running GnuCash with ‘--log gnc.scm=debug’ instead of ‘--debug’. That 
should produce a listing of each price retrieved and its values as 
price-quotes.scm processes them and may offer a clue about the problem.

Regards,
John Ralls


> On Oct 20, 2018, at 9:26 AM, rsbrux via gnucash-user 
>  wrote:
> 
> Dear John,
> The error message was in my subject line:
>> Unable to retrieve quotes for these items:, CURRENCY:EUR
> Thanks for your support!
> 
> 
> Sent from my iPad
> 
>> On 20.10.2018, at 18:00, gnucash-user-requ...@gnucash.org wrote:
>> 
>> Send gnucash-user mailing list submissions to
>>   gnucash-user@gnucash.org
>> 
>> To subscribe or unsubscribe via the World Wide Web, visit
>>   https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> or, via email, send a message with subject or body 'help' to
>>   gnucash-user-requ...@gnucash.org
>> 
>> You can reach the person managing the list at
>>   gnucash-user-ow...@gnucash.org
>> 
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of gnucash-user digest..."
>> Today's Topics:
>> 
>>  1. Re:  Preferences for latest version (Jill Terry)
>>  2.  Unable to retrieve quotes for these items:, CURRENCY:EUR (rsbrux)
>>  3.  OFX Importer Matching: too many false positives in matching
>> with repeated transactions (Milan Kn??ek)
>>  4. Re:  Size of Windows, tabs, Fonts, etc Twice as big in 3.3 vs
>> 3.2 (John Ralls)
>>  5. Re:  Bad URL: owner=c:76e7c13664c9ad99e. . . . . . . .
>> .=c73e0385e4d13ab79. . . . . . . (John Ralls)
>>  6. Re:  Unable to retrieve quotes for these items:, CURRENCY:EUR
>> (John Ralls)
>>  7. Re:  Associate file with transaction path (Anthony Marrian)
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>> ___
>> 
>> 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.

[GNC] Unable to retrieve quotes for these items:, CURRENCY:EUR

2018-10-20 Thread rsbrux via gnucash-user
Dear John,
The error message was in my subject line:
>  Unable to retrieve quotes for these items:, CURRENCY:EUR
Thanks for your support!


Sent from my iPad

> On 20.10.2018, at 18:00, gnucash-user-requ...@gnucash.org wrote:
> 
> Send gnucash-user mailing list submissions to
>gnucash-user@gnucash.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
>gnucash-user-requ...@gnucash.org
> 
> You can reach the person managing the list at
>gnucash-user-ow...@gnucash.org
> 
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
> Today's Topics:
> 
>   1. Re:  Preferences for latest version (Jill Terry)
>   2.  Unable to retrieve quotes for these items:, CURRENCY:EUR (rsbrux)
>   3.  OFX Importer Matching: too many false positives in matching
>  with repeated transactions (Milan Kn??ek)
>   4. Re:  Size of Windows, tabs, Fonts, etc Twice as big in 3.3 vs
>  3.2 (John Ralls)
>   5. Re:  Bad URL: owner=c:76e7c13664c9ad99e. . . . . . . .
>  .=c73e0385e4d13ab79. . . . . . . (John Ralls)
>   6. Re:  Unable to retrieve quotes for these items:, CURRENCY:EUR
>  (John Ralls)
>   7. Re:  Associate file with transaction path (Anthony Marrian)
> 
> 
> 
> 
> 
> 
> 
> ___
> 
> 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 quotes for these items:, CURRENCY:EUR

2018-10-20 Thread John Ralls


> On Oct 20, 2018, at 2:20 AM, rsbrux via gnucash-user 
>  wrote:
> 
> I am using GC 2.6.19 under Ubuntu Studio 18.04 and cannot get Online Quotes 
> to work.
> 
> I have a few currencies enabled for quotation and several stocks. All of them 
> work except for EUR.  My base currency is CHF
> 
> I have successfully tested all of the currencies for which I have Online 
> Quotes enabled successfully using both gnc-fq-dump and gnc-fq-helper.
> 
> I have created a trace by:
> 
> 1. gnucash --debug
> 2. Open Price Editor
> 3. Get Quotes (error message appears)
> 4. Close Price Editor
> 5. Close GnuCash
> 
> However, I find no relevant info in the trace file.
> 
> I also repeated the above using gnucash --debug --extra, but the trace files 
> appear the same.  the --extra option produced a lot of output in the terminal 
> window, but nothing which appeared interesting or relevant.
> 
> Please advise on how to proceed.  Is anyone interested in my trace file?  
> What else can I do to troubleshoot this problem?


What’s the error message?

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.

[GNC] Unable to retrieve quotes for these items:, CURRENCY:EUR

2018-10-20 Thread rsbrux via gnucash-user
I am using GC 2.6.19 under Ubuntu Studio 18.04 and cannot get Online 
Quotes to work.


I have a few currencies enabled for quotation and several stocks. All of 
them work except for EUR.  My base currency is CHF


I have successfully tested all of the currencies for which I have Online 
Quotes enabled successfully using both gnc-fq-dump and gnc-fq-helper.


I have created a trace by:

1. gnucash --debug
2. Open Price Editor
3. Get Quotes (error message appears)
4. Close Price Editor
5. Close GnuCash

However, I find no relevant info in the trace file.

I also repeated the above using gnucash --debug --extra, but the trace 
files appear the same.  the --extra option produced a lot of output in 
the terminal window, but nothing which appeared interesting or relevant.


Please advise on how to proceed.  Is anyone interested in my trace 
file?  What else can I do to troubleshoot this problem?


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