Re: Transferring data from Quicken Home and Business 2007

[keithwjones]

Paul Flanagan wrote
> I have installed GnuCash and have attempted to transfer data from Quicken

You could consider just starting with a new account and no transfer.

This way you will not be importing old details which you no longer need.

This was the best way for me.

Keith




-
GnuCash 2.6.19 - Windows 10
--
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.

Unrealized loss

[cageda]

Hello.

I have have had an "unrealized loss" showing on my balance sheet for 
years. I haven't bothered too much as the amount is extremely small. 
(€7.70).


I had kind advice on this forum as to identify the date on which the 
loss showed up and the procedure to cancel it. I did find the date but 
stangely not the transaction. So I'm not going to keep trying to cancel 
the loss any longer.


I read that, without actually "cancelling" the loss, it is possible to 
prevent it from showing. I know that this is not legal for a company, 
but my book keeping is fully personal so I'd like to know the procedure.


Could someone please tell me?
Thank you in advance.
Alain
___
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: manual load of yahoo quotes via spreadsheet

[John Ralls]

> On Mar 31, 2018, at 9:51 PM, santer  wrote:
> 
> Is there a way to manually update stock quotes via spreadsheet?  I can
> download a spreadsheet of quotes from yahoo, which I'd like to load to
> gnucash.
> 

A CSV price importer will be one of the new features of GnuCash 3.0. We’ll 
release that today or tomorrow, depending on how long it takes me to get all of 
the release notes and such done.

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: Unrealized loss

[John Ralls]

> On Apr 1, 2018, at 5:13 AM, cag...@free.fr wrote:
> 
> 
> Hello.
> 
> I have have had an "unrealized loss" showing on my balance sheet for years. I 
> haven't bothered too much as the amount is extremely small. (€7.70).
> 
> I had kind advice on this forum as to identify the date on which the loss 
> showed up and the procedure to cancel it. I did find the date but stangely 
> not the transaction. So I'm not going to keep trying to cancel the loss any 
> longer.
> 
> I read that, without actually "cancelling" the loss, it is possible to 
> prevent it from showing. I know that this is not legal for a company, but my 
> book keeping is fully personal so I'd like to know the procedure.

“Cancelling” isn’t really the right term. You need to record the loss as either 
expense or negative income depending on how you handle capital gains. There’s 
an explanation of how to do this in 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html 
.

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]

> 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: Unrealized loss

[cageda]

De: "John Ralls"  
À: cag...@free.fr 
Cc: gnucash-user@gnucash.org 
Envoyé: Dimanche 1 Avril 2018 15:34:43 
Objet: Re: Unrealized loss 






On Apr 1, 2018, at 5:13 AM, [ mailto:cag...@free.fr | cag...@free.fr ] wrote: 


Hello. 

I have have had an "unrealized loss" showing on my balance sheet for years. I 
haven't bothered too much as the amount is extremely small. (€7.70). 

I had kind advice on this forum as to identify the date on which the loss 
showed up and the procedure to cancel it. I did find the date but stangely not 
the transaction. So I'm not going to keep trying to cancel the loss any longer. 

I read that, without actually "cancelling" the loss, it is possible to prevent 
it from showing. I know that this is not legal for a company, but my book 
keeping is fully personal so I'd like to know the procedure. 




“Cancelling” isn’t really the right term. You need to record the loss as either 
expense or negative income depending on how you handle capital gains. There’s 
an explanation of how to do this in [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] . 

Regards, 
John Ralls 

John, 

Thank youy for your reply. 

The manual you sent me the link to is very dense and I haven't got a clue where 
to start. 

Given that: 

- I do not manage stock using split transactions (I don't manage currencies 
other than EUR either) 
- As mentioned above, I identified the day the unrealized loss turned up but 
none of the transactions entered on that day (or the day before) can possibly 
explain the loss 

I'd rather have the loss be not "canceled" (which I unsuccessfully tried to do) 
but just hidden, as I've read somewhere that was technically (if not legally 
for a company which I'm not) feasible. 

Alain 




___
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: Unrealized loss

[Christopher Lam]

Salut Alain

You will also incur unrealized gains/losses upon currency transfers, eg 
EUR->GBP->EUR whereby exchange rates are fluid.


HTH


On 01/04/18 18:17, cag...@free.fr wrote:



De: "John Ralls" 
À: cag...@free.fr
Cc: gnucash-user@gnucash.org
Envoyé: Dimanche 1 Avril 2018 15:34:43
Objet: Re: Unrealized loss






