Price Editor

[Jim Muchow]

I know that the stock quotes feature is having issues, so I decided
that since I don't have so many and I don't need any more than
Friday's prices, to try to enter stock/fund prices manually.

This doesn't seem to work either; well, it has issues. Let me explain.

I start up gnucash and then using the pulldown, bring up the Price
Editor window. The first oddity comes when I hit the Add button;
the following is displayed on the terminal window I used to start up
gnucash:

sys:1: GtkWarning: gtk_list_store_get_path: assertion 'iter->stamp ==
GTK_LIST_STORE (tree_model)->stamp' failed

Nothing "bad" happens other than this warning line, so I continue.

In the Price Editor window, I modify the various items to point to
a fund that I want to update and do so. When I use the Apply button,
the changes are taken. If I then hit the Cancel, I can escape without
crashing. This is not the case, if I hit the Apply button. A few seconds
go by and then I get a segfault and the program exits. Curiously,
the program crashes the same way if I try to edit or re-enter a price
for a date already entered (although if I Remove it first, it works).

Anyway, as long as I continue to enter a price, hit Apply, and then
Cancel. I can make this work. The gnucash app sent some debug
and crash info off to Ubuntu after one crash.

I am running Xubuntu 16.06 and Gnucash 2.6.12
___
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.

[GNC] Price editor

[Roger Lewry]

Previously I have been able to update share and fund prices manually using
Price Editor which appeared in the Tools menu. It is no longer there, but
Price Database and Security Editor are there. I tried updating to version
4.11 in the hope that this would solve the problem but it has not.

 

I am using Microsoft Windows 10 Home 21H2. Please can anyone suggest a
solution for me?

 

Roger

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: Price Editor

[Colin Law]

On 4 November 2017 at 21:12, Jim Muchow  wrote:
> I know that the stock quotes feature is having issues, so I decided
> that since I don't have so many and I don't need any more than
> Friday's prices, to try to enter stock/fund prices manually.
>
> This doesn't seem to work either; well, it has issues. Let me explain.

I always do this by first clicking on the most recent price for a fund
then clicking Add and entering the data in the box that pops up. I
have not had any of the problems you describe. That is using 2.6.15 on
Ubuntu (17.04).  By the way there is no Ubuntu 16.06.

Colin

>
> I start up gnucash and then using the pulldown, bring up the Price
> Editor window. The first oddity comes when I hit the Add button;
> the following is displayed on the terminal window I used to start up
> gnucash:
>
> sys:1: GtkWarning: gtk_list_store_get_path: assertion 'iter->stamp ==
> GTK_LIST_STORE (tree_model)->stamp' failed
>
> Nothing "bad" happens other than this warning line, so I continue.
>
> In the Price Editor window, I modify the various items to point to
> a fund that I want to update and do so. When I use the Apply button,
> the changes are taken. If I then hit the Cancel, I can escape without
> crashing. This is not the case, if I hit the Apply button. A few seconds
> go by and then I get a segfault and the program exits. Curiously,
> the program crashes the same way if I try to edit or re-enter a price
> for a date already entered (although if I Remove it first, it works).
>
> Anyway, as long as I continue to enter a price, hit Apply, and then
> Cancel. I can make this work. The gnucash app sent some debug
> and crash info off to Ubuntu after one crash.
>
> I am running Xubuntu 16.06 and Gnucash 2.6.12
> ___
> 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.
___
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.

Re: Price Editor

[Jim Muchow]

On Sat, Nov 4, 2017 at 4:39 PM, Colin Law  wrote:
> On 4 November 2017 at 21:12, Jim Muchow  wrote:
>> I know that the stock quotes feature is having issues, so I decided
>> that since I don't have so many and I don't need any more than
>> Friday's prices, to try to enter stock/fund prices manually.
>>
>> This doesn't seem to work either; well, it has issues. Let me explain.
>
> I always do this by first clicking on the most recent price for a fund
> then clicking Add and entering the data in the box that pops up.

It's still a workaround; just different than that I described. I'm fine with
workarounds, but they're just that, workarounds as opposed to operations
that behave well.

> I have not had any of the problems you describe.

Did you try them? I didn't have these problems either (or didn't know
I had them) until I tried to manually set stock/fund prices. Perhaps it's
version specific. Ubuntu tends to be somewhat behind.

> That is using 2.6.15 on
> Ubuntu (17.04).  By the way there is no Ubuntu 16.06.

OK, 16.04.03.

>
> Colin
>
>>
>> I start up gnucash and then using the pulldown, bring up the Price
>> Editor window. The first oddity comes when I hit the Add button;
>> the following is displayed on the terminal window I used to start up
>> gnucash:
>>
>> sys:1: GtkWarning: gtk_list_store_get_path: assertion 'iter->stamp ==
>> GTK_LIST_STORE (tree_model)->stamp' failed
>>
>> Nothing "bad" happens other than this warning line, so I continue.
>>
>> In the Price Editor window, I modify the various items to point to
>> a fund that I want to update and do so. When I use the Apply button,
>> the changes are taken. If I then hit the Cancel, I can escape without
>> crashing. This is not the case, if I hit the Apply button. A few seconds
>> go by and then I get a segfault and the program exits. Curiously,
>> the program crashes the same way if I try to edit or re-enter a price
>> for a date already entered (although if I Remove it first, it works).
>>
>> Anyway, as long as I continue to enter a price, hit Apply, and then
>> Cancel. I can make this work. The gnucash app sent some debug
>> and crash info off to Ubuntu after one crash.
>>
>> I am running Xubuntu 16.06 and Gnucash 2.6.12
>> ___
>> 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.
___
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.

Re: Price Editor

[Colin Law]

On 4 November 2017 at 22:10, Jim Muchow  wrote:
> On Sat, Nov 4, 2017 at 4:39 PM, Colin Law  wrote:
>> On 4 November 2017 at 21:12, Jim Muchow  wrote:
>>> I know that the stock quotes feature is having issues, so I decided
>>> that since I don't have so many and I don't need any more than
>>> Friday's prices, to try to enter stock/fund prices manually.
>>>
>>> This doesn't seem to work either; well, it has issues. Let me explain.
>>
>> I always do this by first clicking on the most recent price for a fund
>> then clicking Add and entering the data in the box that pops up.
>
> It's still a workaround; just different than that I described. I'm fine with
> workarounds, but they're just that, workarounds as opposed to operations
> that behave well.
>
>> I have not had any of the problems you describe.
>
> Did you try them?

It wasn't clear to me *exactly* what you had done so I was just saying
what I do. From my point of view it is not a workaround as that is how
I have always done it. Which is not to say that there is not a bug
there that you have found by doing it a different way.

Colin

> I didn't have these problems either (or didn't know
> I had them) until I tried to manually set stock/fund prices. Perhaps it's
> version specific. Ubuntu tends to be somewhat behind.
>
>> That is using 2.6.15 on
>> Ubuntu (17.04).  By the way there is no Ubuntu 16.06.
>
> OK, 16.04.03.
>
>>
>> Colin
>>
>>>
>>> I start up gnucash and then using the pulldown, bring up the Price
>>> Editor window. The first oddity comes when I hit the Add button;
>>> the following is displayed on the terminal window I used to start up
>>> gnucash:
>>>
>>> sys:1: GtkWarning: gtk_list_store_get_path: assertion 'iter->stamp ==
>>> GTK_LIST_STORE (tree_model)->stamp' failed
>>>
>>> Nothing "bad" happens other than this warning line, so I continue.
>>>
>>> In the Price Editor window, I modify the various items to point to
>>> a fund that I want to update and do so. When I use the Apply button,
>>> the changes are taken. If I then hit the Cancel, I can escape without
>>> crashing. This is not the case, if I hit the Apply button. A few seconds
>>> go by and then I get a segfault and the program exits. Curiously,
>>> the program crashes the same way if I try to edit or re-enter a price
>>> for a date already entered (although if I Remove it first, it works).
>>>
>>> Anyway, as long as I continue to enter a price, hit Apply, and then
>>> Cancel. I can make this work. The gnucash app sent some debug
>>> and crash info off to Ubuntu after one crash.
>>>
>>> I am running Xubuntu 16.06 and Gnucash 2.6.12
>>> ___
>>> 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.
___
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.

Re: Price Editor

[John Ralls]

> On Nov 4, 2017, at 3:10 PM, Jim Muchow  > wrote:
> 
> On Sat, Nov 4, 2017 at 4:39 PM, Colin Law  > wrote:
>> On 4 November 2017 at 21:12, Jim Muchow > > wrote:
>>> I know that the stock quotes feature is having issues, so I decided
>>> that since I don't have so many and I don't need any more than
>>> Friday's prices, to try to enter stock/fund prices manually.
>>> 
>>> This doesn't seem to work either; well, it has issues. Let me explain.
>> 
>> I always do this by first clicking on the most recent price for a fund
>> then clicking Add and entering the data in the box that pops up.
> 
> It's still a workaround; just different than that I described. I'm fine with
> workarounds, but they're just that, workarounds as opposed to operations
> that behave well.
> 
>> I have not had any of the problems you describe.
> 
> Did you try them? I didn't have these problems either (or didn't know
> I had them) until I tried to manually set stock/fund prices. Perhaps it's
> version specific. Ubuntu tends to be somewhat behind.
> 
>> That is using 2.6.15 on
>> Ubuntu (17.04).  By the way there is no Ubuntu 16.06.
> 
> OK, 16.04.03.

Crashes are bad, but reports on the list tend to get forgotten. Please file a 
bug[1] and attach the tracefile[2] from a crashed session. If you can manage a 
stack trace[3] as well they’re really helpful.

Regards,
John Ralls

[1] https://wiki.gnucash.org/wiki/Bugzilla 

[2] https://wiki.gnucash.org/wiki/Tracefile 

[3] https://wiki.gnucash.org/wiki/Stack_Trace 


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

Re: Price Editor

[Jim Muchow]

Thanks for the info, John. I will reproduce and do/send
the items requested.

On Sat, Nov 4, 2017 at 11:48 PM, John Ralls 
wrote:

>
>
> On Nov 4, 2017, at 3:10 PM, Jim Muchow  wrote:
>
> On Sat, Nov 4, 2017 at 4:39 PM, Colin Law  wrote:
>
> On 4 November 2017 at 21:12, Jim Muchow  wrote:
>
> I know that the stock quotes feature is having issues, so I decided
> that since I don't have so many and I don't need any more than
> Friday's prices, to try to enter stock/fund prices manually.
>
> This doesn't seem to work either; well, it has issues. Let me explain.
>
>
> I always do this by first clicking on the most recent price for a fund
> then clicking Add and entering the data in the box that pops up.
>
>
> It's still a workaround; just different than that I described. I'm fine
> with
> workarounds, but they're just that, workarounds as opposed to operations
> that behave well.
>
> I have not had any of the problems you describe.
>
>
> Did you try them? I didn't have these problems either (or didn't know
> I had them) until I tried to manually set stock/fund prices. Perhaps it's
> version specific. Ubuntu tends to be somewhat behind.
>
> That is using 2.6.15 on
> Ubuntu (17.04).  By the way there is no Ubuntu 16.06.
>
>
> OK, 16.04.03.
>
>
> Crashes are bad, but reports on the list tend to get forgotten. Please
> file a bug[1] and attach the tracefile[2] from a crashed session. If you
> can manage a stack trace[3] as well they’re really helpful.
>
> Regards,
> John Ralls
>
> [1] https://wiki.gnucash.org/wiki/Bugzilla
> [2] https://wiki.gnucash.org/wiki/Tracefile
> [3] https://wiki.gnucash.org/wiki/Stack_Trace
>
>
___
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.

Re: Price Editor

[Jim Muchow]

Helpfully, the Bugzilla system threw up the following when
I was setting up to create a new bug.

https://bugzilla.gnome.org/show_bug.cgi?id=766028

It's not only been seen, but also fixed. Just need to wait
for a newer version.

Thanks again, John


On Sun, Nov 5, 2017 at 6:37 AM, Jim Muchow  wrote:

> Thanks for the info, John. I will reproduce and do/send
> the items requested.
>
> On Sat, Nov 4, 2017 at 11:48 PM, John Ralls  > wrote:
>
>>
>>
>> On Nov 4, 2017, at 3:10 PM, Jim Muchow  wrote:
>>
>> On Sat, Nov 4, 2017 at 4:39 PM, Colin Law  wrote:
>>
>> On 4 November 2017 at 21:12, Jim Muchow  wrote:
>>
>> I know that the stock quotes feature is having issues, so I decided
>> that since I don't have so many and I don't need any more than
>> Friday's prices, to try to enter stock/fund prices manually.
>>
>> This doesn't seem to work either; well, it has issues. Let me explain.
>>
>>
>> I always do this by first clicking on the most recent price for a fund
>> then clicking Add and entering the data in the box that pops up.
>>
>>
>> It's still a workaround; just different than that I described. I'm fine
>> with
>> workarounds, but they're just that, workarounds as opposed to operations
>> that behave well.
>>
>> I have not had any of the problems you describe.
>>
>>
>> Did you try them? I didn't have these problems either (or didn't know
>> I had them) until I tried to manually set stock/fund prices. Perhaps it's
>> version specific. Ubuntu tends to be somewhat behind.
>>
>> That is using 2.6.15 on
>> Ubuntu (17.04).  By the way there is no Ubuntu 16.06.
>>
>>
>> OK, 16.04.03.
>>
>>
>> Crashes are bad, but reports on the list tend to get forgotten. Please
>> file a bug[1] and attach the tracefile[2] from a crashed session. If you
>> can manage a stack trace[3] as well they’re really helpful.
>>
>> Regards,
>> John Ralls
>>
>> [1] https://wiki.gnucash.org/wiki/Bugzilla
>> [2] https://wiki.gnucash.org/wiki/Tracefile
>> [3] https://wiki.gnucash.org/wiki/Stack_Trace
>>
>>
>
___
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.

Re: Price Editor

[Colin Law]

