Re: gnucash 2.6.18

2017-11-13 Thread John Ralls
Les, That wasn’t the problem. 10.13 uses a newer version of libz with a symbol that’s not defined in the version I used in 2.6.17 and earlier. Regards, John Ralls > On Nov 13, 2017, at 10:37 AM, Les wrote: > > I upgraded MacOS over the weekend and "had" to upgrade GC to 2.16.18 because >

Re: files

2017-11-13 Thread John Ralls
Christine, That is what I meant. How did you then open the file in the new location? What operating system/distro are you using? Regards, John Ralls > On Nov 13, 2017, at 8:35 AM, Christine wrote: > > Hi John > Sorry I panicked and could not find out where to send messages. Gnucash was > not

Re: Bank reconciliation

2017-11-13 Thread Adrien Monteleone
That’s what I use as well. I think the usual terminology is Assets:Current Assets:Undeposited Funds. Some people also call this the ‘check clearing’ account though 'Undeposited Funds' is more generalized and could include cash. A business which maintains a ‘Petty Cash’ account and otherwise dep

Re: Bank reconciliation

2017-11-13 Thread D via gnucash-user
The importer cannot manage multiple split transactions, so it does the only thing it can--it puts the entry to imbalance. Once there,the imbalance split is just another split to Gnucash, so subsequent adjustments have to address the imbalance split. To add correct info to such a transaction, I p

Re: How to find out which securities need to be switched from Yahoo to Alphavantage

2017-11-13 Thread D via gnucash-user
I wrote a script to entirely replace your price history with monthly prices for the time you own a stock or mutual fund. It is available on github, but it's strictly unsanctioned, since it modifies the data file directly. I don't know whether the latest issues with F::Q affect it or not. Googlin

Re: Installation of gnucash 2.6.18

2017-11-13 Thread Dave H
Gary, https://wiki.gnucash.org/wiki/MacOSXInstallation should give you some pointers. Cheers Dave H. On 14 November 2017 at 10:26, Gary Davidson wrote: > I have apple system Yosemite 10.10.5 and downloaded gnucash 2.6.18. When > the icon was downloaded onto my desktop what do I do with it to

Installation of gnucash 2.6.18

2017-11-13 Thread Gary Davidson
I have apple system Yosemite 10.10.5 and downloaded gnucash 2.6.18. When the icon was downloaded onto my desktop what do I do with it to have the program in my applications. (Mac 10.5,Intel. and PC) were shown but only Intel and PC could be chosen. Can anyone help me with the proper steps to mov

Cash flow and other reports by month

2017-11-13 Thread rmomxtx
Is there a way to generate a report that shows the cash flow by month in columns? Thanks, Roger ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all yo

F::Q

2017-11-13 Thread Les
I attempted to download quotes today (the first opportunity since adding Alphavantage as source). My Mac died in progress with a message of unknown error.  My Linux Mint 18.2 just stopped without completing (no message). However, my 2 ASX stocks ended up being priced in USD which resulted in t

Re: GnuCash Version 2.6.17 No Longer Downloads Quotes (Updated)

2017-11-13 Thread Robert L. Kief
I finally found alphavantage in the "Unknown" list and have selected it as my source.  I'm still not receiving any quotes, though.  The wiki page where I found info on my and many other's ALPHAVANTAGE problems is here: https://wiki.gnucash.org/wiki/FAQ#Q:_Why_doesn.27t_online_quoting_work.3F

Re: gnucash 2.6.18

2017-11-13 Thread Dave H
No problems running 2.6.18 (xml backend) at all on 10.13.1 on both MacBook Pro (APFS) and iMac (Mac OS Extended). Are you seeing issues ? Cheers Dave H. On 14 November 2017 at 03:40, Chris Tsuji wrote: >Hi >I have upgrade Mac OS 10.13.1 and was wondering if there is a problem >wit

Re: gnucash 2.6.18

2017-11-13 Thread Les
I upgraded MacOS over the weekend and "had" to upgrade GC to 2.16.18 because 2.6.17 would not open.  I understand the upgraded of Mac changed to a different file system (APFS). Les On 11/13/2017 11:40 AM, Chris Tsuji wrote: Hi I have upgrade Mac OS 10.13.1 and was wondering if there is

Re: Bank reconciliation

2017-11-13 Thread Cam Ellison
On 13/11/17 09:45 AM, David Goodenough wrote: Does no-one else have this problem? When we try to split the transaction in the imbalance account to allocate the payment to invoices we notice that it almost lets us add one split, but it does not automatically decrement the amount allocated to th

Re: How to find out which securities need to be switched from Yahoo to Alphavantage

2017-11-13 Thread David Carlson
Ouch!! David T, I vaguely recall that either you or someone you were discussing price retrieval with about a year or two ago developed a way to find and purge old prices from a file in a more selective way than the current purge function works. Is that documented somewhere? Parenthetically, I also

Re: Bank reconciliation

2017-11-13 Thread David Goodenough
Does no-one else have this problem? When we try to split the transaction in the imbalance account to allocate the payment to invoices we notice that it almost lets us add one split, but it does not automatically decrement the amount allocated to the imbalance account and so try to end up with