On Apr 1, 2018, at 5:13 AM, [ mailto:cag...@free.fr | cag...@free.fr ] wrote:


Hello.

I have have had an "unrealized loss" showing on my balance sheet for years. I 
haven't bothered too much as the amount is extremely small. (€7.70).

I had kind advice on this forum as to identify the date on which the loss 
showed up and the procedure to cancel it. I did find the date but stangely not 
the transaction. So I'm not going to keep trying to cancel the loss any longer.

I read that, without actually "cancelling" the loss, it is possible to prevent 
it from showing. I know that this is not legal for a company, but my book keeping is 
fully personal so I'd like to know the procedure.




“Cancelling” isn’t really the right term. You need to record the loss as either 
expense or negative income depending on how you handle capital gains. There’s 
an explanation of how to do this in [ 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] .

Regards,
John Ralls

John,

Thank youy for your reply.

The manual you sent me the link to is very dense and I haven't got a clue where 
to start.

Given that:

- I do not manage stock using split transactions (I don't manage currencies 
other than EUR either)
- As mentioned above, I identified the day the unrealized loss turned up but 
none of the transactions entered on that day (or the day before) can possibly 
explain the loss

I'd rather have the loss be not "canceled" (which I unsuccessfully tried to do) 
but just hidden, as I've read somewhere that was technically (if not legally for a 
company which I'm not) feasible.

Alain




___
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: manual load of yahoo quotes via spreadsheet

[Steven Anter]

Will there be instructions on how to use it?

On Sun, Apr 1, 2018, 6:28 AM John Ralls  wrote:

>
>
> > On Mar 31, 2018, at 9:51 PM, santer  wrote:
> >
> > Is there a way to manually update stock quotes via spreadsheet?  I can
> > download a spreadsheet of quotes from yahoo, which I'd like to load to
> > gnucash.
> >
>
> A CSV price importer will be one of the new features of GnuCash 3.0. We’ll
> release that today or tomorrow, depending on how long it takes me to get
> all of the release notes and such done.
>
> 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: manual load of yahoo quotes via spreadsheet

[John Ralls]

Only if someone volunteers to write them.

Regards,
John Ralls

> On Apr 1, 2018, at 12:31 PM, Steven Anter  wrote:
> 
> Will there be instructions on how to use it?
> 
> On Sun, Apr 1, 2018, 6:28 AM John Ralls  wrote:
> 
> 
> > On Mar 31, 2018, at 9:51 PM, santer  wrote:
> >
> > Is there a way to manually update stock quotes via spreadsheet?  I can
> > download a spreadsheet of quotes from yahoo, which I'd like to load to
> > gnucash.
> >
> 
> A CSV price importer will be one of the new features of GnuCash 3.0. We’ll 
> release that today or tomorrow, depending on how long it takes me to get all 
> of the release notes and such done.
> 
> 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: Fast reactions to 2.7.8

[Mike Alexander]

Thanks for all the research, Geert.  I’ve done some experimentation on MacOSX 
and can add a bit.

> 6. Move this directory to a location on your system that's parsed by gtk. 
> This 
> is platform dependent:
> - Linux: $HOME/.local/share/themes/
> - OS X: Here I'm not sure. Possibly
>$HOME/.local/share/themes/ (like on linux)
>  or  $HOME/Library/Application Support/themes/
>  I suspect the first unless one overrides the XDG_DATA_HOME environment
>  variable
> - Windows: %LOCALAPPDATA%\themes

It seems to be $HOME/.local/share/themes/ even in the native Aqua version of 
GnuCash. 

> 7. Next tell gtk to load this theme.
> Linux users can probably most easily do this by install the "Gnome Tweak 
> Tool" 
> on their platform and select the new theme there.
> 
> The manual method is this:
> Create a file named "settings.ini" in the appropriate location. Again this 
> depends on your platform:
> - Linux: $HOME/.config/gtk-3.0/
> - OS X: Again I'm not sure. Possibly
>$HOME/.config/gtk-3.0/ (like on linux)
>  or  $HOME/Library/Application Support/Gnucash/config/gtk-3.0
>  I suspect the latter in this case because gnucash overrides the
>  XDG_CONFIG_HOME environment variable on OS X
> - Windows: %LOCALAPPDATA%\gtk-3.0\

~/Library/Application Support/GnuCash/config/gtk-3.0/settings.ini works for the 
native version of GnuCash.  If anyone besides me runs the X-Window version on 
MacOS, then the settings.ini file should be in ~/.config/gtk-3.0 like on Linux.