On 5 November 2017 at 15:09, Jim Muchow  wrote:
> Helpfully, the Bugzilla system threw up the following when
> I was setting up to create a new bug.
>
> https://bugzilla.gnome.org/show_bug.cgi?id=766028
>
> It's not only been seen, but also fixed. Just need to wait
> for a newer version.

You likely won't get a fix for that on Ubuntu 16.04.  If you need an
update then can get it from http://www.getdeb.net/software/gnucash.
Or you can upgrade Ubuntu of course, though if you don't like to
upgrade Ubuntu too often then probably best to wait for the next LTS
release in April.

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

Re: Price Editor

[Jim Muchow]

Thanks for the info, Colin.

On Sun, Nov 5, 2017 at 9:37 AM, Colin Law  wrote:

> On 5 November 2017 at 15:09, Jim Muchow  wrote:
> > Helpfully, the Bugzilla system threw up the following when
> > I was setting up to create a new bug.
> >
> > https://bugzilla.gnome.org/show_bug.cgi?id=766028
> >
> > It's not only been seen, but also fixed. Just need to wait
> > for a newer version.
>
> You likely won't get a fix for that on Ubuntu 16.04.  If you need an
> update then can get it from http://www.getdeb.net/software/gnucash.
> Or you can upgrade Ubuntu of course, though if you don't like to
> upgrade Ubuntu too often then probably best to wait for the next LTS
> release in April.
>
> Colin
>
___
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.

[GNC] Price Editor

[Les]

What has happened to Price Editor?  For the last 3 days, when prompted 
to obtain quotes, the app displays a timer which I end up having to 
force GC to close.  Prior to this Price Editor worked as advertised.  I 
only have quote requests for 2 currencies and 4 AMEX accounts.


Linux Mint 19.1 and GC 3.8.  Requests are via Yahoo as JSON.

Thanks,

Les


___
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] Price Editor

[Les]

I have noticed that beginning this week (09/1702018) the price database 
of my securities has been truncated and only the current week's prices 
are being displayed.


Is this a bug?

My system is unchanged (Linux Mint 18.2 and GC 2.6.17).

Thanks,

Les
___
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] Price editor

[David Carlson]

Has the name changed?  Yes, it seems to be called Price Database now, but
it is still the tool to edit, add and delete security prices.  Doesn't that
work for you?

On Sat, Aug 27, 2022 at 6:45 AM Roger Lewry  wrote:

> Previously I have been able to update share and fund prices manually using
> Price Editor which appeared in the Tools menu. It is no longer there, but
> Price Database and Security Editor are there. I tried updating to version
> 4.11 in the hope that this would solve the problem but it has not.
>
>
>
> I am using Microsoft Windows 10 Home 21H2. Please can anyone suggest a
> solution for me?
>
>
>
> Roger
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Price editor

[john]

Yes, we changed the name in 2.6.11 to make clear the difference between the 
price database window and the price editor dialog. The latter is opened with 
the Add and Edit buttons on the former.

Regards,
John Ralls


> On Aug 27, 2022, at 6:53 AM, David Carlson  
> wrote:
> 
> Has the name changed?  Yes, it seems to be called Price Database now, but
> it is still the tool to edit, add and delete security prices.  Doesn't that
> work for you?
> 
> On Sat, Aug 27, 2022 at 6:45 AM Roger Lewry  wrote:
> 
>> Previously I have been able to update share and fund prices manually using
>> Price Editor which appeared in the Tools menu. It is no longer there, but
>> Price Database and Security Editor are there. I tried updating to version
>> 4.11 in the hope that this would solve the problem but it has not.
>> 
>> 
>> 
>> I am using Microsoft Windows 10 Home 21H2. Please can anyone suggest a
>> solution for me?
>> 
>> 
>> 
>> Roger
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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.
>> 
> 
> 
> -- 
> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Price editor

[Fred Bone]

On 27 August 2022 at 10:37, john said:

> Yes, we changed the name in 2.6.11 to make clear the difference between
> the price database window and the price editor dialog. The latter is
> opened with the Add and Edit buttons on the former.

Eh? I have 2.6.21 and the Tools menu item is "Price Editor". Which brings 
up the "Price Database" window.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

Re: [GNC] Price editor

[Roger Lewry]

Thanks very much David. I am embarrassed I did not work it out for myself.

Roger
(from my phone)

On Sat, 27 Aug 2022, 14:53 David Carlson, 
wrote:

> Has the name changed?  Yes, it seems to be called Price Database now, but
> it is still the tool to edit, add and delete security prices.  Doesn't that
> work for you?
>
> On Sat, Aug 27, 2022 at 6:45 AM Roger Lewry  wrote:
>
>> Previously I have been able to update share and fund prices manually using
>> Price Editor which appeared in the Tools menu. It is no longer there, but
>> Price Database and Security Editor are there. I tried updating to version
>> 4.11 in the hope that this would solve the problem but it has not.
>>
>>
>>
>> I am using Microsoft Windows 10 Home 21H2. Please can anyone suggest a
>> solution for me?
>>
>>
>>
>> Roger
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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.
>>
>
>
> --
> David Carlson
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.

[GNC] Price Editor Problems

[DaveW]

Where, please, can I get wo-to-go instructions to get my stock Price
Editor (Re)working??

I am running Ubuntu 18.04.  GNC ver 3.5.  My stock is all on the ASX
(Australia).  Things worked wonderfully until the Yahoo demise and
then for a while I was able to use Alphvantage but that stopped too. 

I have tried all sorts of fixes randomly and fear I have completely
confused GNC in the process.

I would greatly appreciate some step by step assistance.

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

Price editor unbalances accounts

[Keith Bellairs]

The price editor makes unbalanced entries in my accounts by increasing (or
decreasing) the value of securities without the needed balancing entry to
income. In US tax terms the gain (loss) is an "unrealized" gain (loss) so
there's no need to pay tax on it, so some people might not want it show up
as income.  But I would really like it if my trial balance actually
balanced.

Has anyone looked at this "problem"?

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

Price Editor and ASX

[Peter Garcia-Webb]

HI,
ASX has a limits the number of price requests that can be made at any 
one time. As a result Gnucash Price Editor fails to update any prices if 
the number of ASX based stocks exceed nine (9).
Is there any way to limit the number of requests to update that Price 
Editor sends when I click Get quotes?
If not I shall have to set up two different account, say Me1 and Me2 and 
list different stock in each.

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

Price Editor/Database lag

[David G. Pickett]

Now that I am manually updating my stocks monthly, thanks, Yahoo, I find 
that as I pull up the price history to clone a new month end entry for 
the symbol, I get a _*long (30 second) gray out delay*_ (on Linux, and 
not the newest PC) at some point in the cycle, like a premature auto 
save or something.  This makes the process detestibly slow, 40 seconds a 
symbol!  Any suggestions?


___
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] Price Editor

[Adrien Monteleone]

Might be a Yahoo problem. AlphaAdvantage worked fine for me just now.

Check your tracefile before restarting GnuCash and/or run from the command line 
to see if you get any warnings or errors output to a terminal. See the wiki for 
more instructions if you aren’t familiar with either.

Regards,
Adrien

> On Mar 12, 2020 w11d72, at 9:29 AM, Les  wrote:
> 
> What has happened to Price Editor?  For the last 3 days, when prompted to 
> obtain quotes, the app displays a timer which I end up having to force GC to 
> close.  Prior to this Price Editor worked as advertised.  I only have quote 
> requests for 2 currencies and 4 AMEX accounts.
> 
> Linux Mint 19.1 and GC 3.8.  Requests are via Yahoo as JSON.
> 
> Thanks,
> 
> Les

___
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] Price Editor

[David Carlson]

I noticed this too on 2.6.19 in Ubuntu.  If I wait for an hour and come
back I find that it completed. I susect that Yahoo is rate limiting due to
crazy market conditions.

On Thu, Mar 12, 2020 at 10:09 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Might be a Yahoo problem. AlphaAdvantage worked fine for me just now.
>
> Check your tracefile before restarting GnuCash and/or run from the command
> line to see if you get any warnings or errors output to a terminal. See the
> wiki for more instructions if you aren’t familiar with either.
>
> Regards,
> Adrien
>
> > On Mar 12, 2020 w11d72, at 9:29 AM, Les  wrote:
> >
> > What has happened to Price Editor?  For the last 3 days, when prompted
> to obtain quotes, the app displays a timer which I end up having to force
> GC to close.  Prior to this Price Editor worked as advertised.  I only have
> quote requests for 2 currencies and 4 AMEX accounts.
> >
> > Linux Mint 19.1 and GC 3.8.  Requests are via Yahoo as JSON.
> >
> > Thanks,
> >
> > Les
>
> ___
> 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.
>


-- 
David Carlson
___
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] Price Editor

[Les]

I switched to AlphaVantage as per Adrien and all is good.

Thanks,

Les

On 3/12/20 1:52 PM, David Carlson wrote:

I noticed this too on 2.6.19 in Ubuntu.  If I wait for an hour and come
back I find that it completed. I susect that Yahoo is rate limiting due to
crazy market conditions.

On Thu, Mar 12, 2020 at 10:09 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:


Might be a Yahoo problem. AlphaAdvantage worked fine for me just now.

Check your tracefile before restarting GnuCash and/or run from the command
line to see if you get any warnings or errors output to a terminal. See the
wiki for more instructions if you aren’t familiar with either.

Regards,
Adrien


On Mar 12, 2020 w11d72, at 9:29 AM, Les  wrote:

What has happened to Price Editor?  For the last 3 days, when prompted

to obtain quotes, the app displays a timer which I end up having to force
GC to close.  Prior to this Price Editor worked as advertised.  I only have
quote requests for 2 currencies and 4 AMEX accounts.

Linux Mint 19.1 and GC 3.8.  Requests are via Yahoo as JSON.

Thanks,

Les

___
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] Price Editor

[David Carlson]

Les, that seems very strange as the price editor should be displaying all
the prices that are currently in the data file.  Are you using the regular
XML data file format or a database format?

David C

On Thu, Sep 20, 2018 at 4:20 PM Les  wrote:

> I have noticed that beginning this week (09/1702018) the price database
> of my securities has been truncated and only the current week's prices
> are being displayed.
>
> Is this a bug?
>
> My system is unchanged (Linux Mint 18.2 and GC 2.6.17).
>
> Thanks,
>
> Les
> ___
> 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] Price Editor

[Les]

Hi David:

Yes, I have always used XML. And, up untill this week, all of my quotes 
were from date of acquisition, some as old as 2010.  I cannot imagine 
why they have disappeared.


Les


On 09/20/2018 05:00 PM, David Carlson wrote:
Les, that seems very strange as the price editor should be displaying 
all the prices that are currently in the data file.  Are you using the 
regular XML data file format or a database format?


David C

On Thu, Sep 20, 2018 at 4:20 PM Les <mailto:lellio...@gmail.com>> wrote:


I have noticed that beginning this week (09/1702018) the price
database
of my securities has been truncated and only the current week's
prices
are being displayed.

Is this a bug?

My system is unchanged (Linux Mint 18.2 and GC 2.6.17).

Thanks,

Les
___
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
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] Price Editor Problems

[Eric Coates]

Hi (again!)

OK, if you had AlphaVantage working at some time you'll have an 
AlphAvantage API key.


(In GnuCash 3.5 you can confirm this by going through*Edit > Preferences 
> Online Quotes *and confirming that the key appears there)


It sounds as if you've hit the problem with AlphaVantage throttling the 
queries; the way to overcome this is to modify the file 
*AlphaVantage.pm.* I had problems finding the correct file to modify but 
I think in Ubuntu 18.04 it is 
at*/usr/local/share/perl/5.22.1/Finance/Quote*; in 19.04 it's at 
*usr/share/perl5/Finance/Quote/AlphaVantage.pm*. Or, to be more exact, 
that's where it was/is on my system; if it's not there a hint (given by 
John Ralls a while ago) is to look in the */etc/share* directory and 
look in folders called perl or perl5.


Having found the file it needs to be modified to add in a delay that 
overcomes the throttling problem. Very close to the end of the file 
there is a line


*select(undef, undef, undef, .7) if ($quantity);*

(although, to be honest, I can't swear that the final semi-colon 
appears) that needs to be modified to read


*select(undef, undef, undef, .7) if ($quantity); sleep(15);*

(the modified line does need the semi-colon).

It took me some time to gather the courage to go in and modify a 
"system" file; if you share my discomfort I can provide some guidance on 
how to do it.


Best wishes

Eric
**


On 11/05/2019 02:18, DaveW wrote:

Where, please, can I get wo-to-go instructions to get my stock Price
Editor (Re)working??

I am running Ubuntu 18.04.  GNC ver 3.5.  My stock is all on the ASX
(Australia).  Things worked wonderfully until the Yahoo demise and
then for a while I was able to use Alphvantage but that stopped too.

I have tried all sorts of fixes randomly and fear I have completely
confused GNC in the process.

I would greatly appreciate some step by step assistance.

Dave W
___
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] Price Editor Problems

[Eric Coates]

My apologies.

I am going to swear!

The message below is not the one I sent; lots of asterixes have been 
added, to get the correct message remove all of them (and if you want to 
see the original, enbolden the text they delineate)


I was trying to make the text more readable by emphasising the important 
bits - I'm going to have to rethink how that's possible.


Eric




On 11/05/2019 11:12, Eric Coates wrote:

Hi (again!)

OK, if you had AlphaVantage working at some time you'll have an 
AlphAvantage API key.


(In GnuCash 3.5 you can confirm this by going through*Edit > 
Preferences > Online Quotes *and confirming that the key appears there)


It sounds as if you've hit the problem with AlphaVantage throttling 
the queries; the way to overcome this is to modify the file 
*AlphaVantage.pm.* I had problems finding the correct file to modify 
but I think in Ubuntu 18.04 it is 
at*/usr/local/share/perl/5.22.1/Finance/Quote*; in 19.04 it's at 
*usr/share/perl5/Finance/Quote/AlphaVantage.pm*. Or, to be more exact, 
that's where it was/is on my system; if it's not there a hint (given 
by John Ralls a while ago) is to look in the */etc/share* directory 
and look in folders called perl or perl5.


