Re: File Format : XML v MySQL / postgres / sqllite

2018-01-27 Thread David T. via gnucash-user
Sebastien, The problem isn’t with Python (I am told that Macs already have Python on them). The problem as I understand it (John will no doubt correct me when my statements prove ill-informed or flat out wrong) has to do with the fact that GnuCash requires a specific version of Python, which

Re: File Format : XML v MySQL / postgres / sqllite

2018-01-27 Thread Sébastien de Menten
Hello David, Regarding the use of python on windows and Mac, Anaconda has made a huge difference in the last years providing all packages in an easy precompiled version. You can have a look at https://conda.io/docs/user-guide/install/macos.html for the installation (which is simple and does not

Re: Reconcile unusable

2018-01-27 Thread Ronal B Morse
On 01/27/2018 11:26 PM, Mark Lawrence wrote: On 28/01/18 05:50, Ronal B Morse wrote: On 01/27/2018 07:20 AM, Mark Lawrence wrote: With gnucash 2.6.17 on ubuntu 17.10 I cannot do anything with the reconcile screen.  Clicking anywhere to do anything always takes me back to the main screen, I

Re: Reconcile unusable

2018-01-27 Thread Mark Lawrence
On 28/01/18 05:50, Ronal B Morse wrote: On 01/27/2018 07:20 AM, Mark Lawrence wrote: With gnucash 2.6.17 on ubuntu 17.10 I cannot do anything with the reconcile screen.  Clicking anywhere to do anything always takes me back to the main screen, I can't even close it.  It doesn't make any

Reconcile unusable

2018-01-27 Thread Mark Lawrence
With gnucash 2.6.17 on ubuntu 17.10 I cannot do anything with the reconcile screen. Clicking anywhere to do anything always takes me back to the main screen, I can't even close it. It doesn't make any difference whether or not I make changes on the "Reconcile information" screen. I've tried

Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

2018-01-27 Thread D via gnucash-user
I'm glad you're going to look at documenting your suggestions in the Tutorial. I imagine they would fit as a special section in the budgets chapter. As for the idea of having formulas active in the register, I think that there are a number of issues that need consideration and addressing.

Re: Accuracy / Rounding issues - Difference between gnucash and broker account

2018-01-27 Thread D via gnucash-user
Yes. Fill in the amount and the shares, and let Gnucash calculate the price. It won't match the statement exactly (it never does, in my experience), but the price isn't really the part three Mayers; it's the other two that do. David On January 28, 2018, at 2:56 AM, Pawel Wocjan

Re: Subaccounts [WAS Re: Future allocated money vs Budgets]

2018-01-27 Thread Matt Graham
Nice! It seems like we are getting somewhere. I am convinced that the process we think of budgeting where we are saving up for something is really a case of segmenting money within a sub-account. And it looks like Gnucash is already happy with this kind of situation - with the include

Re: yahoo as json stock quotes pounds/pence

2018-01-27 Thread Dave H
Also if you go to https://lists.gnucash.org/pipermail/gnucash-user/2017-November/thread.html#72946 there's a lot more info re the issue of changing quotes from Yahoo to Alphavantage. If you want to search the mailing list you need to specify the site in google e.g. "site:gnucash-user@gnucash.org

Accuracy / Rounding issues - Difference between gnucash and broker account

2018-01-27 Thread Pawel Wocjan
Hi, I have selected dividend reinvestment for MSFT so I end up having fractional shares with my broker. For instance, in my account I see the following data for Microsoft: Price: 94.060 Shares: 30.147 Current value: $2,835.62 I'm trying to reproduce all the data for all my individual stocks,

Re: Reports very slow to open

2018-01-27 Thread John Ralls
> On Jan 25, 2018, at 10:00 PM, David Carlson > wrote: > > Also, I think it is known that release 2.7.3 is unable to install F::Q, even > via the manual program link in the GnuCash program group of the Windows 7 > start menu. If I knew that I'd forgotten. The

Re: yahoo as json stock quotes pounds/pence

2018-01-27 Thread Dave H
This came about because of an issue reported in early November last year and is considered solved I believe What version of Finance Quote are you running as it all changed about then ??? > On 06/11/17 22:43, Erik Colson wrote: >> New version 1.43 of Finance-Quote is available with the

Re: File Format : XML v MySQL / postgres / sqllite

2018-01-27 Thread John Ralls
I suspect David was thinking of CuteCash, Christian Stimming’s experimental Qt GUI. Regards, John Ralls > On Jan 27, 2018, at 10:44 AM, Sébastien de Menten wrote: > > Hello David, > > I saw you were mentioning piecash in your message. If you talk about >

Re: File Format : XML v MySQL / postgres / sqllite

2018-01-27 Thread Sébastien de Menten
Hello David, I saw you were mentioning piecash in your message. If you talk about http://piecash.readthedocs.io/en/latest/, it is not a proof of concept for a frontend but an alternative to the gnucash python bindings to work with gnucash books stored in any of the 3 SQL backends (SQLite,

Re: File Format : XML v MySQL / postgres / sqllite

2018-01-27 Thread D via gnucash-user
Mike, There is nothing new as far as I know about the file formats. You are right that the primary benefit to using sql is being able to generate data sets from sql that can used in reports. Processing a data file is no quicker in sql, since it all gets loaded in at start up. Sql, moreover,

Re: Reports very slow to open

2018-01-27 Thread R. Victor Klassen
This is quite dramatic. Probably my favourite thing to do in code is to make it faster. (Un)fortunately I don’t run Windows, so I have little to offer here. The sudden and dramatic change raises the question of what changed? And I haven’t noticed this issue on the Mac, so I’m guessing the

Re: yahoo as json stock quotes pounds/pence

2018-01-27 Thread ml enquirer
OK, I guess this is not a solved problem, then? I don't see this on the GnuCash FAQ page... and I figure these 2008/2009 threads are quite likely to be outdated. I did the following: - checkout financequote: "git clone https://github.com/finance-quote/finance-quote.git - edit

Re: Please remove me from the mailing list

2018-01-27 Thread Geert Janssens
Op vrijdag 26 januari 2018 23:53:29 CET schreef Adrien Monteleone: > I suppose you’re referring to this: > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > Please