You’re certainly right that Eye-friendly-Dark-RBC isn’t the best theme, but it 
works on MacOS.

Mike

___
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: manual load of yahoo quotes via spreadsheet

[Steven Anter]

I'll do it, if someone walks me through it...


Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

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

> Only if someone volunteers to write them.
>
> Regards,
> John Ralls
>
> > On Apr 1, 2018, at 12:31 PM, Steven Anter  wrote:
> >
> > Will there be instructions on how to use it?
> >
> > On Sun, Apr 1, 2018, 6:28 AM John Ralls  wrote:
> >
> >
> > > On Mar 31, 2018, at 9:51 PM, santer  wrote:
> > >
> > > Is there a way to manually update stock quotes via spreadsheet?  I can
> > > download a spreadsheet of quotes from yahoo, which I'd like to load to
> > > gnucash.
> > >
> >
> > A CSV price importer will be one of the new features of GnuCash 3.0.
> We’ll release that today or tomorrow, depending on how long it takes me to
> get all of the release notes and such done.
> >
> > 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: FW: alphavantage quotes fix

[Steven Anter]

Hi Chris,

Applied your patches and AlphaVantage worked. For now at least.  If I have
future issues, may I contact you?


Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Sat, Mar 31, 2018 at 9:49 PM, Chris Good  wrote:

> Hi Steven,
>
>
>
> Please see my mail below but get the Quote.pm + AlphaVantage.pm from Mike
> Alexander’s git hub instead of mine as he has also put the 1 second delay
> between each request for a currency and you will need that.
>
>
>
> Get from Quote.pm from
>
> https://raw.githubusercontent.com/mtalexander/finance-quote/
> 6ee43ea08b504617142139fda41ae45be865fa38/lib/Finance/Quote.pm
>
>
>
> Get AlphaVantage.pm from
>
> https://github.com/mtalexander/finance-quote/blob/
> 6ee43ea08b504617142139fda41ae45be865fa38/lib/Finance/Quote/AlphaVantage.pm
>
>
>
> Regards,
>
>
>
> Chris Good
>
>
>
> *From:* Chris Good 
> *Sent:* Sunday, 18 March 2018 6:54 PM
> *To:* finance-quote-de...@lists.sourceforge.net
> *Cc:* lordpaul...@gmail.com
> *Subject:* RE: alphavantage quotes fix
>
>
>
> Message: 1
> Date: Sat, 3 Mar 2018 07:49:34 -0600
> From: Paul Bates 
> To: finance-quote-de...@lists.sourceforge.net
> Subject: [Finance-quote-devel] alphavantage quotes fix
> Message-ID:
> 
> Content-Type: text/plain; charset="utf-8"
>
> I have been using the alphavantage module with gnucash to get quotes for
> stocks.  The list is well over 40, so it has become nonfunctional in the
> last couple of months.  I am not a perl programmer, so the fix took
> several
> hours and more cups of coffee.  I hope a perl programmer can add error
> checks and possibly while loops to catch the occasional double message.
> Currently It seems to miss one or two stocks on the list.
>
> In alphavantage.pm   I inserted the following code in the sub
> alphavantage :
>
> my $code = $reply->code;
> my $desc = HTTP::Status::status_message($code);
> my $body = $reply->content;
> if ($code != 200) {
> $info{ $stock, 'success' } = 0;
> $info{ $stock, 'errormsg' } = $desc;
> next;
> }
>
> my $json_data;
> eval {$json_data = JSON::decode_json $body};
>
> #
> ### Insert
> #
> # attempt to handle the Information message
> if ( $json_data->{'Information'} ) {
>sleep (20);
>$reply = $ua->request( GET $url);
>$code = $reply->code;
>$desc = HTTP::Status::status_message($code);
>$body = $reply->content;
>eval {$json_data = JSON::decode_json $body};
> }
> ###
>
> if ($@) {
> $info{ $stock, 'success' } = 0;
> $info{ $stock, 'errormsg' } = $@;
> }
>
> I am sure there are better ways to handle this, but I am not used to the
> developers lists and hate to leave alphavantage being blamed for a problem
> that is not theirs.
>
> Paul Bates
>
> Hi Paul,
>
>
>
> I have modified AlphaVantage.pm as you requested.
>
> If it fails with an Information message, it will try again 4 times, with a
> 20 second delay between each try.
>
> It tests OK for me but I don’t usually use AlphaVantage and it has never
> failed with an Information message for me, so can you please get my code
> from
>
> https://github.com/goodvibes2/finance-quote/blob/FqIss83AlphaVantage/lib/
> Finance/Quote/AlphaVantage.pm
>
> and test it?
>
>
>
> After you test it, I will create a Pull Request to get this change
> incorporated in Finance::Quote.
>
>
>
> Just for completeness, can you tell us what is in the Information messages
> you are getting?
>
>
>
> Regards, Chris Good
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