Having found the file it needs to be modified to add in a delay that 
overcomes the throttling problem. Very close to the end of the file 
there is a line


*select(undef, undef, undef, .7) if ($quantity);*

(although, to be honest, I can't swear that the final semi-colon 
appears) that needs to be modified to read


*select(undef, undef, undef, .7) if ($quantity); sleep(15);*

(the modified line does need the semi-colon).

It took me some time to gather the courage to go in and modify a 
"system" file; if you share my discomfort I can provide some guidance 
on how to do it.


Best wishes

Eric
**


On 11/05/2019 02:18, DaveW wrote:

Where, please, can I get wo-to-go instructions to get my stock Price
Editor (Re)working??

I am running Ubuntu 18.04.  GNC ver 3.5.  My stock is all on the ASX
(Australia).  Things worked wonderfully until the Yahoo demise and
then for a while I was able to use Alphvantage but that stopped too.

I have tried all sorts of fixes randomly and fear I have completely
confused GNC in the process.

I would greatly appreciate some step by step assistance.

Dave W
___
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] Price Editor Problems

[Geert Janssens]

It looks like you have sent an html formatted mail and that got converted to 
plain text somewhere. In plain text mails asterisks are typically the 
replacement of the bold markup. So the text between two asterisks is 
considered boldface.

Regards,

Geert

Op zaterdag 11 mei 2019 12:20:11 CEST schreef Eric Coates:
> My apologies.
> 
> I am going to swear!
> 
> The message below is not the one I sent; lots of asterixes have been
> added, to get the correct message remove all of them (and if you want to
> see the original, enbolden the text they delineate)
> 
> I was trying to make the text more readable by emphasising the important
> bits - I'm going to have to rethink how that's possible.
> 
> Eric
> 
> 
> 
> On 11/05/2019 11:12, Eric Coates wrote:
> > Hi (again!)
> > 
> > OK, if you had AlphaVantage working at some time you'll have an
> > AlphAvantage API key.
> > 
> > (In GnuCash 3.5 you can confirm this by going through*Edit >
> > Preferences > Online Quotes *and confirming that the key appears there)
> > 
> > It sounds as if you've hit the problem with AlphaVantage throttling
> > the queries; the way to overcome this is to modify the file
> > *AlphaVantage.pm.* I had problems finding the correct file to modify
> > but I think in Ubuntu 18.04 it is
> > at*/usr/local/share/perl/5.22.1/Finance/Quote*; in 19.04 it's at
> > *usr/share/perl5/Finance/Quote/AlphaVantage.pm*. Or, to be more exact,
> > that's where it was/is on my system; if it's not there a hint (given
> > by John Ralls a while ago) is to look in the */etc/share* directory
> > and look in folders called perl or perl5.
> > 
> > Having found the file it needs to be modified to add in a delay that
> > overcomes the throttling problem. Very close to the end of the file
> > there is a line
> > 
> > *select(undef, undef, undef, .7) if ($quantity);*
> > 
> > (although, to be honest, I can't swear that the final semi-colon
> > appears) that needs to be modified to read
> > 
> > *select(undef, undef, undef, .7) if ($quantity); sleep(15);*
> > 
> > (the modified line does need the semi-colon).
> > 
> > It took me some time to gather the courage to go in and modify a
> > "system" file; if you share my discomfort I can provide some guidance
> > on how to do it.
> > 
> > Best wishes
> > 
> > Eric
> > **
> > 
> > On 11/05/2019 02:18, DaveW wrote:
> >> Where, please, can I get wo-to-go instructions to get my stock Price
> >> Editor (Re)working??
> >> 
> >> I am running Ubuntu 18.04.  GNC ver 3.5.  My stock is all on the ASX
> >> (Australia).  Things worked wonderfully until the Yahoo demise and
> >> then for a while I was able to use Alphvantage but that stopped too.
> >> 
> >> I have tried all sorts of fixes randomly and fear I have completely
> >> confused GNC in the process.
> >> 
> >> I would greatly appreciate some step by step assistance.
> >> 
> >> Dave W
> >> ___
> >> 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.




___
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] Price Editor Problems

[Eric Coates]

Gert

Thank you for the tip. I have (I think!) found the "offending" setting. 
I have unset it.


I think it's possibly something to do with the mailing list - sending a 
message with *bold* and /italic/ text to another of my email addresses 
shows no problems.




Everybody

Please forgive the small experiment.

Best wishes

Eric

===

On 11/05/2019 18:11, Geert Janssens wrote:

It looks like you have sent an html formatted mail and that got converted to
plain text somewhere. In plain text mails asterisks are typically the
replacement of the bold markup. So the text between two asterisks is
considered boldface.

Regards,

Geert

___
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] Price Editor Problems

[DaveW]

Thank you Eric,

I modified the AlphaVantge.pm file as you suggested.  That it was a
read-only file I had quite a lot of problems saving the modification.
For want of a better solution I resorted to use Master Commander, (sudo
mc), simply because I don't know how to open a file as Root.  What is a
better method???

Yes I confirrmed I have an API key.

But . . . when setting up the Securities, in the "Get online quotes
section, I run into trouble again.  My securities are all on the
Australian Stock Exchange (ASX).  The only AlphaVantage selection
available is AlphaVantage US. I now don't know quite how to set up the
Get Online Quotes section.  I have tried a few of the many
combinations of selections to no avail.

Can you help me further please.  What other information should I
provide?

Dave W





On Sat, 11 May 2019 11:20:11 +0100
Eric Coates  wrote:

> My apologies.
> 
> I am going to swear!
> 
> The message below is not the one I sent; lots of asterixes have been 
> added, to get the correct message remove all of them (and if you want
> to see the original, enbolden the text they delineate)
> 
> I was trying to make the text more readable by emphasising the
> important bits - I'm going to have to rethink how that's possible.
> 
> Eric
> 
> 
> 
> 
> On 11/05/2019 11:12, Eric Coates wrote:
> > Hi (again!)
> >
> > OK, if you had AlphaVantage working at some time you'll have an 
> > AlphAvantage API key.
> >
> > (In GnuCash 3.5 you can confirm this by going through*Edit > 
> > Preferences > Online Quotes *and confirming that the key appears
> > there)
> >
> > It sounds as if you've hit the problem with AlphaVantage throttling 
> > the queries; the way to overcome this is to modify the file 
> > *AlphaVantage.pm.* I had problems finding the correct file to
> > modify but I think in Ubuntu 18.04 it is 
> > at*/usr/local/share/perl/5.22.1/Finance/Quote*; in 19.04 it's at 
> > *usr/share/perl5/Finance/Quote/AlphaVantage.pm*. Or, to be more
> > exact, that's where it was/is on my system; if it's not there a
> > hint (given by John Ralls a while ago) is to look in the
> > */etc/share* directory and look in folders called perl or perl5.
> >
> > Having found the file it needs to be modified to add in a delay
> > that overcomes the throttling problem. Very close to the end of the
> > file there is a line
> >
> > *select(undef, undef, undef, .7) if ($quantity);*
> >
> > (although, to be honest, I can't swear that the final semi-colon 
> > appears) that needs to be modified to read
> >
> > *select(undef, undef, undef, .7) if ($quantity); sleep(15);*
> >
> > (the modified line does need the semi-colon).
> >
> > It took me some time to gather the courage to go in and modify a 
> > "system" file; if you share my discomfort I can provide some
> > guidance on how to do it.
> >
> > Best wishes
> >
> > Eric
> > **
> >
> >
> > On 11/05/2019 02:18, DaveW wrote:  
> >> Where, please, can I get wo-to-go instructions to get my stock
> >> Price Editor (Re)working??
> >>
> >> I am running Ubuntu 18.04.  GNC ver 3.5.  My stock is all on the
> >> ASX (Australia).  Things worked wonderfully until the Yahoo demise
> >> and then for a while I was able to use Alphvantage but that
> >> stopped too.
> >>
> >> I have tried all sorts of fixes randomly and fear I have completely
> >> confused GNC in the process.
> >>
> >> I would greatly appreciate some step by step assistance.
> >>
> >> Dave W
> >> ___
> >> 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

Re: [GNC] Price Editor Problems

[Eric Coates]

Dave

My comments are in-line:

On 14/05/2019 09:07, DaveW wrote:


I modified the AlphaVantge.pm file as you suggested.  That it was a
read-only file I had quite a lot of problems saving the modification.
For want of a better solution I resorted to use Master Commander, (sudo
mc), simply because I don't know how to open a file as Root.  What is a
better method???


The way I edit "system" files is:
(1) Find the file I want to edit. I find that the Terminal command
   locate / AlphaVantage.pm   (or whatever the file name is) is far 
more useful than the find file button in the graphical interface
(2) Using the graphical interface open the directory that contains the 
file (slightly counter-intuitive but hang on!)

(3) Right click in a blank area of the display and select
   Open In Terminal
(4) Optional (but a good idea!) check you're in the right place by 
giving the command   ls   and confirm that Alphavantage.pm appears in 
the output
(5) Give the command   sudo nano AlphaVantage.pm   nano is a generally 
available, simple(ish) text editor.

(6) Make the necessary changes.
(7) Write out the modified file using   CTRL+O   (it'll ask whether you 
want to overwrite the file, just click ENTER)

(8) Exit nano by keyingCTRL+X
(9) Close the Terminal
(10) Job done - well for me it was!
Whether it's better than Master Commander I don't know having never used 
the latter (or ever even hearing of it!), I suppose that's a matter of 
personal choice.



Yes I confirrmed I have an API key.


That's good - without you ain't going nowhere! (A colloquial expression 
which means exactly the opposite of what it says - but, at least, it 
does allow me to use the word "colloquial"))



But . . . when setting up the Securities, in the "Get online quotes
section, I run into trouble again.  My securities are all on the
Australian Stock Exchange (ASX).  The only AlphaVantage selection
available is AlphaVantage US. I now don't know quite how to set up the
Get Online Quotes section.  I have tried a few of the many
combinations of selections to no avail.


