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 re

Re: Please remove me from the mailing list

2018-01-27 Thread Frank H. Ellenberger
Hi, Am 26.01.2018 um 23:53 schrieb 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 remember to CC th

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 lib/Finance/Quote/Yah

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 c

Re: Reports very slow to open

2018-01-27 Thread David Reiser
I can’t time report loading on my macs in 2.7.3 — gnucash crashes whenever I try to create a report. No problems or slowdowns with 2.6.19 -- Dave Reiser dbrei...@icloud.com > On Jan 27, 2018, at 11:39 AM, R. Victor Klassen wrote: > > This is quite dramatic. Probably my favourite thing to d

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, add

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, postgres

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 > http://piecash.readthedocs.io/en/lates

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 follow

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 new build scripts missed copyi

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, m

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 a

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 sub-accoun

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

2018-01-27 Thread Adrien Monteleone
You can already use formulas in scheduled transactions, I just don’t think you can use a present GC register value as a variable. (such as x% of the balance of Assets:Checking) I could be wrong. It should be possible though to use the value of one split as a variable so some auto-allocation migh

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

2018-01-27 Thread D via gnucash-user
Ah, yes that was my incorrect reference. Sorry for the crossed reference. I will note that my confusion stems in part from the fact that, as a Mac user, I have never used anything to do with python and Gnucash, on account of the high barrier to install the proper toolsets (i.e., compiling yourse

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 wrote: Hi, I

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

2018-01-27 Thread D via gnucash-user
Ah. The wonders of autocorrect. "the part three Mayers" really makes more sense if it were written as "the part that matters." David On January 28, 2018, at 9:48 AM, D via gnucash-user wrote: Yes. Fill in the amount and the shares, and let Gnucash calculate the price. It won't match the sta

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

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: Reconcile unusable

2018-01-27 Thread Ronal B Morse
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 difference whether or not I make changes on the

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 differ

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 can

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

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 ca