RE: FW: alphavantage quotes fix

[Chris Good]

Hi Steven,

 

You can but you should ask the gnucash-user email list first as many other 
people are interested, may have more available time and may have answers I 
don’t have.

 

Regards, Chris Good

 

From: Steven Anter  
Sent: Monday, 2 April 2018 9:26 AM
To: Chris Good ; gnucash-user@gnucash.org
Subject: Re: FW: alphavantage quotes fix

 

Hi Chris,

 

Applied your patches and AlphaVantage worked. For now at least.  If I have 
future issues, may I contact you?  

 


 

 

Virus-free.  

 www.avast.com 

 

On Sat, Mar 31, 2018 at 9:49 PM, Chris Good mailto:goodchri...@gmail.com> > wrote:

Hi Steven,

 

Please see my mail below but get the Quote.pm + AlphaVantage.pm from Mike 
Alexander’s git hub instead of mine as he has also put the 1 second delay 
between each request for a currency and you will need that. 

 

Get from Quote.pm from

https://raw.githubusercontent.com/mtalexander/finance-quote/6ee43ea08b504617142139fda41ae45be865fa38/lib/Finance/Quote.pm

 

Get AlphaVantage.pm from

https://github.com/mtalexander/finance-quote/blob/6ee43ea08b504617142139fda41ae45be865fa38/lib/Finance/Quote/AlphaVantage.pm

 

Regards,

 

Chris Good

 

From: Chris Good mailto:goodchri...@gmail.com> > 
Sent: Sunday, 18 March 2018 6:54 PM
To: finance-quote-de...@lists.sourceforge.net 
 
Cc: lordpaul...@gmail.com  
Subject: RE: alphavantage quotes fix 

 

Message: 1 
Date: Sat, 3 Mar 2018 07:49:34 -0600 
From: Paul Bates mailto:lordpaul...@gmail.com> > 
To: finance-quote-de...@lists.sourceforge.net 
  
Subject: [Finance-quote-devel] alphavantage quotes fix 
Message-ID: 
mailto:cal7glafoitanvhwrvtmopy5odnzwgjbdzkfwztusddb4gaj...@mail.gmail.com> > 
Content-Type: text/plain; charset="utf-8" 

I have been using the alphavantage module with gnucash to get quotes for 
stocks.  The list is well over 40, so it has become nonfunctional in the 
last couple of months.  I am not a perl programmer, so the fix took several 
hours and more cups of coffee.  I hope a perl programmer can add error 
checks and possibly while loops to catch the occasional double message. 
Currently It seems to miss one or two stocks on the list. 

In alphavantage.pm I inserted the following code in 
the sub alphavantage : 

my $code = $reply->code; 
my $desc = HTTP::Status::status_message($code); 
my $body = $reply->content; 
if ($code != 200) { 
$info{ $stock, 'success' } = 0; 
$info{ $stock, 'errormsg' } = $desc; 
next; 
} 

my $json_data; 
eval {$json_data = JSON::decode_json $body}; 

# 
### Insert 
# 
# attempt to handle the Information message 
if ( $json_data->{'Information'} ) { 
   sleep (20); 
   $reply = $ua->request( GET $url); 
   $code = $reply->code; 
   $desc = HTTP::Status::status_message($code); 
   $body = $reply->content; 
   eval {$json_data = JSON::decode_json $body}; 
} 
### 

if ($@) { 
$info{ $stock, 'success' } = 0; 
$info{ $stock, 'errormsg' } = $@; 
} 

I am sure there are better ways to handle this, but I am not used to the 
developers lists and hate to leave alphavantage being blamed for a problem 
that is not theirs. 

Paul Bates 

Hi Paul,

 

I have modified AlphaVantage.pm as you requested.

If it fails with an Information message, it will try again 4 times, with a 20 
second delay between each try.

It tests OK for me but I don’t usually use AlphaVantage and it has never failed 
with an Information message for me, so can you please get my code from