It appears that what was AlphaVantage in the "Unknown" section of the 
Edit Security window has been renamed as AlphaVantage, US in the 
"Single" section (I don't know why). For me - and my UK shares - 
choosing AlphaVantage, US gave me all the information I needed (I don't 
know why - some things I just accept). Try it, it may work for ASX 
shares as well - we can but hope.



Can you help me further please.  What other information should I
provide?


Hopefully, that's sufficient for you

Best wishes

Eric
=

On Sat, 11 May 2019 11:20:11 +0100
Eric Coates  wrote:


My apologies.

I am going to swear!

The message below is not the one I sent; lots of asterixes have been
added, to get the correct message remove all of them (and if you want
to see the original, enbolden the text they delineate)

I was trying to make the text more readable by emphasising the
important bits - I'm going to have to rethink how that's possible.

Eric




On 11/05/2019 11:12, Eric Coates wrote:

Hi (again!)

OK, if you had AlphaVantage working at some time you'll have an
AlphAvantage API key.

(In GnuCash 3.5 you can confirm this by going through*Edit >
Preferences > Online Quotes *and confirming that the key appears
there)

It sounds as if you've hit the problem with AlphaVantage throttling
the queries; the way to overcome this is to modify the file
*AlphaVantage.pm.* I had problems finding the correct file to
modify but I think in Ubuntu 18.04 it is
at*/usr/local/share/perl/5.22.1/Finance/Quote*; in 19.04 it's at
*usr/share/perl5/Finance/Quote/AlphaVantage.pm*. Or, to be more
exact, that's where it was/is on my system; if it's not there a
hint (given by John Ralls a while ago) is to look in the
*/etc/share* directory and look in folders called perl or perl5.

Having found the file it needs to be modified to add in a delay
that overcomes the throttling problem. Very close to the end of the
file there is a line

*select(undef, undef, undef, .7) if ($quantity);*

(although, to be honest, I can't swear that the final semi-colon
appears) that needs to be modified to read

*select(undef, undef, undef, .7) if ($quantity); sleep(15);*

(the modified line does need the semi-colon).

It took me some time to gather the courage to go in and modify a
"system" file; if you share my discomfort I can provide some
guidance on how to do it.

Best wishes

Eric
**


On 11/05/2019 02:18, DaveW wrote:

Where, please, can I get wo-to-go instructions to get my stock
Price Editor (Re)working??

I am running Ubuntu 18.04.  GNC ver 3.5.  My stock is all on the
ASX (Australia).  Things worked wonderfully until the Yahoo demise
and then for a while I was able to use Alphvantage but that
stopped too.

I

Re: Price editor unbalances accounts

[John Ralls]

> On Sep 4, 2017, at 7:43 PM, Keith Bellairs  wrote:
> 
> The price editor makes unbalanced entries in my accounts by increasing (or
> decreasing) the value of securities without the needed balancing entry to
> income. In US tax terms the gain (loss) is an "unrealized" gain (loss) so
> there's no need to pay tax on it, so some people might not want it show up
> as income.  But I would really like it if my trial balance actually
> balanced.
> 
> Has anyone looked at this "problem"?

No, the Price Editor doesn’t do anything at all to your accounts. The Accounts 
page shows the value of your securities according to the latest prices in the 
price database, but if you look at the account registers you’ll see that 
there’s no transaction that reflects price changes.

When you run reports you can select what price to apply to assets. “Nearest in 
time” will generally cause the report to show “book value” with no unrealized 
gains or losses; “Most Recent” will price assets at the most recent price found 
in the price database. The other two, “Average Cost” and “Weighted Average” use 
averages of the prices actually paid for the non-default-currency assets but 
average all purchases in different ways.

If you actually want to book unrealized gains (and unless a certified/chartered 
accountant tells you that you do, you don’t) you must create the transactions 
yourself.

Regards,
John Ralls

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

Re: Price editor unbalances accounts

[Keith Bellairs]

Been a gnucash user for years and never understood what Most Recent meant.
BS w/ most recent shows my accounts to be almost in balance.

Thanks,

Keith



On Tue, Sep 5, 2017 at 12:04 AM, John Ralls  wrote:

>
>
> > On Sep 4, 2017, at 7:43 PM, Keith Bellairs  wrote:
> >
> > The price editor makes unbalanced entries in my accounts by increasing
> (or
> > decreasing) the value of securities without the needed balancing entry to
> > income. In US tax terms the gain (loss) is an "unrealized" gain (loss) so
> > there's no need to pay tax on it, so some people might not want it show
> up
> > as income.  But I would really like it if my trial balance actually
> > balanced.
> >
> > Has anyone looked at this "problem"?
>
> No, the Price Editor doesn’t do anything at all to your accounts. The
> Accounts page shows the value of your securities according to the latest
> prices in the price database, but if you look at the account registers
> you’ll see that there’s no transaction that reflects price changes.
>
> When you run reports you can select what price to apply to assets.
> “Nearest in time” will generally cause the report to show “book value” with
> no unrealized gains or losses; “Most Recent” will price assets at the most
> recent price found in the price database. The other two, “Average Cost” and
> “Weighted Average” use averages of the prices actually paid for the
> non-default-currency assets but average all purchases in different ways.
>
> If you actually want to book unrealized gains (and unless a
> certified/chartered accountant tells you that you do, you don’t) you must
> create the transactions yourself.
>
> Regards,
> John Ralls
>
>
___
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.

Fwd: Price Editor and ASX

[John Ralls]

Erik,

I think handling this in F::Q would be cleaner than trying to do it in GnuCash. 
Do you agree?

Regards,
John Ralls


> Begin forwarded message:
> 
> From: "Peter Garcia-Webb" 
> Subject: Price Editor and ASX
> Date: December 4, 2017 at 6:09:29 PM PST
> To: gnucash-user@gnucash.org
> 
> HI,
> ASX has a limits the number of price requests that can be made at any one 
> time. As a result Gnucash Price Editor fails to update any prices if the 
> number of ASX based stocks exceed nine (9).
> Is there any way to limit the number of requests to update that Price Editor 
> sends when I click Get quotes?
> If not I shall have to set up two different account, say Me1 and Me2 and list 
> different stock in each.
> Thanks
> ___
> 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.

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

Re: Price Editor and ASX

[Chris Good]

Message: 3
Date: Tue, 05 Dec 2017 10:09:29 +0800
From: "Peter Garcia-Webb" 
To: gnucash-user@gnucash.org
Subject: Price Editor and ASX
Message-ID: <391dd3e4-cbad-4c23-bf21-7f83a9cda...@iinet.net.au>
Content-Type: text/plain; format=flowed; markup=markdown

HI,
ASX has a limits the number of price requests that can be made at any 
one time. As a result Gnucash Price Editor fails to update any prices if 
the number of ASX based stocks exceed nine (9).
Is there any way to limit the number of requests to update that Price 
Editor sends when I click Get quotes?
If not I shall have to set up two different account, say Me1 and Me2 and 
list different stock in each.
Thanks

> Message: 4
> Date: Mon, 4 Dec 2017 19:54:11 -0800
> From: John Ralls 
> To: Erik Colson 
> Cc: Gnucash Users 
> Subject: Fwd: Price Editor and ASX
> Message-ID: <567bbcc7-28f4-47ed-adc6-19714d9ec...@ceridwen.us>
> Content-Type: text/plain;charset=us-ascii
> 
> Erik,
> 
> I think handling this in F::Q would be cleaner than trying to do it in 
> GnuCash. Do you agree?
> 
> Regards,
> John Ralls

Hi Peter & John,

Finance::Quote for ASX already does a separate web request for each stock code 
because I couldn't figure out how to do multiples when I implemented using the 
new m.asx.com.au url. The ASX web server is very intermittent. Sometimes it 
works, sometimes it doesn't. It does seem to fail more often when a large no of 
stock prices is requested at once. Strangely, they all seem to work or all 
fail...
I haven't been able to get it working reliably yet, but I haven't had much time 
to spend working on it.

I did try using yahoo_json with codes like CBA.AX but that also is unreliable.

Regards, Chris Good

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

Price Editor - currency exchange rates

[i . smajli]

Hello
Problem:
After changing to Alphavantage the exchange rate retrieved by F::Q between 
the Default Currency (in my case MYR) and USD is 55.21, which is 
approximately 13.7 times the actual exchange rate. The same applies to 
other currencies i.e. the exchange rate is in all cases approximately 13.7 
times of the actual exchange rate.
When I change my Default Currency to EUR the exchange rate to other 
currencies is retrieved correctly.
Any suggestions what I can do ?
Cheers 
Ismael


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

Re: Price Editor/Database lag

[farleykj]

You don't necessarily have to update manually. The original Yahoo source has
been ruined, but you can (and I do) use "yahoo_json" as a source. It's
worked fine for me.
As for your actual question, I'm sorry but I've no idea. I'm running on Mac
OSX. People might have some inquiries about the particulars of your setup,
like are you using the XML interface, or SQL? If the latter, maybe there's
something odd going on with the database server? Is your database
particularly large?



-
Ken Farley
--
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: Price Editor/Database lag

[DGPickett via gnucash-user]

Since I was collecting prices daily, I guess my price database is pretty
large, and my family finances are in there for about 5 years.  I have xml
database, and compressed, but I checked my save intervals, even increased
them, but no help.  My PC has 8 GB ram, and a very large solid state swap
drive, so anyy database should stay in memory.



--
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: Price Editor/Database lag

[John Ralls]

> On Apr 1, 2018, at 5:51 AM, DGPickett via gnucash-user 
>  wrote:
> 
> Since I was collecting prices daily, I guess my price database is pretty
> large, and my family finances are in there for about 5 years.  I have xml
> database, and compressed, but I checked my save intervals, even increased
> them, but no help.  My PC has 8 GB ram, and a very large solid state swap
> drive, so anyy database should stay in memory.

GnuCash isn’t yet a database application, so all of the data is always in 
memory regardless of the backend. If the delay you experience is in opening the 
price db dialog then it’s probably due to loading the dialog’s tree model from 
the price db.

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: Price Editor/Database lag

[John Ralls]

Please remember to copy the list on all replies.

The data file is read exactly once, when it's loaded. After that everything is 
stored in GnuCash objects. That's what "all of the data is always in memory" 
means. We store data as either XML or in a SQL database, so mmap() won't do 
anything for us.

The likely problem is that the Price Editor is based on a GtkTreeView, and its 
model needs to be loaded every time you open the Price Editor. We could indeed 
get a pretty big performance enhancement by hiding the Price Editor on close 
instead of destroying it.

Yes, the price db could be kept apart from book data, but it isn't. That would 
be a pretty big design change, and I think better left until we're ready to 
change to query-as-needed database use as that will bring about a lot of 
incompatible storage changes.

Regards,
John Ralls

> On Apr 1, 2018, at 8:40 AM, David  wrote:
> 
> That is an OK excuse for one delay, not delay after delay not in sync with 
> any part of the edit process.
> 
> It is a bug if it reloads the database, rather than keeping an in memory and 
> in file model that can be updated, and an in file model that only gets 
> updated at save time.  Also, it should mmap64() the file, so it is cached in 
> RAM, not read from scratch.  An unsorted flat file pretending to be a 
> database would outperform this.
> 
> The price history might be kept outside the books files, as it is a cache of 
> public data, and can be shared with all if they use the same key symbols, 
> updated once for all sets of books!
> 
> 
> 
> -Original Message-
> From: John Ralls 
> To: DGPickett 
> Cc: gnucash-user 
> Sent: Sun, Apr 1, 2018 9:39 am
> Subject: Re: Price Editor/Database lag
> 
> 
> 
> > On Apr 1, 2018, at 5:51 AM, DGPickett via gnucash-user 
> >  wrote:
> > 
> > Since I was collecting prices daily, I guess my price database is pretty
> > large, and my family finances are in there for about 5 years. I have xml
> > database, and compressed, but I checked my save intervals, even increased
> > them, but no help. My PC has 8 GB ram, and a very large solid state swap
> > drive, so anyy database should stay in memory.
> 
> GnuCash isn’t yet a database application, so all of the data is always in 
> memory regardless of the backend. If the delay you experience is in opening 
> the price db dialog then it’s probably due to loading the dialog’s tree model 
> from the price db.
> 
> 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: Price Editor/Database lag

[David via gnucash-user]

John,

OK, that makes sense, except the lag can occur pretty randomly as I select 
lists of symbols, select symbols from that list, ask for an add window, or work 
in the add window with date, price.  (I select the most recent month end nav so 
it is cloned with the add, just needs a new date and price.)  Maybe it is going 
into thrashing?


 Thanks,

David

 

 

-Original Message-
From: John Ralls 
To: David 
Cc: Gnucash Users 
Sent: Sun, Apr 1, 2018 3:48 pm
Subject: Re: Price Editor/Database lag

Please remember to copy the list on all replies.

The data file is read exactly once, when it's loaded. After that everything is 
stored in GnuCash objects. That's what "all of the data is always in memory" 
means. We store data as either XML or in a SQL database, so mmap() won't do 
anything for us.

The likely problem is that the Price Editor is based on a GtkTreeView, and its 
model needs to be loaded every time you open the Price Editor. We could indeed 
get a pretty big performance enhancement by hiding the Price Editor on close 
instead of destroying it.

Yes, the price db could be kept apart from book data, but it isn't. That would 
be a pretty big design change, and I think better left until we're ready to 
change to query-as-needed database use as that will bring about a lot of 
incompatible storage changes.

Regards,
John Ralls

> On Apr 1, 2018, at 8:40 AM, David  wrote:
> 
> That is an OK excuse for one delay, not delay after delay not in sync with 
> any part of the edit process.
> 
> It is a bug if it reloads the database, rather than keeping an in memory and 
> in file model that can be updated, and an in file model that only gets 
> updated at save time.  Also, it should mmap64() the file, so it is cached in 
> RAM, not read from scratch.  An unsorted flat file pretending to be a 
> database would outperform this.
> 
> The price history might be kept outside the books files, as it is a cache of 
> public data, and can be shared with all if they use the same key symbols, 
> updated once for all sets of books!
> 
> 
> 
> -Original Message-
> From: John Ralls 
> To: DGPickett 
> Cc: gnucash-user 
> Sent: Sun, Apr 1, 2018 9:39 am
> Subject: Re: Price Editor/Database lag
> 
> 
> 
> > On Apr 1, 2018, at 5:51 AM, DGPickett via gnucash-user 
> >  wrote:
> > 
> > Since I was collecting prices daily, I guess my price database is pretty
> > large, and my family finances are in there for about 5 years. I have xml
> > database, and compressed, but I checked my save intervals, even increased
> > them, but no help. My PC has 8 GB ram, and a very large solid state swap
> > drive, so anyy database should stay in memory.
> 
> GnuCash isn’t yet a database application, so all of the data is always in 
> memory regardless of the backend. If the delay you experience is in opening 
> the price db dialog then it’s probably due to loading the dialog’s tree model 
> from the price db.
> 
> 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: Price Editor/Database lag

[John Ralls]

Entirely possible. I’m not too familiar with the GtkTreeList implementation.

Regards,
John Ralls


> On Apr 1, 2018, at 6:59 PM, David  wrote:
> 
> John,
> 
> OK, that makes sense, except the lag can occur pretty randomly as I select 
> lists of symbols, select symbols from that list, ask for an add window, or 
> work in the add window with date, price.  (I select the most recent month end 
> nav so it is cloned with the add, just needs a new date and price.)  Maybe it 
> is going into thrashing?
> 
> Thanks,
> 
> David
> 
> 
> -Original Message-
> From: John Ralls 
> To: David 
> Cc: Gnucash Users 
> Sent: Sun, Apr 1, 2018 3:48 pm
> Subject: Re: Price Editor/Database lag
> 
> Please remember to copy the list on all replies.
> 
> The data file is read exactly once, when it's loaded. After that everything 
> is stored in GnuCash objects. That's what "all of the data is always in 
> memory" means. We store data as either XML or in a SQL database, so mmap() 
> won't do anything for us.
> 
> The likely problem is that the Price Editor is based on a GtkTreeView, and 
> its model needs to be loaded every time you open the Price Editor. We could 
> indeed get a pretty big performance enhancement by hiding the Price Editor on 
> close instead of destroying it.
> 
> Yes, the price db could be kept apart from book data, but it isn't. That 
> would be a pretty big design change, and I think better left until we're 
> ready to change to query-as-needed database use as that will bring about a 
> lot of incompatible storage changes.
> 
> Regards,
> John Ralls
> 
> > On Apr 1, 2018, at 8:40 AM, David  > <mailto:dgpick...@aol.com>> wrote:
> > 
> > That is an OK excuse for one delay, not delay after delay not in sync with 
> > any part of the edit process.
> > 
> > It is a bug if it reloads the database, rather than keeping an in memory 
> > and in file model that can be updated, and an in file model that only gets 
> > updated at save time. Also, it should mmap64() the file, so it is cached in 
> > RAM, not read from scratch. An unsorted flat file pretending to be a 
> > database would outperform this.
> > 
> > The price history might be kept outside the books files, as it is a cache 
> > of public data, and can be shared with all if they use the same key 
> > symbols, updated once for all sets of books!
> > 
> > 
> > 
> > -Original Message-
> > From: John Ralls mailto:jra...@ceridwen.us>>
> > To: DGPickett mailto:dgpick...@aol.com>>
> > Cc: gnucash-user mailto:u...@gnucash.org>>
> > Sent: Sun, Apr 1, 2018 9:39 am
> > Subject: Re: Price Editor/Database lag
> > 
> > 
> > 
> > > On Apr 1, 2018, at 5:51 AM, DGPickett via gnucash-user 
> > > mailto:u...@gnucash.org>> wrote:
> > > 
> > > Since I was collecting prices daily, I guess my price database is pretty
> > > large, and my family finances are in there for about 5 years. I have xml
> > > database, and compressed, but I checked my save intervals, even increased
> > > them, but no help. My PC has 8 GB ram, and a very large solid state swap
> > > drive, so anyy database should stay in memory.
> > 
> > GnuCash isn’t yet a database application, so all of the data is always in 
> > memory regardless of the backend. If the delay you experience is in opening 
> > the price db dialog then it’s probably due to loading the dialog’s tree 
> > model from the price db.
> > 
> > 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: Price Editor/Database lag

[David Carlson]

There could be other artifacts in the system such as network lags that may
also come into play.

David C

On Sun, Apr 1, 2018, 10:12 PM John Ralls  wrote:

> Entirely possible. I’m not too familiar with the GtkTreeList
> implementation.
>
> Regards,
> John Ralls
>
>
> > On Apr 1, 2018, at 6:59 PM, David  wrote:
> >
> > John,
> >
> > OK, that makes sense, except the lag can occur pretty randomly as I
> select lists of symbols, select symbols from that list, ask for an add
> window, or work in the add window with date, price.  (I select the most
> recent month end nav so it is cloned with the add, just needs a new date
> and price.)  Maybe it is going into thrashing?
> >
> > Thanks,
> >
> > David
> >
> >
> > -Original Message-
> > From: John Ralls 
> > To: David 
> > Cc: Gnucash Users 
> > Sent: Sun, Apr 1, 2018 3:48 pm
> > Subject: Re: Price Editor/Database lag
> >
> > Please remember to copy the list on all replies.
> >
> > The data file is read exactly once, when it's loaded. After that
> everything is stored in GnuCash objects. That's what "all of the data is
> always in memory" means. We store data as either XML or in a SQL database,
> so mmap() won't do anything for us.
> >
> > The likely problem is that the Price Editor is based on a GtkTreeView,
> and its model needs to be loaded every time you open the Price Editor. We
> could indeed get a pretty big performance enhancement by hiding the Price
> Editor on close instead of destroying it.
> >
> > Yes, the price db could be kept apart from book data, but it isn't. That
> would be a pretty big design change, and I think better left until we're
> ready to change to query-as-needed database use as that will bring about a
> lot of incompatible storage changes.
> >
> > Regards,
> > John Ralls
> >
> > > On Apr 1, 2018, at 8:40 AM, David  dgpick...@aol.com>> wrote:
> > >
> > > That is an OK excuse for one delay, not delay after delay not in sync
> with any part of the edit process.
> > >
> > > It is a bug if it reloads the database, rather than keeping an in
> memory and in file model that can be updated, and an in file model that
> only gets updated at save time. Also, it should mmap64() the file, so it is
> cached in RAM, not read from scratch. An unsorted flat file pretending to
> be a database would outperform this.
> > >
> > > The price history might be kept outside the books files, as it is a
> cache of public data, and can be shared with all if they use the same key
> symbols, updated once for all sets of books!
> > >
> > >
> > >
> > > -Original Message-
> > > From: John Ralls mailto:jra...@ceridwen.us>>
> > > To: DGPickett mailto:dgpick...@aol.com>>
> > > Cc: gnucash-user mailto:u...@gnucash.org>>
> > > Sent: Sun, Apr 1, 2018 9:39 am
> > > Subject: Re: Price Editor/Database lag
> > >
> > >
> > >
> > > > On Apr 1, 2018, at 5:51 AM, DGPickett via gnucash-user <
> gnucash-user@gnucash.org <mailto:u...@gnucash.org>> wrote:
> > > >
> > > > Since I was collecting prices daily, I guess my price database is
> pretty
> > > > large, and my family finances are in there for about 5 years. I have
> xml
> > > > database, and compressed, but I checked my save intervals, even
> increased
> > > > them, but no help. My PC has 8 GB ram, and a very large solid state
> swap
> > > > drive, so anyy database should stay in memory.
> > >
> > > GnuCash isn’t yet a database application, so all of the data is always
> in memory regardless of the backend. If the delay you experience is in
> opening the price db dialog then it’s probably due to loading the dialog’s
> tree model from the price db.
> > >
> > > 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: Price Editor/Database lag

[John Ralls]

Other artifacts, certainly, but it would be an unusual computer that puts a 
network between its RAM and CPU.

Regards,
John Ralls


> On Apr 1, 2018, at 8:57 PM, David Carlson  wrote:
> 
> There could be other artifacts in the system such as network lags that may 
> also come into play.
> 
> David C 
> 
> On Sun, Apr 1, 2018, 10:12 PM John Ralls  <mailto:jra...@ceridwen.us>> wrote:
> Entirely possible. I’m not too familiar with the GtkTreeList implementation.
> 
> Regards,
> John Ralls
> 
> 
> > On Apr 1, 2018, at 6:59 PM, David  > <mailto:dgpick...@aol.com>> wrote:
> >
> > John,
> >
> > OK, that makes sense, except the lag can occur pretty randomly as I select 
> > lists of symbols, select symbols from that list, ask for an add window, or 
> > work in the add window with date, price.  (I select the most recent month 
> > end nav so it is cloned with the add, just needs a new date and price.)  
> > Maybe it is going into thrashing?
> >
> > Thanks,
> >
> > David
> >
> >
> > -Original Message-
> > From: John Ralls mailto:jra...@ceridwen.us>>
> > To: David mailto:dgpick...@aol.com>>
> > Cc: Gnucash Users  > <mailto:gnucash-user@gnucash.org>>
> > Sent: Sun, Apr 1, 2018 3:48 pm
> > Subject: Re: Price Editor/Database lag
> >
> > Please remember to copy the list on all replies.
> >
> > The data file is read exactly once, when it's loaded. After that everything 
> > is stored in GnuCash objects. That's what "all of the data is always in 
> > memory" means. We store data as either XML or in a SQL database, so mmap() 
> > won't do anything for us.
> >
> > The likely problem is that the Price Editor is based on a GtkTreeView, and 
> > its model needs to be loaded every time you open the Price Editor. We could 
> > indeed get a pretty big performance enhancement by hiding the Price Editor 
> > on close instead of destroying it.
> >
> > Yes, the price db could be kept apart from book data, but it isn't. That 
> > would be a pretty big design change, and I think better left until we're 
> > ready to change to query-as-needed database use as that will bring about a 
> > lot of incompatible storage changes.
> >
> > Regards,
> > John Ralls
> >
> > > On Apr 1, 2018, at 8:40 AM, David  > > <mailto:dgpick...@aol.com> <mailto:dgpick...@aol.com 
> > > <mailto:dgpick...@aol.com>>> wrote:
> > >
> > > That is an OK excuse for one delay, not delay after delay not in sync 
> > > with any part of the edit process.
> > >
> > > It is a bug if it reloads the database, rather than keeping an in memory 
> > > and in file model that can be updated, and an in file model that only 
> > > gets updated at save time. Also, it should mmap64() the file, so it is 
> > > cached in RAM, not read from scratch. An unsorted flat file pretending to 
> > > be a database would outperform this.
> > >
> > > The price history might be kept outside the books files, as it is a cache 
> > > of public data, and can be shared with all if they use the same key 
> > > symbols, updated once for all sets of books!
> > >
> > >
> > >
> > > -Original Message-
> > > From: John Ralls mailto:jra...@ceridwen.us> 
> > > <mailto:jra...@ceridwen.us <mailto:jra...@ceridwen.us>>>
> > > To: DGPickett mailto:dgpick...@aol.com> 
> > > <mailto:dgpick...@aol.com <mailto:dgpick...@aol.com>>>
> > > Cc: gnucash-user  > > <mailto:gnucash-user@gnucash.org> <mailto:u...@gnucash.org 
> > > <mailto:u...@gnucash.org>>>
> > > Sent: Sun, Apr 1, 2018 9:39 am
> > > Subject: Re: Price Editor/Database lag
> > >
> > >
> > >
> > > > On Apr 1, 2018, at 5:51 AM, DGPickett via gnucash-user 
> > > > mailto:gnucash-user@gnucash.org> 
> > > > <mailto:u...@gnucash.org <mailto:u...@gnucash.org>>> wrote:
> > > >
> > > > Since I was collecting prices daily, I guess my price database is pretty
> > > > large, and my family finances are in there for about 5 years. I have xml
> > > > database, and compressed, but I checked my save intervals, even 
> > > > increased
> > > > them, but no help. My PC has 8 GB ram, and a very large solid state swap
> > > > drive, so anyy database should stay in memory.
> > >
> > > GnuCash isn

Re: Price Editor/Database lag

[David via gnucash-user]

I just discovered my swap was all turned off.  It might also explain very un-VM 
messages like "Your computer does not have enough free memory to automatically 
analyze the problem and send a report to the developers."  Now I have a huge, 
dedicated drive SSD swap (which one article said was a bad idea, but maybe any 
churn wear will be more distributed on a huge (150G) swap).  Let me see if that 
helps!

Of course, I am also moving my price source to Yahoo_JSON.

 

 

 

-Original Message-
From: John Ralls 
To: David 
Cc: gnucash-user 
Sent: Sun, Apr 1, 2018 11:09 pm
Subject: Re: Price Editor/Database lag


Entirely possible. I’m not too familiar with the GtkTreeList implementation.


Regards,
John Ralls




On Apr 1, 2018, at 6:59 PM, David  wrote:


John,

OK, that makes sense, except the lag can occur pretty randomly as I select 
lists of symbols, select symbols from that list, ask for an add window, or work 
in the add window with date, price.  (I select the most recent month end nav so 
it is cloned with the add, just needs a new date and price.)  Maybe it is going 
into thrashing?


 Thanks,

David

 

 

-Original Message-
From: John Ralls 
To: David 
Cc: Gnucash Users 
Sent: Sun, Apr 1, 2018 3:48 pm
Subject: Re: Price Editor/Database lag

Please remember to copy the list on all replies.

The data file is read exactly once, when it's loaded. After that everything is 
stored in GnuCash objects. That's what "all of the data is always in memory" 
means. We store data as either XML or in a SQL database, so mmap() won't do 
anything for us.

The likely problem is that the Price Editor is based on a GtkTreeView, and its 
model needs to be loaded every time you open the Price Editor. We could indeed 
get a pretty big performance enhancement by hiding the Price Editor on close 
instead of destroying it.

Yes, the price db could be kept apart from book data, but it isn't. That would 
be a pretty big design change, and I think better left until we're ready to 
change to query-as-needed database use as that will bring about a lot of 
incompatible storage changes.

Regards,
John Ralls

> On Apr 1, 2018, at 8:40 AM, David  wrote:
> 
> That is an OK excuse for one delay, not delay after delay not in sync with 
> any part of the edit process.
> 
> It is a bug if it reloads the database, rather than keeping an in memory and 
> in file model that can be updated, and an in file model that only gets 
> updated at save time.  Also, it should mmap64() the file, so it is cached in 
> RAM, not read from scratch.  An unsorted flat file pretending to be a 
> database would outperform this.
> 
> The price history might be kept outside the books files, as it is a cache of 
> public data, and can be shared with all if they use the same key symbols, 
> updated once for all sets of books!
> 
> 
> 
> -Original Message-
> From: John Ralls 
> To: DGPickett 
> Cc: gnucash-user 
> Sent: Sun, Apr 1, 2018 9:39 am
> Subject: Re: Price Editor/Database lag
> 
> 
> 
> > On Apr 1, 2018, at 5:51 AM, DGPickett via gnucash-user 
> >  wrote:
> > 
> > Since I was collecting prices daily, I guess my price database is pretty
> > large, and my family finances are in there for about 5 years. I have xml
> > database, and compressed, but I checked my save intervals, even increased
> > them, but no help. My PC has 8 GB ram, and a very large solid state swap
> > drive, so anyy database should stay in memory.
> 
> GnuCash isn’t yet a database application, so all of the data is always in 
> memory regardless of the backend. If the delay you experience is in opening 
> the price db dialog then it’s probably due to loading the dialog’s tree model 
> from the price db.
> 
> 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: Price Editor/Database lag

[David via gnucash-user]

 PS: No, swap does not prevent this.

I did notice that it struck just once during the first symbol, and then not 
again until I did a null update, so maybe it trashes the in-memory object after 
every mod., and reinstates it from scratch.  But for that, I would expect the 
delay to be more synchronous in the cycle of actions.

 
An object that lived in a mmap'd file could be updated in place at RAM speeds, 
is potentially visible to many processes, yet even if the app crashes, is saved 
by the dirty page writer.  I have noticed that mmap() is one of the most 
neglected aspects of C/C++/JAVA/??? -- direct access to VM with memory objects 
visible to multiple processes by mmap() or file calls, access to all free RAM 
as your cache.

 

-Original Message-
From: David 
To: jralls 
Cc: gnucash-user 
Sent: Mon, Apr 2, 2018 11:30 am
Subject: Re: Price Editor/Database lag


I just discovered my swap was all turned off.  It might also explain very un-VM 
messages like "Your computer does not have enough free memory to automatically 
analyze the problem and send a report to the developers."  Now I have a huge, 
dedicated drive SSD swap (which one article said was a bad idea, but maybe any 
churn wear will be more distributed on a huge (150G) swap).  Let me see if that 
helps!

Of course, I am also moving my price source to Yahoo_JSON.

 

 

 

-Original Message-
From: John Ralls 
To: David 
Cc: gnucash-user 
Sent: Sun, Apr 1, 2018 11:09 pm
Subject: Re: Price Editor/Database lag


Entirely possible. I’m not too familiar with the GtkTreeList implementation.


Regards,
John Ralls




On Apr 1, 2018, at 6:59 PM, David  wrote:


John,

OK, that makes sense, except the lag can occur pretty randomly as I select 
lists of symbols, select symbols from that list, ask for an add window, or work 
in the add window with date, price.  (I select the most recent month end nav so 
it is cloned with the add, just needs a new date and price.)  Maybe it is going 
into thrashing?


 Thanks,

David

 

 

-Original Message-
From: John Ralls 
To: David 
Cc: Gnucash Users 
Sent: Sun, Apr 1, 2018 3:48 pm
Subject: Re: Price Editor/Database lag

Please remember to copy the list on all replies.

The data file is read exactly once, when it's loaded. After that everything is 
stored in GnuCash objects. That's what "all of the data is always in memory" 
means. We store data as either XML or in a SQL database, so mmap() won't do 
anything for us.

The likely problem is that the Price Editor is based on a GtkTreeView, and its 
model needs to be loaded every time you open the Price Editor. We could indeed 
get a pretty big performance enhancement by hiding the Price Editor on close 
instead of destroying it.

Yes, the price db could be kept apart from book data, but it isn't. That would 
be a pretty big design change, and I think better left until we're ready to 
change to query-as-needed database use as that will bring about a lot of 
incompatible storage changes.

Regards,
John Ralls

> On Apr 1, 2018, at 8:40 AM, David  wrote:
> 
> That is an OK excuse for one delay, not delay after delay not in sync with 
> any part of the edit process.
> 
> It is a bug if it reloads the database, rather than keeping an in memory and 
> in file model that can be updated, and an in file model that only gets 
> updated at save time.  Also, it should mmap64() the file, so it is cached in 
> RAM, not read from scratch.  An unsorted flat file pretending to be a 
> database would outperform this.
> 
> The price history might be kept outside the books files, as it is a cache of 
> public data, and can be shared with all if they use the same key symbols, 
> updated once for all sets of books!
> 
> 
> 
> -Original Message-
> From: John Ralls 
> To: DGPickett 
> Cc: gnucash-user 
> Sent: Sun, Apr 1, 2018 9:39 am
> Subject: Re: Price Editor/Database lag
> 
> 
> 
> > On Apr 1, 2018, at 5:51 AM, DGPickett via gnucash-user 
> >  wrote:
> > 
> > Since I was collecting prices daily, I guess my price database is pretty
> > large, and my family finances are in there for about 5 years. I have xml
> > database, and compressed, but I checked my save intervals, even increased
> > them, but no help. My PC has 8 GB ram, and a very large solid state swap
> > drive, so anyy database should stay in memory.
> 
> GnuCash isn’t yet a database application, so all of the data is always in 
> memory regardless of the backend. If the delay you experience is in opening 
> the price db dialog then it’s probably due to loading the dialog’s tree model 
> from the price db.
> 
> Regards,
> John Ralls
> 








___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscrib

Re: Price Editor/Database lag

[DGPickett via gnucash-user]

I started vmstat -tw 11 in a wide xterm and I do see a lot of swap out for
some but not all delays.  The not-first delays seem to be smaller now.  The
first delay did 3K+ so, later ones did 2K+, 300+ or almost no so.  Almost no
so may indicate the container is not dealing well with the volume and
requests it gets, even when it has all the ram it desires.  Is the tree
keyed on category, symbol, date reverse like the display?

*First:*

$ vmstat -tw 11
procs ---memory-- ---swap--
-io -system-- cpu -timestamp-
 r  b swpd free buffcache   si   sobi   
bo   in   cs  us  sy  id  wa  st EDT
 5  0  2690184   14634026604   7888046   16   109  
123  117   16  70   9  20   1   0 2018-04-03 12:17:40
 6  1  2687992   12718426896   793168  2270   641  
164 2051 5894  88  12   0   0   0 2018-04-03 12:17:51
 5  2  2688552   28853226828   778192  173  151   694 
2167 2089 7312  78  18   3   0   0 2018-04-03 12:18:02
 5  0  2688400   26131627028   781584   260   329  
143 1798 6898  68  30   2   0   0 2018-04-03 12:18:13
 3  0  2685660   25796428028   791768  2140   486 
1114 2294 7585  48  33  16   2   0 2018-04-03 12:18:24
 2  0  2685636   24595228076   79159610 7  
139 2496 7604  30  37  32   1   0 2018-04-03 12:18:35
 1  0  2685272   23749628280   791948   32049  
267 3459 8448  31  22  46   1   0 2018-04-03 12:18:46
 0  0  2685244   17517628980   79343630   179  
134 3407 8631  44  13  42   2   0 2018-04-03 12:18:57
 0  0  2685204   21988429200   7931605019  
230 3655 8706  32  13  54   1   0 2018-04-03 12:19:08
 2  0  2685056   19353629260   812132   140  1700  
118 2710 8191  61  10  27   2   0 2018-04-03 12:19:19
 3  0  2685040   17945229312   81221620 2  
124 1875 8148  81   9  10   0   0 2018-04-03 12:19:30
 1  0  2722160   30416422520   721880   20 339531 
3555 2212 7960  78  10  11   0   0 2018-04-03 12:19:41
^C
*
Later:*

$ vmstat -tw 11
procs ---memory-- ---swap--
-io -system-- cpu -timestamp-
 r  b swpd free buffcache   si   sobi   
bo   in   cs  us  sy  id  wa  st EDT
 3  0  2721700   26362423340   7356886   16   109  
123  119   20  70   9  20   1   0 2018-04-03 12:20:23
 2  0  2721676   25974023392   73556420 3   
86 2907 8945  57  11  32   0   0 2018-04-03 12:20:34
 0  0  2721640   25654823476   7358483011  
185 3634 8735  37  13  49   1   0 2018-04-03 12:20:45
 1  0  2721616   25082023540   73583620 2  
253 3601 8358  30  12  57   1   0 2018-04-03 12:20:56
 6  0  2721604   25031623596   73573210 1  
140 2443 8143  70  10  20   0   0 2018-04-03 12:21:07
 6  0  2720948   24504423672   735940   66067  
128 1901 7925  80   9  11   0   0 2018-04-03 12:21:18
 1  0  2720932   23954823736   7366682059  
139 2719 8306  56  11  33   1   0 2018-04-03 12:21:29
 2  0  2744192   30570023672   6870841 2115 2 
2266 2686 8077  64  12  23   0   0 2018-04-03 12:21:40
 2  0  2744148   29758423760   68742850 7  
120 1975 8049  75  10  15   0   0 2018-04-03 12:21:51
 5  0  2744060   26157223852   689276   280   183  
111 3459 8838  36  17  45   2   0 2018-04-03 12:22:02
 5  0  2744048   28747223900   68919210 9  
306 3690 8710  32  13  54   1   0 2018-04-03 12:22:13
 1  0  2744008   28328823968   68931630 4  
220 2173 8488  65  12  23   1   0 2018-04-03 12:22:24
 3  0  2744004   27920424028   68926800 1  
110 1773 8291  74  10  16   0   0 2018-04-03 12:22:35
 3  0  2743988   27651224112   68901610 1  
216 2224 8250  68   9  23   1   0 2018-04-03 12:22:46
 5  1  2743188   26456424160   689260   980   115  
120 2628 8056  66   9  25   0   0 2018-04-03 12:22:57
 3  0  2743156   27505224208   68942820 2  
124 3673 8813  46  12  41   1   0 2018-04-03 12:23:08
 2  0  2743128   27145624284   68940420 2  
195 2569 8044  67  10  22   1   0 2018-04-03 12:23:19
 2  0  2743080   26514024336   68938870 8  
149 1651 8070  76   9  15   0   0 2018-04-03 12:23:30
 0  0  2743036   26003224388   68919240 4  
121 2802 8166  51 

Re: Price Editor/Database lag

[DGPickett via gnucash-user]

I discovered my vm.swappiness=60, dropped it to 10 as recommended for desktop
LINUX.  Now no si/so on vmstat, but a peak in cs and a moderate delay,
around 20 seconds, when adding price quotes.

Again, it looks like it is using too big a RAM space to manage this data, or
some similar process inefficiency.  I would think a properly keyed tree
container would be good, allowing you to look up a symbol and then pull the
tree in key order from that point.  Perhaps it force-saves after every
modification?



--
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: Price Editor/Database lag

[DGPickett via gnucash-user]

PS: Sometimes, trees of trees/containers outperform having everything in one
tree/container.  If the quotes for each symbol are in a separate container,
the RAM hit to query or churn data for that symbol is minimized.  If the
data is kept sorted in all storage forms (when inserted into the container,
when converted to XML), then you really do not need a tree; a simpler list
would do.  Just a thought.

I set my swappiness down to 5.  However, I am now getting daily quotes using
yahoo JSON, so the churn is in the background at midnight.



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

[GNC] Problem With Price Editor

[Les]

Previously I posted a problem where I had created a new stock entry but 
it never got populated in Price Editor although it is in Security Editor 
and in my list of stocks.


Since I have not received any suggestions, I attempted to "fix" this 
myself but removing the account from my list of stocks and from Security 
Editor.  I was able to remove it from my list of stocks, but when I 
attempted to remove it from Security Editor, I was prevented from doing so.


So, I am appealing to the list for assistance with this issue. Any 
suggestions greatly appreciated.


Les

___
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] More Price Editor questions

