Re: Transferring data from Quicken Home and Business 2007

2018-04-01 Thread 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

Unrealized loss

2018-04-01 Thread 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 b

Re: Price Editor/Database lag

2018-04-01 Thread 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 driv

Re: manual load of yahoo quotes via spreadsheet

2018-04-01 Thread 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 tha

Re: Unrealized loss

2018-04-01 Thread 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 l

Re: Price Editor/Database lag

2018-04-01 Thread 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

Re: Unrealized loss

2018-04-01 Thread 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

Re: Unrealized loss

2018-04-01 Thread 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: R

Re: manual load of yahoo quotes via spreadsheet

2018-04-01 Thread 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 t

Re: Price Editor/Database lag

2018-04-01 Thread 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 u

Re: manual load of yahoo quotes via spreadsheet

2018-04-01 Thread 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

Re: Fast reactions to 2.7.8

2018-04-01 Thread 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 >$

Re: manual load of yahoo quotes via spreadsheet

2018-04-01 Thread Steven Anter
I'll do it, if someone walks me through it... Virus-free. www.avast.com

Re: FW: alphavantage quotes fix

2018-04-01 Thread 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

RE: FW: alphavantage quotes fix

2018-04-01 Thread 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@gnucas

2.7.8 fails to find environment file

2018-04-01 Thread 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, whic

Finance::Quote Yahoo_JSON Alpha Vantage

2018-04-01 Thread 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 i

Re: Price Editor/Database lag

2018-04-01 Thread 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 p

Re: manual load of yahoo quotes via spreadsheet

2018-04-01 Thread 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,

Re: manual load of yahoo quotes via spreadsheet

2018-04-01 Thread 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 throug

Re: Price Editor/Database lag

2018-04-01 Thread 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 a

Re: 2.7.8 fails to find environment file

2018-04-01 Thread 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 wou

Re: Fast reactions to 2.7.8

2018-04-01 Thread 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

Re: Price Editor/Database lag

2018-04-01 Thread 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,