https://github.com/goodvibes2/finance-quote/blob/FqIss83AlphaVantage/lib/Finance/Quote/AlphaVantage.pm

and test it?

 

After you test it, I will create a Pull Request to get this change incorporated 
in Finance::Quote.

 

Just for completeness, can you tell us what is in the Information messages you 
are getting?

 

Regards, Chris Good

 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

2.7.8 fails to find environment file

[lj]

Using: gnucash-2.7.8(unstable) on 32-bit Slackware Linux 14.2

I built gnucash-2.7.8 (unstable) to be installed at /opt/gnucash. I used
a cmake line that included:
  -D CMAKE_INSTALL_PREFIX=/opt/gnucash

After build and install, gnucash would not start. First error was unable to
find schemas, which I worked around by setting XDG_DATA_DIRS. Then it
failed on unable to find modules.

It turned out that "make install" created the environment file here:
(1) /etc/opt/gnucash/gnucash/environment
But using strace I saw Gnucash was looking for it here:
(2) /opt/gnucash/etc/gnucash/environment

I copy the file from (1) to (2) and then it works.

(Should I write this up at bugzilla.gnome.org ?)

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Finance::Quote Yahoo_JSON Alpha Vantage

[Chris Good]

Hi,

 

I have no problems using Yahoo_JSON as a quote source for my 16 stocks for
which I download prices only weekly.

However, I have been working with another user and it seems Yahoo_JSON fails
when there are many stocks and/or prices for them are requested often.

 

I suggest people who run into Yahoo _JSON problems use Alpha Vantage as the
quote source.

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

 

Alpha Vantage purposefully fails quote requests if it detects a user hogging
their web server resources by returning an Information message that says:

Please consider optimizing your API call frequency

and pausing for approx. 20 seconds.

 

If you use Alpha Vantage, there have been mods made to Finance::Quote so
that usage complies with the Alpha Vantage recommendations that only 1 price
request per second is made in order to ensure that the webserver resources
are shared amongst all users.

 

If the information message is detected for a particular stock (or currency
conversion thanks Mike Alexander), then Finance::Quote also pauses for 20
seconds, then retries up to 4 times.

As this means you should not have to retry getting prices for all stocks or
currencies if you have a failure, and this will minimise usage of the Alpha
Vantage web server, I suggest people install the modified perl programs.

 

The modified Finance::Quote perl programs are currently not yet incorporated
into the latest version of Finance::Quote (1.47), and as the Finance::Quote
maintainers are, like everyone else, busy, it may be a long time (it has
been over a year in the past) before these mods are included in the next
release of Finance::Quote.

 

To install these mods without waiting for them to be incorporated in
Finance::Quote:

 

1. Make sure the standard Quote.pm and AlphaVantage.pm files are writable.

 

For Windows 10 these files are usually:

C:\strawberry\perl\site\lib\Finance\Quote.pm

C:\strawberry\perl\site\lib\Finance\Quote\AlphaVantage.pm

Using File Manager, right click on the file, Properties, Untick 'Read Only',
then OK

 

For Ubuntu Linux, these files are usually:

/usr/local/share/perl/5.22.1/Finance/Quote.pm

/usr/local/share/perl/5.22.1/Finance/Quote/AlphaVantage.pm

>From a terminal:

cd /usr/local/share/perl/5.22.1/Finance

sudo chmod 666 Quote.pm Quote/AlphaVantage.pm

 

2. To install the modified Quote.pm:

Open
https://raw.githubusercontent.com/mtalexander/finance-quote/6ee43ea08b504617
142139fda41ae45be865fa38/lib/Finance/Quote.pm

in a browser, click in the code, then  use Control-A to highlight it all,
then paste it into a text editor

(say Notepad for Windows, or gedit for Linux), then 'Save As' over the top
of the existing
Quote.pm.



3. To install the modified AlphaVantage.pm:

Open
https://github.com/mtalexander/finance-quote/blob/6ee43ea08b504617142139fda4
1ae45be865fa38/lib/Finance/Quote/AlphaVantage.pm

 

in a browser, click in the code, then  use Control-A to highlight it all,
then paste it into a text editor

(say Notepad for Windows, or gedit for Linux), then 'Save As' over the top
of the existing
AlphaVantage.pm.




Sorry, I don't have a Mac so I cannot provide instructions.

 

If you want to check on the progress of the Pull Request to incorporate
these changes in Finance::Quote, please see:

https://github.com/finance-quote/finance-quote/pull/85

 