[Keith Bellairs]

Since the price upload was failing I tried manually updating security
prices and found that the editor is unbelievably slow. Could be that the
price server is just timing out waiting for the editor. (I have many years
worth of price data and its acting like its doing a bubble sort on all the
prices every time it is touched.) While the price editor is churning gnc is
completely non responsive.

I am in Ubuntu 16.04 LTS and the gnucash packaged with it is 2.6.17 built
2017-07-04.

Is there a later build available? And has any work been done on the price
editor? I think that's the only thing I am having trouble with, but it
would be worth an upgrade.

Keith
___
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] Price editor uses old entry

[Rainer Dorsch via gnucash-user]

Hi,

I noticed that if the price editor has an entry in EUR and an entry in USD, it 
used the EUR entry, even if the USD entry has a newer date. My account 
currency is EUR.

Is that intended and is there an option to change this behavior?

I usually get the EUR entry, if I buy or sell stock or funds, which are 
accounted in USD.

Thanks
Rainer

-- 
Rainer Dorsch
http://bokomoko.de/


___
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: GnuCash: Price Editor -- Linux Mint

[Bill Swanson]

How do I update the Price Editor to use the Financial::Quote?

GnuCash  Version: 2.6.12

I used the:
perl -MCPAN -e shell
install Finance::Quote