Re: GnuCash Version 2.6.17 No Longer Downloads Quotes

2017-11-13 Thread Geert Janssens
Op maandag 13 november 2017 00:11:52 CET schreef Robert L. Kief: > Gentlemen: > > I'm running Linux Mint 18.1. > > I've installed Finance::Quote 1.45 and acquired an ALPHAVANTAGE key. > I've tested 1.45 by using this string "export > ALPHAVANTAGE_API_KEY=" in terminal (using my n

gnucash 2.6.18

2017-11-13 Thread Chris Tsuji
Hi I have upgrade Mac OS 10.13.1 and was wondering if there is a problem with 2.6.18 with this operating system. Thanks in advance. Chris Tsuji ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinf

Re: Removal of unnecessary listed Account names

2017-11-13 Thread Derek Atkins
David, David Carlson writes: > Where are you seeing the multiple account names? If you actually changed > the names in your chart of accounts, there should not be accounts with the > old names. Similarly, in the OFX, QIF and CSV imports, you should not see > the old account names when matching

Re: How to find out which securities need to be switched from Yahoo to Alphavantage

2017-11-13 Thread D via gnucash-user
See below. On November 13, 2017, at 9:02 PM, David Carlson wrote: >I have been using GnuCash for many years and there are many securities in >my file that I no longer own, but I may or may not have discontinued >downloading their prices.  In trying to get my Alphavantage source working, >it app

RE: files

2017-11-13 Thread Christine via gnucash-user
Hi John Sorry I panicked and could not find out where to send messages. Gnucash was not open when I placed the files in a folder. If that is what you mean. Kind regards Christine -Original Message- From: John Ralls [mailto:jra...@ceridwen.us] Sent: 13 November 2017 01:55 To: Christine Cc:

Re: Error Connecting with MySql

2017-11-13 Thread Maf. King
Hi Mubasher, did you also see the reply from John Ralls a couple of hours after I posted? He knows much more about GC than I do, and his reply suggested an alternative route for you. sorry for the distraction, Maf. On Monday, 13 November 2017 13:25:16 GMT you wrote: > Hi, > > Thank you for

Re: How to find out which securities need to be switched from Yahoo to Alphavantage

2017-11-13 Thread gnucash3
Ah, this was the problem for me as well. I found an ancient Templeton fund that hadn't been switched over. The actual bug here (and I have written it before on this mailing list) is that the error message that Gnucash provides is useless. It needs to contain more information about what failed.

How to find out which securities need to be switched from Yahoo to Alphavantage

2017-11-13 Thread David Carlson
I have been using GnuCash for many years and there are many securities in my file that I no longer own, but I may or may not have discontinued downloading their prices. In trying to get my Alphavantage source working, it appears that it does not work if there is a mix of some securities changed an

Re: gnc-fq-dump doesn't work for most sources

2017-11-13 Thread gnucash3
I did (tediously) update my securities to Other/alphavantage. Whatever the problem is, that isn't it. On Mon, Nov 13, 2017 at 07:05:04AM -0600, Fross, Michael wrote: > Hello, > > Did you update your securities in GNUCash to use Alphavantage instead of > yahoo? I selected Other / Alphavantage in

Re: Request of help

2017-11-13 Thread John Ralls
Please remember to copy the list on all replies. https://lists.gnucash.org/pipermail/gnucash-user/2017-November/thread.html Regards, John Ralls > On Nov 12, 2017, at 10:37 PM, Ettore Scalese > wrote: > > Dear John,

Finance-Quote 1.45 AlphaVantage ETFs return incorrect UKP amount

2017-11-13 Thread Bob Foulger
Earlier it was reported that UK prices were returned from AlphaVantage 100x too high. This was changed in an F-C update and my UK share prices are now correctly reported but my ETFs prices are reported as 100x too low, see below. Using Finance-Quote 1.45 Finance::Quote fields Gnucash uses:   

Re: gnc-fq-dump doesn't work for most sources

2017-11-13 Thread Fross, Michael
Hello, Did you update your securities in GNUCash to use Alphavantage instead of yahoo? I selected Other / Alphavantage in the securities editor. Hopefully it's as simple as that (although it can be tedious depending on how many you have.) Michael On Sun, Nov 12, 2017 at 9:43 PM, wrote: > I a

Re: Latest WIKI page for stock quote setup

2017-11-13 Thread Geert Janssens
Op zaterdag 11 november 2017 16:12:16 CET schreef Ken Schneider: > After all of the discussion on the yahoo quotes no longer working I was > trying to find the latest wiki page describing how to change to > AlphaVantage and changing all of the required files. > https://wiki.gnucash.org/wiki/FAQ#Q:

Re: remove from mailing list

2017-11-13 Thread Liz
On Mon, 13 Nov 2017 09:05:33 + Kevin Barber wrote: > Kevin > > Sent from Mail for Windows 10 > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC t

remove from mailing list

2017-11-13 Thread Kevin Barber
Kevin Sent from Mail for Windows 10 ___ 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 Rep