Regards, Chris Good

 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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: manual load of yahoo quotes via spreadsheet

[D via gnucash-user]

Steven,

I'm not sure of your antecedents. Which will you need walking through -- the 
import process or the write-up? 

If it is the latter, I'd recommend putting it into the wiki, perhaps at 
https://wiki.gnucash.org/wiki/Using_GnuCash#Stocks_and_Commodities

David

On April 2, 2018, at 2:00 AM, Steven Anter  wrote:

I'll do it, if someone walks me through it...


Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

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

> Only if someone volunteers to write them.
>
> Regards,
> John Ralls
>
> > On Apr 1, 2018, at 12:31 PM, Steven Anter  wrote:
> >
> > Will there be instructions on how to use it?
> >
> > On Sun, Apr 1, 2018, 6:28 AM John Ralls  wrote:
> >
> >
> > > On Mar 31, 2018, at 9:51 PM, santer  wrote:
> > >
> > > Is there a way to manually update stock quotes via spreadsheet?  I can
> > > download a spreadsheet of quotes from yahoo, which I'd like to load to
> > > gnucash.
> > >
> >
> > A CSV price importer will be one of the new features of GnuCash 3.0.
> We’ll release that today or tomorrow, depending on how long it takes me to
> get all of the release notes and such done.
> >
> > 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: manual load of yahoo quotes via spreadsheet

[D via gnucash-user]

I should be a little clearer and say that your write up would go as a new page, 
with a link at the spot I noted, in the manner as the other topics listed there.

On April 2, 2018, at 7:01 AM, D via gnucash-user  
wrote:

Steven,

I'm not sure of your antecedents. Which will you need walking through -- the 
import process or the write-up? 

If it is the latter, I'd recommend putting it into the wiki, perhaps at 
https://wiki.gnucash.org/wiki/Using_GnuCash#Stocks_and_Commodities

David

On April 2, 2018, at 2:00 AM, Steven Anter  wrote:

I'll do it, if someone walks me through it...


Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

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

> Only if someone volunteers to write them.
>
> Regards,
> John Ralls
>
> > On Apr 1, 2018, at 12:31 PM, Steven Anter  wrote:
> >
> > Will there be instructions on how to use it?
> >
> > On Sun, Apr 1, 2018, 6:28 AM John Ralls  wrote:
> >
> >
> > > On Mar 31, 2018, at 9:51 PM, santer  wrote:
> > >
> > > Is there a way to manually update stock quotes via spreadsheet?  I can
> > > download a spreadsheet of quotes from yahoo, which I'd like to load to
> > > gnucash.
> > >
> >
> > A CSV price importer will be one of the new features of GnuCash 3.0.
> We’ll release that today or tomorrow, depending on how long it takes me to
> get all of the release notes and such done.
> >
> > 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.
___
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  > > 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: 2.7.8 fails to find environment file

[John Ralls]

> On Apr 1, 2018, at 6:03 PM, lj  wrote:
> 
> Using: gnucash-2.7.8(unstable) on 32-bit Slackware Linux 14.2
> 
> I built gnucash-2.7.8 (unstable) to be installed at /opt/gnucash. I used
> a cmake line that included:
>  -D CMAKE_INSTALL_PREFIX=/opt/gnucash
> 
> After build and install, gnucash would not start. First error was unable to
> find schemas, which I worked around by setting XDG_DATA_DIRS. Then it
> failed on unable to find modules.
> 
> It turned out that "make install" created the environment file here:
>(1) /etc/opt/gnucash/gnucash/environment
> But using strace I saw Gnucash was looking for it here:
>(2) /opt/gnucash/etc/gnucash/environment
> 
> I copy the file from (1) to (2) and then it works.
> 
> (Should I write this up at bugzilla.gnome.org ?)

Sure.

We should be be using CMAKE_INSTALL_FULL_SYSCONFDIR to set the path so that it 
always works no matter what cmake does with it, and cmake’s unique 
understanding of the gnu coding standard leads it to do some strange things 
with sysconfdir.

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: Fast reactions to 2.7.8

[Mike Alexander]

> On Mar 31, 2018, at 8:37 AM, Geert Janssens  
> wrote:
> 
> * On linux there's a second default theme called "Adwaita-dark" which should 
> also give you a dark themed gnucash. Unfortunately this doesn't work on 
> Windows. I suppose it's not included or improperly configured there ? On OS X 
> I haven't tried this.

This is packaged in the app bundle on MacOS and seems to work ok.

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