Got version 1.47

How do I get this to show up in the drop down in the Security Editor? (
*Alphavantage)*

https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F

The OS is LinuxMint 17.1

-- 
Bill Swanson
207-2443946
___
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.

Re: GnuCash: Price Editor -- Linux Mint

[Dave H]

Assuming you've setup everything as per the wiki link in your email it
shows up under the "Unknown" quote source.

Cheers Dave H.

On 14 December 2017 at 09:52, Bill Swanson  wrote:

> How do I update the Price Editor to use the Financial::Quote?
>
> GnuCash  Version: 2.6.12
>
> I used the:
> perl -MCPAN -e shell
> install Finance::Quote
>
> Got version 1.47
>
> How do I get this to show up in the drop down in the Security Editor? (
> *Alphavantage)*
>
> https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F
>
> The OS is LinuxMint 17.1
>
> --
> Bill Swanson
> 207-2443946
> ___
> 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.
>
___
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.

Re: Price Editor - currency exchange rates

[David Carlson]

Ismael,

It seems that I failed to see your question until now, and perhaps most
others did not see it either or someone would have responded.

Alas, I do not know what happened in your case, but hopefully someone else
will know.  I do suspect, however, that it may be a bug in the
Finance-Quote module and if others concur, you will need to take it up with
the developer of that module.

David C

On Wed, Dec 27, 2017 at 3:09 AM,  wrote:

> Hello
> Problem:
> After changing to Alphavantage the exchange rate retrieved by F::Q between
> the Default Currency (in my case MYR) and USD is 55.21, which is
> approximately 13.7 times the actual exchange rate. The same applies to
> other currencies i.e. the exchange rate is in all cases approximately 13.7
> times of the actual exchange rate.
> When I change my Default Currency to EUR the exchange rate to other
> currencies is retrieved correctly.
> Any suggestions what I can do ?
> Cheers
> Ismael
>
>
> ___
> 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.
>
___
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.

Re: [GNC] Problem With Price Editor

[David Carlson]

Les,

It is important that you clearly define your problem when you ask for help
in this maillist.

I see that you have been trying things out with GnuCash for some time now,
but when I sampled your comments I did not find a consistent pattern of
mentioning the OS, or GnuCash version when asking about a problem.  I think
that you are using release 2.6.21 installed by a procedure called Snap,
which I know nothing about, into some version of Linux.  If you are now
trying to use release 3.2, there is a completely different set of possible
issues.

Further, I am confused about whether you completed the entire process of
creating a security in the security list (which is not an account, by the
way) with a proper ticker reference and security type as well as creating a
security account associated with a brokerage account and entering an
initial buy or sell transaction.  While the part of creating a security
account and recording a purchase or sale is optional, it (a)helps to have a
way to see the security in your data and (b)creates an initial price entry
in the price database.

I also saw that you were having issues with setting up AlphaVantage
earlier. Did you resolve those, or is that a part of the problem you are
now having with the price editor?

Several of us are willing to help, but we need more specific details.

David C

On Fri, Jun 22, 2018 at 5:31 AM, Les  wrote:

> Previously I posted a problem where I had created a new stock entry but it
> never got populated in Price Editor although it is in Security Editor and
> in my list of stocks.
>
> Since I have not received any suggestions, I attempted to "fix" this
> myself but removing the account from my list of stocks and from Security
> Editor.  I was able to remove it from my list of stocks, but when I
> attempted to remove it from Security Editor, I was prevented from doing so.
>
> So, I am appealing to the list for assistance with this issue. Any
> suggestions greatly appreciated.
>
> Les
>
> ___
> 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] Problem With Price Editor

[Les]

Ok, sorry.  I am running Linux Mint 18.2 with GC 2.6.21.  I am still 
having problems with AlphaVantage but manage to get downloads a couple 
of time per week.


For the record, I have been using GC since 2008.

I setup the new stock by click new account, entered the name of the 
stock and selected stock from the list and selected CAD for currency.  
This took me to the Security Editor where I reentered the stock name and 
its ticker symbol.  I checked get stock quotes and selected AlphaVantage 
for the source.


I then went back to the stock in my investments folder and entered the 
date acquired, the number of shares and the price, then the amount of 
the charge for the purchase, and then selected the brokerage account. 
Clicked save.


Les


On 06/22/2018 07:35 AM, David Carlson wrote:

Les,

It is important that you clearly define your problem when you ask for 
help in this maillist.


I see that you have been trying things out with GnuCash for some time 
now, but when I sampled your comments I did not find a consistent 
pattern of mentioning the OS, or GnuCash version when asking about a 
problem.  I think that you are using release 2.6.21 installed by a 
procedure called Snap, which I know nothing about, into some version 
of Linux.  If you are now trying to use release 3.2, there is a 
completely different set of possible issues.


Further, I am confused about whether you completed the entire process 
of creating a security in the security list (which is not an account, 
by the way) with a proper ticker reference and security type as well 
as creating a security account associated with a brokerage account and 
entering an initial buy or sell transaction.  While the part of 
creating a security account and recording a purchase or sale is 
optional, it (a)helps to have a way to see the security in your data 
and (b)creates an initial price entry in the price database.


I also saw that you were having issues with setting up AlphaVantage 
earlier. Did you resolve those, or is that a part of the problem you 
are now having with the price editor?


Several of us are willing to help, but we need more specific details.

David C

On Fri, Jun 22, 2018 at 5:31 AM, Les <mailto:lellio...@gmail.com>> wrote:


Previously I posted a problem where I had created a new stock
entry but it never got populated in Price Editor although it is in
Security Editor and in my list of stocks.

Since I have not received any suggestions, I attempted to "fix"
this myself but removing the account from my list of stocks and
from Security Editor.  I was able to remove it from my list of
stocks, but when I attempted to remove it from Security Editor, I
was prevented from doing so.

So, I am appealing to the list for assistance with this issue. Any
suggestions greatly appreciated.

Les

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

Re: [GNC] Problem With Price Editor

[C M Reinehr]

Les,

Actually, you did receive an answer to your question, from John Ralls, 
only a few hours after your post:



On Jun 21, 2018, at 2:51 AM, Les  wrote:

Yesterday, I created a new stock account, like all of the other stock accounts 
that I have.  The strange thing is while the stock is listed in my Security 
Editor, it is NOT listed in Price Editor.  How is this possible?

How can I fix this problem?


Get or create a price for the new security.

Regards,
John Ralls


CMR


On 06/22/2018 05:31 AM, Les wrote:
Previously I posted a problem where I had created a new stock entry 
but it never got populated in Price Editor although it is in Security 
Editor and in my list of stocks.


Since I have not received any suggestions, I attempted to "fix" this 
myself but removing the account from my list of stocks and from 
Security Editor.  I was able to remove it from my list of stocks, but 
when I attempted to remove it from Security Editor, I was prevented 
from doing so.


So, I am appealing to the list for assistance with this issue. Any 
suggestions greatly appreciated.


Les

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


--
Linux distribution Debian 9 "Stretch"

"Owning a handgun doesn't make you armed any more than owning a guitar
makes you a musician." ~ Jeff Cooper
--

___
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] Problem With Price Editor

[Les]

I have searched my emails and cannot find John Ralls' reply.  I can only 
see it via your adding it inline to your reply.  For what its worth, I 
am using Thunderbird and when I post something, it ends up in my Sent 
folder and I do not see it in the GC folder.


Les
On 06/22/2018 10:02 AM, C M Reinehr wrote:

Les,

Actually, you did receive an answer to your question, from John Ralls, 
only a few hours after your post:



On Jun 21, 2018, at 2:51 AM, Les  wrote:

Yesterday, I created a new stock account, like all of the other 
stock accounts that I have.  The strange thing is while the stock is 
listed in my Security Editor, it is NOT listed in Price Editor.  How 
is this possible?


How can I fix this problem?


Get or create a price for the new security.

Regards,
John Ralls


CMR


On 06/22/2018 05:31 AM, Les wrote:
Previously I posted a problem where I had created a new stock entry 
but it never got populated in Price Editor although it is in Security 
Editor and in my list of stocks.


Since I have not received any suggestions, I attempted to "fix" this 
myself but removing the account from my list of stocks and from 
Security Editor.  I was able to remove it from my list of stocks, but 
when I attempted to remove it from Security Editor, I was prevented 
from doing so.


So, I am appealing to the list for assistance with this issue. Any 
suggestions greatly appreciated.


Les

___
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] Problem With Price Editor

[David Carlson]

First, did you previously succeed in setting up any securities or is this
your first? Have you separately set up a brokerage account to contain your
securities?
I am puzzled by the sequence that you described.
You stated that you went through the process of setting up a security
account  but then you assigned a currency to that account which should be
impossible because it is a security account.

Then you stopped before you got to the part where you would go back to the
price editor and look under the namespace where you assigned the security
to see (or not) the security symbol that was in the securities list.  Have
you previously set up other securities?

David C


On Fri, Jun 22, 2018 at 11:01 AM, Les  wrote:

> I have searched my emails and cannot find John Ralls' reply.  I can only
> see it via your adding it inline to your reply.  For what its worth, I am
> using Thunderbird and when I post something, it ends up in my Sent folder
> and I do not see it in the GC folder.
>
> Les
>
> On 06/22/2018 10:02 AM, C M Reinehr wrote:
>
>> Les,
>>
>> Actually, you did receive an answer to your question, from John Ralls,
>> only a few hours after your post:
>>
>> On Jun 21, 2018, at 2:51 AM, Les  wrote:
>>>>
>>>> Yesterday, I created a new stock account, like all of the other stock
>>>> accounts that I have.  The strange thing is while the stock is listed in my
>>>> Security Editor, it is NOT listed in Price Editor.  How is this possible?
>>>>
>>>> How can I fix this problem?
>>>>
>>>> Get or create a price for the new security.
>>>
>>> Regards,
>>> John Ralls
>>>
>>> CMR
>>
>>
>> On 06/22/2018 05:31 AM, Les wrote:
>>
>>> Previously I posted a problem where I had created a new stock entry but
>>> it never got populated in Price Editor although it is in Security Editor
>>> and in my list of stocks.
>>>
>>> Since I have not received any suggestions, I attempted to "fix" this
>>> myself but removing the account from my list of stocks and from Security
>>> Editor.  I was able to remove it from my list of stocks, but when I
>>> attempted to remove it from Security Editor, I was prevented from doing so.
>>>
>>> So, I am appealing to the list for assistance with this issue. Any
>>> suggestions greatly appreciated.
>>>
>>> Les
>>>
>>> ___
>>> 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] Problem With Price Editor

[Les]

I have set up a large number of stocks, so it is not my first by any 
means.  As a matter of fact, I setup another stock prior to this one 
without any issues.  Same procedure.  I have several brokage accounts 
and stocks in several countries, including Canada, Singapore, Hong Kong, 
Australia, previously other countries. Each country has its own 
currency, so the stock in question is in Canada, so I assigned CAD for 
its currency.


Les


On 06/22/2018 12:23 PM, David Carlson wrote:
First, did you previously succeed in setting up any securities or is 
this your first? Have you separately set up a brokerage account to 
contain your securities?

I am puzzled by the sequence that you described.
You stated that you went through the process of setting up a security 
account  but then you assigned a currency to that account which should 
be impossible because it is a security account.


Then you stopped before you got to the part where you would go back to 
the price editor and look under the namespace where you assigned the 
security to see (or not) the security symbol that was in the 
securities list.  Have you previously set up other securities?


David C


On Fri, Jun 22, 2018 at 11:01 AM, Les <mailto:lellio...@gmail.com>> wrote:


I have searched my emails and cannot find John Ralls' reply.  I
can only see it via your adding it inline to your reply.  For what
its worth, I am using Thunderbird and when I post something, it
ends up in my Sent folder and I do not see it in the GC folder.

Les

On 06/22/2018 10:02 AM, C M Reinehr wrote:

Les,

Actually, you did receive an answer to your question, from
John Ralls, only a few hours after your post:

On Jun 21, 2018, at 2:51 AM, Lesmailto:lellio...@gmail.com>> wrote:

Yesterday, I created a new stock account, like all of
the other stock accounts that I have.  The strange
thing is while the stock is listed in my Security
Editor, it is NOT listed in Price Editor.  How is this
possible?

How can I fix this problem?

Get or create a price for the new security.

Regards,
John Ralls

CMR


On 06/22/2018 05:31 AM, Les wrote:

Previously I posted a problem where I had created a new
stock entry but it never got populated in Price Editor
although it is in Security Editor and in my list of stocks.

Since I have not received any suggestions, I attempted to
"fix" this myself but removing the account from my list of
stocks and from Security Editor.  I was able to remove it
from my list of stocks, but when I attempted to remove it
from Security Editor, I was prevented from doing so.

So, I am appealing to the list for assistance with this
issue. Any suggestions greatly appreciated.

Les

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

Re: [GNC] More Price Editor questions

[David Carlson]

Keith,

I think that you have the latest version that is pre-packaged for Ubuntu
16.04. I am running the same version.

There are later versions for Windows and Mac but they are not likely any
better at downloading stock prices through AlphaVantage and they have other
open bugs that make them unsuitable for some users.  See the release notes
for version 3.2  Version 3.3 is scheduled for September 30.

There are instructions for rolling your own Linux version of release 3.2
but there has been an ongoing discussion about various details in doing
that which you should review before taking the plunge to try that.

That is my opinion.

David C

On Sun, Aug 5, 2018 at 1:09 PM, Keith Bellairs  wrote:

> Since the price upload was failing I tried manually updating security
> prices and found that the editor is unbelievably slow. Could be that the
> price server is just timing out waiting for the editor. (I have many years
> worth of price data and its acting like its doing a bubble sort on all the
> prices every time it is touched.) While the price editor is churning gnc is
> completely non responsive.
>
> I am in Ubuntu 16.04 LTS and the gnucash packaged with it is 2.6.17 built
> 2017-07-04.
>
> Is there a later build available? And has any work been done on the price
> editor? I think that's the only thing I am having trouble with, but it
> would be worth an upgrade.
>
> Keith
> ___
> 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] Price editor uses old entry

[john]

> On Nov 5, 2021, at 4:22 AM, Rainer Dorsch via gnucash-user 
>  wrote:
> 
> Hi,
> 
> I noticed that if the price editor has an entry in EUR and an entry in USD, 
> it 
> used the EUR entry, even if the USD entry has a newer date. My account 
> currency is EUR.
> 
> Is that intended and is there an option to change this behavior?
> 
> I usually get the EUR entry, if I buy or sell stock or funds, which are 
> accounted in USD.

GnuCash always prefers a direct conversion over an indirect one regardless of 
the date. It's not optional. I suppose the problem arises because you're 
trading USD-priced stocks from an EUR-denominated brokerage account and the 
trades create the EUR prices. The simplest work around is to remove those EUR 
prices from the pricedb; it won't affect the transaction or reports using the 
average-cost price source. To avoid the problem going forward create an 
intermediary USD bank account in your brokerage account hierarchy and when 
recording the trade make separate splits for USD<->EUR and stock<->USD. Chris 
Lam is working on a stock trading assistant to make this a bit less cumbersome; 
we hope it will be finished in time for GnuCash 5.

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] Price editor uses old entry

[Rainer Dorsch via gnucash-user]

Am Freitag, 5. November 2021, 16:39:28 CET schrieben Sie:
> > On Nov 5, 2021, at 4:22 AM, Rainer Dorsch via gnucash-user
> >  wrote:
> > 
> > Hi,
> > 
> > I noticed that if the price editor has an entry in EUR and an entry in
> > USD, it used the EUR entry, even if the USD entry has a newer date. My
> > account currency is EUR.
> > 
> > Is that intended and is there an option to change this behavior?
> > 
> > I usually get the EUR entry, if I buy or sell stock or funds, which are
> > accounted in USD.
> 
> GnuCash always prefers a direct conversion over an indirect one regardless
> of the date. It's not optional. I suppose the problem arises because you're
> trading USD-priced stocks from an EUR-denominated brokerage account and the
> trades create the EUR prices. The simplest work around is to remove those
> EUR prices from the pricedb; it won't affect the transaction or reports
> using the average-cost price source. To avoid the problem going forward
> create an intermediary USD bank account in your brokerage account hierarchy
> and when recording the trade make separate splits for USD<->EUR and
> stock<->USD. Chris Lam is working on a stock trading assistant to make this
> a bit less cumbersome; we hope it will be finished in time for GnuCash 5.
> 

Thanks John for your quick reply.

The scenario you describe matches well my use case.

Yes, I manually delete the EUR entries in the pricedb

I am looking forward to the stock trading assistant.

Can you tell why GnuCash always prefers a direct conversion over an indirect 
one regardless of the date? Is this a bug or a feature :-) ?

Thanks
Rainer

-- 
Rainer Dorsch
http://bokomoko.de/


___
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] Price editor uses old entry

[Frank H. Ellenberger]

Hi,

Am 05.11.21 um 21:48 schrieb Rainer Dorsch via gnucash-user:
> Can you tell why GnuCash always prefers a direct conversion over an indirect 
> one regardless of the date? Is this a bug or a feature :-) ?

you will end in very complex scenarios of the graph theory:
multiple pathes with different costs.

Regards
Frank
___
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] Price editor uses old entry

[David Carlson]

Perhaps something was lost in translation.   When a transaction has an
embedded price Gnucash assumes that it is a purchase or sale and the price
is exact for that trade.   Quotes are generally assumed to be estimates,
therefore somewhat soft like newspaper quotes.

On Fri, Nov 5, 2021, 5:57 PM Frank H. Ellenberger <
frank.h.ellenber...@gmail.com> wrote:

> Hi,
>
> Am 05.11.21 um 21:48 schrieb Rainer Dorsch via gnucash-user:
> > Can you tell why GnuCash always prefers a direct conversion over an
> indirect
> > one regardless of the date? Is this a bug or a feature :-) ?
>
> you will end in very complex scenarios of the graph theory:
> multiple pathes with different costs.
>
> Regards
> Frank
> ___
> 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] Price editor uses old entry

[john]

> On Nov 5, 2021, at 1:48 PM, Rainer Dorsch  wrote:
> 
> Am Freitag, 5. November 2021, 16:39:28 CET schrieben Sie:
>>> On Nov 5, 2021, at 4:22 AM, Rainer Dorsch via gnucash-user
>>>  wrote:
>>> 
>>> Hi,
>>> 
>>> I noticed that if the price editor has an entry in EUR and an entry in
>>> USD, it used the EUR entry, even if the USD entry has a newer date. My
>>> account currency is EUR.
>>> 
>>> Is that intended and is there an option to change this behavior?
>>> 
>>> I usually get the EUR entry, if I buy or sell stock or funds, which are
>>> accounted in USD.
>> 
>> GnuCash always prefers a direct conversion over an indirect one regardless
>> of the date. It's not optional. I suppose the problem arises because you're
>> trading USD-priced stocks from an EUR-denominated brokerage account and the
>> trades create the EUR prices. The simplest work around is to remove those
>> EUR prices from the pricedb; it won't affect the transaction or reports
>> using the average-cost price source. To avoid the problem going forward
>> create an intermediary USD bank account in your brokerage account hierarchy
>> and when recording the trade make separate splits for USD<->EUR and
>> stock<->USD. Chris Lam is working on a stock trading assistant to make this
>> a bit less cumbersome; we hope it will be finished in time for GnuCash 5.
>> 
> 
> Thanks John for your quick reply.
> 
> The scenario you describe matches well my use case.
> 
> Yes, I manually delete the EUR entries in the pricedb
> 
> I am looking forward to the stock trading assistant.
> 
> Can you tell why GnuCash always prefers a direct conversion over an indirect 
> one regardless of the date? Is this a bug or a feature :-) ?
> 

Please remember to copy the list on all replies.

I don't think it's either a bug or a feature that GnuCash prefers direct 
conversion, it's just a more efficient way to find a price given the way price 
database is arranged in a sort of tree structure of linked lists.

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] Price editor uses old entry

[Rainer Dorsch via gnucash-user]

Am Samstag, 6. November 2021, 03:51:55 CET schrieb john:
> > On Nov 5, 2021, at 1:48 PM, Rainer Dorsch  wrote:
> > 
> > Am Freitag, 5. November 2021, 16:39:28 CET schrieben Sie:
> >>> On Nov 5, 2021, at 4:22 AM, Rainer Dorsch via gnucash-user
> >>>  wrote:
> >>> 
> >>> Hi,
> >>> 
> >>> I noticed that if the price editor has an entry in EUR and an entry in
> >>> USD, it used the EUR entry, even if the USD entry has a newer date. My
> >>> account currency is EUR.
> >>> 
> >>> Is that intended and is there an option to change this behavior?
> >>> 
> >>> I usually get the EUR entry, if I buy or sell stock or funds, which are
> >>> accounted in USD.
> >> 
> >> GnuCash always prefers a direct conversion over an indirect one
> >> regardless
> >> of the date. It's not optional. I suppose the problem arises because
> >> you're
> >> trading USD-priced stocks from an EUR-denominated brokerage account and
> >> the
> >> trades create the EUR prices. The simplest work around is to remove those
> >> EUR prices from the pricedb; it won't affect the transaction or reports
> >> using the average-cost price source. To avoid the problem going forward
> >> create an intermediary USD bank account in your brokerage account
> >> hierarchy
> >> and when recording the trade make separate splits for USD<->EUR and
> >> stock<->USD. Chris Lam is working on a stock trading assistant to make
> >> this
> >> a bit less cumbersome; we hope it will be finished in time for GnuCash 5.
> > 
> > Thanks John for your quick reply.
> > 
> > The scenario you describe matches well my use case.
> > 
> > Yes, I manually delete the EUR entries in the pricedb
> > 
> > I am looking forward to the stock trading assistant.
> > 
> > Can you tell why GnuCash always prefers a direct conversion over an
> > indirect one regardless of the date? Is this a bug or a feature :-) ?
> 
> Please remember to copy the list on all replies.

I remembered immediately and resent it also to the list.

The current implementation works well for me, just have to remember that for 
each new transaction (could also be earnings), I need to delete the "new 
price" from the price editor otherwise I lose my quote updates silently. I 
just wanted to find out if I am doing something wrong.

But I have to admit: from a pure user perspective, all the arguments given so 
far, do not convince me at all. I thought it might be useful to share it since 
there might be more users which have by far not the experience with accounting 
tools and insight in the gnucash implementation, which you have.

> I don't think it's either a bug or a feature that GnuCash prefers direct
> conversion, it's just a more efficient way to find a price given the way
> price database is arranged in a sort of tree structure of linked lists.

Frank worte:
> you will end in very complex scenarios of the graph theory:
> multiple pathes with different costs.

When I read this first, I was not sure if the comment was pure irony or if it 
was serious. Since Johns argument is similar, I assume it is serious:

The price editor manages to sort the quotes by date, so there must be already 
code which does that :-)

David wrote:
> When a transaction has an embedded price Gnucash assumes that it is a
> purchase or sale and the price is exact for that trade.   Quotes are
> generally assumed to be estimates, therefore somewhat soft like newspaper
> quotes.

I which usecase would I be more interested in an exact historic price than in 
a current estimate?

As written before, with the current implementation there are workarounds for 
me, just wanted to give my humble user perspective.

Thanks for keeping gnucash up to date and running for so many years!
Rainer

-- 
Rainer Dorsch
http://bokomoko.de/


___
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] Adding Namespace Item to Price Editor

[Jack Frillman via gnucash-user]

In the GNUCash Price Editor  you have to choose from a list of seven 
*Namespace* items:


Currencies, All non-currencies, AMEX, EUREX, FUND, NASDAQ, NYSE

Is there any way of adding an item to this list?

Thanks.

--
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

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

Price Editor broke today for unknown reasons

[Keith Myers]

I can't get Price Editor to work today. Worked fine up till yesterday.  
Now all it does is hang GnuCash with a spinner and timeout.  I 
completely removed Perl and reinstalled including the Finance-Quote 
module.  When I run gnc-fq-check, gnc-fq-dump, and gnc-fq-update, they 
all come back with the expected correct responses. Perl sees the module 
fine.  Why is GnuCash broken today.  All the rest of GnuCash is working 
correctly, just the Price Editor can't get any updates.  I have repaired 
GnuCash, rebooted the computer umpteen times and nothing has got the 
Price Editor to not hang GnuCash.


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

Re: [GNC] Adding Namespace Item to Price Editor

[Derek Atkins]

Hi,

On Sun, March 21, 2021 2:14 pm, Jack Frillman via gnucash-user wrote:
>
> In the GNUCash Price Editor  you have to choose from a list of seven
> *Namespace* items:
>
> Currencies, All non-currencies, AMEX, EUREX, FUND, NASDAQ, NYSE
>
> Is there any way of adding an item to this list?

When you create a new commodity, you can choose to type in anything you
wish in that section (i.e., you don't have to choose only from the
available list).

> Thanks.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
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] Adding Namespace Item to Price Editor

[D. via gnucash-user]

You don't *have* to choose from the list. Type what you want. 


 Original Message 
From: Jack Frillman via gnucash-user 
Sent: Sun Mar 21 14:14:32 EDT 2021
To: gnucash-user@gnucash.org
Subject: [GNC] Adding Namespace Item to Price Editor


In the GNUCash Price Editor  you have to choose from a list of seven 
*Namespace* items:

Currencies, All non-currencies, AMEX, EUREX, FUND, NASDAQ, NYSE

Is there any way of adding an item to this list?

Thanks.

-- 
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Mail formatting (was: Price Editor Problems)

[Geert Janssens]

Hi Eric,

Your change seems to have fixed the editing. I now see your html message 
properly formatted.

Regards,

Geert

Op zaterdag 11 mei 2019 22:17:08 CEST schreef Eric Coates:
> Gert
> 
> Thank you for the tip. I have (I think!) found the "offending" setting.
> I have unset it.
> 
> I think it's possibly something to do with the mailing list - sending a
> message with *bold* and /italic/ text to another of my email addresses
> shows no problems.
> 
> 
> 
> Everybody
> 
> Please forgive the small experiment.
> 
> Best wishes
> 
> Eric
> 
> ===
> 
> On 11/05/2019 18:11, Geert Janssens wrote:
> > It looks like you have sent an html formatted mail and that got converted
> > to plain text somewhere. In plain text mails asterisks are typically the
> > replacement of the bold markup. So the text between two asterisks is
> > considered boldface.
> > 
> > Regards,
> > 
> > Geert




___
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: Price Editor broke today for unknown reasons

[Derek Atkins]

Keith Myers  writes:

> I can't get Price Editor to work today. Worked fine up till
> yesterday.  Now all it does is hang GnuCash with a spinner and
> timeout.  I completely removed Perl and reinstalled including the
> Finance-Quote module.  When I run gnc-fq-check, gnc-fq-dump, and
> gnc-fq-update, they all come back with the expected correct
> responses. Perl sees the module fine.  Why is GnuCash broken today. 
> All the rest of GnuCash is working correctly, just the Price Editor
> can't get any updates.  I have repaired GnuCash, rebooted the computer
> umpteen times and nothing has got the Price Editor to not hang
> GnuCash.

I presume you mean "Price Grabber" and not "Price Editor".  The *Price
Editor" itself does not use Perl or anything else -- it's a dialog that
lets you manually enter prices.  If you then click on "Get Quotes", that
launches the "Price Grabber", which does use Perl.

Apparently Yahoo is b0rked right now.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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.

Re: Price Editor broke today for unknown reasons

[Keith Myers]

Yes, that is what I meant.  The "Get Quotes" function within the Price Editor 
which uses the Perl Finance:Quote module.  I even when into the Security Editor 
and tried a couple of the other stock scrapers for some of the securities.  
Whatever has happened to Yahoo has borked everything.

  From: Derek Atkins 
 To: Keith Myers  
Cc: gnucash-user@gnucash.org
 Sent: Thursday, November 2, 2017 7:32 AM
 Subject: Re: Price Editor broke today for unknown reasons
   
Keith Myers  writes:

> I can't get Price Editor to work today. Worked fine up till
> yesterday.  Now all it does is hang GnuCash with a spinner and
> timeout.  I completely removed Perl and reinstalled including the
> Finance-Quote module.  When I run gnc-fq-check, gnc-fq-dump, and
> gnc-fq-update, they all come back with the expected correct
> responses. Perl sees the module fine.  Why is GnuCash broken today. 
> All the rest of GnuCash is working correctly, just the Price Editor
> can't get any updates.  I have repaired GnuCash, rebooted the computer
> umpteen times and nothing has got the Price Editor to not hang
> GnuCash.

I presume you mean "Price Grabber" and not "Price Editor".  The *Price
Editor" itself does not use Perl or anything else -- it's a dialog that
lets you manually enter prices.  If you then click on "Get Quotes", that
launches the "Price Grabber", which does use Perl.

Apparently Yahoo is b0rked right now.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
      Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
      Member, MIT Student Information Processing Board  (SIPB)
      URL: http://web.mit.edu/warlord/   PP-ASEL-IA    N1NWH
      warl...@mit.edu                        PGP key available

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

[GNC] Price editor is not getting the quotes.

[Bill Swanson]

I am using alphavantage. Has the get quotes method changed?

Thanks in advance!

-- 
Bill Swanson
207-2443946
___
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] Fw: Prices automatically rounding in price editor (unwanted)

[anobono via gnucash-user]

I searched for an answer to this question unsuccessfully before posting here.

I have recently installed Gnucash 4.6 on Windows 10 and when adding security 
prices in the price editor, the amount rounds to 2 decimals automatically which 
is wrong. Specifically, I type an amount with more than two decimals and if I 
click to add this price or just move the focus away, the interface displays the 
number with only two decimals. Is this a bug or did I do something wrong? I 
went temporarily back to 3.11 because it doesn't have that issue, but i has an 
old bug I was happy to see fixed, so I'd rather have 4.6, but functioning 
normally.

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

Price editor updates only work when opening from CLI

[Jeremy Foote]

I have a strange problem. I updated Finance::Quote, got my alphavantage API
key and updated /etc/gnucash/environment.

When I opened GC to try to update my securities to use alphavantage it did
not appear in the "other" list. To try to troubleshoot, I opened GC from
the command line. When I did that, alphavantage appeared, and I updated all
of my securities to use it and successfully updated the prices.

I then closed GC and opened it from the OS and tried to update prices again
and it failed! It looks like GC may be using one version of Finance::Quote
if I open it from the CLI and another if I open it from the OS?

This is on Ubuntu 17.10, GC 2.6.17, Finance::Quote 1.47
___
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.

Re: [GNC] Fw: Prices automatically rounding in price editor (unwanted)

[Gyle McCollam]

No, you did nothing wrong.  That is a bug that was fixed in 4.7.  If you don't 
want to upgrade just yet, the "fix" is to hit the enter key after entering the 
number.  That will retain the number of decimals you entered.  It is not the 
best, but it does work, you just have to remember to hit the enter key instead 
of the way you were entering the prices.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: gnucash-user  on 
behalf of anobono via gnucash-user 
Sent: Saturday, October 9, 2021 8:37 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Fw: Prices automatically rounding in price editor (unwanted)

I searched for an answer to this question unsuccessfully before posting here.

I have recently installed Gnucash 4.6 on Windows 10 and when adding security 
prices in the price editor, the amount rounds to 2 decimals automatically which 
is wrong. Specifically, I type an amount with more than two decimals and if I 
click to add this price or just move the focus away, the interface displays the 
number with only two decimals. Is this a bug or did I do something wrong? I 
went temporarily back to 3.11 because it doesn't have that issue, but i has an 
old bug I was happy to see fixed, so I'd rather have 4.6, but functioning 
normally.

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